SOLVING QUERIES BY TREE PROJECTIONS

Authors
Citation
Y. Sagiv et O. Shmueli, SOLVING QUERIES BY TREE PROJECTIONS, ACM transactions on database systems, 18(3), 1993, pp. 487-511
Citations number
31
Categorie Soggetti
Computer Sciences","Computer Applications & Cybernetics
ISSN journal
03625915
Volume
18
Issue
3
Year of publication
1993
Pages
487 - 511
Database
ISI
SICI code
0362-5915(1993)18:3<487:SQBTP>2.0.ZU;2-X
Abstract
Suppose a database schema D is extended to DBAR by adding new relation schemas, and states for D are extended to states for DBAR by applying joins and projections to existing relations. It is shown that certain desirable properties that DBAR has with respect to D are equivalent t o the existence of a tree projection of DBAR with respect to D. These properties amount to the ability to compute efficiently the join of al l relations in a state for D from an extension of this state over DBAR . The equivalence is proved for unrestricted (i.e., both finite and in finite) databases. If DBAR is obtained from D by adding a set of new r elation schemas that form a tree schema, then the equivalence also hol ds for finite databases. In this case there is also a polynomial time algorithm for testing the existence of a tree projection of DBAR with respect to D.