article

Free access

Enhancing data quality in data warehouse environments

Authors:

Donald P. Ballou,

Giri Kumar TayiAuthors Info & Claims

Communications of the ACM, Volume 42, Issue 1

Pages 73 - 78

https://doi.org/10.1145/291469.291471

Published: 01 January 1999 Publication History

All formats PDF

References

[1]

Ballou, D., and Pazer, H. Modeling data and process quality in multiinput, multi-output information systems. Management Science 3i, 2 (Feb. 1985), 150-162.

Digital Library

Google Scholar

[2]

Ballou, D., and Pazer, H. Designing information systems to optimize the accuracy-timeliness trade-off. Information Systems Research 6, 1 (Mar. 1995), 51-72.

Digital Library

Google Scholar

[3]

Ballou, D., and Tayi, G. Methodology for allocating resources for data quality enhancement. Commun. ACM 32, 3 (Mar. 1989), 320-329.

Digital Library

Google Scholar

[4]

Celko, J., and McDonald, J. Don't warehouse dirty data. Datamation 4i, 19 (Oct. 1995), 42-53.

Google Scholar

[5]

Cushing, B. A mathematical approach to the analysis and design of internal control systems. Accounting Review 49, 1 (Jan. 1974), 24-41.

Google Scholar

[6]

Laudon, K. Data quality and due process in large interorganizational record systems. Commun. ACM 29, 1 (Jan. 1986), 4-18.

Digital Library

Google Scholar

[7]

Morey, R.C. Estimating and improving the quality of information in an MIS. Commun. ACM25, 5 (May 1982), 337-342.

Digital Library

Google Scholar

[8]

Redman, T. Data Quality: Management and Technology. Bantam Books, New York, 1992.

Digital Library

Google Scholar

[9]

Strong, D., and Miller, S. Exceptions and exception handling in computerized information processes. A CM Transactions on Information Systems 13, 2 (Apr. 1995), 206-233.

Digital Library

Google Scholar

[10]

Wand, Y. and Wang, R. Anchoring data quality dimensions ontological foundations. Commun. ACM 39, 11 (Nov. 1996), 86-95.

Digital Library

Google Scholar

[11]

Wang, R., Storey, V., and Firth C. A framework for analysis of data quality research. IJEJEJE Transactions on Knowledge and Data Engineering 7, 4 (Aug. 1995), 623-640.

Digital Library

Google Scholar

[12]

Wang, R.Y. and Strong, D.M. Beyond accuracy: What data quality means to data consumers. Journal of Management Information Systems i2, 4 (Spring 1996), 5-34.

Digital Library

Google Scholar

Cited By

View all

Nydegger KObergfell THeesen PSchelling GStuder GBode-Lesniewska BFuchs B(2024)Planned and Unplanned Sarcoma Resections: Comparative Analysis of Local Recurrence, Metastasis, and MortalityCancers10.3390/cancers1619340816:19(3408)Online publication date: 7-Oct-2024
https://doi.org/10.3390/cancers16193408
Obergfell TNydegger KHeesen PSchelling GBode-Lesniewska BStuder GFuchs B(2024)Improving Sarcoma Outcomes: Target Trial Emulation to Compare the Impact of Unplanned and Planned Resections on the OutcomeCancers10.3390/cancers1613244316:13(2443)Online publication date: 3-Jul-2024
https://doi.org/10.3390/cancers16132443
Schwabe DBecker KSeyferth MKlaß ASchaeffter T(2024)The METRIC-framework for assessing data quality for trustworthy AI in medicine: a systematic reviewnpj Digital Medicine10.1038/s41746-024-01196-47:1Online publication date: 3-Aug-2024
https://doi.org/10.1038/s41746-024-01196-4
Show More Cited By

Index Terms

Enhancing data quality in data warehouse environments

Recommendations

Towards Data Quality into the Data Warehouse Development
DASC '11: Proceedings of the 2011 IEEE Ninth International Conference on Dependable, Autonomic and Secure Computing

Commonly, DW development methodologies, paying little attention to the problem of data quality and completeness. One of the common mistakes made during the planning of a data warehousing project is to assume that data quality will be addressed during ...
Alliance Rules for Data Warehouse Cleansing
ICSPS '09: Proceedings of the 2009 International Conference on Signal Processing Systems

Data Cleansing is an activity performed on the data sets of data warehouse to enhance and maintain the quality and consistency of the data. This paper addresses the problems related with dirty data, entrance of dirty data and detection of dirty data in ...
An Enhanced Technique to Clean Data in the Data Warehouse
DESE '11: Proceedings of the 2011 Developments in E-systems Engineering

Data quality is a critical factor for the success of data warehousing projects. Improving the quality of data is important in data warehouse, because it is used in the process of decision support, which requires accurate data. There are many errors and ...

Comments

Please enable JavaScript to view thecomments powered by Disqus.

Information & Contributors

Information

Published In

Communications of the ACM Volume 42, Issue 1

Jan. 1999

91 pages

ISSN:0001-0782

EISSN:1557-7317

DOI:10.1145/291469

