关于考试成绩数据库差错检查的研究

数据差错检查对于数据准确性具有重要意义,目前对于数据差错的检查研究主要是检查数据的取值是否在有效的范围之内,或者随机抽查数据是否准确,但没有系统性地检查数据的准确性,针对这一情况,以作者为熟悉的考试数据库查错为例,在分析了数据可能出错的环节的基础上,详细介绍了宏观检查法、特殊值检查法、参照对比法等数据差错检查方法,并提出了差错检查程序设计的基本原则和策略。

Study on Research of Exam Score Database Error Check

Database error check has important meaning to data accuracy. At present the research on database error check focus on whether the value is valid, or the data random check is accuracy. There is no systematic check for the data accuracy. According to this situation, an example of the author's familiar exam database check error is given. Based on analysing the link of making mistakes, the paper introduces in detail macro check method, special value check method and reference counterpoint method, and presents the principle and strategy of designing the data check program.