Download:
|
by Edward P. F. Chan, Ron Van Der Meyden
http://linus.socs.uts.edu.au/~ron/research/oocont.ps
Add To MetaCart
Abstract:
In the optimization of queries in an object-oriented database system (OODB), a natural first step is to use the typing constraints imposed by the schema to transform a query into an equivalent one that logically accesses a minimal set of objects. We study a class of queries for OODB's called conjunctive queries. Variables in a conjunctive query range over heterogeneous sets of objects. Consequently, a conjunctive query is equivalent to a union of conjunctive queries of a special kind, called terminal conjunctive queries. Testing containment is a necessary step in solving the equivalence and minimization problems. We first characterize the containment and minimization conditions for the class of terminal conjunctive queries. We then characterize containment for the class of all conjunctive queries, and derive an optimization algorithm for this class. The equivalent optimal query produced is expressed as a union of terminal conjunctive queries which has the property that the number of variables as well as their search spaces are minimal among all unions of terminal conjunctive queries. Finally, we investigate the complexity of the containment problem. We show that it is complete in \Pi
Citations
|
632
|
Logical Foundations of Object-Oriented and FrameBased Languages
– Kifer, Lausen, et al.
- 1995
|
|
461
|
Querying objectoriented databases
– Kiier, Kim, et al.
- 1992
|
|
368
|
The Objectstore Database System
– Lamb, Landis, et al.
- 1991
|
|
313
|
Optimal implementation of conjunctive queries in relational data bases
– Chandra, Merlin
- 1977
|
|
309
|
Object Identity as a Query Language Primitive
– Abiteboul, Kanellakis
- 1989
|
|
226
|
The polynomial-time hierarchy
– Stockmeyer
- 1977
|
|
212
|
Principles of Database and
– Ullman
- 1989
|
|
200
|
Word problems requiring exponential time: Preliminary report
– Stockmeyer, Meyer
- 1973
|
|
160
|
Updatable Views in Object-Oriented Databases
– Scholl, Laasch, et al.
- 1991
|
|
149
|
Development of an object-oriented DBMS
– Maier, Stein, et al.
- 1986
|
|
129
|
On the power of languages for the manipulation of complex objects
– Abiteboul, Beeri
- 1988
|
|
97
|
Equivalences among relational expressions with the union and difference operators
– Sagiv, Yannakakis
- 1980
|
|
96
|
ILOG: declarative creation and manipulation of object identifiers
– Hull, Yoshikawa
- 1990
|
|
84
|
IRIS: An object-oriented database management system
– Fishman, Beech, et al.
- 1987
|
|
82
|
Özsu: “Queries and Query Processing in Object-Oriented Database Systems
– Straube, T
- 1990
|
|
81
|
A general framework for the optimization of object-oriented queries
– Cluet, Delobel
- 1992
|
|
70
|
Complete sets and the polynomial-time hierarchy
– Wrathall
- 1976
|
|
62
|
Object-oriented database systems
– Bancilhon
- 1988
|
|
54
|
Kornatzky: Algebraic Optimization of Object-Oriented Query Languages
– Beeri, Y
- 1990
|
|
52
|
The Database Language GEM
– Zaniolo
- 1983
|
|
41
|
A survey of theoretical research on typed complex database objects
– Hull
- 1987
|
|
37
|
Equivalence of relational expressions
– Aho, Sagiv, et al.
- 1979
|
|
36
|
Zdonik: “Object-Oriented Queries: Equivalence and Optimization
– Shaw, S
- 1989
|
|
30
|
Containment and minimization of positive conjunctive queries in oodb’s
– Chan
- 1992
|
|
18
|
Querying object oriented databases
– Kifer, Kim, et al.
- 1992
|
|
18
|
Optimization of nonrecursive queries in OODBs
– Lanzelotte, Valduriez, et al.
- 1991
|
|
12
|
Extending the Data Base Relational Model to Capture More Meaning
– Codd
- 1979
|
|
10
|
On the equivalence of database restructurings involving object identifiers
– Hull, Yoshikawa
- 1991
|
|
8
|
Type Systems for Querying Class Hierarchies with Non Strict Inheritance
– Borgida
- 1989
|
|
8
|
Manipulation of Structured Values on Object-Oriented Databases
– Lecluse, Richard
- 1989
|
|
1
|
The Object-Oriented Database System Manifisto
– Atkinson, Bancilhon, et al.
- 1989
|
|
1
|
Testing Satisfiability of a Class of Object-Oriented Conjunctive Queries
– Chan
- 1994
|
|
1
|
Database Theory-Past and Future
– Ullman
- 1987
|
