Computer Science and Engineering

p-ISSN: 2163-1484     e-ISSN: 2163-1492

2011;  1(1): 8-14

doi: 10.5923/j.computer.20110101.02

Data Warehouse Scripts Generation Through MDA Cartridge

Copyright © 2011 Scientific & Academic Publishing. All Rights Reserved.

Abstract

Increasing market competitiveness has led entrepreneurs to require more and more information from Information Technology areas to allow for efficient decision-making. Two alternatives to solving this problem are allied in this work: use of Model Driven Architecture (MDA) and Data Warehousing (DW). This research developed and tested a MDA cartridge. It creates scripts for automatic generation and loads DW based databases on the Online Transaction Processing Model (OLTP) through a MDA tool. With the use of this approach any change in the model would be a corresponding change in the scripts without manual rework.

Keywords: Database, MDA, Data Warehouse, Data Model

Paper's body in HTML will come soon.

Reference

[1]  AndroMDA, “What is AndroMDA”, 2006. [Online]. Avail-able: http://galaxy.andromda.org/index.php?option=com_content&view=category&layout=blog&id=19&Itemid=42.[Accessed: Dez. 14, 2009]
[2]  Apache, “Apache Velocity Engine”, 2008. [Online]. Available: http://velocity.apache.org/engine/index.html. [Accessed: Dez. 14, 2009]
[3]  G. Booch, J. Rumbaugh and I. Jacobson, “The Unified Mod-elling Language User Guide”. 1998
[4]  R. Elmasri and S. B. Navathe, Sistema de Banco de Dados, São Paulo: Pearson Addison Wesley, 2005
[5]  J. Farhad, The UML Extension Mechanisms Dept of Computer Science, London: University College London, 2002
[6]  W. H. Inmon, Building the Data Warehouse, Q E D Publisher Co, 1992
[7]  R. Kimball, The Data Warehouse Toolkit: Practical Techniques for Building Dimensional Data Warehouses. John Wiley & Sons Inc Press, 1996
[8]  A. Kleppe, J. Warmer and W. Bast, MDA Explained: The Model Driven Architecture™, Practice and Promise. 2003
[9]  M. Kontio, Architectural Manifesto: MDA for the enterprise, 2005. [Online]. Available: https://www.ibm.com/developerworks/wireless/library/wi-arch16/. [Accessed: Dez. 14, 2009]
[10]  G. A. Lewis and L. Wrage, Approaches to Constructive In-teroperability (CMU/SEI-2004-TR-020 ESC-TR-2004-020). Pittsburgh, PA: Software Engineering Institute, Carnegie Mellon University, [Online]. Available: http://www.sei.cmu.edu/library/abstracts/reports/04tr020.cfm [Accessed: Dez. 14, 2009]
[11]  OMG, Object Management Group, 2008. [Online]. Available: http://www.omg.org/cgi-bin/doc?formal/03-03-26 [Accessed: Dez. 14, 2009]
[12]  OMG, Object Management Group, 2007. [Online]. Available: http://www.omg.org/gettingstarted/what_is_uml.htm[Accessed: Dez. 14, 2009]
[13]  OMG, Object Management Group, 2003. MDA Guide Ver-sion 1.0.1. – Document omg/2003-06-01 [Online]. [Accessed: Dez. 14, 2009]
[14]  OMG, Object Management Group, 2003. Common Warehouse Metamodel (CWM) Specification,Version 1.1, Volume 1 - Document - formal/03-03-02, [Online]. [Accessed: Dez. 14, 2009]
[15]  I. Sommerville, Engenharia de software. São Paulo: Pearson Addison Wesley, 2003
[16]  C. KocH, Why doesn´t you ROI add up? You do the match. Darwin Magazine: March, 2002
[17]  Wilkinson, K., Simitsis, A., Castellanos, M., Dayal, U., 2010, "Leveraging Business Process Models For Etl Design". In: Er'10 Proceedings of the 29th International Conference On Conceptual Modeling, Pp.15-30. Vancouver, Bc, Canada. Novembro 2010
[18]  Zepeda, L., Celma, M., Zatarain, R., 2009, "A Mixed Approach for Data Warehouse Conceptual Design With Mda". In: Iccsa 2008, Part Ii, Lncs 5073, Pp. 1204–1218. Perugia, Itália 2008
[19]  Saurabh, A. K., Nagpal, B., 2011. "A Survey On Current Security Strategies In Data Warehouses". In: International Journal of Engineering Science and Technology (Ijest), Vol. 3 No. 4, Pp.3485-3488. Issn: 0975-5462. Abril 2011
[20]  Pardillo, J. Mazón, J. N., Trujillo, J., 2010, "Designing Olap Schemata for Data Warehouses from Conceptual Models With Mda". In: Computer and Information Science, Volume: In Press, Pp. 1-13. Issn: 01679236. Doi: 10.1016/J.Dss.2010.04.006
[21]  Muñoz, L., Mazón, J. N., Trujillo, J., 2009, "Automatic Generation of Etl Processes From Conceptual Models". In: Dolap'09 Proceeding Of The Acm Twelfth International Workshop On Data Warehousing And Olap, Pp.33-40. Isbn: 978-1-60558-801-8 Doi>10.1145/1651291.1651298. Hong Kong, China. Novembro 2009
[22]  Moral, O. R., Simitsis, A., Gamazo, A. A., 2010, "Gem Re-quirement Driven Generation of Etl and Multidimensional Conceptual Designs". Technical Report. Universitat Politècnica De Catalunya. Departament D'enginyeria De Serveis I Sistemes D'informació
[23]  Hyensook, K., Oussena, S., Zhang, Y., Clark, T., 2010, "Automatic Generation of Data Merging Program Codes". In: 5th International Conference on Software and Data Tech-nologies (Icsoft 2010), Pp. 179-186. Greece, Julho, 2010
[24]  Glorio O., Trujillo J., 2008, "An Mda Approach for the De-velopment of Spatial Data Warehouses". In: Dawak'08 Pro-ceedings Of The 10th International Conference On Data Warehousing And Knowledge Discovery, Pp. 23-32. Isbn: 978-3-540-85835-5 Doi>10.1007/978-3-540-85836-2_3. Turin, Itália. Setembro 2008
[25]  Mathew, A. D., Ma, L., Hargreaves, D. J., 2008, "A Con-ceptual Data Modelling Methodology for Asset Management Data Warehousing". In: Proceedings World Congress For Engineering Asset Management, Pp. 1086-1095, Beijing, China, 2008
[26]  Mazon, J. N., Trujillo, J., Serrano, M., Piattini, M., 2005, "Applying Mda To The Development of Data Warehouses". In: Dolap'05 Proceedings Of The 8th Acm International Workshop on Data Warehousing And Olap, Pp.57-66 Isbn: 1-59593-162-7 Doi>10.1145/1097002.1097012. Bremen, Alemanha. Outubro-Novembro 2005