An Efficient Method for Estimating Null Values in Relational Databases

NHUIR > College of Science and Technology > Department of Electronic Commerce Management > Periodical Articles > Item 987654321/23550

Please use this identifier to cite or link to this item: http://nhuir.nhu.edu.tw/handle/987654321/23550

Title:	An Efficient Method for Estimating Null Values in Relational Databases
Authors:	王佳文;Wang, Jia-Wen;Cheng, Ching-Hsue
Contributors:	電子商務管理學系
Keywords:	Relational database systems;Null value;Degree of influence
Date:	2007-08
Issue Date:	2015-10-05 17:09:17 (UTC+8)
Abstract:	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.
Relation:	Knowledge and Information Systems vol. 12, no. 3 pp.379-394
Appears in Collections:	[ Department of Electronic Commerce Management] Periodical Articles

Files in This Item:

File	Description	Size	Format
index.html		0Kb	HTML	529	View/Open