Abstract
Decision Support System (DSS) designers face two data models complexities: OLTP (On Line Transaction Processing) database model and multidimensional model. These models relying on different concepts force the designer to have double skills. The objective of this paper is to assist the DSS designer producing rapidly Data Mart (DM) schemas starting from the Data Warehouse (DW) data model. More accurately, we aim to automate the generation of DM schemas from a relational DW schema according to the MDA (Model Driven Architecture) paradigm. To do so, we propose an approach based on a set of transformation rules that we define in ATL language and illustrate with an example.
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
Kimball, R.: The Data Warehouse Toolkit. John Wiley and Sons Inc., Chichester (1997)
Kimball, R., Revues, L., Ross, M., Thornthwaite, W.: Le data warehouse: Guide de conduite de projet, Eyrolles (2005)
Golfarelli, M., Maio, D., Rizzi, S.: Conceptual Design of Data Warehouses from E/R Schemas. In: Conference on System Sciences, Kona-Hawaii, vol. VII (1998)
Cabibbo, L., Torlone, R.: A Logical Approach to Multidimensional Databases. In: Conference on Extended Database Technology, Valencia, Spain, pp. 187–197 (1998)
Moody, L.D., Kortink, M.A.R.: From Enterprise Models to Dimensional Models: A Methodology for Data Warehouses and Data Mart Design. In: Proc. of the International Workshop on Design and Management of Data Warehouses, Stockholm, Sweden (2000)
Hüsemann, B., Lechtenbörger, J., Vossen, G.: Conceptual Data Warehouse Design. In: Proc. of the Int’l Workshop on Design and Management of Data Warehouses, Stockholm, Sweden, pp. 6.1–6.11 (2000)
Böhnlein, M., Ulbrich-vom Ende, A.: Deriving Initial Data Warehouse Structures from the Conceptual Data Models of the Underlying Operational Information Systems. In: Proc. Int. Workshop on Data Warehousing and OLAP, Kansas City, MO, USA, pp. 15–21 (1999)
Sinz, E.J.: Datenmodellierung im Strukturierten Entity-Relationship-Modell (SERM), Fachliche Analyse von Informations systemen. Addison-Wesley, Bonn (1992)
Phipps, C., Davis, K.: Automating data warehouse conceptual schema design and evaluation. In: DMDW 2002, Canada (2002)
Bonifati, A., Cattaneo, F., Ceri, S., Fuggetta, A., Paraboschi, S.: Designing Data Marts for Data Warehouse. ACM Transaction on Software Engineering and Methodology 10, 452–483 (2001)
Soussi, A., Feki, J., Gargouri, F.: Approche semi-automatisée de conception de schémas multidimensionnels valides. Revue RNTI B(1), 71–90 (2005)
Prat, N., Akoka, J., Comyn-Wattiau, I.: A UML-based data warehouse design method. Decision Support Systems 42(3), 1449–1473 (2006)
OMG, Object Management Group, MDA Guide 1.0.1, http://www.omg.org/cgi-bin/doc?omg/03-06-01
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2011 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Choura, H., Feki, J. (2011). MDA Compliant Approach for Data Mart Schemas Generation. In: Bellatreche, L., Mota Pinto, F. (eds) Model and Data Engineering. MEDI 2011. Lecture Notes in Computer Science, vol 6918. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-642-24443-8_27
Download citation
DOI: https://doi.org/10.1007/978-3-642-24443-8_27
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-642-24442-1
Online ISBN: 978-3-642-24443-8
eBook Packages: Computer ScienceComputer Science (R0)