Abstract
Multidimensional models are used to obtain the required database metadata for implementing the data warehouse. Surprisingly, current approaches for multidimensional modelling overlook the necessity of additional data-cube metadata to allow end-user tools to query the data warehouse. To overcome this situation, we propose the use of the Model Driven Architecture (MDA) in order to automatically derive both kinds of metadata in a systematic and integrated way.
This work has been partially supported by the ESPIA project (TIN2007-67078) and by the FPU grants AP2006-00332 and AP2005-1360 from the Spanish Ministry of Education and Science, and by the QUASIMODO project (PAC08-0157-0668) from the Castilla-La Mancha Ministry of Education and Science (Spain).
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
Inmon, W.H.: Building the Data Warehouse. Wiley, Chichester (1996)
Kimball, R., Ross, M.: The Data Warehouse Toolkit. Wiley, Chichester (2002)
Hüsemann, B., Lechtenbörger, J., Vossen, G.: Conceptual data warehouse modeling. In: DMDW, p. 6 (2000)
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)
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)
Object Management Group: Catalog of Specifications, http://www.omg.org
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)
Mazón, J.N., Trujillo, J.: An MDA approach for the development of data warehouses. Decis. Support Syst. doi: 10.1016/j.dss.2006.12.003, doi: 10.1016/j.dss.2006.12.003
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). Towards the Automatic Generation of Analytical End-User Tools Metadata for Data Warehouses. In: Gray, A., Jeffery, K., Shao, J. (eds) Sharing Data, Information and Knowledge. BNCOD 2008. Lecture Notes in Computer Science, vol 5071. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-540-70504-8_22
Download citation
DOI: https://doi.org/10.1007/978-3-540-70504-8_22
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-70503-1
Online ISBN: 978-3-540-70504-8
eBook Packages: Computer ScienceComputer Science (R0)