Weak Functional Dependencies in Higher-Order Datamodels - The Case of the Union Constructor -

We present an axiomatisation for weak functional depen- dencies, i.e. disjunctions of functional dependencies, in the presence of several constructors for complex values. These constructors are the tu- ple constructor, the set-constructor, an optionality constructor, and a union constructor. The theory is smooth and rather uniform, if the union- constructor is absent. Its presence, however, complicates all results and proofs significantly. The reason for this is that the union-constructor comes alomg with non-trivial restructuring rules. In particular, if the union-constructor is absent, a subset of the rules is complete for the im- plication of ordinary functional dependencies, but this does not hold, if the union constructor is present.

[1]  Zahir Tari,et al.  Object normal forms and dependency constraints for object-oriented schemata , 1997, TODS.

[2]  Wenfei Fan,et al.  Keys for XML , 2002, Comput. Networks.

[3]  Sven Hartmann Decomposing relationship types by pivoting and schema equivalence , 2001, Data Knowl. Eng..

[4]  Marc Gyssens,et al.  The Structure of the Relational Database Model , 1989, EATCS Monographs on Theoretical Computer Science.

[5]  Bernhard Thalheim,et al.  Fundamental Concepts of Object Oriented Databases , 1993, Acta Cybern..

[6]  Shamkant B. Navathe,et al.  Conceptual Database Design: An Entity-Relationship Approach , 1991 .

[7]  Bernhard Thalheim,et al.  Dependencies in relational databases , 1991, Teubner-Texte zur Mathematik.

[8]  Serge Abiteboul,et al.  Restructuring Hierarchical Database Objects , 1988, Theor. Comput. Sci..

[9]  A Min Tjoa,et al.  Transformation of Requirement Specifications Expressed in Natural Language into an EER Model , 1993, ER.

[10]  Dan Suciu,et al.  Data on the Web: From Relations to Semistructured Data and XML , 1999 .

[11]  Peter P. Chen The entity-relationship model: toward a unified view of data , 1975, VLDB '75.

[12]  David W. Embley,et al.  A normal form for precisely characterizing redundancy in nested relations , 1996, TODS.

[13]  Sven Hartmann,et al.  On Functional Dependencies in Advanced Data Models , 2003, Electron. Notes Theor. Comput. Sci..

[14]  Serge Abiteboul,et al.  Foundations of Databases , 1994 .

[15]  Wenfei Fan,et al.  On XML integrity constraints in the presence of DTDs , 2001, PODS '01.

[16]  Marcelo Arenas,et al.  A normal form for XML documents , 2002, PODS '02.

[17]  Z. Meral Özsoyoglu,et al.  A new normal form for nested relations , 1987, TODS.

[18]  Roger King,et al.  Semantic database modeling: survey, applications, and research issues , 1987, CSUR.

[19]  Bernhard Thalheim,et al.  Foundations of entity-relationship modeling , 1993, Annals of Mathematics and Artificial Intelligence.

[20]  Wenfei Fan,et al.  Integrity constraints for XML , 2003, J. Comput. Syst. Sci..

[21]  Millist Walter Vincent,et al.  THE SEMANTIC JUSTIFICATION FOR NORMAL FORMS IN RELATIONAL DATABASE DESIGN , 1994 .

[22]  Klaus-Dieter Schewe,et al.  Axiomatizing functional dependencies in the Higher-Order Entity-Relationship Model , 2003, Inf. Process. Lett..

[23]  Peter P. Chen English Sentence Structure and Entity-Relationship Diagrams , 1983, Inf. Sci..

[24]  Bernhard Thalheim,et al.  Entity-relationship modeling - foundations of database technology , 2010 .