An information-theoretic approach to normal forms for relational and XML data

Journal of the ACM

Volumn 52, Issue 2, 2005, Pages 246-283

  Arenas, Marcelo ^a   Libkin, Leonid ^a  

^a UNIVERSITY OF TORONTO   (Canada)

Author keywords

Design; Information theory; Normal forms; Normalization algorithms; Relational databases; XML

Indexed keywords

ALGORITHMS; MATHEMATICAL MODELS; XML;

NORMAL FORMS; NORMALIZATION ALGORITHMS;

RELATIONAL DATABASE SYSTEMS;

EID: 27844528478     PISSN: 00045411     EISSN: 00045411     Source Type: Journal    
DOI: 10.1145/1059513.1059519     Document Type: Conference Paper

References (29)

1. ABITEBOUL, S., HULL, R., AND VIANU, V. 1995. Foundations of Databases. Addison-Wesley, Reading, Mass.
2. ALBERT, J., IOANNIDIS, Y., AND RAMAKRISHNAN, R. 1999. Equivalence of keyed relational schemas by conjunctive queries. J. Comput. Syst. Sci. 58, 3, 512-534.
3. ARENAS, M., AND LIBKIN, L. 2002. A normal form for XML documents. In Proceedings of the 21st ACM SIGACT-SIGMOD-SIGART Symposium on Principles of Database Systems. ACM, New York, 85-96.
4. ARENAS, M., AND LIBKIN, L. 2004. A normal form for XML documents. ACM Trans. Datab. Syst. 29, 1, 195-232.
5. BEERI, C., BERNSTEIN, P., AND GOODMAN, N. 1978. A sophisticate's introduction to database normalization theory. In Proceedings of the 4th International Conference on Very Large Data Bases. 113-124.
6. BISKUP, J. 1995. Achievements of relational database schema design theory revisited. In Semantics in Databases, L. Libkin and B. Thalheim, Eds. Springer-Verlag, New York, 29-54.
7. CAVALLO, R., AND PITTARELLI, M. 1987. The theory of probabilistic databases. In Proceedings of 13th International Conference on Very Large Data Bases. 71-81.
8. COVER, T., AND THOMAS, J. 1991. Elements of Information Theory. Wiley-Interscience, New York.
9. DALKILIC, M., AND ROBERTSON, E. 2000. Information dependencies. In Proceedings of the 19th ACM Symposium on Principles of Database Systems. ACM, New York, 245-253.
10. EMBLEY, D., AND MOK, W. Y. 2001. Developing XML documents with guaranteed "good" properties. In Proceedings of the 20th International Conference on Conceptual Modeling. 426-441.
11. FAGIN, R. 1977. Multivalued dependencies and a new normal form for relational databases. ACM Trans. Datab. Syst. 2, 3, 262-278.
12. FAGIN, R. 1979. Normal forms and relational database operators. In Proceedings of the 1979 ACM SIGMOD International Conference on Management of Data. ACM, New York, 153-160.
13. FAGIN, R. 1981. A normal form for relational databases that is based on domians and keys. ACM Trans. Datab. Syst. 6, 3, 387-415.
14. HULL, R. 1986. Relative information capacity of simple relational database schemata. SIAM J. Comput. 15, 3, 856-886.
15. KANELLAKIS, P. 1990. Elements of relational database theory. In Handbook of Theoretical Computer Science, Volume B. MIT Press, Cambridge, Mass., 1075-1144.
16. LEE, T. 1987. An information-theoretic analysis of relational databases - Part I: Data dependencies and information metric. IEEE Trans. Softw. Eng. 13, 10, 1049-1061.
17. LEVENE, M., AND LOIZOU, G. 2003. Why is the snowflake schema a good data warehouse design? Inf. Syst. 28, 3, 225-240.
18. LEVENE, M., AND VINCENT, M. 2000. Justification for inclusion dependency normal form. IEEE Trans. Knowl. Data Eng. 12, 2, 281-291.
19. LEY, M. 2003. DBLP. http://www.informatik.uni-trier.de/~~ley/db/index. html.
20. MAIER, D., MENDELZON, A., AND SAGIV, Y 1979. Testing implications of data dependencies. ACM Trans. Datab. Syst. 4, 4, 455-469.
21. MOK, W. Y., NG, Y.-K., AND EMBLEY, D. 1996. A normal form for precisely characterizing redundancy in nested relations. ACM Trans. Datab. Syst. 21, 1, 77-106.
22. ÖZSOYOGLU, M., AND YUAN, L.-Y. 1987. A new normal form for nested relations. ACM Trans. Datab. Syst. 12, 1, 111-136.
23. PAPADIMITRIOU, C. 1994. Computational complexity. Addison-Wesley, Reading, Mass.
24. SHANNON, C. 1948. A mathematical theory of communication. Bell Syst. Tech. J. 27, 379-423 (Part I), 623-656 (Part II).
25. SUCIU, D. 2001. On database theory and XML. SIGMOD Record 30, 3, 39-45.
26. TATARINOV, I., IVES, Z., HALEVY, A., AND WELD, D. 2001. Updating XML. In Proceedings of the 2001 ACM SIGMOD International Conference on Management of Data. ACM, New York, 413-424.
27. VIANU, V. 2001. A web odyssey: From Codd to XML. In Proceedings of the 20th ACM SIGACT-SIGMOD-SIGART Symposium on Principles of Database Systems. ACM, New York, 1-15.
28. VINCENT, M. 1997. A corrected 5NF definition for relational database design. Theoret. Comput. Sci. 185, 2, 319-391.
29. VINCENT, M. 1999. Semantic foundations of 4NF in relational database design. Acta Inf. 36, 3, 173-213.