MetaCartSign in to MyCiteSeer

Include Citations | Advanced Search | Help

Include Citations | Advanced Search | Help

  The SB-Tree: An Index-Sequential Structure for High-Performance Sequential Access (1992) [5 citations — 0 self]

Download:
Download as a PDF | Download as a PS
by Patrick E. O'neil
Acta Informatica
http://www.cs.umb.edu/~poneil/sb-tree.ps
Add To MetaCart

Abstract:

ABSTRACT. A variant of a B-tree known as an SB-tree is introduced, with the object of offering high-performance sequential disk access for long range retrievals. The key to this efficiency is a structure which supports multi-page reads (or writes) during sequential access to any node level below the root, even following significant node splitting. In addition, the SBtree will support a policy to "stripe " successive multi-page blocks on multiple disks to achieve maximum parallelism. Compared to traditional B-tree structures, SB-tree performance characteristics are less subject to degradation resulting from modifications entailed in growing and shrinking; SB-trees are therefore more appropriate for use in situations where frequent reorganization is not possible. A performance analysis reveals the strengths of the SB-tree by comparing its performance under various circumstances to the B-tree and the Bounded Disorder (BD) file of [11]. The performance analysis formulates a new useful concept, the "effective depth " of an SB- or B-tree, defined as the expected number of pages read from disk to perform a random retrieval search given standard buffering behavior. A graph of effective depth against tree size is shown to have a scalloped appearance, reflecting the changing effectiveness of incremental additions to buffer space.

Citations

472 The Ubiquitous B-Tree – Comer - 1979
133 Maximizing Performance in a Striped Disk Array – Chen, Patterson - 1990
61 Prefix B-trees – Bayer, Unterauer - 1977
54 An evaluation of redundant arrays of disks using an Amdahl 5890 – Chen, Gibson, et al. - 1990
50 Managing IBM Database 2 buffers to maximize performance – Teng, Gumaer - 1984
22 Organization and Maintenance of Large Ordered – Bayer, McCreight - 1972
22 The five minute rule for trading memory for disk accesses and the 10 byte rule for trading memory for cpu time – Gray, Putzolu - 1987
22 Database Design – Wiederhold - 1983
6 Revisiting DBMS Benchmarks. Datamation – O'Neil - 1989
4 A Simple Bounded Disorder File Organization with Good Performance – Lomet - 1988
2 private communication – Gawlick, DEC - 1989
1 Expected Behavior of B + -trees under Random – Baeza-Yates - 1989
1 DISCS", Notes for talk Sponsored by DEC Cambridge Research Lab and Greater Boston SIGMOD – Gray - 1989
1 The Set Query Benchmark", The Performance Handbook: for Database and Transaction Processing Systems – O'Neil - 1991
1 Unsafe Operations in B-trees, Acta Informatica 26 – Zhang, Hsu - 1989