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

Cristina Ciferri, Ricardo Ciferri, Leticia Gómez, Markus Schneider, Alejandro Vaisman and Esteban Zimányi
Additional contact information
Cristina Ciferri: Department of Computer Science, Universidade de São Paulo at São Carlos, São Carlos, Brazil
Ricardo Ciferri: Department of Computer Science, Universidade de São Paulo at São Carlos, São Carlos, Brazil
Leticia Gómez: Department of Software Engineering, Instituto Tecnológico de Buenos Aires, Buenos Aires, Argentina
Markus Schneider: Department of Computer and Information Science and Engineering, University of Florida, Gainesville, FL, USA
Alejandro Vaisman: Department of Computer & Decision Engineering, Université Libre de Bruxelles, Brussels, Belgium
Esteban Zimányi: Department of Computer & Decision Engineering (CoDE), Université Libre de Bruxelles, Brussels, Belgium

International Journal of Data Warehousing and Mining (IJDWM), 2013, vol. 9, issue 2, 39-65

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.

Date: 2013
References: Add references at CitEc
Citations:

Downloads: (external link)
http://services.igi-global.com/resolvedoi/resolve. ... 4018/jdwm.2013040103 (application/pdf)

Related works:
This item may be available elsewhere in EconPapers: Search for items with the same title.

Export reference: BibTeX RIS (EndNote, ProCite, RefMan) HTML/Text

Persistent link: https://EconPapers.repec.org/RePEc:igg:jdwm00:v:9:y:2013:i:2:p:39-65

Access Statistics for this article

International Journal of Data Warehousing and Mining (IJDWM) is currently edited by Eric Pardede

More articles in International Journal of Data Warehousing and Mining (IJDWM) from IGI Global
Bibliographic data for series maintained by Journal Editor ().