This Article 
 Bibliographic References 
 Add to: 
Index Organizations for Object-Oriented Database Systems
April 1995 (vol. 7 no. 2)
pp. 193-209

Abstract—In this paper we present an indexing technique providing support for queries involving complex, nested objects and inheritance hierarchies. This technique is compared with two techniques obtained from more traditional organizations. The three techniques are evaluated using an analytical cost model. The discussion will be cast in the framework of object-oriented databases. However, results are applicable to data management systems characterized by features such as complex objects and inheritance hierarchies.

[1] 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.
[2] E. Bertino,“An indexing technique for object-oriented databases,” Proc. Seventh IEEE Int’l Conf. Data Eng.,Kobe, Japan, Apr. 1991.
[3] E. Bertino and L. Martino,“Object-oriented database management systems: Concepts and issues,” Computer, vol. 24, no. 4, pp. 33-47, 1991.
[4] E. Bertino and P. Foscoli,“On modeling cost functions for complex objects,” submitted for publication, Jan. 1992, available from the authors.
[5] E. Bertino and A. Quarati,“An approach to support method invoca-tions in object-orientedqueries,” Proc. Int’l Workshop Research Issues in Transactions and Query Processing(RIDE-TQP),Phoenix, Ariz., Feb. 1992.
[6] E. Bertino and E. Montesi,“Towards a logical-object oriented programming language fordatabases,” Proc. Third Int’l Conf. Extending Database Technology (EDBT),Vienna, Mar. 1992.
[7] E. Bertino,S. Bottarelli,M. Damiani,M. Migliorati,, and P. Randi,“The ADKMS knowledge acquisition system,” Proc. Second Far-East Workshop Future Database Systems, Apr. 1992.
[8] E. Bertino,M. Negri,G. Pelagatti,, and L. Sbattella,“Object-oriented query languages: The notion and the issues,” IEEE Trans. Knowledge and Data Eng., vol. 4, no. 3, pp. 223-237, 1992.
[9] E. Bertino and C. Guglielmina,“Path-Index: An approach to the efficient execution of object-orientedqueries,” Data and Knowledge Eng., North-Holland, 1993.
[10] E. Bertino,“A survey of indexing techniques for object-oriented databases,” Proc. Dagsthul Seminar Query Processing in Object-Oriented, Complex-Objectand Nested Relational Databases, C. Freytag, D. Maier, and G. Vossen, eds., Morgan-Kaufmann, 1993.
[11] A. Borgida et al., "Classic: A Structural Data Model for Objects," Proc. 1989 ACM SIGMOD Int'l Conf. Management of Data, ACM Press, New York, 1989, pp. 59-67.
[12] F. Cacace,S. Ceri,S. Crespi-Reghizzi,L. Tanca,, and R. Zicari,“Interating object-oriented data modeling with a rule-based programmingparadigm,” Proc. 1990 ACM SIGMOD Int’l Conf. on Management of Data, SIGMOD Record, vol. 19 no. 2, pp. 225-237, June 1990.
[13] M. Carey and D. DeWitt,“An overview of the EXODUS project,” Proc. ACM-SIGMOD Int’l Conf. Management of Data,Chicago, Ill., June 1988.
[14] A. Jhingran,“Precomputation in a complex object environment,” Proc. Seventh IEEE Int’l Conf. Data Eng.,Kobe, Japan, Apr. 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,C. Kilger,, and G. Moerkotte,“Function materialization in object bases,” Proc. ACM-SIGMOD Int’l Conf. Management of Data,Denver, Colo., May 1991.
[17] 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.
[18] D. Maier and J. Stein,“Indexing in an object-oriented DBMS,” Proc. IEEE Workshop Object-Oriented DBMS,Asilomar, Calif., Sept. 1986.
[19] M. Stonebraker,L. Row, and M. Hirohama,"The implementation of POSTGRES," IEEE Trans. Knowledge and Data Engineering, vol. 2, no. 7, pp. 125-142, Mar. 1990.
[20] P. Valduriez, “Join Indices,” ACM Trans. Database Systems, vol. 12, no. 2, 1987.
[21] C. Zaniolo,“Object identity and inheritance in deductive databases—Anevolutionary approch,” Proc. First Int’l Conf. Deductive and Object-Oriented Databases (DOOD),Kyoto, Japan, Dec. 1989.
[22] S.B. Yao, "Approximating Block Accesses in Database Organizations," Comm. ACM, vol. 20, no. 4, pp. 260-261, Apr. 1977.

Index Terms:
Object-oriented databases, complex objects, inheritance, query languages, query processing, data structures.
Elisa Bertino, Paola Foscoli, "Index Organizations for Object-Oriented Database Systems," IEEE Transactions on Knowledge and Data Engineering, vol. 7, no. 2, pp. 193-209, April 1995, doi:10.1109/69.382292
Usage of this product signifies your acceptance of the Terms of Use.