Axiomatisations of functional dependencies in the presence of records, lists, sets and multisets
- 作者：Sven Hartmann ; Sebastian Link and Klaus-Dieter Schewe
- 关键词：Semantics in databases ; Data types ; Axiomatisation ; Functional dependency ; Brouwerian algebra
- 刊名：Theoretical Computer Science
- 出版年：2006
- 期刊代码：114_03043975
- 类别：cp
- 出版时间：11 April 2006
- 卷：355
- 期：2
- 页码：167-196
- 文件大小：551 K
摘要
We investigate functional dependencies in databases that support complex values such as records, lists, sets and multisets. Therefore, an abstract algebraic framework is proposed that classifies data models according to the underlying types they support. This allows to emphasise the impact of the data types rather than the specifics of a particular data model.
The main results are finite, minimal, sound and complete sets of inference rules for the implication of functional dependencies in the presence of records and all combinations of lists, sets and multisets. The inference rules are similar to Armstrong's original axioms for the relational data model, thanks to the algebraic framework. The completeness result, however, requires a deep analysis in the case of sets and, in particular, multisets.