CFP last date
22 April 2024
Reseach Article

Issues of Data Quality in Data Warehouses

Published on April 2014 by Jyoti Sheoran
International Conference on Advances in Computer Engineering and Applications
Foundation of Computer Science USA
ICACEA - Number 6
April 2014
Authors: Jyoti Sheoran
4eef4569-9a29-4bac-859a-15f766a60ce1

Jyoti Sheoran . Issues of Data Quality in Data Warehouses. International Conference on Advances in Computer Engineering and Applications. ICACEA, 6 (April 2014), 6-8.

@article{
author = { Jyoti Sheoran },
title = { Issues of Data Quality in Data Warehouses },
journal = { International Conference on Advances in Computer Engineering and Applications },
issue_date = { April 2014 },
volume = { ICACEA },
number = { 6 },
month = { April },
year = { 2014 },
issn = 0975-8887,
pages = { 6-8 },
numpages = 3,
url = { /proceedings/icacea/number6/15835-1465/ },
publisher = {Foundation of Computer Science (FCS), NY, USA},
address = {New York, USA}
}
%0 Proceeding Article
%1 International Conference on Advances in Computer Engineering and Applications
%A Jyoti Sheoran
%T Issues of Data Quality in Data Warehouses
%J International Conference on Advances in Computer Engineering and Applications
%@ 0975-8887
%V ICACEA
%N 6
%P 6-8
%D 2014
%I International Journal of Computer Applications
Abstract

In recent years, corporate scandals, regulatory changes, and the collapse of major financial institutions have brought much warranted attention to the quality of enterprise information. If we understand the underlying sources of quality issues, then we can develop a plan of action to address the problem that is both proactive and strategic. The relationship between data quality and data consistency is investigated in this research paper. Poor data quality is costly as it adds expenses and lowers user satisfaction so Data Profiling could be enforced. It was observed that quality of data in a data warehouse is affected by factors like: data not fully captured, lack of planning, data aging.

References
  1. Scott W. Ambler (2001) Challenges with legacy data: knowing your data enemy is the first step in overcoming it, practice Leader, Agile Development, Rational Methods Group, IBM,01Jul 2001
  2. IJCSI International Journal of Computer Science issues, Vol 7,Issue 3, No 2, May 2010
  3. John Hess (1998), Dealing With Missing Values in the Data Warehouse, a report of Stonebridge Technologies, Inc(1998)
  4. Atre,S. , 1997, Achieving Unity of data, Computerworld, Sep 15, 1997. vol. 31 n37, pp. 79(2)
  5. Clerar Targets Vital for Data Warehousing, 1996, Insurance Systems Bulletin, Oct 1996, Vol 12(4), pp. 6
  6. Clements, R. B. , 1990, Creating and Assuring Quality, ASQC Quality press
  7. David Loshin, "The data quality business case: projecting return on investment", Information White paper. Available at: http://www. melissadata. com/enews/articles/1007/2. htm
  8. Won Kim et al (2002)- "A Taxonomy of Dirty data" Kluwer Academic Publishers 2002
  9. Matteo Golfarelli (2009) Survey on Temporal Data Warehousing, International Journal of data warehousing and mining
  10. Wrembel, R. & Mendelzon, A. (2001). Metadata Management in a Multiversion Data Warehouse. Journal of Data Semantics,8, 118-157
  11. Inmon, W. H. , Building the Data Warehouse. John Wiley, 1992
  12. Kimball, R. The data Warehouse Toolkit. John Wiley, 1996
  13. Wuisdom, J. "Research Problems in Data Warehousing" 4th International CIKM Conf. 1995
  14. J. Dean and S. Ghemawat. MapReduce: Simplified Data Processing on Large Clusters. In OSDI, 2004
  15. Gupta, A. , & Mumick, I. S. (1995). Maintenance of materialized views: problems, techniques and applications. Data Engineering Bulletin, 18(2), 3-18
Index Terms

Computer Science
Information Sciences

Keywords

Aging Data Consistency Data Profiling Data Quality Data Warehouse.