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.
翻译:在现代数据库中,数据规范化实践对于提升数据完整性、减少冗余和消除异常仍然至关重要。然而,自其提出及后续改进以来,尚未有方法专门约束那些仅能取有限数量值的属性。这些非有限可区分属性在许多关系型数据库中构成问题,因为它们可能导致数据异常和查询错误。因此,有必要引入一种新的数据库规范化方法——有限可区分范式(LDNF),以改进当前既有的数据规范化流程。简而言之,LDNF通过强制属性符合有限数量的取值,将非有限可区分属性转化为有限可区分属性。将LDNF与现有范式结合使用,能够满足仅采用当前方法时无法实现的规范化需求。本文据此提出了一种LDNF的形式化方法。