Editor:
Diane Crawford

Issue’s Table of Contents

Permission to make digital or hard copies of all or part of this work for personal or classroom use is granted without fee provided that copies are not made or distributed for profit or commercial advantage and that copies bear this notice and the full citation on the first page. Copyrights for components of this work owned by others than ACM must be honored. Abstracting with credit is permitted. To copy otherwise, or republish, to post on servers or to redistribute to lists, requires prior specific permission and/or a fee. Request permissions from [email protected]

Publisher

Association for Computing Machinery

New York, NY, United States

Publication History

Published: 01 January 1999

Published in CACM Volume 42, Issue 1

Permissions

Request permissions for this article.

Request Permissions

Check for updates

Qualifiers

Article

Contributors

Other Metrics

View Article Metrics

Bibliometrics & Citations

Bibliometrics

Article Metrics

196
Total Citations
View Citations
7,394
Total Downloads

Downloads (Last 12 months)689
Downloads (Last 6 weeks)94

Reflects downloads up to 20 Nov 2024

Other Metrics

View Author Metrics

Citations

Cited By

View all

Nydegger KObergfell THeesen PSchelling GStuder GBode-Lesniewska BFuchs B(2024)Planned and Unplanned Sarcoma Resections: Comparative Analysis of Local Recurrence, Metastasis, and MortalityCancers10.3390/cancers1619340816:19(3408)Online publication date: 7-Oct-2024
https://doi.org/10.3390/cancers16193408
Obergfell TNydegger KHeesen PSchelling GBode-Lesniewska BStuder GFuchs B(2024)Improving Sarcoma Outcomes: Target Trial Emulation to Compare the Impact of Unplanned and Planned Resections on the OutcomeCancers10.3390/cancers1613244316:13(2443)Online publication date: 3-Jul-2024
https://doi.org/10.3390/cancers16132443
Schwabe DBecker KSeyferth MKlaß ASchaeffter T(2024)The METRIC-framework for assessing data quality for trustworthy AI in medicine: a systematic reviewnpj Digital Medicine10.1038/s41746-024-01196-47:1Online publication date: 3-Aug-2024
https://doi.org/10.1038/s41746-024-01196-4
Navigli RConia SRoss B(2023)Biases in Large Language Models: Origins, Inventory, and DiscussionJournal of Data and Information Quality10.1145/359730715:2(1-21)Online publication date: 22-Jun-2023
https://dl.acm.org/doi/10.1145/3597307
Timko CNiederstadt MGoel NFaltings B(2023)Incentive Mechanism Design for Responsible Data Governance: A Large-scale Field ExperimentJournal of Data and Information Quality10.1145/359261715:2(1-18)Online publication date: 19-Apr-2023
https://dl.acm.org/doi/10.1145/3592617
Priestley MO’donnell FSimperl E(2023)A Survey of Data Quality Requirements That Matter in ML Development PipelinesJournal of Data and Information Quality10.1145/359261615:2(1-39)Online publication date: 19-Apr-2023
https://dl.acm.org/doi/10.1145/3592616
Simard VRönnqvist MLebel LLehoux N(2023)A Method to Classify Data Quality for Decision Making Under UncertaintyJournal of Data and Information Quality10.1145/359253415:2(1-27)Online publication date: 21-Apr-2023
https://dl.acm.org/doi/10.1145/3592534
Ao JCheng ZChirkova RKolaitis P(2023)Theory and Practice of Relational-to-RDF Temporal Data Exchange and Query AnsweringJournal of Data and Information Quality10.1145/359135915:2(1-27)Online publication date: 8-Apr-2023
https://dl.acm.org/doi/10.1145/3591359
Hoffpauir KSimmons JSchmidt NPittala RBriggs IMakani SJararweh Y(2023)A Survey on Edge Intelligence and Lightweight Machine Learning Support for Future Applications and ServicesJournal of Data and Information Quality10.1145/358175915:2(1-30)Online publication date: 25-Jan-2023
https://dl.acm.org/doi/10.1145/3581759
Skavantzos PLeck UZhao KLink S(2023)Uniqueness Constraints for Object StoresJournal of Data and Information Quality10.1145/358175815:2(1-29)Online publication date: 19-Jan-2023
https://dl.acm.org/doi/10.1145/3581758
Show More Cited By

View Options

View options

PDF

View or Download as a PDF file.

PDF

eReader

View online with eReader.

eReader

Magazine Site

View this article on the magazine site (external)

Magazine Site

Login options

Check if you have access through your login credentials or your institution to get full access on this article.

References

Cited By

Index Terms

Recommendations

Towards Data Quality into the Data Warehouse Development

Alliance Rules for Data Warehouse Cleansing

An Enhanced Technique to Clean Data in the Data Warehouse

Comments

Information

Published In

Publisher

Publication History

Permissions

Check for updates

Qualifiers

Contributors

Other Metrics

Bibliometrics

Article Metrics

Other Metrics

Citations

Cited By

View options

PDF

eReader

Magazine Site

Login options

Full Access

Figures

Other

Share

Share this Publication link

Share on social media

Affiliations