Missing Data in OLAP Cubes
- 1 July 2021
- journal article
- research article
- Published by IGI Global in Journal of Database Management
- Vol. 32 (3), 1-28
- https://doi.org/10.4018/jdm.2021070101
Abstract
Online analytical processing (OLAP) engines display aggregated data to help business analysts compare data, observe trends, and make decisions. Issues of data quality and, in particular, issues with missing data impact the quality of the information. Key decision-makers who rely on these data typically make decisions based on what they assume to be all the available data. The authors investigate three approaches to dealing with missing data: 1) ignore missing data, 2) show missing data explicitly (e.g., as unknown data values), and 3) design mitigation algorithms for missing data (e.g., allocate missing data into known value categories). The authors evaluate the approach with focus groups and controlled experiments. When one tries to inform decision-makers using the approaches in the research, the authors find that they often alter their decisions and adjust their decision confidence: individual differences of tolerance for ambiguity and pre-existing omission bias in the decision context influence their decisions. Request access from your librarian to read this article's full text.Keywords
This publication has 20 references indexed in Scilit:
- A Model of Error Propagation in Conjunctive Decisions and its Application to Database Quality ManagementJournal of Database Management, 2012
- A review and comparison of strategies for handling missing values in separate-and-conquer rule learningJournal of Intelligent Information Systems, 2010
- The Tolerance for Ambiguity Scale: Towards a more refined measure for international management researchInternational Journal of Intercultural Relations, 2010
- Do people treat missing information adaptively when making inferences?The Quarterly Journal of Experimental Psychology, 2009
- Comparative judgments with missing information: A regression and process tracing analysisActa Psychologica, 2007
- Managerial decision support with knowledge of accuracy and completeness of the relational aggregate functionsDecision Support Systems, 2006
- Supporting data quality management in decision-makingDecision Support Systems, 2006
- Omission bias, individual differences, and normalityOrganizational Behavior and Human Decision Processes, 2004
- Correspondence to what? Coherence to what? What is good scenario-based decision making?Technological Forecasting and Social Change, 2003
- Omission bias in vaccination decisions: Where’s the “omission”? Where’s the “bias”?Organizational Behavior and Human Decision Processes, 2003