skip to main content
10.1145/67544.66940acmconferencesArticle/Chapter ViewAbstractPublication PagesmodConference Proceedingsconference-collections
Article
Free Access

On accessing object-oriented databases: expressive power, complexity, and restrictions

Published:01 June 1989Publication History

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.

References

  1. AH87a.S. Abiteboul and R. Hull. IFO: A formal semantic database model. A UM Trans. on Database Systems, 12(4):525-565, 1987. Google ScholarGoogle ScholarDigital LibraryDigital Library
  2. 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 ScholarGoogle ScholarDigital LibraryDigital Library
  3. 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 ScholarGoogle ScholarDigital LibraryDigital Library
  4. 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 ScholarGoogle ScholarDigital LibraryDigital Library
  5. 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 ScholarGoogle ScholarDigital LibraryDigital Library
  6. 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 ScholarGoogle ScholarCross RefCross Ref
  7. 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 ScholarGoogle ScholarCross RefCross Ref
  8. Cha81.A.K. Chandra. Programming primitives for database languages, in Proc. A CM Syrup. on Principles of Programming Languages, pages 50-62, 1981. Google ScholarGoogle ScholarDigital LibraryDigital Library
  9. GJ79.M.R. Garey and D.S. Johnson. Computers and Intractability: A Guide to the Theory of NP-Completeness. Freeman, 1979. Google ScholarGoogle ScholarDigital LibraryDigital Library
  10. 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 ScholarGoogle ScholarDigital LibraryDigital Library
  11. 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 ScholarGoogle Scholar
  12. HS89.R. Hull and J. Su. Untyped sets, invention, and computable queries. In Proe. A CM Syrup. on Principles of Database Systems, 1989. Google ScholarGoogle ScholarDigital LibraryDigital Library
  13. 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 ScholarGoogle ScholarDigital LibraryDigital Library
  14. HU79.J.E. Hopcroft and J.D. Ullman. Introduction to Automata Theory, Languages, and Computation. Addison Wesley, 1979. Google ScholarGoogle ScholarDigital LibraryDigital Library
  15. 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 ScholarGoogle ScholarDigital LibraryDigital Library
  16. Imm86.N. Immerman. Relational queries computable in polynomial time. Information and Control, 68:86-104, 1986. Google ScholarGoogle ScholarDigital LibraryDigital Library
  17. 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 ScholarGoogle ScholarDigital LibraryDigital Library
  18. 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 ScholarGoogle ScholarDigital LibraryDigital Library
  19. 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 ScholarGoogle ScholarDigital LibraryDigital Library
  20. 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 ScholarGoogle ScholarDigital LibraryDigital Library
  21. 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 ScholarGoogle ScholarDigital LibraryDigital Library
  22. Ull88.J.D. Ullman. Database and Knowledge-Base Systems, volume 1. Computer Science Press, 1988. Google ScholarGoogle ScholarDigital LibraryDigital Library
  23. 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 ScholarGoogle ScholarDigital LibraryDigital Library

Index Terms

  1. On accessing object-oriented databases: expressive power, complexity, and restrictions

                  Recommendations

                  Reviews

                  Felipe Carino

                  Four contributions to the area of object-oriented database (OODB) access compose this paper: (1) introduction of a formal framework for studying the power and complexity of OODB queries, (2) articulation and comparison of three alternative approaches for incorporating sets into OODBs, (3) a body of theoretical results concerning the expressive power and complexity of data access to OODBs that incorporate sets in three ways, and (4) description of a new relational query language, Algebra + pointwise recursion (ALG+pwrec). In the introduction, the authors compare the expressive power of OODB queries and relational database queries using the natural correspondence between OODB and relational schemas. They devote a major portion of the paper to the explicit definition of various aspects of OODB, since the field is young and there is no widely accepted formalism. The second contribution consists of three types of approaches: semantic database schemas and instances without multivalued attributes (which can have set-valued types); object-oriented database schemas (a semantic schema with methods, where methods cannot introduce new types into a schema); and an OODB imperative language (Smalltalk) or the existing programming language C.<__?__Pub Fmt eos-space> Operational semantics provided for method calls on OODB instances are based on method execution trees (METs), which provide a faithful copy of object-oriented system semantics. METs consist of three types: successful, aborted, and nonterminating. The data access model uses a simple correspondence between semantic, OODB, and relational schemas to introduce the notion of OODB access languages. The authors' third contribution defines hyper-exponential complexity, then defines elementary queries x to consist of the set of relational mappings having hyper-exponential complexity. In addition, computable queries C are defined to contain relational mappings computable by Turing machines x ?C . The authors then analyze three semantic approaches to set modeling: object-based semantics, value-based semantics, and the algebraic OODB model (which employs multivalued attributes instead of set-valued types, and method implementations that use relational algebra operators with no side effects). If the <__?__Pub Fmt italic>new<__?__Pub Fmt /italic> operator is prohibited, the paper shows their respective time (space) complexity—PSPACE complexity for the object-based semantic approach, hyper-exponential complexity for the value-based approach, and PTIME complexity for the algebraic OODB approach. The fourth contribution introduces a new relational query language, Algebra + pointwise recursion (ALG+pwrec). The paper shows that ALG+pwrec is a proper extension of relational algebra (and calculus) that permits some forms of transitivity and recursion; has the ability to perform generalized transitive closure operations, without reference structures outside the relational model; and is<__?__Pub Caret> equivalent in expressive power to an algebraic OODB language specified in the paper. I would recommend this well-written paper to anyone interested in OODB formalisms and semantic modeling. The semantic modeling time (space) complexity analysis restricted the use of the new operator. In order for this excellent body of work to have future general-purpose value, the new operator must be allowed, however.

                  Access critical reviews of Computing literature here

                  Become a reviewer for Computing Reviews.

                  Comments

                  Login options

                  Check if you have access through your login credentials or your institution to get full access on this article.

                  Sign in
                  • Published in

                    cover image ACM Conferences
                    SIGMOD '89: Proceedings of the 1989 ACM SIGMOD international conference on Management of data
                    June 1989
                    451 pages
                    ISBN:0897913175
                    DOI:10.1145/67544

                    Copyright © 1989 ACM

                    Permission to make digital or hard copies of all or part of this work for personal or classroom use is granted without fee provided that copies are not made or distributed for profit or commercial advantage and that copies bear this notice and the full citation on the first page. Copyrights for components of this work owned by others than ACM must be honored. Abstracting with credit is permitted. To copy otherwise, or republish, to post on servers or to redistribute to lists, requires prior specific permission and/or a fee. Request permissions from [email protected]

                    Publisher

                    Association for Computing Machinery

                    New York, NY, United States

                    Publication History

                    • Published: 1 June 1989

                    Permissions

                    Request permissions about this article.

                    Request Permissions

                    Check for updates

                    Qualifiers

                    • Article

                    Acceptance Rates

                    Overall Acceptance Rate785of4,003submissions,20%

                  PDF Format

                  View or Download as a PDF file.

                  PDF

                  eReader

                  View online with eReader.

                  eReader