Computational problems related to the design of normal form relational schemas-Reference-Cited by-同舟云学术

Computational problems related to the design of normal form relational schemas

Published:1979-03 Issue:1 Volume:4 Page:30-59
ISSN:0362-5915
Container-title:ACM Transactions on Database Systems
language:en
Short-container-title:ACM Trans. Database Syst.

Author:

Beeri Catriel¹,Bernstein Philip A.²

Affiliation:

1. Hebrew Univ., Jerusalem, Israel

2. Harvard Univ., Cambridge, MA

Abstract

Problems related to functional dependencies and the algorithmic design of relational schemas are examined. Specifically, the following results are presented: (1) a tree model of derivations of functional dependencies from other functional dependencies; (2) a linear-time algorithm to test if a functional dependency is in the closure of a set of functional dependencies; (3) a quadratic-time implementation of Bernstein's third normal form schema synthesis algorithm. Furthermore, it is shown that most interesting algorithmic questions about Boyce-Codd normal form and keys are NP -complete and are therefore probably not amenable to fast algorithmic solutions.

Publisher

Association for Computing Machinery (ACM)

Subject

Information Systems

Link

https://dl.acm.org/doi/pdf/10.1145/320064.320066

Reference25 articles.

1. AHo A.V. HOPCROFT J.E. AND ULLMAN J.D. The Design and Analysis of Computer Algorithms. Addison-Wesley Reading Mass. I974. AHo A.V. HOPCROFT J.E. AND ULLMAN J.D. The Design and Analysis of Computer Algorithms. Addison-Wesley Reading Mass. I974.

2. On the membership problem for multivalued dependencies in relational databases. TR- 229, Dept. EE and Comptr. Sci., Princeton U., Princeton;BEERI C;N.J.,1977

3. A complete axiomatization for functional and multivalued dependencies in database relations

Cited by 289 articles. 订阅此论文施引文献订阅此论文施引文献，注册后可以免费订阅5篇论文的施引文献，订阅后可以查看论文全部施引文献

1. Implicit Representation of Relations;Theory of Computing Systems;2023-08-15

2. Conceptual Modeling: Topics, Themes, and Technology Trends;ACM Computing Surveys;2023-07-17

3. Normalizing Property Graphs;Proceedings of the VLDB Endowment;2023-07

4. Composite Object Normal Forms: Parameterizing Boyce-Codd Normal Form by the Number of Minimal Keys;Proceedings of the ACM on Management of Data;2023-05-26

5. Cardinality constraints and functional dependencies in SQL: Taming data redundancy in logical database design;Information Systems;2023-05