Academic Journals Database
Disseminating quality controlled scientific knowledge

Research of Data Quality Assurance about ETL of Telecom Data Warehouse

Author(s): Sun Wei | Wei Wei | Jing Zhang | Wei Wang | Jinwei Zhao | Junhuai Li | Peiyi Shen | Xiaoyan Yin | Xiangrong Xiao | Jie Hu

Journal: Information Technology Journal
ISSN 1812-5638

Volume: 12;
Issue: 9;
Start page: 1839;
Date: 2013;
VIEW PDF   PDF DOWNLOAD PDF   Download PDF Original page

Keywords: ETL | data quality | Data warehouse | data audit

In recent years, with the development of data warehouse and Web technology, more and more attention has been paid to multiple applications of the data in warehouse. However, data quality issue is one of the biggest obstacles to the success using of data warehouse project for many enterprises. So a data audit model is proposed and the relevant methods are studied in the study based on the characteristics of the telecommunications industry. Further, a three data layer audit method, consisted of audit mode data file level, record level and index level, is constructed during Extraction Transformation Loading (ETL) process. It can effectively improve the data quality of data warehouse.

Tango Rapperswil
Tango Rapperswil

     Affiliate Program