Specifying aggregation functions in multidimensional models with OCL
Please use this identifier to cite or link to this item:
http://hdl.handle.net/10045/21199
Title: | Specifying aggregation functions in multidimensional models with OCL |
---|---|
Authors: | Cabot, Jordi | Mazón, Jose-Norberto | Pardillo Vela, Jesús | Trujillo, Juan |
Research Group/s: | Lucentia |
Center, Department or Service: | Universidad de Alicante. Departamento de Lenguajes y Sistemas Informáticos |
Keywords: | Multidimensional models | Data warehouse | Aggregation functions | OCL |
Knowledge Area: | Lenguajes y Sistemas Informáticos |
Issue Date: | 2010 |
Publisher: | Springer Berlin / Heidelberg |
Citation: | CABOT, Jordi, et al. "Specifying aggregation functions in multidimensional models with OCL". En: Conceptual Modeling - ER 2010 : 29th International Conference on Conceptual Modeling, Vancouver, BC, Canada, November 1-4, 2010, Proceedings / Jeffrey Parsons [et al.] (Eds.). Berlin : Springer, 2010. (Lecture Notes in Computer Science; 6412). ISBN 978-3-642-16372-2, pp. 419-432 |
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. |
Sponsor: | 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. |
URI: | http://hdl.handle.net/10045/21199 |
ISBN: | 978-3-642-16372-2 |
ISSN: | 0302-9743 (Print) | 1611-3349 (Online) |
DOI: | 10.1007/978-3-642-16373-9_30 |
Language: | eng |
Type: | info:eu-repo/semantics/conferenceObject |
Rights: | The original publication is available at www.springerlink.com |
Peer Review: | si |
Publisher version: | http://dx.doi.org/10.1007/978-3-642-16373-9_30 |
Appears in Collections: | INV - WaKe - Comunicaciones a Congresos, Conferencias, etc. INV - LUCENTIA - Comunicaciones a Congresos, Conferencias, etc. |
Files in This Item:
File | Description | Size | Format | |
---|---|---|---|---|
ER10.pdf | Versión revisada (acceso abierto) | 423,94 kB | Adobe PDF | Open Preview |
ER10_final.pdf | Versión final (acceso restringido) | 303,91 kB | Adobe PDF | Open Request a copy |
Items in RUA are protected by copyright, with all rights reserved, unless otherwise indicated.