Optimization of object-oriented queries involving weakly dependent subqueries

  • Authors:
  • Michał Bleja;Tomasz Kowalski;Radosław Adamus;Kazimierz Subieta

  • Affiliations:
  • Faculty of Mathematics and Computer Science, University of Łódź, Poland;Computer Engineering Department, Technical University of Łódź, Poland;Computer Engineering Department, Technical University of Łódź, Poland;Polish-Japanese Institute of Information Technology, Warsaw, Poland and Institute of Computer Science, Polish Academy of Sciences, Warsaw, Poland

  • Venue:
  • ICOODB'09 Proceedings of the Second international conference on Object databases
  • Year:
  • 2009

Quantified Score

Hi-index 0.00

Visualization

Abstract

A new static optimization method in object query languages is presented. We introduce a special kind of subqueries of a query referred to as "weakly dependent subqueries". A subquery is weakly dependent if it depends from an external query operator only on an expression returning the result of an enumerated type. If a query contains such subqueries then we rewrite it to an equivalent form which guarantees much better performance. Our method is based on the stack-based approach (SBA) and its query language SBQL (Stack-Based Query Language) implemented in the ODRA system. SBA is relevant for a general object model and for its specific variants. Clean formal semantics and abstract implementation of SBQL, integration with the constructs of programming languages and advanced data structures give the possibility to investigate different areas that are related to query optimization techniques. The paper presents examples how the optimization method works. General and detailed features of the implemented algorithm are also presented.