Practical algorithms for finding prime attributes and testing normal forms
Summary: Algorithms for testing attribute primality and normal forms with running time polynomial in the number of maximal non-determining sets (i.e., generators of the closure family) instead of all attribute subsets. Shows this parameter is small in practice, giving simple, fast implementations used in Design-By-Example. (summarized by gpt-5-mini on Feb 09 2026)
Incoming Non-self Citations Over Time
Authors
- 1. Heikki Mannila (University of Helsinki)
- 2. Kari-Jouko Räihä (University of Tampere)
BibTeX Citation
@inproceedings{mannila_pods89,
address = {New York, NY, USA},
series = {{PODS} '89},
title = {{Practical algorithms for finding prime attributes and testing normal forms}},
url = {https://dl.acm.org/doi/10.1145/73721.73734},
doi = {10.1145/73721.73734},
booktitle = {Proceedings of the {ACM} {SIGMOD} Symposium on {Principles} of {Database} {Systems}},
publisher = {Association for Computing Machinery},
author = {Mannila, Heikki and Räihä, Kari-Jouko},
year = {1989}
}
Incoming Citations (Sorted by Pagerank)
Showing 1 of 1 citing papers.
| Rank | Citing Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 8,480 | Discovering XSD Keys from XML Data | 2013 | SIGMOD | 5.4167813e-05 |
Previous
Page 1 / 1
Next
Outgoing Citations (Sorted by Pagerank)
Showing 2 of 2 cited papers.
Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.
| Rank | Cited Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 5,249 | Computing Covers for Embedded Functional Dependencies | 1987 | PODS | 6.2996929e-05 |
| 6,645 | An Improved Algorithm for Finding a Key of a Relation | 1985 | PODS | 5.8149777e-05 |
Previous
Page 1 / 1
Next
Semantically Similar Papers
| # | Overall Rank | Paper | Year | Venue |
|---|---|---|---|---|
| 1 | 6,516 | The Design of non-1NF Relational Databases into Nested Normal Form | 1987 | SIGMOD |
| 2 | 3,222 | Comprehensive Approach to the Design of Relational Database Schemes | 1984 | VLDB |
| 3 | 3,437 | Reflections on Boyce-Codd Normal Form | 1982 | VLDB |
| 4 | 14,469 | SMALL ARMSTRONG RELATIONS FOR DATABASE DESIGN (Extended abstract) | 1985 | PODS |
| 5 | 5,249 | Computing Covers for Embedded Functional Dependencies | 1987 | PODS |
| 6 | 3,942 | On the Complexity of Deriving Schema Mappings from Database Instances | 2008 | PODS |
| 7 | 12,055 | SQL Schema Design: Foundations, Normal Forms, and Normalization | 2016 | SIGMOD |
| 8 | 6,698 | Properties Of Database Schemata With Functional Dependencies | 1984 | PODS |
| 9 | 3,456 | Automatic Discovery of Attributes in Relational Databases | 2011 | SIGMOD |
| 10 | 9,864 | Tractable Database Design through Bounded Treewidth | 2006 | PODS |