Abstract
As a foundation for providing semantics for aggregation within recursion, the structure of subsets of partially ordered domains is studied. We argue that the underlying cause of many of the difficulties encountered in extending deductive database semantics to include aggregation is that set construction does not preserve the structure of the underlying domain very well. We study a binary relation ⊏ that is stronger than the standard ⊂, contrasting its properties on domains with differing amounts of structure. An analogous ≻ is defined that is more appropriate than R[ for minimization problems.
A class of aggregate functions, based on structural recursion, is defined formally. Proposed language constructs permit users to define their own interpreted functions and aggregates.
Several relational algebra operations are not monotonic w.r.t. ⊏. To overcome this problem, unfolding is proposed to “bury” the nonmonotonic operations inside aggregation.
Preview
Unable to display preview. Download preview PDF.
References
C. Beeri, R. Ramakrishnan, D. Srivastava, and S. Sudarshan. The valid model semantics for logic programs. In ACM Symposium on Principles of Database Systems, 1992.
S. Burris and H. P. Sankappanavar. A Course in Universal Algebra. Springer-Verlag, New York, 1981.
V. Breazu-Tannen, P. Buneman, and L. Wong. Naturally embedded query languages. In Int'l Conf. on Database Theory, 1992.
M. Escobar-Molano, R. Hull, and D. Jacobs. Safety and translation of calculus queries with scalar functions. In ACM Symposium on Principles of Database Systems, 1993.
G. Ganguly, S. Greco, and C. Zaniolo. Minimum and maximum predicates in logic programs. In ACM Symposium on Principles of Database Systems, pages 154–163, 1991.
D. B. Kemp and P. J. Stuckey. Semantics of logic programs with aggregates. In International Logic Programming Symposium, pages 387–401, 1991.
R. Ramakrishnan, F. Bancilhon, and A. Silberschatz. Safety of recursive horn clauses with infinite relations. In ACM Symposium on Principles of Database Systems, 1987.
K. A. Ross and Y. Sagiv. Monotonic aggregation in deductive databases. In ACM Symposium on Principles of Database Systems, 1992.
S. Sudarshan and R. Ramakrishnan. Aggregation and relevance in deductive databases. In Seventeenth International Conference on Very Large Data Bases, pages 501–511, 1991.
D. Stemple and T. Sheard. Specification and verification of abstract database types. In ACM Symposium on Principles of Database Systems, pages 248–257, 1984.
T. Sheard and D. Stemple. Automatic verification of database transaction safety. ACM Transactions on Database Systems, 14(3):322–368, 1991.
A. Van Gelder. The well-founded semantics of aggregation. In ACM Symposium on Principles of Database Systems, 1992.
L. Wong. Normal forms and conservative prpoperties for query languages over collection types. In ACM Symposium on Principles of Database Systems, 1993.
Author information
Authors and Affiliations
Editor information
Rights and permissions
Copyright information
© 1993 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Van Gelder, A. (1993). Foundations of aggregation in deductive databases. In: Ceri, S., Tanaka, K., Tsur, S. (eds) Deductive and Object-Oriented Databases. DOOD 1993. Lecture Notes in Computer Science, vol 760. Springer, Berlin, Heidelberg. https://doi.org/10.1007/3-540-57530-8_2
Download citation
DOI: https://doi.org/10.1007/3-540-57530-8_2
Published:
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-57530-6
Online ISBN: 978-3-540-48212-3
eBook Packages: Springer Book Archive