Cited by 40Data Quality and ManagementAlgorithms and Data CompressionStatistical Methods and Applications

An Accuracy Metric: Percentages, Randomness, and Probabilities

Fisher, Craig W., Lauria, Eitel J. M., Matheus, Carolyn C.·2009·Journal of Data and Information Quality

Abstract

Practitioners and researchers regularly refer to error rates or accuracy percentages of databases. The former is the number of cells in error divided by the total number of cells; the latter is the number of correct cells divided by the total number of cells. However, databases may have similar error rates (or accuracy percentages) but differ drastically in the complexity of their accuracy problems. A simple percent does not provide information as to whether the errors are systematic or randomly distributed throughout the database. We expand the accuracy metric to include a randomness measure and include a probability distribution value. The proposed randomness check is based on the Lempel-Ziv (LZ) complexity measure. Through two simulation studies we show that the LZ complexity measure can clearly differentiate as to whether the errors are random or systematic. This determination is a significant first step and is a major departure from the percentage-alone technique. Once it is determined that the errors are random, a probability distribution, Poisson, is used to help address various managerial questions.

Integrity signals

Registry

Crossref · 10.1145/1659225.1659229

Cites

3 of 3 references verified0 citation errors · 0 not checkable

Statistics

Recomputing p-values needs the paper’s full text.

Claims the paper makes

We couldn’t retrieve this paper’s full text, so its claims and self-check weren’t run. The registry and citation checks still apply.

Claims other papers make about this one

Each is checked against this paper’s own text: does it say what the citing paper says it does?

  • Real-time data is vital in domains such as stock trading, while daily or weekly updates may suffice for inventory management.

    “Real-time data is vital in domains such as stock trading, where rapid changes demand instant responses [37], while daily or weekly updates may suffice for inventory management, helping prevent overproduction or stockouts [38].”

Cites

Flagged first, then by citations

Research works printed but not linked: 32

  1. 10.1109/TBME.2006.883696 · DOI
  2. 10.1145/291469.291471 · DOI
  3. 10.1080/07421222.2003.11045769 · DOI
  4. Chaitin G. J., 1975, Randomness and mathematical proof. Sci, Amer., 232, 47
  5. Clarke R. D. 1946. An application of the poisson distribution. J. Inst. Actuaries 72. Clarke R. D. 1946. An application of the poisson distribution. J. Inst. Actuaries 72 . · DOI
  6. Dietel E. J., 2003, Recordkeeping integrity: Assessing records’ content after Enron, Inform. Manag. J., 37, 43
  7. 10.1037/0033-295X.104.2.301 · DOI
  8. Gelman A. Carlin J. Stern H. and Rubin D. 1995. Bayesian Data Analysis. Chapman and Hall/CRC. Gelman A. Carlin J. Stern H. and Rubin D. 1995. Bayesian Data Analysis . Chapman and Hall/CRC. · DOI · Paper page
  9. 10.1093/bioinformatics/15.12.994 · DOI
  10. Huang K.-T. Lee Y. W. and Wang R. Y. 1999. Quality Information and Knowledge. Prentice Hall Englewood Cliffs NJ. Huang K.-T. Lee Y. W. and Wang R. Y. 1999. Quality Information and Knowledge . Prentice Hall Englewood Cliffs NJ.
  11. Kac M., 1983, What is random, Amer. Sci., 71, 405
  12. 10.1103/PhysRevA.36.842 · DOI
  13. Kolmogorov A. N., 1965, Three approaches to the quantitative definition of information, Probl. Inform. Transmis., 1, 1
  14. Lee Y. W. Pipino L. L. Funk J. D. and Wang R. Y. 2006. Journey to Data Quality. MIT Press Cambridge MA. Lee Y. W. Pipino L. L. Funk J. D. and Wang R. Y. 2006. Journey to Data Quality . MIT Press Cambridge MA. · DOI
  15. 10.1109/TIT.1976.1055501 · DOI
  16. Levin R. I. Rubin D. S. and Stinson J. P. 1986. Quantitative Approaches to Management. McGraw-Hill New York. Levin R. I. Rubin D. S. and Stinson J. P. 1986. Quantitative Approaches to Management . McGraw-Hill New York.
  17. Li M. and Vitanyi P. 1997. A Introduction to Kolmogorov Complexity and its Applications. Springer Verlag Berlin. Li M. and Vitanyi P. 1997. A Introduction to Kolmogorov Complexity and its Applications . Springer Verlag Berlin. · DOI
  18. The Merriam-Webster Dictionary, Edited by H. B. Woolf
  19. 10.1080/07421222.2005.11045823 · DOI · Paper page
  20. Olson J. E., 2003, Data Quality: The Accuracy Dimension. Morgan Kaufman
  21. Pierce E. M., 1997, Modeling database error rates, Data Qual., 3, 1
  22. 10.1093/intqhc/12.1.47 · DOI
  23. 10.1080/07421222.1999.11518259 · DOI
  24. Redman T., Measuring data accuracy
  25. 10.1145/269012.269025 · DOI
  26. 10.1002/j.1538-7305.1948.tb01338.x · DOI · Paper page
  27. Summers D. C. S. 2006. Quality. Pearson/Prentice Hall Upper Saddle River NJ. Summers D. C. S. 2006. Quality . Pearson/Prentice Hall Upper Saddle River NJ.
  28. Triola M. F., Elementary Statistics
  29. 10.1080/07421222.1996.11518099 · DOI · Paper page
  30. Winkel B. J., e and the Poisson Distribution
  31. 10.1109/TIT.1977.1055714 · DOI · Paper page
  32. 10.1109/TIT.1978.1055934 · DOI · Paper page

Cited by

Sorted by citations

Authors
Fisher, C. W., Lauria, E. J. M., & Matheus, C. C.
Affiliations
  • Marist University (US)
  • Marist College
  • State University of New York (US)
Venue
Journal of Data and Information Quality
Published
2009-12
Volume
1
Issue
3
Pages
1-21
ISSN
  • 1936-1955 (ISSN-L)
  • 1936-1963
OpenAlex
W2090624037
Cited by
40
References
3
Citations by year
2025: 8 · 2024: 3 · 2023: 3 · 2022: 3 · 2021: 1 · 2020: 1 · 2019: 1 · 2018: 4 · 2017: 3 · 2016: 1 · 2015: 3 · 2014: 2 · 2013: 2 · 2012: 2
FWCI
2.26
Type
journal article
Language
en
Open access
closed
Locations
Journal of Data and Information Quality (publishedVersion)
Topics
  • Physical Sciences › Computer Science › Information Systems › Data Quality and Management
  • Physical Sciences › Mathematics › Theoretical Computer Science › Algorithms and Data Compression
  • Physical Sciences › Mathematics › Statistics and Probability › Statistical Methods and Applications
Keywords
database accuracy, accuracy measures, error rate, Lempel-Ziv complexity, Poisson distribution, data quality measurement

About these checks

Registry, retraction, Cites and statistics results are computed, not judged, with one exception: a printed reference that no index lists is read once by a model before it counts as a citation error. Claims are extracted by a model and kept only when their quote appears verbatim in the text; each cited source is then checked, with a model’s help, for whether it says what the claim relies on. Those verdicts can be wrong — read the claim’s quote and the cited source before relying on one.

Statistics and arithmetic are recomputed, not judged.

Confidence bands are shown only for fields calibrated on our annotated test set. None is calibrated yet, so no band is shown.

What counts as a claim ›How we measure confidence ›How we check this ›

Are you an author, or do you see a problem with this page? Request a review