ABSTRACT
A formal framework for studying the expressive power and complexity of OODB queries is developed. Three approaches to modeling sets are articulated and compared. The class of regular OODB schemas supports the explicit representation of set-valued types. Using an object-based semantics for sets, the regular schemas correspond to most implemented OODB systems in the literature; a value-based semantics for sets is also introduced. Without restrictions, both of these approaches support the specification of all computable queries. Assuming that the new operator is prohibited, the query language of the regular OODB schemas under the object-based semantics is complete in PSPACE; and under the value-based semantics it has hyper-exponential complexity. The third approach to modeling sets is given by the algebraic OODB model, in which multi-valued attributes rather than set-valued types are supported. method implementations can use operators stemming from the relational algebra, and do not have side-effects. The query language of algebraic OODBs is more powerful than the relational algebra but has complexity bounded by PTIME. The expressive power and complexity of data access for other variations of OODBs are also considered. Finally, a new relational query language, called algebra + pointwise recursion, is introduced. This is equivalent to the algebraic OODB language, and can compute generalized transitive closure.
- AH87a.S. Abiteboul and R. Hull. IFO: A formal semantic database model. A UM Trans. on Database Systems, 12(4):525-565, 1987. Google ScholarDigital Library
- AH87b.T. Andrews and C. Harris. Combining language and database advances in an objectoriented development environment. In Proc. Conf on OOPSLA, pages 430-440, 1987. Google ScholarDigital Library
- AV88.S. Abiteboul and V. Vianu. Procedural and declarative database update languages. In Proc. A CM Syrup. on Principles of Database Systems, pages 240-250, 1988. Google ScholarDigital Library
- BCD89.F. Bancilhon, S. Cluet, and C. Delobel. Query languages for object-oriented database systems. In 2nd Intl. Workshop on Database Programming Languages, June 1989. to appear. Google ScholarDigital Library
- BCG+87.J Banerjee, H.-T. Chou, J. F. Garza, W. Kim, D. Woelk, and N. Ballou. Data model issues for object-oriented applications. A CM Trans. on Office Information Systems, 5(1):3- 26, 1987. Google ScholarDigital Library
- CH80.A.K. Chandra and D. Hard. Computable queries for relational data bases. Journal of Computer and System Sciences, 21(2):156- 178, 1980.Google ScholarCross Ref
- CH82.A.K. Chandra and D. Hard. Structure and complexity of relational queries. Journal of Computer and System Sciences, 25(1):99-128, 1982.Google ScholarCross Ref
- Cha81.A.K. Chandra. Programming primitives for database languages, in Proc. A CM Syrup. on Principles of Programming Languages, pages 50-62, 1981. Google ScholarDigital Library
- GJ79.M.R. Garey and D.S. Johnson. Computers and Intractability: A Guide to the Theory of NP-Completeness. Freeman, 1979. Google ScholarDigital Library
- HS88a.R. Hull and J. Su. On the expressive power of database queries with intermediate types. Technical Report 88-53, Computer Science Department, Univ. of Southern California, 1988. Invited to special issue of Journal of Computer and System Sciences.Google ScholarDigital Library
- HS88b.R. Hull and J. Su. On the expressive power of database queries with intermediate types. In Proe. A CM Syrup. on Principles o.f Database Systems, pages 39-51, 1988. Google Scholar
- HS89.R. Hull and J. Su. Untyped sets, invention, and computable queries. In Proe. A CM Syrup. on Principles of Database Systems, 1989. Google ScholarDigital Library
- HTY88.R. Hull, K. Tanaka, and M. Yoshikawa. Behavior analysis of object-oriented databases: Method structure, exeuction trees, and reachability (extended abstract). Technical Report 88-52, Computer Science Department, University of Southern California, 1988. to appear, Third Intl. Conf. on Foundations of Data Organization and Algorithms, Paris, June 1989. Google ScholarDigital Library
- HU79.J.E. Hopcroft and J.D. Ullman. Introduction to Automata Theory, Languages, and Computation. Addison Wesley, 1979. Google ScholarDigital Library
- Hul87.R. Hull. A survey of theoretical research on typed complex database objects. In J. Paredaens, editor, Databases, pages 193- 256. Academic Press (London), 1987. Google ScholarDigital Library
- Imm86.N. Immerman. Relational queries computable in polynomial time. Information and Control, 68:86-104, 1986. Google ScholarDigital Library
- KV88.G.M. Kuper and M. Y. Vardi. On the complexity of queries in the logical data model. In Proc. 1at. Conf. on Database Theory, pages 267-280, 1988. Google ScholarDigital Library
- LRV88.C. Lecluse, P. Richard, and F. Velez. 02: An object-oriented formal data model. In Proc. A CM SIGMOD Int. Conf. on Management of Data, pages 424-433, Chicago, June 1988. Google ScholarDigital Library
- PSM87.A. Purdy, B. Schuchardt, and D. Maier. Integrating an object server with other worlds. A CM Trans. on Office Information Systems, 5(1):27-47, 1987. Google ScholarDigital Library
- RHDM86.A. Rosenthal, S. Heiler, U. Dayal, and F. Manola. Traversal recursion: A practical approach to supporting recursive applications. in Proc. A CM SIGMOD Int. Conf. on Management of Data, pages 166-176, 1986. Google ScholarDigital Library
- Shi81.D.W. Shipman. The functional data model and the data language DAPLEX. A CM Trans. on Database Systems, 6(1):140-173, 1981. Google ScholarDigital Library
- Ull88.J.D. Ullman. Database and Knowledge-Base Systems, volume 1. Computer Science Press, 1988. Google ScholarDigital Library
- Var82.M.Y. Vardi. The complexity of relational query languages. In Proc. A CM SIGACT Syrup. on the Theory of Computing, pages 137-146, 1982. Google ScholarDigital Library
Index Terms
- On accessing object-oriented databases: expressive power, complexity, and restrictions
Recommendations
On accessing object-oriented databases: expressive power, complexity, and restrictions
A formal framework for studying the expressive power and complexity of OODB queries is developed. Three approaches to modeling sets are articulated and compared. The class of regular OODB schemas supports the explicit representation of set-valued types. ...
Federating Object-Oriented and Relational Databases: The IRO-DB Experience
COOPIS '97: Proceedings of the Second IFCIS International Conference on Cooperative Information SystemsFrom the beginning of 1994 to the end of 1996, the IRO-DB (Interoperable Relational and Object-Oriented Databases) ESPRIT project has developed tools for accessing relational and object-oriented databases in an integrated way, and for designing and ...
Query Interoperation Among Object-Oriented and Relational Databases
ICDE '95: Proceedings of the Eleventh International Conference on Data EngineeringWe develop an efficient algorithm for the query interoperation among existing heterogeneous object-oriented and relational databases. Our algorithm utilizes a canonical deductive database as a uniform representation of object-oriented schema and data. ...
Comments