Index set: A practical indexing scheme for object database systems

Abstract Efficient indexing in a class hierarchy is essential for the achievement of high performance in query evaluation for object database management systems. In this paper, we present a practical indexing scheme, index set , which provides good index configuration for any real database environment. The proposed scheme considers the distribution of key values, as well as query patterns such as query weight on each class. The index set can easily be applied to any database system, since it uses the well-known B + -tree structure. We develop a cost model and, through experiments, demonstrate the performance of the proposed scheme over various class hierarchies.

[1]  Kien A. Hua,et al.  Object Skeletons: an efficient navigation structure for object-oriented database systems , 1994, Proceedings of 1994 IEEE 10th International Conference on Data Engineering.

[2]  Beng Chin Ooi,et al.  H-trees: a dynamic associative search index for OODB , 1992, SIGMOD '92.

[3]  Won Kim,et al.  Cyclic query processing in object-oriented databases , 1989, [1989] Proceedings. Fifth International Conference on Data Engineering.

[4]  Ehud Gudes A Uniform Indexing Scheme for Object-Oriented Databases , 1997, Inf. Syst..

[5]  Elisa Bertino,et al.  Definition and Analysis of Index Organizations for Object-Oriented Database Systems , 1998, Inf. Syst..

[6]  Won Kim,et al.  Object-Oriented Concepts, Databases, and Applications , 1989 .

[7]  Sridhar Ramaswamy,et al.  OODB indexing by class-division , 1995, SIGMOD '95.

[8]  B. Sreenath,et al.  The hcC-tree: An Efficient Index Structure for Object Oriented Databases , 1994, VLDB.

[9]  Elisa Bertino,et al.  Index Organizations for Object-Oriented Database Systems , 1995, IEEE Trans. Knowl. Data Eng..

[10]  Michael Stonebraker,et al.  Object-Relational DBMSs: Tracking the Next Great Wave , 1998 .

[11]  Guido Moerkotte,et al.  Access Support Relations: An Indexing Method for Object Bases , 1992, Inf. Syst..

[12]  Jiawei Han,et al.  Join Index Hierarchies for Supporting Efficient Navigations in Object-Oriented Databases , 1994, VLDB.

[13]  Hiroyuki Kitagawa,et al.  Evaluation of signature files as set access facilities in OODBs , 1993, SIGMOD '93.

[14]  Won Kim,et al.  Introduction to Object-Oriented Databases , 1991, Computer systems.

[15]  Guido Moerkotte,et al.  Indexing Multiple Sets , 1994, VLDB.

[16]  Christian S. Jensen Review - R-Trees: A Dynamic Index Structure for Spatial Searching , 1999, ACM SIGMOD Digit. Rev..

[17]  Elisa Bertino,et al.  Indexing Techniques for Queries on Nested Objects , 1989, IEEE Trans. Knowl. Data Eng..

[18]  Antonin Guttman,et al.  R-trees: a dynamic index structure for spatial searching , 1984, SIGMOD '84.

[19]  Douglas Comer,et al.  Ubiquitous B-Tree , 1979, CSUR.