Welcome to the InfoSci Platform
Reference Hub2
Missing Data in OLAP Cubes: Challenges and Strategies

Missing Data in OLAP Cubes: Challenges and Strategies

Monica Chiarini Tremblay, Alan R. Hevner
Copyright: © 2021 |Volume: 32 |Issue: 3 |Pages: 28
ISSN: 1063-8016|EISSN: 1533-8010|EISBN13: 9781799859109|DOI: 10.4018/JDM.2021070101
Cite Article Cite Article

MLA

Tremblay, Monica Chiarini, and Alan R. Hevner. "Missing Data in OLAP Cubes: Challenges and Strategies." JDM vol.32, no.3 2021: pp.1-28. http://doi.org/10.4018/JDM.2021070101

APA

Tremblay, M. C. & Hevner, A. R. (2021). Missing Data in OLAP Cubes: Challenges and Strategies. Journal of Database Management (JDM), 32(3), 1-28. http://doi.org/10.4018/JDM.2021070101

Chicago

Tremblay, Monica Chiarini, and Alan R. Hevner. "Missing Data in OLAP Cubes: Challenges and Strategies," Journal of Database Management (JDM) 32, no.3: 1-28. http://doi.org/10.4018/JDM.2021070101

Export Reference

Mendeley
Favorite Full-Issue Download

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

You do not own this content. Please login to recommend this title to your institution's librarian or purchase it from the IGI Global bookstore.