Framework design of a domain-key schema of a relational database

详细信息

下载全文

推荐本文 |

• 作者：B. E. Panchenko (1) pr-bob@ukr.net
• 关键词：relational database schema &#8211 ; relational framework &#8211 ; domain ; key normal form (DK/NF) &#8211 ; arbitrary object domain &#8211 ; synthesis of a DK/NF schema
• 刊名：Cybernetics and Systems Analysis
• 出版时间：May 2012
• 出版年：2012
• 期刊代码：16_10600396
• 类别：mt
• 卷：48
• 期：3
• 页码：469-478
• 数据来源：sp

摘要

A new approach to the synthesis of the domain-key normal form (DK/NF) for an arbitrary domain is proposed. The Cartesian dependency, which is a special case of multivalued dependencies, is investigated. A lemma on the non-abnormality of a special relational and a theorem on the non-abnormality of the actual part of a relational framework are proved. A new criterion for determining the belonging of a database schema to DK/NF is given. The proposed approach can be used in designing information warehouse schemas.