Abstract
The development of a data warehouse is based on the definition of a conceptual multidimensional model. This model is used to obtain the required database metadata for implementing the data- warehouse repository. Surprisingly, current approaches for multidimensional modelling overlook the necessity of generating additional data-cube metadata to allow end-user tools to query the data warehouse. To overcome this situation, we propose an approach based on “model-driven engineering” techniques in order to automatically derive both kinds of metadata in a systematic and integrated way. Specifically, in this paper, we describe how to obtain the data-cube metadata for “on-line analytical processing” (OLAP) tools. As a proof of concept, our approach has been implemented in the Eclipse development platform, thus showing its feasibility.
Supported by the TIN2007-67078 project from the Spanish Ministry of Education and Science and FPU grants AP2006-00332 and AP2005-1360, and by the PAC08-0157-0668 project from the Castilla-La Mancha Ministry of Education and Science.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
References
Jarke, M., Lenzerini, M., Vassiliou, Y., Vassiliadis, P.: Fundamentals of Data Warehouses. Springer, Heidelberg (2000)
Inmon, W.H.: Building the Data Warehouse. Wiley, Chichester (2005)
Kimball, R., Ross, M.: The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling. Wiley, Chichester (2002)
Hüsemann, B., Lechtenbörger, J., Vossen, G.: Conceptual data warehouse modeling. In: DMDW, p. 6 (2000)
Rizzi, S., Abelló, A., Lechtenbörger, J., Trujillo, J.: Research in data warehouse modeling and design: dead or alive?. In: DOLAP, pp. 3–10 (2006)
Golfarelli, M., Maio, D., Rizzi, S.: The Dimensional Fact Model: A Conceptual Model for Data Warehouses. Int. J. Cooperative Inf. Syst. 7(2-3), 215–247 (1998)
Abelló, A., Samos, J., Saltor, F.: YAM2: a multidimensional conceptual model extending UML. Inf. Syst. 31(6), 541–567 (2006)
Prat, N., Akoka, J., Comyn-Wattiau, I.: A UML-based data warehouse design method. Decis. Support Syst. 42(3), 1449–1473 (2006)
Pardillo, J., Mazón, J.N., Trujillo, J.: Towards the Automatic Generation of Analytical End-user Tool Metadata for Data Warehouses. In: BNCOD, pp. 203–206 (2008)
Bézivin, J.: Model Driven Engineering: An Emerging Technical Space. In: GTTSE, pp. 36–64 (2006)
Chaudhuri, S., Dayal, U.: An Overview of Data Warehousing and OLAP Technology. SIGMOD Record 26(1), 65–74 (1997)
Mazón, J.N., Trujillo, J.: An MDA approach for the development of data warehouses. Decision Support Systems 45(1), 41–58 (2008)
Hahn, K., Sapia, C., Blaschka, M.: Automatically Generating OLAP Schemata from Conceptual Graphical Models. In: DOLAP, pp. 9–16 (2000)
Object Management Group (OMG): Catalog of OMG Specifications (March 2008), http://www.omg.org/technology/documents/spec_catalog.htm
Luján-Mora, S., Trujillo, J., Song, I.Y.: A UML profile for multidimensional modeling in data warehouses. Data Knowl. Eng. 59(3), 725–769 (2006)
Giovinazzo, W.A.: Object-Oriented Data Warehouse Design: Building A Star Schema. Prentice Hall, Englewood Cliffs (2000)
Cuzzocrea, A., Furfaro, F., Saccà, D.: Hand-OLAP: A System for Delivering OLAP Services on Handheld Devices. In: ISADS, pp. 80–87 (2003)
Maniatis, A.S.: The Case for Mobile OLAP. In: Lindner, W., Mesiti, M., Türker, C., Tzitzikas, Y., Vakali, A.I. (eds.) EDBT 2004. LNCS, vol. 3268, pp. 405–414. Springer, Heidelberg (2004)
Rizzi, S.: OLAP preferences: a research agenda. In: DOLAP, pp. 99–100 (2007)
Zubcoff, J.J., Pardillo, J., Trujillo, J.: Integrating Clustering Data Mining into the Multidimensional Modeling of Data Warehouses with UML Profiles. In: Song, I.-Y., Eder, J., Nguyen, T.M. (eds.) DaWaK 2007. LNCS, vol. 4654, pp. 199–208. Springer, Heidelberg (2007)
Author information
Authors and Affiliations
Editor information
Rights and permissions
Copyright information
© 2008 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Pardillo, J., Mazón, JN., Trujillo, J. (2008). Model-Driven Metadata for OLAP Cubes from the Conceptual Modelling of Data Warehouses. In: Song, IY., Eder, J., Nguyen, T.M. (eds) Data Warehousing and Knowledge Discovery. DaWaK 2008. Lecture Notes in Computer Science, vol 5182. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-540-85836-2_2
Download citation
DOI: https://doi.org/10.1007/978-3-540-85836-2_2
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-85835-5
Online ISBN: 978-3-540-85836-2
eBook Packages: Computer ScienceComputer Science (R0)