1 / 17

Indexing Structures for Files

This chapter discusses various indexing structures for files, including primary index, clustering index, secondary index, B-tree, and grid array. It also explains insertion and deletion operations on B+-trees and provides examples.

millerg
Download Presentation

Indexing Structures for Files

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. Chapter 14 Indexing Structures for Files

  2. FIGURE 14.1Primary index on the ordering key field of the file shown in Figure 13.7.

  3. FIGURE 14.2A clustering index on the DEPTNUMBER ordering nonkey field of an EMPLOYEE file.

  4. FIGURE 14.3Clustering index with a separate block cluster for each group of records that share the same value for the clustering field.

  5. FIGURE 14.4A dense secondary index (with block pointers) on a nonordering key field of a file.

  6. FIGURE 14.5A secondary index (with recored pointers) on a nonkey field implemented using one level of indirection so that index entries are of fixed length and have unique field values.

  7. FIGURE 14.6A two-level primary index resembling ISAM (Indexed Sequential Access Method) organization.

  8. FIGURE 14.7A tree data structure that shows an unbalanced tree.

  9. FIGURE 14.8A node in a search tree with pointers to subtrees below it.

  10. FIGURE 14.9A search tree of order p = 3.

  11. FIGURE 14.10B-tree structures. (a) A node in a B-tree with q – 1 search values. (b) A B-tree of order p = 3. The values were inserted in the order 8, 5, 1, 7, 3, 12, 9, 6.

  12. FIGURE 14.11The nodes of a B+-tree. (a) Internal node of a B+-tree with q –1 search values. (b) Leaf node of a B+-tree with q – 1 search values and q – 1 data pointers.

  13. FIGURE 14.12An example of insertion in a B+-tree with q = 3 and pleaf = 2.

  14. FIGURE 14.13An example of deletion from a B+-tree.

  15. FIGURE 14.14Example of a grid array on DNO and AGE attributes.

  16. FIGURE 14.15B+-tree insertion with left redistribution.

More Related