Query Optimization in OODB

• Main Authors: Hwee Hwa PANG, LU, Hongjun, OOI, Beng Chin
• Format: text
• Language: English
• Published: Institutional Knowledge at Singapore Management University 1992
• Subjects: Computer Sciences; Databases and Information Systems
• Online Access: https://ink.library.smu.edu.sg/sis_research/2876; https://ink.library.smu.edu.sg/context/sis_research/article/3876/viewcontent/OODB_1991_DASFAA.pdf
• Institution: Singapore Management University

In object-oriented databases, relationships are generally maintained explicitly. The partial result of a retrieved object can be used to efficiently retrieve related objects. Instead of optimizing joins as in relational database systems, pointer chasing is optimized in object-oriented database systems. Further, semantics inherent in the object-oriented database, like superclass-subclass relationships and composite-component relationships between object classes, must be realised. In this paper, we describe our initial result in query optimization in an object-oriented database system. Semantic query transformation is used to preprocess the query. semantically optimized query is then translated into a query evaluation plan which comprises method invocations that can be evaluated directly by the system. In the process of query evaluation plan generation, initial results tend to show that a one source query plan is almost optimal. A prototype based on this design has been completed and some results from a simulation study on this prototype are also reported in this paper.