Magic conditions
- 1 March 1996
- journal article
- Published by Association for Computing Machinery (ACM) in ACM Transactions on Database Systems
- Vol. 21 (1) , 107-155
- https://doi.org/10.1145/227604.227624
Abstract
Much recent work has focused on the bottom-up evaluation of Datalog programs [Bancilhon and Ramakrishnan 1988]. One approach, called magic-sets, is based on rewriting a logic program so that bottom-up fixpoint evaluation of the program avoids generation of irrelevant facts [Bancilhon et al. 1986; Beeri and Ramakrishnan 1987; Ramakrishnan 1991]. It was widely believed for some time that the principal application of the magic-sets technique is to restrict computation in recursive queries using equijoin predicates. We extend the magic-sets transformation to use predicates other than equality ( X >10, for example) in restricting computation. The resulting ground magic-sets transformation is an important step in developing an extended magic-sets transformation that has practical utility in “real” relational databases, not only for recursive queries, but for nonrecursive queries as well [Mumick et al. 1990b; Mumick 1991].Keywords
This publication has 18 references indexed in Scilit:
- Implementation of magic-sets in a relational database systemPublished by Association for Computing Machinery (ACM) ,1994
- Compiling query constraints (extended abstract)Published by Association for Computing Machinery (ACM) ,1994
- Pushing constraint selectionsThe Journal of Logic Programming, 1993
- Magic templates: a spellbinding approach to logic programsThe Journal of Logic Programming, 1991
- Magic conditionsPublished by Association for Computing Machinery (ACM) ,1990
- Starburst mid-flight: as the dust clears (database project)IEEE Transactions on Knowledge and Data Engineering, 1990
- On the power of magicPublished by Association for Computing Machinery (ACM) ,1987
- Implementation of logical query languages for databasesACM Transactions on Database Systems, 1985
- Magic sets and other strange ways to implement logic programs (extended abstract)Published by Association for Computing Machinery (ACM) ,1985
- On optimizing an SQL-like nested queryACM Transactions on Database Systems, 1982