The effects of normalisation on data error finding : an experimental evaluation

Bowen, Paul L. (1995). The effects of normalisation on data error finding : an experimental evaluation Master's Thesis, Dept. of Commerce, The University of Queensland.

       
Attached Files (Some files may be inaccessible until you login with your UQ eSpace credentials)
Name Description MIMEType Size Downloads
THE14336.pdf THE14336.pdf application/pdf 3.77MB 1
Author Bowen, Paul L.
Thesis Title The effects of normalisation on data error finding : an experimental evaluation
School, Centre or Institute Dept. of Commerce
Institution The University of Queensland
Publication date 1995
Thesis type Master's Thesis
Total pages 95
Language eng
Subjects 1402 Applied Economics
Formatted abstract In most organisations, accurate data are some of their most precious assets. Many empirical studies, however, have sl10wn that many organisations' databases contain errors (Neter and Loebbecke 1975; Ki111ley 1979, Ramage et al. 1979; Johnston et al. 1981; Hylas and Ashton 1982; Morey 1982; Ham et al. 1985; Willingham and Wright 1985; Kreutzfeldt and Wallace 1986; Laudon 1986; Icerman and Hillison 1991). Data errors entering the databases can be reduced by implementing various input validation controls. Higher levels of normalisation can also help reduce the number of errors entering the database. Even ill well maintained databases, however, data errors will still accumulate. The accuracy and quality of data in databases can be improved by periodically querying the databases to locate and correct data errors.

High levels of normalisation may facilitate updates, but adversely affect users' ability to perform queries. The results of this study showed that increased levels of normalisation lowered the effectiveness and efficiency of queries, however, unnormalised data structures had an even more adverse effect on user queries. Data structures normalised to first normal form (1NF) appear to be most effective and efficient for user queries, e.g., for finding existing data errors.


 
Citation counts: Google Scholar Search Google Scholar
Access Statistics: 32 Abstract Views, 1 File Downloads  -  Detailed Statistics
Created: Sat, 06 Nov 2010, 12:48:26 EST by Ning Jing on behalf of The University of Queensland Library