Next: The Query Locality Set
Up: DBMIN - A Buffer
Previous: Load Controller
- Selection of local replacement policies.
- Estimate sizes for the localoty sets of each file instance.
- Straight Sequential
- The locality set size is 1.
- On page fault, read from disk and overwrite data on the buffer page.
- Clustered Sequential
- The locality set size is (# of records in largest cluster)/(blocking
factor).
- The page replacement discipline can be both LRU or FIFO for optimality.
- Looping Sequential
- The locality set size is the total number of pages in the file.
- The page replacement discipline is MRU for optimality.
- Independent Random
- The locality set size has an upper bound(approx) provided by Yao's
formula. It estimates the total # of pages referenced, b, in a series
of k random record accesses.
- When references are sparse, 1 page is sufficient.
- The actual size can be one of the two depending on the likelihood that
each page is re-referenced.
- The page replacement discipline choice is immaterial.
- Clustered Random
- The locality set size is approximated by the number of records in the
largest cluster.
- The page replacement discipline can be both LRU or FIFO for optimality.
- Straight Heirarchical (SH), H/SS, H/CS
- The locality set size is 1.
- CS references is applicable here xpt each member in a cluster is now a
key-pointer pair than a data record.
- Looping Hierarchical
- An ideal reference algo should keep the active pages of the upper
levels of a tree resident and multiplex the rest of the pages in a
scratch buffer.
- ``Residual Buffer'' concept can be used to determine the number of
upper levels to be kept in memory.
- In many cases, root is the only page worth keeping in memory, since
fan-out is large. Then LIFO and 3-4 buffers with root pinned gives
a reasonable level of performance.
Next: The Query Locality Set
Up: DBMIN - A Buffer
Previous: Load Controller
Deepak Kumar Tawri
Wed Apr 21 21:25:41 IST 1999