Location via proxy:   [ UP ]  
[Report a bug]   [Manage cookies]                
skip to main content
10.1145/308386.308409acmconferencesArticle/Chapter ViewAbstractPublication PagespodsConference Proceedingsconference-collections
Article
Free access

On the expressive power of database queries with intermediate types

Published: 01 March 1988 Publication History

Abstract

The set-height of a complex object type is defined to be its level of nesting of the set construct. In a query of the complex object calculus which maps a database D to an output type T, an intermediate type is a type which is used by some variable of the query, but which is not present in D or T. For each k, i ≥ 0 we define CALCk,i to be the family of calculus queries mapping from and to types with set-height ≤ k and using intermediate types with set-height ≤ i In particular, CALC0,0 is the relational calculus, and CALC0,1 is equivalent to the family of second-order (relational) queries
Several results concerning these families of languages are obtained. A primary focus is on the families CALC0,i, which map relations to relations Upper bounds on the complexity of these families are provided, and it is shown that CALC0,3 has at least the complexity of exponential space. The CALC0,i hierarchy does not collapse, because for each i, CALC0,i is strictly less expressive than CALC0,i+2. The union ∪0≤iCALC0,i is strictly less expressive than the family of 'computable' database queries.
The expressive power of queries from the complex object calculus interpreted using a semantics based on the use of arbitrarily large finite numbers of invented values is studied. Under this semantics, the expressive power of the relational calculus is not increased, and the CALC0,i hierarchy collapses at CALC0,1. We also consider queries which use a bounded number of invented values.

References

[1]
Serge Abiteboul and Catnel Been On the manipulation of complex objects (extended abstract), in Proc. Intl. Workshop on Tlteo~ and ApplicaLions of IV~d Rela~ and Complez Objects, Darmstadt, April 1987.
[2]
K. Apt, H. Blair, and A. Walker. Toward a theory of declarative knowledge. In Proc. of Workdwp on Foundations of Deduchee Databasea and Lo~c P~mmmg, 1986.
[3]
S. Abiteboul and S. Grumbach. COL: a language for complex objects based on recuxdve rules (extended abstract). in Proc. Workdtop on Dutabase Ply. 9rammin9 /;angeages, Roscoff, France, September 1987.
[4]
S. Abiteboul and R. Hull. IFO: a formal semantic database model. A CM 23~ns. on Databgse Sy~enu, Dec. 1987. to appeal
[5]
A.V. Alto and J. D. Ulimaa. Uaivenality of data retrieval languages. In ~. A CM $~p. on Prine,plu of Programming/;ongeages, pages 110-120, 1979.
[6]
Serge Abiteboul and Victor Vianu. Procedural and d~!~ative database update lsngug~, this pm~g.
[7]
Serge Abiteboul and Victor Vianu. A transaction language complete for database update and spedfieation. In Proc. A CM Strop. on Principles of Database Systems, pages 260-268, 1987.
[8]
J.H. Bennett. On Spectra. PhD thesis, Princeton Univ~ty, Pz}inceton, N.J., 1962.
[9]
F. Banc/lhon and S. Khoshdan. A ~aleulu for complex objects. In Proc. A CM $1~np. on P~nciplet of Database Systems, 1986.
[10]
C. Beed, S. Naqvi, R. Ramakrishnan, O. Sehmueli, and S. Taut. Sets sad negstion in s logic database language ( L D L 1). In P~. ACM S~p. on PMnc,ples of Database Systcn., 1987.
[11]
Ashok K. Chandrs and David Hazel. Computable queries for relational data bases. Journal of Computer and System Sc,ences, 21(2):156--178, Oct. 1980.
[12]
Ashok K. Chandra and David H~rel. Horn clauses and the fixpoint query 111- erarchy. In Proc A CM Syrup. on Pr~nc:- pies of Database Systems, pages 158-163, 1982
[13]
Ashok K. Chandra and David Hare} Structure and complexity of relational queries. Journal of Computer and System Sc:ences, 25:99-128, 1982.
[14]
P C. Fischer and S J. Thomas. Operators for non-ftrst-normal-form relations. In Proc IEEE Computer Software A pphcahons Conference, pages 464-475, 1983
[15]
R. Hull and R King Semantic database modeling, survey, applications, and research Lmues. A CM Compuhng Surveys, June 1987. to appear.
[16]
M. Hammer and D. McLeod. Database description with SDM: s semantic database model. A CM Trans. on Database Systems, 6(3).351-386, 1981.
[17]
R. Hull. Relative information capa~ty of simple relational schemata. SIAM Journal of Compuhng, 15(3) 856-886, August 1986.
[18]
R. Hull. A survey of theoretical research on typed complex database objects. In J Paredaens, editor, Databases, pages 193- 256, Academic Press (London), 1987.
[19]
Barry Jacobs. On database logic. 3. A cu, 29(2):slo-ss2, 1982.
[20]
B. Jaeschke and H. J. Schek Remarks on the algebra of non first normal form relations. In Proc. A CM 5IGA CT-SIGMOD Syrup. on Prmcsples of Database Systems, 1982.
[21]
G M. Kuper. Logic programming with sets. In P~oc. A CM Syrup on Prmcsples of Database S~stems, pages 11-20, 1987.
[22]
G.M. Kuper and M.Y. Vazdi personal communication.
[23]
Gabriel M. Kuper and Moshe Y Vazdl A new approach to database logic In Proc. A GM Syrup on P~ncsples of Database Systems, pages 86-96, 1984
[24]
David Msier. The Theory of Relatwnal Databases Computer Science Press, Potomac, Maryland, 1983.
[25]
Michael Mschtcy and Paul Young. An Introductson to the General Theory o~ Algo~hms. North Holland, New York, 1979.
[26]
J. Psredaens and D. van Gucht. Posdbdities and limitations of using fiat operatozs in nested algebra expressions, this pzoceedmgs.
[27]
M.A. Roth, H. F. Korth, and A. Silberschats. Eztended algebra and cakulus for not lNF Relatsonal Databases. Technical Report TR-85-19, University of Texas st Austin, 1985.
[28]
D. Shipman. The functional model and the data language daplex. A CM Trans. on Database SyJtems, 6(1):140- 173, 1981.
[29]
Jeffrey D. Ullmu. PMncsplea of Database Systems (~nd ed:t:on). Computer Science Press, Potomac, Maryland, 1982.
[30]
Moshe Y. V~di. The complexity of relational query languages. In Proc. A CM SXGA CT Syrup. on the Theory of Computing, pages 137-146, 1982.
[31]
A. van Gelder. Negation as fadure using tight derivations for general logic progrmm. In Proc. of Workshop on Foundat:ons of Deducts~e Databases and I, ogsc Programming, 1986.

