An efficient method for estimating null values in relational databases

Authors:
Jia-Wen Wang;Ching-Hsue Cheng
Affiliations:
National Yunlin University of Science and Technology, Department of Information Management, 123, Section 3, University Road, Yunlin 640, Touliu, Taiwan, R.O.C.;National Yunlin University of Science and Technology, Department of Information Management, 123, Section 3, University Road, Yunlin 640, Touliu, Taiwan, R.O.C.
Venue:
Knowledge and Information Systems
Year:
2007

Citing 12
Cited 0

Multivariate data analysis (4th ed.): with readings

Multivariate data analysis (4th ed.): with readings
Extending the database relational model to capture more meaning

ACM Transactions on Database Systems (TODS)
Data mining: concepts and techniques

Data mining: concepts and techniques
Even no data has a value

Communications of the ACM
Multipass algorithms for mining association rules in text databases

Knowledge and Information Systems
Current Approaches to Handling Imperfect Information in Data and Knowledge Bases

IEEE Transactions on Knowledge and Data Engineering
A pseudo-nearest-neighbor approach for missing data recovery on Gaussian random data sets

Pattern Recognition Letters
Refining Initial Points for K-Means Clustering

ICML '98 Proceedings of the Fifteenth International Conference on Machine Learning
Symbolic and numerical regression: experiments and applications

Information Sciences—Informatics and Computer Science: An International Journal - Special issue on recent advances in soft computing
Managing Multiuser Database Buffers Using Data Mining Techniques

Knowledge and Information Systems
A new method to estimate null values in relational database systems based on automatic clustering techniques

Information Sciences: an International Journal
Generating weighted fuzzy rules from relational database systems for estimating values using genetic algorithms

IEEE Transactions on Fuzzy Systems

Quantified Score

Hi-index	0.00

Visualization

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.