Cube Algebra: A Generic User-Centric Model and Query Language for OLAP Cubes | IGI Global Scientific Publishing
Welcome to the InfoSci Platform
Reference Hub18
Cube Algebra: A Generic User-Centric Model and Query Language for OLAP Cubes

Cube Algebra: A Generic User-Centric Model and Query Language for OLAP Cubes

Cristina Ciferri, Ricardo Ciferri, Leticia Gómez, Markus Schneider, Alejandro Vaisman, Esteban Zimányi
Copyright: © 2013 |Volume: 9 |Issue: 2 |Pages: 27
ISSN: 1548-3924|EISSN: 1548-3932|EISBN13: 9781466633087|DOI: 10.4018/jdwm.2013040103
Cite Article Cite Article

MLA

Ciferri, Cristina, et al. "Cube Algebra: A Generic User-Centric Model and Query Language for OLAP Cubes." IJDWM vol.9, no.2 2013: pp.39-65. https://doi.org/10.4018/jdwm.2013040103

APA

Ciferri, C., Ciferri, R., Gómez, L., Schneider, M., Vaisman, A., & Zimányi, E. (2013). Cube Algebra: A Generic User-Centric Model and Query Language for OLAP Cubes. International Journal of Data Warehousing and Mining (IJDWM), 9(2), 39-65. https://doi.org/10.4018/jdwm.2013040103

Chicago

Ciferri, Cristina, et al. "Cube Algebra: A Generic User-Centric Model and Query Language for OLAP Cubes," International Journal of Data Warehousing and Mining (IJDWM) 9, no.2: 39-65. https://doi.org/10.4018/jdwm.2013040103

Export Reference

Mendeley
Favorite Full-Issue Download

Abstract

The lack of an appropriate conceptual model for data warehouses and OLAP systems has led to the tendency to deploy logical models (for example, star, snowflake, and constellation schemas) for them as conceptual models. ER model extensions, UML extensions, special graphical user interfaces, and dashboards have been proposed as conceptual approaches. However, they introduce their own problems, are somehow complex and difficult to understand, and are not always user-friendly. They also require a high learning curve, and most of them address only structural design, not considering associated operations. Therefore, they are not really an improvement and, in the end, only represent a reflection of the logical model. The essential drawback of offering this system-centric view as a user concept is that knowledge workers are confronted with the full and overwhelming complexity of these systems as well as complicated and user-unfriendly query languages such as SQL OLAP and MDX. In this article, the authors propose a user-centric conceptual model for data warehouses and OLAP systems, called the Cube Algebra. It takes the cube metaphor literally and provides the knowledge worker with high-level cube objects and related concepts. A novel query language leverages well known high-level operations such as roll-up, drill-down, slice, and drill-across. As a result, the logical and physical levels are hidden from the unskilled end user.

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 Scientific Publishing bookstore.