{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2026,6,10]],"date-time":"2026-06-10T15:26:11Z","timestamp":1781105171142,"version":"3.54.1"},"reference-count":24,"publisher":"IGI Global Scientific Publishing","issue":"2","content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":[],"published-print":{"date-parts":[[2013,4,1]]},"abstract":"<p>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.<\/p>","DOI":"10.4018\/jdwm.2013040103","type":"journal-article","created":{"date-parts":[[2013,7,1]],"date-time":"2013-07-01T12:22:28Z","timestamp":1372681348000},"page":"39-65","source":"Crossref","is-referenced-by-count":18,"title":["Cube Algebra"],"prefix":"10.4018","volume":"9","author":[{"given":"Cristina","family":"Ciferri","sequence":"first","affiliation":[{"name":"Department of Computer Science, Universidade de S\u00e3o Paulo at S\u00e3o Carlos, S\u00e3o Carlos, Brazil"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Ricardo","family":"Ciferri","sequence":"additional","affiliation":[{"name":"Department of Computer Science, Universidade de S\u00e3o Paulo at S\u00e3o Carlos, S\u00e3o Carlos, Brazil"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Leticia","family":"G\u00f3mez","sequence":"additional","affiliation":[{"name":"Department of Software Engineering, Instituto Tecnol\u00f3gico de Buenos Aires, Buenos Aires, Argentina"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Markus","family":"Schneider","sequence":"additional","affiliation":[{"name":"Department of Computer and Information Science and Engineering, University of Florida, Gainesville, FL, USA"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Alejandro","family":"Vaisman","sequence":"additional","affiliation":[{"name":"Department of Computer & Decision Engineering, Universit\u00e9 Libre de Bruxelles, Brussels, Belgium"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Esteban","family":"Zim\u00e1nyi","sequence":"additional","affiliation":[{"name":"Department of Computer & Decision Engineering (CoDE), Universit\u00e9 Libre de Bruxelles, Brussels, Belgium"}],"role":[{"vocabulary":"crossref","role":"author"}]}],"member":"2432","reference":[{"key":"jdwm.2013040103-0","doi-asserted-by":"crossref","unstructured":"Abell\u00f3, A., Samos, J., & Saltor, F. (2001) Understanding facts in a multidimensional object-oriented model. In Proceedings of the 4th ACM International Workshop on Data Warehousing and OLAP. ACM Press.","DOI":"10.1145\/512236.512241"},{"key":"jdwm.2013040103-1","doi-asserted-by":"crossref","unstructured":"Abell\u00f3, A., Samos, J., & Saltor, F. (2002). On relationships offering new drill-across possibilities. In D. Theodoratos (Ed.), Proceedings of the 5th International Workshop on Data Warehousing and OLAP (pp. 7-13). ACM Press.","DOI":"10.1145\/583890.583892"},{"key":"jdwm.2013040103-2","doi-asserted-by":"publisher","DOI":"10.1016\/j.is.2004.12.002"},{"key":"jdwm.2013040103-3","doi-asserted-by":"crossref","unstructured":"Agrawal, R., Gupta, A., & Sarawagi, S. (1997). Modeling multidimensional databases. In W. A. Gray & P. Larson (Eds.), Proceedings of the 13th International Conference on Data Engineering (pp. 232-243). IEEE Computer Society Press.","DOI":"10.1109\/ICDE.1997.581777"},{"key":"jdwm.2013040103-4","doi-asserted-by":"crossref","unstructured":"Cabibbo, L., & Torlone, R. (1997). Querying multidimensional databases. In S. Cluet & R. Hull (Eds.), Proceedings of the 6th International Workshop on Database Programming Languages, LCNS 1369 (pp. 319\u2013335). Springer-Verlag.","DOI":"10.1007\/3-540-64823-2_18"},{"key":"jdwm.2013040103-5","doi-asserted-by":"crossref","unstructured":"Cabibbo, L., & Torlone, R. (1998). A logical approach to multidimensional databases. In H. Schek, F. Saltor, I. Ramos & G. Alonso (Eds.), Proceedings of the 6th International Conference on Extending Database Technology, LCNS 1377 (pp. 253-269). Springer-Verlag.","DOI":"10.1007\/BFb0100985"},{"key":"jdwm.2013040103-6","unstructured":"Cabot, J., Maz\u00f3n, J.-N., Trujillo, J., & Pardillo, J. (2009). Towards the conceptual specification of statistical functions with OCL. In Proceedings of CAiSE Forum (pp. 7-12)."},{"key":"jdwm.2013040103-7","doi-asserted-by":"publisher","DOI":"10.1016\/S0167-9236(99)00052-4"},{"key":"jdwm.2013040103-8","doi-asserted-by":"crossref","unstructured":"Golfarelli, M., & Rizzi, S. (1998). A methodological framework for data warehouse design. In Proceedings of the 1st International Workshop on Data Warehousing and OLAP (pp. 3-9). ACM Press.","DOI":"10.1145\/294260.294261"},{"key":"jdwm.2013040103-9","unstructured":"Gyssens, M., & Lakshmanan, L. (1997). A foundation for multi-dimensional databases. In M. Jarke, M. Carey, K. Dittrich, F. Lochovsky, P. Loucopoulos & M. Jeusfeld (Eds.), Proceedings of the 23rd International Conference on Very Large Data Bases (pp. 106-115). Morgan Kaufmann."},{"key":"jdwm.2013040103-10","doi-asserted-by":"crossref","unstructured":"Lehner, W. (1998). Modelling large scale OLAP scenarios. In H. Schek, F. Saltor, I. Ramos & G. Alonso (Eds.), Proceedings of the 6th International Conference on Extending Database Technology, LCNS 1377 (pp. 153-167). Springer-Verlag.","DOI":"10.1007\/BFb0100983"},{"key":"jdwm.2013040103-11","doi-asserted-by":"crossref","unstructured":"Li, C., & Wang, S. (1996). A data model for supporting on-line analytical processing. In Proceedings of the 5th International Conference on Information and Knowledge Management (pp. 81-88). ACM Press.","DOI":"10.1145\/238355.238444"},{"key":"jdwm.2013040103-12","author":"E.Malinowski","year":"2008","journal-title":"Advanced data warehouse design: From conventional to spatial and temporal applications"},{"issue":"5","key":"jdwm.2013040103-13","first-page":"515","article-title":"Modeling and querying multidimensional databases: An overview.","volume":"2","author":"P.Marcel","year":"1999","journal-title":"Networking and Information Systems"},{"key":"jdwm.2013040103-14","doi-asserted-by":"crossref","unstructured":"Nguyen, T. B., Tjoa, A. M., & Wagner, R. (2000). An object oriented multidimensional data model for OLAP. In H. Lu & A. Zhou (Eds.), Proceedings of the 1st International Conference on Web-Age Information Management, LNCS 1846 (pp. 69-82). Springer-Verlag.","DOI":"10.1007\/3-540-45151-X_7"},{"key":"jdwm.2013040103-15","doi-asserted-by":"crossref","unstructured":"Pardillo, J., Maz\u00f3n, J.-N., & Trujillo, J. (2008). Bridging the semantic gap in OLAP models: Platform-independent queries. In I.-Y. Song & A. Abell\u00f3 (Eds.), Proceedings of the 11th ACM International Workshop on Data Warehousing and OLAP (pp. 89-96). ACM Press.","DOI":"10.1145\/1458432.1458448"},{"key":"jdwm.2013040103-16","doi-asserted-by":"publisher","DOI":"10.1016\/j.ins.2009.11.006"},{"key":"jdwm.2013040103-17","doi-asserted-by":"publisher","DOI":"10.4018\/jdwm.2008010102"},{"key":"jdwm.2013040103-18","first-page":"1","article-title":"Conceptual modeling solutions for the data warehouse","author":"S.Rizzi","year":"2007","journal-title":"Data warehouses and OLAP: Concepts, architectures and solutions"},{"key":"jdwm.2013040103-19","doi-asserted-by":"crossref","unstructured":"Romero, O., & Abell\u00f3, A. (2007). On the need of a reference algebra for OLAP. In I.-Y. Song, J. Eder and T.M. Nguyen (Eds.), Proceedings of the 9th International Conference on Data Warehousing and Knowledge Discovery, (LCNS 4654, pp. 99-110). Springer-Verlag.","DOI":"10.1007\/978-3-540-74553-2_10"},{"key":"jdwm.2013040103-20","doi-asserted-by":"crossref","unstructured":"Tryfona, N., Busborg, F., & Borch Christiansen, J. (1999). starER: A conceptual model for data warehouse design. In Proceedings of the 2nd ACM International Workshop on Data Warehousing and OLAP (pp. 3-8). ACM Press.","DOI":"10.1145\/319757.319776"},{"key":"jdwm.2013040103-21","unstructured":"Tsois, A., Karayannidis, N., & Sellis, T. (2001). MAC: Conceptual data modeling for OLAP. In D. Theodoratos, J. Hammer, M. Jeusfeld & M. Staudt (Eds.), Proceedings of the 3rd International Workshop on Design and Management of Data Warehouses (pp. 5). CEUR-WS.org."},{"key":"jdwm.2013040103-22","volume":"Vol. I","author":"J.Ullman","year":"1988","journal-title":"Principles of database and knowledge-base systems"},{"key":"jdwm.2013040103-23","doi-asserted-by":"crossref","unstructured":"Vassiliadis, P. (1998). Modeling multidimensional databases, cubes and cube operations. In M. Rafanelli and M. Jarke (Eds.), Proceedings of the 10th International Conference on Scientific and Statistical Database Management, (pp. 53-62). IEEE Computer Society.","DOI":"10.1109\/SSDM.1998.688111"}],"container-title":["International Journal of Data Warehousing and Mining"],"original-title":[],"language":"ng","link":[{"URL":"https:\/\/www.igi-global.com\/viewtitle.aspx?TitleId=78286","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2022,6,1]],"date-time":"2022-06-01T17:33:01Z","timestamp":1654104781000},"score":1,"resource":{"primary":{"URL":"https:\/\/services.igi-global.com\/resolvedoi\/resolve.aspx?doi=10.4018\/jdwm.2013040103"}},"subtitle":["A Generic User-Centric Model and Query Language for OLAP Cubes"],"short-title":[],"issued":{"date-parts":[[2013,4,1]]},"references-count":24,"journal-issue":{"issue":"2","published-print":{"date-parts":[[2013,4]]}},"URL":"https:\/\/doi.org\/10.4018\/jdwm.2013040103","relation":{},"ISSN":["1548-3924","1548-3932"],"issn-type":[{"value":"1548-3924","type":"print"},{"value":"1548-3932","type":"electronic"}],"subject":[],"published":{"date-parts":[[2013,4,1]]}}}