Join Index Hierarchy: An Indexing Structure for Efficient Navigation in Object-Oriented Databases

A novel indexing structure-the join index hierarchy-is proposed to handle the "gotos on disk" problem in object-oriented query processing. The method constructs a hierarchy of join indices and transforms a sequence of pointer-chasing operations into a simple search in an appropriate join index file, and thus accelerates navigation in object-oriented databases. The method extends the join index structure studied in relational and spatial databases, supports both forward and backward navigation among objects and classes, and localizes update propagations in the hierarchy. Our performance study shows that a partial join index hierarchy outperforms several other indexing mechanisms in object-oriented query processing.

[1]  Jiawei Han,et al.  Distance-associated join indices for spatial range search , 1992, [1992] Eighth International Conference on Data Engineering.

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

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

[4]  Elke A. Rundensteiner,et al.  Augmented inherited multi-index structure for maintenance of materialized path query views , 1996, Proceedings RIDE '96. Sixth International Workshop on Research Issues in Data Engineering.

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

[6]  Michael J. Carey,et al.  Performance enhancement through replication in an object-oriented DBMS , 1989, SIGMOD '89.

[7]  Takashi Masuda,et al.  Persistent Caching: An Implementation Technique for Complex Objects with Object Identity , 1992, IEEE Trans. Software Eng..

[8]  Guido Moerkotte,et al.  Advanced Query Processing in Object Bases Using Access Support Relations , 1990, VLDB.

[9]  Goetz Graefe,et al.  Experiences building the open OODB query optimizer , 1993, SIGMOD Conference.

[10]  M. Tamer Özsu,et al.  Queries and query processing in object-oriented database systems , 1990, TOIS.

[11]  Doron Rotem.  Spatial join indices , 1991, [1991] Proceedings. Seventh International Conference on Data Engineering.

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

[13]  Elisa Bertino,et al.  An indexing techniques for object-oriented databases , 1991, [1991] Proceedings. Seventh International Conference on Data Engineering.

[14]  Theo Härder.  Implementing a generalized access path structure for a relational database system , 1978, TODS.

[15]  Jay Banerjee,et al.  Queries in object-oriented databases , 1988, Proceedings. Fourth International Conference on Data Engineering.

[16]  Thomas A. Mück,et al.  The multikey type index for persistent object sets , 1997, Proceedings 13th International Conference on Data Engineering.

[17]  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.

[18]  Beng Chin Ooi,et al.  Indexing OODB instances based on access proximity , 1997, Proceedings 13th International Conference on Data Engineering.

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

[20]  Patrick Valduriez,et al.  Join indices , 1987, TODS.

[21]  Goetz Graefe,et al.  Query evaluation techniques for large databases , 1993, CSUR.

[22]  Object-Oriented Data,et al.  An Indexing Technique for Object-Oriented Databases , 1991 .

[23]  Sophie Cluet,et al.  A general framework for the optimization of object-oriented queries , 1992, SIGMOD '92.

[24]  Stanley B. Zdonik,et al.  Fido: A Cache That Learns to Fetch , 1991, VLDB.

[25]  Patrick Valduriez,et al.  Optimization of Nonrecursive Queries in OODBs , 1991, DOOD.

[26]  Elisa Bertino,et al.  On the selection of optimal index configuration in OO databases , 1994, Proceedings of 1994 IEEE 10th International Conference on Data Engineering.

[27]  Yoon-Joon Lee,et al.  Methodology for Index Configurations in Object-Oriented Databases , 1996, Inf. Sci..

[28]  Guido Moerkotte,et al.  Access support in object bases , 1990, SIGMOD '90.

[29]  David Maier,et al.  Indexing in an Object-Oriented DBMS , 1986, OODBS.

[30]  Beng Chin Ooi,et al.  Index nesting – an efficient approach to indexing in object-oriented databases , 1996, The VLDB Journal.

[31]  David Maier,et al.  Efficient assembly for complex objects , 1991, SIGMOD '91.

[32]  S. B. Yao,et al.  Approximating block accesses in database organizations , 1977, CACM.

[33]  David Maier,et al.  Query Optimization in Object-Oriented Database Systems: A Prospectus , 1988, OODBS.