Database Decomposition into Fourth Normal Form.
Gösta Grahne, Kari-Jouko Räihä:
Database Decomposition into Fourth Normal Form.
VLDB 1983: 186-196@inproceedings{DBLP:conf/vldb/GrahneR83,
author = {G{\"o}sta Grahne and
Kari-Jouko R{\"a}ih{\"a}},
editor = {Mario Schkolnick and
Costantino Thanos},
title = {Database Decomposition into Fourth Normal Form},
booktitle = {9th International Conference on Very Large Data Bases, October
31 - November 2, 1983, Florence, Italy, Proceedings},
publisher = {Morgan Kaufmann},
year = {1983},
isbn = {0-934613-15-X},
pages = {186-196},
ee = {db/conf/vldb/GrahneR83.html},
crossref = {DBLP:conf/vldb/83},
bibsource = {DBLP, http://dblp.uni-trier.de}
}
BibTeX
Abstract
We present an algorithm that decom-
poses a database scheme when the dependency set
contains functional and multivalued dependencies.
The schemes in the resulting decomposition are in
fourth normal form and have a lossless join. Our
algorithm does not impose restrictions on the
allowed set of dependencies, and it never re-
quires the computation of the full closure of the
dependency set. Furthermore, the algorithm works
in polynomial time for classes of dependencies
that properly contain conflict-free dependency
sets.
Copyright © 1983 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 4, VLDB '75-'88" and ...
DVD Version: Load ACM SIGMOD Anthology DVD 1" and ...
BibTeX
Printed Edition
Mario Schkolnick, Costantino Thanos (Eds.):
9th International Conference on Very Large Data Bases, October 31 - November 2, 1983, Florence, Italy, Proceedings.
Morgan Kaufmann 1983, ISBN 0-934613-15-X
Contents BibTeX
References
- [ABU79]
- 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
- [AtP82]
- Paolo Atzeni, Douglas Stott Parker Jr.:
Assumptions in Relational Database Theory.
PODS 1982: 1-9 BibTeX
- [BBG78]
- Catriel Beeri, Philip A. Bernstein, Nathan Goodman:
A Sophisticate's Introduction to Database Normalization Theory.
VLDB 1978: 113-124 BibTeX
- [BeB79]
- 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
- [Bee80]
- Catriel Beeri:
On the Membership Problem for Functional and Multivalued Dependencies in Relational Databases.
ACM Trans. Database Syst. 5(3): 241-259(1980) BibTeX
- [BFM81]
- Catriel Beeri, Ronald Fagin, David Maier, Mihalis Yannakakis:
On the Desirability of Acyclic Database Schemes.
J. ACM 30(3): 479-513(1983) BibTeX
- [BeK83]
- Catriel Beeri, Michael Kifer:
Elimination of Intersection Anomalies from Database Schemes.
PODS 1983: 340-351 BibTeX
- [BDB79]
- Joachim Biskup, Umeshwar Dayal, Philip A. Bernstein:
Synthesizing Independent Database Schemas.
SIGMOD Conference 1979: 143-151 BibTeX
- [Cod72]
- E. F. Codd:
Further Normalization of the Data Base Relational Model.
IBM Research Report, San Jose, California RJ909: (1971) BibTeX
- [Cod74]
- E. F. Codd:
Recent Investigations in Relational Data Base Systems.
IFIP Congress 1974: 1017-1021 BibTeX
- [daS80]
- ...
- [Dat81]
- ...
- [Fag77]
- Ronald Fagin:
Multivalued Dependencies and a New Normal Form for Relational Databases.
ACM Trans. Database Syst. 2(3): 262-278(1977) BibTeX
- [Gal82]
- Zvi Galil:
An Almost Linear-Time Algorithm for Computing a Dependency Basis in a Relational Database.
J. ACM 29(1): 96-102(1982) BibTeX
- [HIT79]
- Kenichi Hagihara, Minoru Ito, Kenichi Taniguchi, Tadao Kasami:
Decision Problems for Multivalued Dependencies in Relational Databases.
SIAM J. Comput. 8(2): 247-264(1979) BibTeX
- [Lie81]
- Y. Edmund Lien:
Hierarchical Schemata for Relational Databases.
ACM Trans. Database Syst. 6(1): 48-69(1981) BibTeX
- [Lie82]
- Y. Edmund Lien:
On the Equivalence of Database Models.
J. ACM 29(2): 333-362(1982) BibTeX
- [Sci81]
- Edward Sciore:
Real-World MVD's.
SIGMOD Conference 1981: 121-132 BibTeX
- [TsF80]
- ...
- [Ull82a]
- Jeffrey D. Ullman:
The U. R. Strikes Back.
PODS 1982: 10-22 BibTeX
- [Ull82b]
- Jeffrey D. Ullman:
Principles of Database Systems, 2nd Edition.
Computer Science Press 1982, ISBN 0-914894-36-6
BibTeX
Referenced by
- Z. Meral Özsoyoglu, Li-Yan Yuan:
Reduced MVDs and Minimal Covers.
ACM Trans. Database Syst. 12(3): 377-394(1987)
- Mark A. Roth, Henry F. Korth:
The Design of ¬1NF Relational Databases into Nested Normal Form.
SIGMOD Conference 1987: 143-159
- Li-Yan Yuan, Z. Meral Özsoyoglu:
Logical Design of Relational Database Systems.
PODS 1987: 38-47
- Z. Meral Özsoyoglu, Li-Yan Yuan:
A Design Method for Nested Relational Databases.
ICDE 1987: 599-608
- Li-Yan Yuan, Z. Meral Özsoyoglu:
Unifying Functional and Multivalued Dependencies for Relational Database Design.
PODS 1986: 183-190
- Gösta Grahne, Kari-Jouko Räihä:
Dependency Characterizations for Acyclic Database Schemes.
PODS 1984: 9-18
BibTeX
ACM SIGMOD Anthology - DBLP:
[Home | Search: Author, Title | Conferences | Journals]
VLDB Proceedings: Copyright © by VLDB Endowment,
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:18 2009