Managerial decision support with knowledge of accuracy and completeness of the relational aggregate functions

Decision Support Systems

Volumn 42, Issue 3, 2006, Pages 1494-1502

  Parssian, Amir ^a  

^a UNIVERSITY OF ILLINOIS AT SPRINGFIELD   (United States)

Author keywords

Information quality; Relational aggregate functions; Sampling strategies

Indexed keywords

BIT ERROR RATE; DATA ACQUISITION; DATA WAREHOUSES; DECISION MAKING; ERROR CORRECTION; INFORMATION ANALYSIS; KNOWLEDGE ACQUISITION; MAXIMUM LIKELIHOOD ESTIMATION; MONTE CARLO METHODS;

DATA ERROR RATE; INFORMATION QUALITY; MANAGERIAL DECISION SUPPORT; RELATIONAL AGGREGATE FUNCTIONS;

DECISION SUPPORT SYSTEMS;

EID: 33750490429     PISSN: 01679236     EISSN: None     Source Type: Journal    
DOI: 10.1016/j.dss.2005.12.005     Document Type: Article

References (29)

1. Ballou D.P., Pazer H.L., Wang R.Y., and Tayi G.K. Modeling information manufacturing systems to determine information product quality. Management Science 44 4 (1998) 462-484
2. Boland P.J., and Proschan F. Schur convexity of the maximum likelihood function for the multivariate hypergeometric and multinomial distributions. Statistics & Probability Letters 5 (1987) 317-322
3. Chen A.L.P., Chiu J., and Tseng F.S.C. Evaluating aggregate operations over imprecise data. IEEE Transactions on Knowledge and Data Engineering 8 2 (1996) 273-284
4. Chengalur-Smith I.N., Ballou D.P., and Pazer H.L. The impact of data quality information on decision making: an exploratory analysis. IEEE Transactions on Knowledge and Data Engineering 11 6 (1999) 853-864
5. Codd E.F. Missing information (applicable and inapplicable) in relational databases. SIGMOD Record 15 4 (1986) 53-78
6. Eppler M.J. Managing Information Quality (2003), Springer Verlag, Berlin
7. G. Gottlob, R. Zicari, Closed world databases opened through null values. Proceedings of the 14th VLDB Conference, Los Angeles, California (1988) 50-61.
8. Hou W.C., and Ozsoyoglu G. Statistical estimators for aggregate relational algebra queries. ACM Transactions on Database Systems 16 4 (1991) 600-654
9. Imielinski T., and Lipski W. Incomplete information in relational databases. Journal of ACM 31 4 (1984) 761-791
10. Johnson N.L., Kotz S., and Kemp A.W. Univariate Discrete Distributions (1993), Wiley Interscience
11. Klein B.D., Goodhue D.L., and Davis G.B. Can humans detect errors in data? Impact of base rates, incentives, and goals. MIS Quarterly (1997 (June)) 169-194
12. H. Kon, S. Madnick, M.D. Seigel, Good answers from bad data: a data management strategy. Proceedings of Workshop on Information Technologies and Systems, Amsterdam, The Netherlands, 1995.
13. Montgomery D.C. Introduction to Statistical Quality Control. 4th ed. (2001), Wiley
14. Montgomery A.Y., D'Souza D.J., and Lee S.B. The Cost of Relational Algebraic Operations on Skewed Data: Estimates and Experiments, Information Processing (1983) 235-241
15. Morey R.C. Estimating and improving the quality of information in the MIS. Communications of the ACM 25 5 (1982) 337-342
16. A. Motro, Completeness information and its application to query processing. Proceedings of the 12th VLDB Conference, Kyoto, Japan (1986) 170-178.
17. Motro A. Integrity = Validity + Completeness. ACM Transactions on Database Systems 14 4 (1989) 480-502
18. A. Motro, I. Rakov, Estimating the quality of databases. Proceedings of the Third International Conference on Flexible Query Answering Systems, Roskilde, Denmark (1998) 298-307.
19. A. Ola, G. Ozsoyoglu, A family of incomplete relational database models. Proceedings of the 15th VLDB Conference, Amsterdam, Holland (1989) 23-31.
20. F. Olken, D. Rotemt, Simple random sampling from relational databases. Proceedings of the 12th VLDB Conference, Kyoto, Japan (1986) 160-169.
21. Ozsoyoglu G., Ozsoyoglu Z.M., and Matos V. Extending relational algebra and relational calculus with set-valued attributes and aggregate functions. ACM Transactions on Database Systems 12 4 (1987) 566-592
22. Parssian A., Sarkar S., and Jacob V.S. Assessing data quality for information products: impact of selection, projection, and Cartesian product. Management Science 50 7 (2004) 967-982
23. Prade H., and Testemale C. Generalizing database relational algebra for the treatment of incomplete or uncertain information and vague queries. Information Sciences 34 (1984) 115-143
24. M. Reddy, R.Y. Wang, Estimating Data Accuracy in a Federated Database Environment. Proceedings of 6th International Conference on Information Systems and Management of Data, Bombay, India, (1995) 115-134.
25. Reiter R. On closed world databases. In: Gallaire H., and Minker J. (Eds). Logic and Databases (1978), Plenum Press 55-76
26. Shankaranarayan G., Ziad M., and Wang R.Y. Managing data quality in dynamic decision environments: an information product approach. Journal of Database Management 14 4 (2003) 14-32
27. Thomson S.K. Sampling. 2nd ed. (2002), Wiley Interscience, New York
28. Wand Y., and Wang R.Y. Anchoring data quality dimensions in ontological foundations. Communications of the ACM 39 11 (1996) 86-95
29. Wang R.Y., Reddy M.P., and Kon H.B. Toward quality data: an attribute-based approach. Decision Support Systems 13 (1995) 349-372