Cited By

View all

Recommendations

Comments

Information & Contributors

Information

Published In

cover image ACM Conferences
PODS '88: Proceedings of the seventh ACM SIGACT-SIGMOD-SIGART symposium on Principles of database systems
March 1988
352 pages
ISBN:0897912632
DOI:10.1145/308386
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]

Sponsors

Publisher

Association for Computing Machinery

New York, NY, United States

Publication History

Published: 01 March 1988

Permissions

Request permissions for this article.

Check for updates

Qualifiers

  • Article

Conference

SIGMOD/PODS05

Acceptance Rates

Overall Acceptance Rate 642 of 2,707 submissions, 24%

Contributors

Other Metrics

Bibliometrics & Citations

Bibliometrics

Article Metrics

  • Downloads (Last 12 months)31
  • Downloads (Last 6 weeks)8
Reflects downloads up to 09 Nov 2024

Other Metrics

Citations

Cited By

View all
  • (2005)An algebra for pomsetsDatabase Theory — ICDT '9510.1007/3-540-58907-4_16(191-207)Online publication date: 2-Jun-2005
  • (2005)Evaluation and optimization of complex object selectionsDeductive and Object-Oriented Databases10.1007/3-540-55015-1_12(226-243)Online publication date: 4-Jun-2005
  • (2005)Playing games with objectsICDT '9010.1007/3-540-53507-1_68(25-38)Online publication date: 7-Jun-2005
  • (2005)An introduction to the completeness of languages for complex objects and nested relationsNested Relations and Complex Objects in Databases10.1007/3-540-51171-7_23(117-138)Online publication date: 2-Jun-2005
  • (2005)Four views of complex objects: A sophisticate's introductionNested Relations and Complex Objects in Databases10.1007/3-540-51171-7_22(85-116)Online publication date: 2-Jun-2005
  • (2005)Data models and languages for databasesICDT '8810.1007/3-540-50171-1_2(19-40)Online publication date: 1-Jun-2005
  • (2005)On the complexity of queries in the logical data modelICDT '8810.1007/3-540-50171-1_17(267-280)Online publication date: 1-Jun-2005
  • (1993)Database method schemas and object creationProceedings of the twelfth ACM SIGACT-SIGMOD-SIGART symposium on Principles of database systems10.1145/153850.153911(265-275)Online publication date: 1-Aug-1993
  • (1993)Towards tractable algebras for bagsProceedings of the twelfth ACM SIGACT-SIGMOD-SIGART symposium on Principles of database systems10.1145/153850.153855(49-58)Online publication date: 1-Aug-1993
  • (1993)Algebraic and calculus query languages for recursively typed complex objectsJournal of Computer and System Sciences10.1016/0022-0000(93)90022-O47:1(121-156)Online publication date: 1-Aug-1993
  • Show More Cited By

View Options

View options

PDF

View or Download as a PDF file.

PDF

eReader

View online with eReader.

eReader

Get Access

Login options

Media

Figures

Other

Tables

Share

Share

Share this Publication link

Share on social media