Research of data quality assurance about ETL of telecom data warehouse

被引：0
|
作者：
机构：
[1] Department of Information Engineering, Shaanxi Polytechnic Institute, Shaanxi, Xian'yang
[2] School of Computer Science and Engineering, XI'an University of Technology
[3] National School of Software, Xidian University, 710071, Xi'an, Shaanxi
[4] Department of Computer Science and Technology, Northwest University
[5] School of Information Engineering, Zhejiang Agriculture and Forest University
来源：
Wei, S. | 1839年 / Asian Network for Scientific Information卷 / 12期
关键词：
Data audit; Data quality; Data warehouse; ETL;
D O I：
10.3923/itj.2013.1839.1844
中图分类号：
学科分类号：
摘要：
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. © 2031 Asian Network for Scientific Information.
引用
收藏
页码：1839 / 1844
页数：5
相关论文
共 50 条
  • [21] Developing a data quality assurance ontology for research data repositories
    Lee, Dong Joon
    Stvilia, Besiki
    Gunaydin, Fatih
    Pang, Yuanying
    JOURNAL OF DOCUMENTATION, 2025, 81 (07) : 63 - 84
  • [22] Knowledge Based Data Cleaning for Data Warehouse Quality
    Bradji, Louardi
    Boufaida, Mahmoud
    DIGITAL INFORMATION PROCESSING AND COMMUNICATIONS, PT 2, 2011, 189 : 373 - +
  • [23] Stakeholder perceptions of data quality in a data warehouse environment
    Giannoccaro, A
    Shanks, G
    Darke, P
    AUSTRALIAN COMPUTER JOURNAL, 1999, 31 (04): : 110 - 117
  • [24] An improved join-free snowflake schema for ETL and OLAP of data warehouse
    Wang Jianmin
    Zhao Wenbin
    Fan Tongrang
    Yang Shilong
    Lv Hongwei
    CONCURRENCY AND COMPUTATION-PRACTICE & EXPERIENCE, 2020, 32 (23)
  • [25] On the Research of Data Warehouse in Big Data
    Qin, Hai-fei
    Qian, Zhi-ming
    Zhao, Yong-chao
    2015 INTERNATIONAL CONFERENCE ON NETWORK AND INFORMATION SYSTEMS FOR COMPUTERS (ICNISC), 2015, : 354 - 357
  • [26] Quality Ananlysis and ETL Processing of the Sales Data in a Certain Supermarket Chain
    Chen, Jiangping
    Yu, Zhenguo
    Cai, Ying
    Xiang, Jiangfan
    Dong, Wei
    Ni, Yuzhen
    PROCEEDINGS OF THE 5TH INTERNATIONAL CONFERENCE ON COOPERATION AND PROMOTION OF INFORMATION RESOURCES IN SCIENCE AND TECHNOLOGY(COINFO 10), 2010, : 315 - +
  • [27] An Exploratory Investigation of Factors Influencing Data Quality in Data Warehouse
    Zellal, Nouha
    Zaouia, Abdellah
    PROCEEDINGS OF 2015 THIRD IEEE WORLD CONFERENCE ON COMPLEX SYSTEMS (WCCS), 2015,
  • [28] A Measurement Model for Factors Influencing Data Quality in Data Warehouse
    Zellal, Nouha
    Zaouia, Abdellah
    2016 4TH IEEE INTERNATIONAL COLLOQUIUM ON INFORMATION SCIENCE AND TECHNOLOGY (CIST), 2016, : 46 - 51
  • [29] Modeling and Optimization of Extraction-Transformation-Loading (ETL) processes in Data Warehouse: An Overview
    Anand, Nitin
    Kumar, Manoj
    2013 FOURTH INTERNATIONAL CONFERENCE ON COMPUTING, COMMUNICATIONS AND NETWORKING TECHNOLOGIES (ICCCNT), 2013,
  • [30] Implementation of Change Data Capture in ETL Process for Data Warehouse Using HDFS and Apache Spark
    Denny
    Atmaja, I. Pulu Medagia
    Saptawijaya, Ali
    Aminah, Siti
    2017 INTERNATIONAL WORKSHOP ON BIG DATA AND INFORMATION SECURITY (IWBIS 2017), 2017, : 49 - 55
12345