评估数据质量的过程

A process for assessing data quality

评估关系数据库的质量的过程对数据库产业至关重要。评估关系数据库的质量包含两种独立的审计方式:一种是对图表中描述的数据库结构的审计,另一种是在指定点对数据库内容进行审计。数据库图表审计主要检查设计缺陷,是否有违背数据库准则以及偏离原始数据模型的情况,同时测量数据库的大小、复杂性和结构质量。数据库内容审计则比较选择的数据的状态属性,以确定是否有不正确的数据,并检查是否有丢失和多余的记录。上述两种方式的目的都是为了启动数据清理过程,以确保或恢复数据的质量。

Assessing the quality of relational databases is very crucial for the database industry. The approach combines two separate audits, an audit of the database structure as described in the schema and an audit of the database content at a given point. The audit of the database schema checks for design weaknesses, data rule violations and deviations from the original data model. It also measures the size, complexity and structural quality of the database. The audit of the database content compares the state of selected data attributes to identify incorrect data and cheeks for missing and redundant records. The purpose of these two methods is to initiate a data clean-up process to ensure or restore the quality of the data.