Experiences building the open OODB query optimizer

José A. Blakeley, William J. McKenna, Goetz Graefe
1993 SIGMOD record  
This paper reports our experiences building the query optimizer for TI's Open 00DB system. To the best of our knowledge, it is the first working object query optimizer to be based on a complete extensible optimization framework including logical algebra, execution algorithms, property enforcers, logical transformation rules, implementation rules, and selectivity and cost estimation. Our algebra incorporates a new rr@erialize operator with its corresponding logical transformation and
more » ... on rules that enable the optimization of path expressions. Initial experiments on queries obtained from the object query optimization literature demonstrate that our optimizer is able to derive plans that are as efficient as, and often substantially more efficient than, the plans generated by other query optimization strategies. These experiments demonstrate that our initial choices for populating each pert of our optimization framework are reasonable. Our experience also shows that having a complete optimization framework is crucial for two reasons. Firs~it allows the optimizer to discover plans that cannot be revealed by exploring only the alternatives provided by the logical algebra and its transformations. Sewnd, it helps and forces the database system designer to consider all parts of the framework and to maintain a good btdance of choices when incorporating a new logical operator, execution algorithm, transformation rule, or implementation rule. The Open OODB query optimizer was constructed using the Volcano Optimizer Generator, demonstrating that this second-generation optimizer generator enables rapid development of efficient and effective query optimizers for non-standard data models and systems.
doi:10.1145/170036.170080 fatcat:fidz7fennnhi3izbm5czw33yoy