arXivDaily arXiv每日学术速递 周一至周五更新
arXiv周末暂无论文更新,休息一下吧,周末愉快~~
arXiv 2510.02865cs.DB
收藏

一种面向有限互异属性的新范式

A New Normalization Form for Limited Distinct Attributes

University of Auckland(奥克兰大学)

Niko S. Snell, Rayen C. Lee

AI总结:

针对关系数据库中非有限互异属性易引发数据异常与查询不准的问题,提出有限互异范式LDNF,通过强制属性取值有限化实现转换,与现有范式结合可填补数据规范化的现有需求缺口,并给出其形式化方法。

摘要:

在现代数据库中,数据规范化实践在提升数据完整性、最大程度减少冗余以及消除异常方面依然具有重要意义。然而,自规范化概念提出及后续改进以来,尚无研究尝试记录一种对仅能拥有有限数量取值的属性的值进行约束的方法。这些非有限互异属性在众多关系数据库中引发了问题,因为它们可能导致数据异常和查询不准确。因此,有必要提出一种新的数据库规范化方法——有限互异范式(Limited Distinct Normal Form,LDNF),以改进当前已建立的数据规范化流程。简而言之,LDNF是通过强制属性符合有限数量的取值,将非有限互异属性转化为有限互异属性的方法。将LDNF与现有范式结合使用,可填补仅使用当前方法时无法满足的规范化需求。本文据此提出了LDNF的形式化方法。

英文摘要:

In modern databases, the practice of data normalization continues to be important in improving data integrity, minimizing redundancies, and eliminating anomalies. However, since its inception and consequent improvements, there have been no attempts to document a method which constrains the values of attributes capable of only possessing a limited quantity of values. These non-limited distinct attributes pose a problem throughout many relational databases as they have the potential to cause data anomalies and query inaccuracies. Thus, a new database normalization method, Limited Distinct Normal Form (LDNF), is necessary in order to improve upon the currently established data normalization process. In brief, LDNF is a method which turns non-limited distinct attributes into limited distinct attributes by forcing the attributes to conform to a limited quantity of values. Utilizing LDNF in tandem with existing normal forms fulfills a need in normalization that is otherwise not present when only using current methods. A formal approach to LDNF is therefore proposed.

机构、总结、中文摘要均由AI分析而来,可能存在错误,请以论文正文为准。

↑