The Magic of Duplicates and Aggregates.
Inderpal Singh Mumick, Hamid Pirahesh, Raghu Ramakrishnan:
The Magic of Duplicates and Aggregates.
VLDB 1990: 264-277@inproceedings{DBLP:conf/vldb/MumickPR90,
author = {Inderpal Singh Mumick and
Hamid Pirahesh and
Raghu Ramakrishnan},
editor = {Dennis McLeod and
Ron Sacks-Davis and
Hans-J{\"o}rg Schek},
title = {The Magic of Duplicates and Aggregates},
booktitle = {16th International Conference on Very Large Data Bases, August
13-16, 1990, Brisbane, Queensland, Australia, Proceedings},
publisher = {Morgan Kaufmann},
year = {1990},
isbn = {1-55860-149-X},
pages = {264-277},
ee = {db/conf/vldb/MumickPR90.html},
crossref = {DBLP:conf/vldb/90},
bibsource = {DBLP, http://dblp.uni-trier.de}
}
Abstract
We present a formal treatment of multi- sets (that arise when duplicates are not eliminated) and aggregate operators for deductive and relational databases.
We define the semantics rigorously and extend the Magic- Sets technique to programs containing multi- sets and aggregates.
The work presented here is an important step in demonstrating the applicability of the Magic-Sets technique for optimizing queries in commercial query languages such as SQL.
Copyright © 1990 by the VLDB Endowment.
Permission to copy without fee all or part of this material is granted provided that the copies are not made or
distributed for direct commercial advantage, the VLDB
copyright notice and the title of the publication and
its date appear, and notice is given that copying
is by the permission of the Very Large Data Base
Endowment. To copy otherwise, or to republish, requires
a fee and/or special permission from the Endowment.
Online Paper
CDROM Version: Load the CDROM "Volume 1 Issue 5, VLDB '89-'97" and ...
DVD Version: Load ACM SIGMOD Anthology DVD 1" and ...
Printed Edition
Dennis McLeod, Ron Sacks-Davis, Hans-Jörg Schek (Eds.):
16th International Conference on Very Large Data Bases, August 13-16, 1990, Brisbane, Queensland, Australia, Proceedings.
Morgan Kaufmann 1990, ISBN 1-55860-149-X
References
- [ABC+76]
- Morton M. Astrahan, Mike W. Blasgen, Donald D. Chamberlin, Kapali P. Eswaran, Jim Gray, Patricia P. Griffiths, W. Frank King III, Raymond A. Lorie, Paul R. McJones, James W. Mehl, Gianfranco R. Putzolu, Irving L. Traiger, Bradford W. Wade, Vera Watson:
System R: Relational Approach to Database Management.
ACM Trans. Database Syst. 1(2): 97-137(1976)
- [ABW88]
- Krzysztof R. Apt, Howard A. Blair, Adrian Walker:
Towards a Theory of Declarative Knowledge.
Foundations of Deductive Databases and Logic Programming. 1988: 89-148
- [BMSU86]
- François Bancilhon, David Maier, Yehoshua Sagiv, Jeffrey D. Ullman:
Magic Sets and Other Strange Ways to Implement Logic Programs.
PODS 1986: 1-15
- [BNR+87]
- Catriel Beeri, Shamim A. Naqvi, Raghu Ramakrishnan, Oded Shmueli, Shalom Tsur:
Sets and Negation in a Logic Database Language (LDL1).
PODS 1987: 21-37
- [BR87]
- Catriel Beeri, Raghu Ramakrishnan:
On the Power of Magic.
PODS 1987: 269-284
- [CH85]
- Ashok K. Chandra, David Harel:
Horn Clauses Queries and Generalizations.
J. Log. Program. 2(1): 1-15(1985)
- [CKW89]
- Weidong Chen, Michael Kifer, David Scott Warren:
HiLog: A First-Order Semantics for Higher-Order Logic Programming Constructs.
NACLP 1989: 1090-1114
- [CM90]
- Mariano P. Consens, Alberto O. Mendelzon:
Low Complexity Aggregation in GraphLog and Datalog.
ICDT 1990: 379-394
- [ISO89]
- ...
- [Klu82]
- Anthony C. Klug:
Equivalence of Relational Algebra and Relational Calculus Query Languages Having Aggregate Functions.
J. ACM 29(3): 699-717(1982)
- [KM89]
- ...
- [Kup87]
- Gabriel M. Kuper:
Logic Programming With Sets.
PODS 1987: 11-20
- [KW89]
- Michael Kifer, James Wu:
A Logic for Object-Oriented Logic Programming (Maier's O-Logic Revisited).
PODS 1989: 379-393
- [MFPR90a]
- Inderpal Singh Mumick, Sheldon J. Finkelstein, Hamid Pirahesh, Raghu Ramakrishnan:
Magic Conditions.
PODS 1990: 314-330
- [MFPR90b]
- Inderpal Singh Mumick, Sheldon J. Finkelstein, Hamid Pirahesh, Raghu Ramakrishnan:
Magic is Relevant.
SIGMOD Conference 1990: 247-258
- [MP90]
- ...
- [MR89]
- Michael J. Maher, Raghu Ramakrishnan:
Déjà Vu in Fixpoints of Logic Programs.
NACLP 1989: 963-980
- [MUVG86]
- Katherine A. Morris, Jeffrey D. Ullman, Allen Van Gelder:
Design Overview of the NAIL! System.
ICLP 1986: 554-568
- [NT88]
- Shamim A. Naqvi, Shalom Tsur:
A Logical Language for Data and Knowledge Bases.
Computer Science Press 1989, ISBN 0-7167-8200-6
- [OOM87]
- Gultekin Özsoyoglu, Z. Meral Özsoyoglu, Victor Matos:
Extending Relational Algebra and Relational Calculus with Set-Valued Attributes and Aggregate Functions.
ACM Trans. Database Syst. 12(4): 566-592(1987)
- [Pir89]
- ...
- [Prz88]
- Teodor C. Przymusinski:
On the Declarative Semantics of Deductive Databases and Logic Programs.
Foundations of Deductive Databases and Logic Programming. 1988: 193-216
- [Ros90]
- Kenneth A. Ross:
Modular Stratification and Magic Sets for DATALOG Programs with Negation.
PODS 1990: 161-171
- [Ull88]
- Jeffrey D. Ullman:
Principles of Database and Knowledge-Base Systems, Volume I.
Computer Science Press 1988, ISBN 0-7167-8158-1
Contents - [Ull89]
- Jeffrey D. Ullman:
Principles of Database and Knowledge-Base Systems, Volume II.
Computer Science Press 1989, ISBN 0-7167-8162-X
Contents - [VBKL90]
- ...
Copyright © Fri Mar 12 17:22:50 2010
by Michael Ley (ley@uni-trier.de)