An efficient method for estimating null values in relational databases

作者:Jia-Wen Wang, Ching-Hsue Cheng

摘要

Generally, a database system containing null value attributes will not operate properly. This study proposes an efficient and systematic approach for estimating null values in a relational database which utilizes clustering algorithms to cluster data, and a regression coefficient to determine the degree of influence between different attributes. Two databases are used to verify the proposed method: (1) Human resource database; and (2) Waugh's database. Furthermore, the mean of absolute error rate (MAER) and average error are used as evaluation criteria to compare the proposed method with other methods. It demonstrates that the proposed method is superior to existing methods for estimating null values in relational database systems.

论文关键词:Relational database systems, Null value, Degree of influence

论文评审过程:

论文官网地址:https://doi.org/10.1007/s10115-006-0028-4