Extension Joins.
Peter Honeyman:
Extension Joins.
VLDB 1980: 239-244@inproceedings{DBLP:conf/vldb/Honeyman80,
author = {Peter Honeyman},
title = {Extension Joins},
booktitle = {Sixth International Conference on Very Large Data Bases, October
1-3, 1980, Montreal, Quebec, Canada, Proceedings},
publisher = {IEEE Computer Society},
year = {1980},
pages = {239-244},
ee = {db/conf/vldb/Honeyman80.html},
crossref = {DBLP:conf/vldb/80},
bibsource = {DBLP, http://dblp.uni-trier.de}
}
BibTeX
Abstract
In proving that a set of relation schemes is a lossless decomposition
of a set of attributes, it is sometimes possible to derive a sequence of extension
joins whlich, upon execution, computes the join of the corresponding relations.
Unlike natural join, any sequence of extension joins, which are really projections
followed by joins, can be computed in polynomial time. The technique is
effective in the important cases of decomposition into independent components
and database schemes produced by Codd's third normal form algorithm.
Copyright © 1980 by The Institute of
Electrical and Electronic Engineers, Inc. (IEEE).
Abstract used with permission.
CDROM Version: Load the CDROM "Volume 1 Issue 4, VLDB '75-'88" and ...
DVD Version: Load ACM SIGMOD Anthology DVD 1" and ...
BibTeX
Printed Edition
Sixth International Conference on Very Large Data Bases, October 1-3, 1980, Montreal, Quebec, Canada, Proceedings.
IEEE Computer Society 1980
Contents BibTeX
References
- [1]
- Alfred V. Aho, Catriel Beeri, Jeffrey D. Ullman:
The Theory of Joins in Relational Databases.
ACM Trans. Database Syst. 4(3): 297-314(1979) BibTeX
- [2]
- Adarsh K. Arora, C. Robert Carlson:
The Information Preserving Properties of Relational Database Transformations.
VLDB 1978: 352-359 BibTeX
- [3]
- Catriel Beeri, Philip A. Bernstein:
Computational Problems Related to the Design of Normal Form Relational Schemas.
ACM Trans. Database Syst. 4(1): 30-59(1979) BibTeX
- [4]
- Catriel Beeri, Peter Honeyman:
Preserving Functional Dependencies.
SIAM J. Comput. 10(3): 647-656(1981) BibTeX
- [5]
- Catriel Beeri, Alberto O. Mendelzon, Yehoshua Sagiv, Jeffrey D. Ullman:
Equivalence of Relational Database Schemes.
STOC 1979: 319-329 BibTeX
- [6]
- Philip A. Bernstein:
Synthesizing Third Normal Form Relations from Functional Dependencies.
ACM Trans. Database Syst. 1(4): 277-298(1976) BibTeX
- [7]
- Joachim Biskup, Umeshwar Dayal, Philip A. Bernstein:
Synthesizing Independent Database Schemas.
SIGMOD Conference 1979: 143-151 BibTeX
- [8]
- E. F. Codd:
A Relational Model of Data for Large Shared Data Banks.
Commun. ACM 13(6): 377-387(1970) BibTeX
- [9]
- E. F. Codd:
Further Normalization of the Data Base Relational Model.
IBM Research Report, San Jose, California RJ909: (1971) BibTeX
- [10]
- Ronald Fagin:
Multivalued Dependencies and a New Normal Form for Relational Databases.
ACM Trans. Database Syst. 2(3): 262-278(1977) BibTeX
- [11]
- David Maier, Alberto O. Mendelzon, Fereidoon Sadri, Jeffrey D. Ullman:
Adequacy of Decompositions of Relational Databases.
Advances in Data Base Theory 1979: 101-114 BibTeX
- [12]
- David Maier, Alberto O. Mendelzon, Yehoshua Sagiv:
Testing Implications of Data Dependencies.
ACM Trans. Database Syst. 4(4): 455-469(1979) BibTeX
- [13]
- ...
- [14]
- Jorma Rissanen:
Independent Components of Relations.
ACM Trans. Database Syst. 2(4): 317-325(1977) BibTeX
- [15]
- Jorma Rissanen:
Theory of Relations for Databases - A Tutorial Survey.
MFCS 1978: 536-551 BibTeX
Referenced by
- Mark Levene, George Loizou:
Database Design for Incomplete Relations.
ACM Trans. Database Syst. 24(1): 80-125(1999)
- Dominique Laurent, Jens Lechtenbörger, Nicolas Spyratos, Gottfried Vossen:
Complements for Data Warehouses.
ICDE 1999: 490-499
- Priti Mishra, Margaret H. Eich:
Join Processing in Relational Databases.
ACM Comput. Surv. 24(1): 63-113(1992)
- Héctor J. Hernández, Edward P. F. Chan:
Constant-Time-Maintainable BCNF Database Schemes.
ACM Trans. Database Syst. 16(4): 571-599(1991)
- Paolo Atzeni, Edward P. F. Chan:
Efficient Optimization of Simple Chase Join Expressions.
ACM Trans. Database Syst. 14(2): 212-230(1989)
- Jeffrey D. Ullman:
Principles of Database and Knowledge-Base Systems, Volume II.
Computer Science Press 1989, ISBN 0-7167-8162-X
Contents - Héctor J. Hernández, Edward P. F. Chan:
A Characterization of Constant-time-mainteinability for BCNF Database Schemes.
SIGMOD Conference 1988: 209-217
- Edward P. F. Chan, Héctor J. Hernández:
Independence-reducible Database Schemes.
PODS 1988: 163-173
- Paolo Atzeni, Maria Cristina De Bernardis:
A New Basis for the Weak Instance Model.
PODS 1987: 79-86
- Marc H. Graham, Ke Wang:
Constant Time Maintenance or The Triumph of the fd.
PODS 1986: 202-216
- Edward P. F. Chan, Héctor J. Hernández:
On the Desirability of gamma-Acyclic BCNF Database Schemes.
ICDT 1986: 105-122
- Arthur M. Keller:
Algorithms for Translating View Updates to Database Updates for Views Involving Selections, Projections, and Joins.
PODS 1985: 154-163
- Paolo Atzeni, Edward P. F. Chan:
Efficient Query Answering in the Representative Instance Approach.
PODS 1985: 181-188
- Edward P. F. Chan:
Optimal Computation of Total Projections with Unions of Simple Chase Join Expressions.
SIGMOD Conference 1984: 149-163
- Yehoshua Sagiv:
A Characterization of Globally Consistent Databases and Their Correct Access Paths.
ACM Trans. Database Syst. 8(2): 266-286(1983)
- David Maier, David Rozenshtein, David Scott Warren:
Windows on the World.
SIGMOD Conference 1983: 68-78
- Peter Honeyman, Edward Sciore:
A New Characterization of Independence.
SIGMOD Conference 1983: 92-96
- Stavros S. Cosmadakis:
The Complexity of Evaluating Relational Queries.
PODS 1983: 149-155
- David Maier:
The Theory of Relational Databases.
Computer Science Press 1983, ISBN 0-914894-42-0
Contents - Sharon McCure Kuck, Yehoshua Sagiv:
A Universal Relation Database System Implemented via the Network Model.
PODS 1982: 147-157
- Yehoshua Sagiv:
Can We Use the Universal Instance Assumption Without Using Nulls?
SIGMOD Conference 1981: 108-120
BibTeX
ACM SIGMOD Anthology - DBLP:
[Home | Search: Author, Title | Conferences | Journals]
VLDB Proceedings (1977-1981): Copyright © by IEEE,
ACM SIGMOD Anthology: Copyright © by ACM (info@acm.org), Corrections: anthology@acm.org
DBLP: Copyright © by Michael Ley (ley@uni-trier.de), last change: Sat May 16 23:45:09 2009