Skip to main content
Article thumbnail
Location of Repository

Specifying aggregation functions in multidimensional models with OCL

By Jordi Cabot, José Norberto Mazón López, Jesús Pardillo Vela and Juan Carlos Trujillo Mondéjar

Abstract

Multidimensional models are at the core of data warehouse systems, since they allow decision makers to early define the relevant information and queries that are required to satisfy their information needs. The use of aggregation functions is a cornerstone in the definition of these multidimensional queries. However, current proposals for multidimensional modeling lack the mechanisms to define aggregation functions at the conceptual level: multidimensional queries can only be defined once the rest of the system has already been implemented, which requires much effort and expertise. In this sense, the goal of this paper is to extend the Object Constraint Language (OCL) with a predefined set of aggregation functions. Our extension facilitates the definition of platform-independent queries as part of the specification of the conceptual multidimensional model of the data warehouse. These queries are automatically implemented with the rest of the data warehouse during the code-generation phase. The OCL extensions proposed in this paper have been validated by using the USE tool.Work supported by the projects: TIN2008-00444, ESPIA (TIN2007-67078) from the Spanish Ministry of Education and Science (MEC), QUASIMODO (PAC08-0157-0668) from the Castilla-La Mancha Ministry of Education and Science (Spain), and DEMETER (GVPRE/2008/063) from the Valencia Government (Spain). Jesús Pardillo is funded by MEC under FPU grant AP2006-00332

Topics: Multidimensional models, Data warehouse, Aggregation functions, OCL, Lenguajes y Sistemas Informáticos
Publisher: Springer Berlin / Heidelberg
Year: 2010
DOI identifier: 10.1007/978-3-642-16373-9_30
OAI identifier: oai:rua.ua.es:10045/21199

Suggested articles


To submit an update or takedown request for this paper, please submit an Update/Correction/Removal Request.