Towards a framework for dealing with data quality in data warehouses.

Peng, Taoxin (2006) Towards a framework for dealing with data quality in data warehouses. In: Current Computing Developments in E-Commerce, Security, HCI, DB, Collaborative and Cooperative Systems. ATINER, Athens, Greece, pp. 241-256. ISBN 960-6672-07-7

Full text not available from this repository. (Request a copy)


The popularity of data warehouses (DWs) in recent years confirms the importance of data quality in today’s business success. It is estimated that as high as 75% of the effort spent on building a data warehouse can be attributed to back-end issues, such as readying the data and transporting it into the data warehouse. In order to improve the efficiency of building up a data warehouse, other than issues about design and implementation, data cleaning is a crucial task. Regarding this task, there are at least two questions needed to be answered: How can we manage to reduce the time used for data cleaning? How can we manage to improve the degree of automation when performing data cleaning? This paper attempts to answer these two questions by presenting a novel framework, which provides an approach to managing data cleaning in data warehouses by focusing on the use of data quality factors, and decoupling the cleaning process into several sub-processes. Initial test run of the processes in the framework demonstrates that the approach presented is efficient and scalable for cleaning data in data warehouses.

Item Type: Book Section
ISBN: 960-6672-07-7
Uncontrolled Keywords: Data warehouses; quality; cleaning; framework; scalable;
University Divisions/Research Centres: Faculty of Engineering, Computing and Creative Industries > School of Computing
Dewey Decimal Subjects: 000 Computer science, information & general works > 000 Computer science, knowledge & systems > 004 Data processing & computer science
Library of Congress Subjects: Q Science > QA Mathematics > QA75 Electronic computers. Computer science
Item ID: 3429
Depositing User: Computing Research
Date Deposited: 16 Mar 2010 11:59
Last Modified: 23 Aug 2011 09:52

Actions (login required)

View Item View Item

Edinburgh Napier University is a registered Scottish charity. Registration number SC018373