Semantic Query Optimization for ODMG-93 Databases

  • Authors:
  • M. F. Van Bommel

  • Affiliations:
  • -

  • Venue:
  • IDEAS '99 Proceedings of the 1999 International Symposium on Database Engineering & Applications
  • Year:
  • 1999

Quantified Score

Hi-index 0.00

Visualization

Abstract

We present a graphical technique for semantic query optimization for ODMG-93 compliant databases. The OQL object query is represented as a graph based on the information contained in the ODL object schema.The graph reflects the constraints on possible objects satisfying the query. Vertices represent objects, which may be members of interfaces, ranges of values, constant values, objects returned by subqueries, object collections (count, sum, etc.), or constructs (sets, lists, etc). Key constraints and inverse relationships contained in the schema are used to perform join elimination, join simplification, and scan reduction via graph transformations. A marking scheme on the graph is used to perform subquery to join transformations and the detection of unnecessary duplication elimination.We argue that our approach generalizes previous research on object-based query optimization by providing a more natural representation of the query allowing simpler, more intuitive transformations, and leading to more efficient evaluation plans.