Title | ||
---|---|---|
Managing referential integrity and non key-based dependencies in a denormalized context |
Abstract | ||
---|---|---|
The roots of the normal forms ore well known in terms of elimination of the redundancy and updates anomalies, although highly normalized databases have frequently a mediocre performance. On the other hand, pre-joined fables or infinity-sigma -tables materializing the join of two or more Boyce-Codd Normal Form (BCNF) virtual components into a single flat relation, speed up recovering but slow down updating and may became dangerous for the consistency of data. Dealing with denormalized tables requires the re-study of basic operations since they must spread their effects over all replications of data in order to keep consistency. Generated integrity constraints must also be formalized. This paper explores referential integrity constraints, dependencies and basic operations, when actual poorly normalized tables are seen as the result of joins of BCNF tables. The semantic of insertions, deletions and updates, clearly defined for tables without redundancy. is used to understand the transformations of those operations over non-BCNF relations. |
Year | Venue | Field |
---|---|---|
2000 | IRMA Conference | Computer science,Artificial intelligence,Natural language processing,Database,Referential integrity |
DocType | ISBN | Citations |
Conference | 1-878-28984-5 | 1 |
PageRank | References | Authors |
0.37 | 1 | 2 |
Name | Order | Citations | PageRank |
---|---|---|---|
Laura C. Rivero | 1 | 9 | 2.34 |
Horacio Doorn | 2 | 128 | 16.20 |