Weak Functional Dependencies on Trees with Restructuring

We present an axiomatisation for weak functional dependencies, i.e. disjunctions of functional dependencies, in the presence of several constructors for complex values. The investigated constructors capture records, sets, multisets, lists, disjoint union and optionality, i.e. the complex values are indeed trees. The constructors cover the gist of all complex value data models including object oriented databases and XML. Functional and weak functional dependencies are expressed on a lattice of subattributes, which even carries the structure of a Brouwer algebra as long as the union-constructor is absent. Its presence, however, complicates all results and proofs significantly. The reason for this is that the union-constructor causes non-trivia l restructuring rules to hold. In particular, if either the set- or the the union-constructor is absent, a subset of the rules is complete for the implication of ordinary functional dependencies, while in the general case no finite axiomatisation for functional dependencies exists.

[1]  Jixue Liu,et al.  Multivalued Dependencies and a 4NF for XML , 2003, CAiSE.

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

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

[4]  Klaus-Dieter Schewe,et al.  Reasoning about Functional and Multi-valued Dependencies in the Presence of Lists , 2004, FoIKS.

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

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

[7]  Nicolás Marín,et al.  Review of Data on the Web: from relational to semistructured data and XML by Serge Abiteboul, Peter Buneman, and Dan Suciu. Morgan Kaufmann 1999. , 2003, SGMD.

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

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

[10]  Chengfei Liu,et al.  Strong functional dependencies and their application to normal forms in XML , 2004, TODS.

[11]  Marcelo Arenas,et al.  A normal form for XML documents , 2004, TODS.

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

[13]  Jixue Liu,et al.  Functional Dependencies for XML , 2003, APWeb.

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

[15]  Attila Sali Minimal Keys in Higher-Order Datamodels , 2004, FoIKS.

[16]  János Demetrovics,et al.  On the functional dependency and some generalizations of it , 1981, Acta Cybern..

[17]  Wenfei Fan,et al.  Keys for XML , 2001, WWW '01.

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

[19]  Junhu Wang,et al.  Removing XML Data Redundancies Using Functional and Equality-Generating Dependencies , 2005, ADC.

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

[21]  Jixue Liu,et al.  Multivalued Dependencies in XML , 2003, BNCOD.

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

[23]  Klaus-Dieter Schewe,et al.  Axiomatisations of functional dependencies in the presence of records, lists, sets and multisets , 2006, Theor. Comput. Sci..

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

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

[26]  Klaus-Dieter Schewe,et al.  Functional Dependencies over XML Documents with DTDs , 2005, Acta Cybern..

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

[28]  Klaus-Dieter Schewe,et al.  A Characterisation of Coincidence Ideals for Complex Values , 2009, J. Univers. Comput. Sci..

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

[30]  Klaus-Dieter Schewe,et al.  Weak Functional Dependencies in Higher-Order Datamodels , 2004, FoIKS.

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

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

[33]  Klaus-Dieter Schewe Functional Dependencies with Counting on Trees , 2005, J. Univers. Comput. Sci..

[34]  Klaus-Dieter Schewe,et al.  Functional and multivalued dependencies in nested databases generated by record and list constructor , 2006, Annals of Mathematics and Artificial Intelligence.

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