This Article 
 Bibliographic References 
 Add to: 
Join Index Hierarchy: An Indexing Structure for Efficient Navigation in Object-Oriented Databases
March/April 1999 (vol. 11 no. 2)
pp. 321-337

Abstract—A novel indexing structure—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 navigations among objects and classes, and localizes update propagations in the hierarchy. Our performance study shows that partial join index hierarchy outperforms several other indexing mechanisms in object-oriented query processing.

[1] J. Banerjee, W. Kim, and K.C. Kim, "Queries in Object-Oriented Databases," Proc. IEEE Int'l Conf. Data Eng., pp. 31-38, 1988.
[2] E. Bertino, "An Indexing Technique for Object-Oriented Databases," Proc. Int'l Conf. Data Eng., pp. 160-170,Kobe, Japan, Apr. 1991.
[3] E. Bertino and P. Foscoli, "Index Organizations for Object-Oriented Database Systems," IEEE Trans. Knowledge and Data Eng., vol. 7, no. 2, pp. 193-209, 1995.
[4] E. Bertino and W. Kim, “Indexing Technique for Queries on Nested Objects,” IEEE Trans. Knowledge and Data Eng., vol. 1, no. 2, pp. 196-214, 1989.
[5] J.A. Blakeley, W.J. McKenna, and G. Graefe, “Experiences Building the Open OODB Query Optimizer,” Proc. ACM SIGMOD Conf. Management of Data, pp. 287-295, May 1993.
[6] C.Y. Chan, C.H. Goh, and B.C. Ooi, "Indexing OODB Instances Based on Access Proximity," Proc. 13th IEEE Int'l Conf. Data Eng., pp. 14-21, 1997.
[7] S. Choenni, E. Bertino, H.M. Blanken, and T. Chang, "On the Selection of Optimal Index Configuration in OO Databases," Proc. Int'l Conf. Data Eng., pp. 526-537,Phoenix, Ariz., Feb. 1994.
[8] S. Cluet and C. Delobel, “A General Framework for the Optimization of Object-Oriented Queries,” Proc. ACM SIGMOD Conf., pp. 383–392, June 1992.
[9] G. Graefe, "Query Evaluation Techniques for Large Databases," ACM Computing Surveys, vol. 25, no. 2, pp. 73-170, June 1993.
[10] G. Graefe and D. Maier,“Query optimization in object-oriented database system: A prospectus,” Proc. Second Int’l Workshop Object-Oriented Database Systems, pp. 358-363, Springer Verlag, 1988.
[11] T. Haerder, "Implementing A Generalized Access Path Structure for A Relational Database System," ACM Trans. Database Systems, vol. 3, no. 3, pp. 285-298, Sept. 1978.
[12] K.A. Hua and C. Tripathy, "Object Skeletons: An Efficient Navigation Structure for Object-Oriented Database Systems," Proc. Int'l Conf. Data Eng., pp. 508-517,Houston, Feb. 1994.
[13] K. Kato and T. Masuda, “Persistent Caching: An Implementation Technique for Complex Objects with Object Identity,” IEEE Trans. Software Eng., vol. 18, no. 7, pp. 631-645, July 1992.
[14] T. Keller, G. Graefe, and D. Maier, "Efficient Assembly of Complex Objects," Proc. ACM SIGMOD Conf.,Denver, Colo., pp. 148-157, 1991.
[15] A. Kemper and G. Moerkotte, “Access Support in Object Bases,” Proc. ACM-SIGMOD Int'l Conf. Management of Data, pp. 364-374, 1990.
[16] A. Kemper and G. Moerkotte, "Advanced Query Processing in Object Bases Using Access Support Relations," Proc. Int'l Conf. Very Large Databases, pp. 290-301,Brisbane, Australia, Aug. 1990.
[17] C. Kilger and G. Moerkotte, "Indexing Multiple Sets," Proc. Int'l Conf. Very Large Databases,Santiago, Chile, Sept. 1994.
[18] W. Kim, K.C. Kim, and A. Dale, "Indexing Techniques for Object-Oriented Databases," W. Kim and F. Lochovsky, eds., Object-Oriented Concepts, Databases, and Applications, pp. 371-394, Addison-Wesley, 1989.
[19] H.A. Kuno and E.A. Rundensteiner, "Augmented Inherited MultiIndex Structure for Maintenance of Materialized Path Query Views," RIDE-NDS, pp. 128-137, 1996.
[20] R.S.G. Lanzelotte, P. Valduriez, M. Ziane, and J. Cheiney, "Optimization of Nonrecursive Queries in OODBs," Proc. Int'l Conf. Deductive and Object-Oriented Databases (DOOD),Munich, Germany, Dec. 1991.
[21] C.C. Low, B.C. Ooi, and H. Lu, "H-Trees: A Dynamic Associative Search Index for OODB," Proc. SIGMOD Int'l Conf. Management Data, pp. 134-143, ACM, 1992.
[22] W. Lu and J. Han, "Distance-Associated Join Indices for Spatial Range Search," Proc. Int'l Conf. Data Eng., pp. 284-292, 1992.
[23] D. Maier and J. Stein,“Indexing in an object-oriented DBMS,” Proc. IEEE Workshop Object-Oriented DBMS,Asilomar, Calif., Sept. 1986.
[24] T.A. Mueck and M.L. Polaschek, "The Multikey Type Index for Persistent Object Sets," Proc. 13th Int'l Conf. Data Eng., pp. 22-31,Birmingham, U.K., 1997.
[25] B.C. Ooi, J. Han, H. Lu, and K.L. Tan, "Index Nesting—An Efficient Approach to Indexing in Object-Oriented Databases," VLDB J., vol. 5, pp. 215-228, 1996.
[26] M. Palmer and S.B. Zdonik, “Fido: A Cache that Learns to Fetch,” Proc. 17th Int'l Conf. Very Large Data Bases, pp. 255–262, Sept. 1991.
[27] S. Ramaswamy and P.C. Kanellakis, "OODB Indexing by Class-Division," SIGMOD Record, vol. 24, pp. 139-150, 1995.
[28] D. Rotem, "Spatial Join Indices," Proc. Seventh Int'l Conf. Data Eng., pp. 500-509, 1991.
[29] S.K. Seo and Y.J. Lee, "Methodology for Index Configurations in Object-Oriented Databases," Information Sciences, vol. 93, pp. 187-210, 1996.
[30] E.J. Shekita and M.J. Carey, “Performance Enhancement Through Replication in an Object-Oriented DBMS,” Proc. ACM SIGMOD Conf. Management of Data, pp. 325-336, June 1989.
[31] D.D. Straube and M.T. Ozsu, “Queries and Query Processing in Object-Oriented Database Systems,” ACM Trans. Information Systems, vol. 8, no. 4, 1990.
[32] P. Valduriez, “Join Indices,” ACM Trans. Database Systems, vol. 12, no. 2, 1987.
[33] Z. Xie and J. Han, "Optimization of Queries Containing Complex Selections, Joins, and Aggregations," Proc. Int'l Conf. Computing and Information,Peterborough, Ont., Canada, May 1994.
[34] S.B. Yao, "Approximating Block Accesses in Database Organizations," Comm. ACM, vol. 20, no. 4, pp. 260-261, Apr. 1977.

Index Terms:
Index structures, join indices, query processing, query optimization, object-oriented database.
Jiawei Han, Zhaohui (Alex) Xie, Yongjian Fu, "Join Index Hierarchy: An Indexing Structure for Efficient Navigation in Object-Oriented Databases," IEEE Transactions on Knowledge and Data Engineering, vol. 11, no. 2, pp. 321-337, March-April 1999, doi:10.1109/69.761666
Usage of this product signifies your acceptance of the Terms of Use.