Solving queries by tree projections
- 1 September 1993
- journal article
- Published by Association for Computing Machinery (ACM) in ACM Transactions on Database Systems
- Vol. 18 (3) , 487-511
- https://doi.org/10.1145/155271.155277
Abstract
Suppose a database schema D is extended to D¯ by adding new relation schemas, and states for D are extended to states for D¯ by applying joins and projections to existing relations. It is shown that certain desirable properties that D¯ has with respect to D . These properties amount to the ability to compute efficiently the join of all relations in a state for D from an extension of this state over D¯ . The equivalence is proved for unrestricted (i.e., both finite and infinite) databases. If D¯ is obtained from D by adding a set of new relation schemas that form a tree schema, then the equivalence also holds for finite databases. In this case there is also a polynomial time algorithm for testing the existence of a tree projection of D¯ with respect to D .Keywords
This publication has 24 references indexed in Scilit:
- A provably efficient algorithm for dynamic storage allocationJournal of Computer and System Sciences, 1989
- An extension of conflict-free multivalued dependency setsACM Transactions on Database Systems, 1984
- The tree projection theorem and relational query processingJournal of Computer and System Sciences, 1984
- Testing containment of conjunctive queries under functional and inclusion dependenciesJournal of Computer and System Sciences, 1984
- Acyclic join dependency and data base projectionsJournal of Computer and System Sciences, 1983
- Syntactic Characterization of Tree Database SchemasJournal of the ACM, 1983
- Degrees of acyclicity for hypergraphs and relational database schemesJournal of the ACM, 1983
- Tree queriesACM Transactions on Database Systems, 1982
- Using Semi-Joins to Solve Relational QueriesJournal of the ACM, 1981
- Testing implications of data dependenciesACM Transactions on Database Systems, 1979