{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2023,1,13]],"date-time":"2023-01-13T06:13:16Z","timestamp":1673590396053},"reference-count":28,"publisher":"IGI Global","issue":"3","content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":[],"published-print":{"date-parts":[[2015,7,1]]},"abstract":"<p>Modeling and data warehousing have been considered, for more than one decade, as a new challenging research topic for which different approaches have been proposed. Nevertheless these proposals have focused on static aspects only. In practice, the evolution of the operational information system can lead to changes in its dependent multidimensional data warehouse (i.e. that this system feeds with data), and therefore may require the evolution of the data warehouse model. In this evolving context, the authors propose a model-driven based approach in order to automate the propagation of the evolutions occurred in the source database towards the multidimensional data warehouse. This approach is based on two evolution models, along with a set of transformation rules formalized in Query\/View\/Transformation. This paper describes this evolution approach for which we are developing a software prototype called DWE\u00a9 (Data Warehouse Evolution).<\/p>","DOI":"10.4018\/ijdsst.2015070104","type":"journal-article","created":{"date-parts":[[2015,7,17]],"date-time":"2015-07-17T14:37:35Z","timestamp":1437143855000},"page":"65-89","source":"Crossref","is-referenced-by-count":2,"title":["An MDA Approach for the Evolution of Data Warehouses"],"prefix":"10.4018","volume":"7","author":[{"given":"Said","family":"Taktak","sequence":"first","affiliation":[{"name":"MIRACL Laboratory, University of Sfax, Sfax, Tunisia"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Saleh","family":"Alshomrani","sequence":"additional","affiliation":[{"name":"Faculty of Computing and Information Technology, University of Jeddah, Jeddah, Saudi Arabia"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Jamel","family":"Feki","sequence":"additional","affiliation":[{"name":"MIRACL Laboratory, University of Sfax, Sfax, Tunisia"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Gilles","family":"Zurfluh","sequence":"additional","affiliation":[{"name":"Institut de Recherche en Informatique de Toulouse (IRIT), Universit\u00e9 Toulouse I Capitole, Toulouse, France"}],"role":[{"role":"author","vocabulary":"crossref"}]}],"member":"2432","reference":[{"key":"ijdsst.2015070104-0","first-page":"247","article-title":"A unified model driven methodology for data warehouses and ETL design.","author":"F.Atigui","year":"2011","journal-title":"International Conference on Enterprise Information Systems (ICEIS"},{"key":"ijdsst.2015070104-1","doi-asserted-by":"publisher","DOI":"10.1007\/s101150200008"},{"key":"ijdsst.2015070104-2","doi-asserted-by":"crossref","unstructured":"Bellatreche, L. & Wrembel, R. (2013). Evolution and Versioning in Semantic Data Integration Systems. Journal on Data Semantics, (2), 57-59.","DOI":"10.1007\/s13740-013-0020-6"},{"key":"ijdsst.2015070104-3","unstructured":"Benitez-Guerrero, E., Collet, C., & Adiba, M. (2004). The WHES Approach to Data Warehouse Evolution. E-Gnosis [online], 2. From http:\/\/www.e-gnosis.udg.mx\/vol2\/art11"},{"key":"ijdsst.2015070104-4","doi-asserted-by":"publisher","DOI":"10.1007\/3-540-48298-9_17"},{"key":"ijdsst.2015070104-5","first-page":"206","article-title":"Dimension Hierarchies Updates in Data Warehouses: a User-driven Approach.","author":"C.Favre","year":"2007","journal-title":"9th International Conference on Enterprise Information Systems (ICEIS 07)"},{"key":"ijdsst.2015070104-6","doi-asserted-by":"publisher","DOI":"10.1016\/j.datak.2005.09.004"},{"key":"ijdsst.2015070104-7","doi-asserted-by":"crossref","unstructured":"Golfarelli, M., Rizzi, S., & Vrdoljak, B. (2001). Data Warehouse Design from XML Sources. In proceedings of ACM International Workshop on Data Warehousing and OLAP (DOLAP\u201901) (pp. 40-47). ACM.","DOI":"10.1145\/512236.512242"},{"key":"ijdsst.2015070104-8","first-page":"346","article-title":"Maintaining Data Cubes under Dimension Updates.","author":"C. A.Hurtado","year":"1999","journal-title":"15th International Conference on Data Engineering (ICDE 99)"},{"key":"ijdsst.2015070104-9","author":"W.Inmon","year":"2002","journal-title":"Building the Data Warehouse (3rdEdition)"},{"key":"ijdsst.2015070104-10","author":"R.Kimball","year":"2002","journal-title":"The Data Warehouse Toolkit"},{"key":"ijdsst.2015070104-11","doi-asserted-by":"crossref","unstructured":"Mazon, J.N. & Trujillo, J. 2008. An MDA Approach for the Development of Data Warehouses. Decision Support Systems (DSS\u201908), 45(1), 41-58.","DOI":"10.1016\/j.dss.2006.12.003"},{"key":"ijdsst.2015070104-12","first-page":"226","article-title":"Towards an automatic Data Warehouse and Data Mart Design","author":"A.Nabli","year":"2005","journal-title":"7th International Conference on Enterprise Information Systems ICEIS"},{"key":"ijdsst.2015070104-13","unstructured":"OMG. (2001). Object Management Group: Unified Modeling Language Specification 1.4. From http:\/\/www.omg.org\/cgi-bin\/doc?formal\/01-09-67"},{"key":"ijdsst.2015070104-14","unstructured":"OMG. (2004). Object Management Group: Model Driven Architecture (MDA). From http:\/\/www.omg.org\/cgibin\/doc?formal\/03-06-01"},{"key":"ijdsst.2015070104-15","unstructured":"OMG. (2009). Object Management Group: Meta Object Facility (MOF) 2.0 Query\/View\/Transformation, version 1.1. From http:\/\/www.omg.org\/spec\/QVT\/1.1\/Beta2\/"},{"key":"ijdsst.2015070104-16","first-page":"55","article-title":"Rule based Management of Schema Changes at ETL Sources.","author":"G.Papastefanatos","year":"2009","journal-title":"The International Workshop on Managing Evolution of Data Warehouses (MEDWa)"},{"key":"ijdsst.2015070104-17","unstructured":"Phipps, C., & Davis, K. (2002). Automating data warehouse conceptual schema design and evaluation. In Design and Management of Data Warehouses (DMDW'02), Canada."},{"key":"ijdsst.2015070104-18","unstructured":"Rundensteiner, E. A., Nica, A., & Lee, A. J. (1997). On Preserving Views in Evolving Environments. In the 4 International Workshop Knowledge Representation Meets Databases (pp.131\u2013141)."},{"key":"ijdsst.2015070104-19","doi-asserted-by":"publisher","DOI":"10.4018\/jdwm.2005040102"},{"issue":"3","key":"ijdsst.2015070104-20","first-page":"63","article-title":"Slowly Changing Dimensions Specification: A Relational Algebra Approach.","volume":"1","author":"V.Santos","year":"2011","journal-title":"ACEEE International Journal on Information Technology"},{"key":"ijdsst.2015070104-21","unstructured":"Solodov\u0146ikova, D. (2008). The Formal Model for Multiversion Data Warehouse Evolution. In the 8th International Baltic Conference on Databases and Information Systems, (pp.91-102). Tallinn, Estonia. IOS Press."},{"key":"ijdsst.2015070104-22","doi-asserted-by":"publisher","DOI":"10.1007\/978-3-642-33609-6_18"},{"key":"ijdsst.2015070104-23","first-page":"77","article-title":"Mod\u00e9lisation des transformations pour l\u2019\u00e9volution de mod\u00e8les multidimensionnels.","volume":"B-10","author":"S.Taktak","year":"2014","journal-title":"Revue des Nouvelles Technologies de l'Information"},{"key":"ijdsst.2015070104-24","first-page":"472","article-title":"Toward Evolution Models for Data Warehouses.","author":"S.Taktak","year":"2014","journal-title":"2nd International Conference on Model-Driven Engineering and Software Development (MODELSWARD 2014)."},{"issue":"7","key":"ijdsst.2015070104-25","first-page":"917","article-title":"Implementing Schema Evolution in Data Warehouse through Complex Hierarchy Semantics.","volume":"3","author":"K.Talwar","year":"2012","journal-title":"International Journal of Scientific & Engineering Research"},{"key":"ijdsst.2015070104-26","doi-asserted-by":"publisher","DOI":"10.14569\/IJACSA.2011.020513"},{"key":"ijdsst.2015070104-27","doi-asserted-by":"publisher","DOI":"10.1007\/978-3-540-70664-9_5"}],"container-title":["International Journal of Decision Support System Technology"],"original-title":[],"language":"ng","link":[{"URL":"https:\/\/www.igi-global.com\/viewtitle.aspx?TitleId=133851","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2022,6,1]],"date-time":"2022-06-01T22:19:44Z","timestamp":1654121984000},"score":1,"resource":{"primary":{"URL":"https:\/\/services.igi-global.com\/resolvedoi\/resolve.aspx?doi=10.4018\/ijdsst.2015070104"}},"subtitle":[""],"short-title":[],"issued":{"date-parts":[[2015,7,1]]},"references-count":28,"journal-issue":{"issue":"3","published-print":{"date-parts":[[2015,7]]}},"URL":"https:\/\/doi.org\/10.4018\/ijdsst.2015070104","relation":{},"ISSN":["1941-6296","1941-630X"],"issn-type":[{"value":"1941-6296","type":"print"},{"value":"1941-630X","type":"electronic"}],"subject":[],"published":{"date-parts":[[2015,7,1]]}}}