HCB-Tree: A Height Compressed B-Tree for Parallel Processing

B-tree type indexes are popular in database applications because they provide a fast access path to large databases. In this paper we present a new storage structure which is suitable for fast parallel searching by using B-tree like indexes [I]. We call this modified B_ tree structure the Height Compressed B_ tree (HCB_tree). The main results presented in this paper are that parallel processing of HCB_ trees reduces access time, and minimizes the frequency of restructuring considerably. Since the I/O processing time is dependent on the number of disk accesses, i.e., the height of the index tree, reducing the number of levels of the index tree is very important for secondary database storage. One way to reduce the height of B_ trees is to use a large index node. But we shall show through queueing models that this approach alone may not improve performance. And in certain circumstances this approach may even degrade performance because of increased I/O transfer time and processing time required for large nodes. The logical construction of HCB_trees is based on conventional B_ trees, but the overall philosophy is different. The goal of the HCB_tree is to

[1]  J. D. Uiiman,et al.  Principles of Database Systems , 2004, PODS 2004.

[2]  R. Bayer,et al.  Organization and maintenance of large ordered indices , 1970, SIGFIDET '70.

[3]  Kevin Wilkinson,et al.  Overview of the Jasmin database machine , 1984, SIGMOD '84.

[4]  G. Jack Lipovski,et al.  The Architectural Features and Implementation Techniques of the Multicell CASSM , 1979, IEEE Transactions on Computers.

[5]  Hans Christoph Zeidler,et al.  RDBM: A Dedicated Multiprocessor System for Database Management , 1983, Advanced Database Machine Architecture.

[6]  Haruo Yokota,et al.  The Design and Implementation of Relational Database Machine Delta , 1985, IWDM.

[7]  Sakti Pramanik,et al.  Index Database Machine , 1986, Comput. J..

[8]  David K. Hsiao,et al.  Advanced Database Machine Architecture , 1983, Advanced Database Machine Architecture.

[9]  Sakti Pramanik,et al.  Optimal file distribution for partial match retrieval , 1988, SIGMOD '88.

[10]  Kenneth C. Smith,et al.  RAP: an associative processor for data base management , 1975, AFIPS '75.

[11]  Sadayuki Hikita,et al.  Database Machine FREND , 1985, IWDM.

[12]  S. Pramannik,et al.  Generalized parallel processing models for database systems , 1988 .

[13]  Sakti Pramanik Performance Analysis of a Database Filter Search Hardware , 1986, IEEE Transactions on Computers.

[14]  Michelle Y. Kim,et al.  Synchronized Disk Interleaving , 1986, IEEE Transactions on Computers.

[15]  Sheldon M. Ross,et al.  Introduction to probability models , 1975 .