Query Optimization in an OODBMS

It is clearly crucial for the success of object-oriented databases to find effiĆ cient implementations that improve on the performance of relational sysĆ tems, rather than being powerful in terms of modeling and features, but just too slow to be used. This paper describes the mapping of COCOON to DASDBS, a nested relational database kernel system, as an example OODBMS mapping to a complex storage system. We describe 1) choices for physical designs that make use of the complex storage model and 2) the generation of efficient, set-oriented execution plans for object-oriented database queries, using rule-based query optimization techniques. We use hierarchical clustering and embedded (sets of) object references, and show how to explore them for efficient path traversals expressed in queries inĆ volving complex objects. Prototypes of both, a physical design tool and a query optimizer have been implemented. Preliminary results show feasibilĆ ity, and execution time improvements of an o...

• Type: Conference
• Year: 1993
• Where: BTW
• Authors: Christian Rich, Marc H. Scholl
• Keywords: BTW 1993, Complex Storage, Database, Object-oriented Database, Physical Design