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

One-sided recursions

Published: 01 June 1987 Publication History

Abstract

The performance of systems with recursive query languages can be improved by recognizing simple, easily evaluable classes of recursions and using algorithms tailored to these classes whenever possible. In this paper we identify a useful subset of recursive definitions, the one-sided recursions. We show how to detect one-sided recursions, and give two simple evaluation algorithms that cover one-sided definitions in that for any selection on a one-sided definition, at least one of the two algorithms will apply. These algorithms have simple termination conditions, maintain minimal state and use selections on the recursively defined relation whenever possible. We show that there are no similar algorithms for many-sided recursions We also prove that it is undecidable whether an arbitrary definition has an equivalent one-sided definition. However, we do present a procedure that converts many potentially one-sided recursions to one-sided form, and prove it complete for a useful class of recursions.

References

[1]
Alfled V Aho and Jeffrey D Ullman Universality of data retrieval languages. In Proceedings of the Sixth ACM Symposium on Principles of Programming Lauguages, pages 110-120, 1979
[2]
Francois Bancllhon, David Maier, Yehoshua Sagiv, and Jeffiey D Ullman. Magic sets and other strange ways to implement logic programs in Proceedings of the ACM SIGACT-SIGMOD Symposium on Principles of Database Systems, 1986
[3]
Francios Bancihon, and Raghn Ramakrishnan An amateur's introduction to recursive query processing strategies In Proceedings of the ACM SIGMOD International Conference on Management of Data, 1986
[4]
C Chang On the evaluation of queries containing derived relationds in a relational data base In H Gallalre, J Minker, and J Nicolas, edilors, Advances in Data Base Theory, Volume 1, Plenum Press, 1981
[5]
Hiam Gaifman, Harry Manson, Yehoshua Sagiv, and Moshe Y Vardi Undecidable optimization problems for database logic programs December 1986 Unpublsihed manuscript
[6]
Micheal R Genesereth The MRS Casebook Technical Report IIPP-83-26, Stanford University. May 1983
[7]
Lawrence J Henschen and Shanum A Naqvi On compiling queries in recursive first order databases JACM, 31(1) 47-85. 1984
[8]
H V Jagadish and Rakesh Agtawal A study of transitive closure as a recutslon mechanism 1986 Unpublished Manuscript
[9]
Paris C Kanellakis Logic Programming and Parallel Complexity Technical Report CS-86 23, Brown University, October 1986
[10]
Jack Minker and Jean M Nicolas On recursive axioms in relational databases lnformation Systems, 8(1) 1 13, 1q82
[11]
Jeffrey F Nauton Data independent recusionin deductive databases In Proceedings of the ACM SIGACT-SIGMOD Symposium on Principles of Database Systems, 1986
[12]
Jeffrey F Naughton One sided recursions 1987 Stanford TR, to appear
[13]
Jeffrey F Naughton Optimizing Function,- free Recursive Inference Rules Technical Report STAN-CS-86-1114, Stanford, May 1986
[14]
Linda Ness Reducing Lenear Recursive Relations to Transitive Closure Technical Report TR-86-25, University of Texas, at Austin, November 1986
[15]
Yehoshua Sagiv Optimizing datalog programs ln Proceedings of the ACM SIGACT-SIGARE- SIGMOD Symposium on Principles of Database Systems, March 1987

Cited By

View all
  • (2013)2D-BarcodeProceedings of the 2013 International Conference on Computational and Information Sciences10.1109/ICCIS.2013.437(1675-1678)Online publication date: 21-Jun-2013
  • (2007)Evaluation of a deductive database system for CAD applicationsSystems and Computers in Japan10.1002/scj.469023130223:13(15-27)Online publication date: 21-Mar-2007
  • (2005)Normalization of linear recursions based on graph transformationsInformation Systems and Data Management10.1007/3-540-60584-3_38(265-282)Online publication date: 2-Jun-2005
  • Show More Cited By

Recommendations

Comments

Information & Contributors

Information

Published In

cover image ACM Conferences
PODS '87: Proceedings of the sixth ACM SIGACT-SIGMOD-SIGART symposium on Principles of database systems
June 1987
363 pages
ISBN:0897912233
DOI:10.1145/28659
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 June 1987

Permissions

Request permissions for this article.

Check for updates

Qualifiers

  • Article

Conference

PODS '87
Sponsor:
PODS '87: Principles of database systems
March 23 - 25, 1987
California, San Diego, USA

Acceptance Rates

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

Contributors

Other Metrics

Bibliometrics & Citations

Bibliometrics

Article Metrics

  • Downloads (Last 12 months)54
  • Downloads (Last 6 weeks)7
Reflects downloads up to 15 Jan 2025

Other Metrics

Citations

Cited By

View all
  • (2013)2D-BarcodeProceedings of the 2013 International Conference on Computational and Information Sciences10.1109/ICCIS.2013.437(1675-1678)Online publication date: 21-Jun-2013
  • (2007)Evaluation of a deductive database system for CAD applicationsSystems and Computers in Japan10.1002/scj.469023130223:13(15-27)Online publication date: 21-Mar-2007
  • (2005)Normalization of linear recursions based on graph transformationsInformation Systems and Data Management10.1007/3-540-60584-3_38(265-282)Online publication date: 2-Jun-2005
  • (2005)Strategies for parallel linear recursive query processingRules in Database Systems10.1007/3-540-60365-4_129(211-229)Online publication date: 2-Jun-2005
  • (2005)On the power of query-independent compilationAdvances in Computing and Information — ICCI '9110.1007/3-540-54029-6_168(185-196)Online publication date: 1-Jun-2005
  • (2005)Decomposition of linear recursive logic programsGraph-Theoretic Concepts in Computer Science10.1007/3-540-53832-1_50(291-310)Online publication date: 7-Jun-2005
  • (2005)The processing and evaluation of transitive closure queriesAdvances in Database Technology—EDBT '8810.1007/3-540-19074-0_47(49-75)Online publication date: 24-May-2005
  • (1999)Regular Path Queries with ConstraintsJournal of Computer and System Sciences10.1006/jcss.1999.162758:3(428-452)Online publication date: 1-Jun-1999
  • (1997)Regular path queries with constraintsProceedings of the sixteenth ACM SIGACT-SIGMOD-SIGART symposium on Principles of database systems10.1145/263661.263676(122-133)Online publication date: 1-May-1997
  • (1997)On the completeness of naive memoing in PrologNew Generation Computing10.1007/BF0303723515:2(141-162)Online publication date: 1-Jun-1997
  • Show More Cited By

View Options

View options

PDF

View or Download as a PDF file.

PDF

eReader

View online with eReader.

eReader

Login options

Media

Figures

Other

Tables

Share

Share

Share this Publication link

Share on social media