Characterising nested database dependencies by fragments of propositional logic

Sven Hartmann, Sebastian Link
2008 Annals of Pure and Applied Logic  
We extend the earlier results on the equivalence between the Boolean and the multivalued dependencies in relational databases and fragments of the Boolean propositional logic. It is shown that these equivalences are still valid for the databases that store complex data elements obtained from the recursive nesting of record, list, set and multiset constructors. The major proof argument utilises properties of Brouwerian algebras. The equivalences have several consequences. Firstly, they provide
more » ... w insights into databases that are not in first normal form. Secondly, they characterise the implication of data dependencies in nested databases in purely logical terms. The database designer can take advantage of these equivalences to reduce database design problems to well-studied problems in Boolean propositional logic. Furthermore, relational database design solutions can be reused to solve problems for nested databases.
doi:10.1016/j.apal.2007.11.004 fatcat:tanr2vwpjna5lodvkpqawlejdu