{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2026,6,10]],"date-time":"2026-06-10T16:32:35Z","timestamp":1781109155945,"version":"3.54.1"},"reference-count":25,"publisher":"IGI Global Scientific Publishing","issue":"3","content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":[],"published-print":{"date-parts":[[2013,7,1]]},"abstract":"<p>Business Intelligence (BI) applications require the design, implementation, and maintenance of processes that extract, transform, and load suitable data for analysis. The development of these processes (known as ETL) is an inherently complex problem that is typically costly and time consuming. In a previous work, the authors have proposed a vendor-independent language for reducing the design complexity due to disparate ETL languages tailored to specific design tools with steep learning curves. Nevertheless, the designer still faces two major issues during the development of ETL processes: (i) how to implement the designed processes in an executable language, and (ii) how to maintain the implementation when the organization data infrastructure evolves. In this paper, the authors propose a model-driven framework that provides automatic code generation capability and ameliorate maintenance support of our ETL language. They present a set of model-to-text transformations able to produce code for different ETL commercial tools as well as model-to-model transformations that automatically update the ETL models with the aim of supporting the maintenance of the generated code according to data source evolution. A demonstration using an example is conducted as an initial validation to show that the framework covering modeling, code generation and maintenance could be used in practice.<\/p>","DOI":"10.4018\/jdwm.2013070103","type":"journal-article","created":{"date-parts":[[2013,7,3]],"date-time":"2013-07-03T19:20:22Z","timestamp":1372879222000},"page":"46-72","source":"Crossref","is-referenced-by-count":34,"title":["A BPMN-Based Design and Maintenance Framework for ETL Processes"],"prefix":"10.4018","volume":"9","author":[{"given":"Zineb","family":"El Akkaoui","sequence":"first","affiliation":[{"name":"Department of Computer & Decision Engineering (CoDE), Universit\u00e9 Libre de Bruxelles, Brussels, Belgium"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Esteban","family":"Zim\u00e1nyi","sequence":"additional","affiliation":[{"name":"Department of Computer & Decision Engineering (CoDE), Universit\u00e9 Libre de Bruxelles, Brussels, Belgium"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Jose-Norberto","family":"Maz\u00f3n","sequence":"additional","affiliation":[{"name":"Department of Software and Computing Systems, University of Alicante, Alicante, Spain"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Juan","family":"Trujillo","sequence":"additional","affiliation":[{"name":"Department of Software and Computing Systems, University of Alicante, Alicante, Spain"}],"role":[{"vocabulary":"crossref","role":"author"}]}],"member":"2432","reference":[{"issue":"1","key":"jdwm.2013070103-0","first-page":"761","article-title":"Graceful database schema evolution: the prism workbench.","volume":"1","author":"C. A.Curino","year":"2008","journal-title":"PVLDB"},{"key":"jdwm.2013070103-1","unstructured":"Cuzzocrea, A. (2011). A UML-extended approach for mining OLAP data cubes in complex knowledge discovery environments. In I. Song & E. Zim\u00e1nyi (Eds.), Proceedings of the 13th International Conference on Enterprise Information Systems (ICEIS\u201911) (pp. 281\u2013289). Beijing, China: SciTePress."},{"key":"jdwm.2013070103-2","unstructured":"Cuzzocrea, A., Francesco, F., & Pontieri, L. (2010). Effective analysis of flexible collaboration processes by way of abstraction and mining techniques. Filipe, J., & Cordeiro, J. (Eds.), Proceedings of the twentieth International Conference on Enterprise Information Systems (ICEIS\u201911) (pp. 157\u2013166). Funchal, Madeira, Portugal: SciTePress."},{"issue":"3","key":"jdwm.2013070103-3","first-page":"217","article-title":"Model-driven data mining engineering: From solution-driven implementations to 'composable' conceptual data mining models. International Journal of Data Mining","volume":"3","author":"A.Cuzzocrea","year":"2011","journal-title":"Modelling and Management"},{"key":"jdwm.2013070103-4","doi-asserted-by":"crossref","unstructured":"El Akkaoui, Z., Maz\u00f3n, J.-N., Vaisman, A., & Zim\u00e1nyi, E. (2012). BPMN-based conceptual modeling of ETL processes. In A. Cuzzocrea & U. Dayal (Eds.), Proceedings of the 14th International Conference on Data Warehousing and Knowledge Discovery (DAWAK\u201912). Vienna, Austria: Springer.","DOI":"10.1007\/978-3-642-32584-7_1"},{"key":"jdwm.2013070103-5","doi-asserted-by":"crossref","unstructured":"El Akkaoui, Z., & Zim\u00e1nyi, E. (2009). Defining ETL worfklows using BPMN and BPEL. In I. Song & E. Zim\u00e1nyi (Eds.), Proceedings of the 12th ACM International Workshop on Data Warehousing and OLAP (DOLAP\u201909) (pp. 41\u201348). Hong Kong, China: ACM Press.","DOI":"10.1145\/1651291.1651299"},{"key":"jdwm.2013070103-6","doi-asserted-by":"crossref","unstructured":"El Akkaoui, Z., Zim\u00e1nyi, E., Maz\u00f3n, J.-N., & Trujillo, J.-C. (2011). A model-driven framework for ETL process development. In I. Song, A. Cuzzocrea & K. C. Davis (Eds.), Proceedings of the 14th ACM International Workshop on Data Warehousing and OLAP (DOLAP\u201911) (pp. 45\u201352). Glasgow, UK: ACM Press.","DOI":"10.1145\/2064676.2064685"},{"key":"jdwm.2013070103-7","doi-asserted-by":"publisher","DOI":"10.1016\/j.datak.2005.09.004"},{"key":"jdwm.2013070103-8","author":"W.Inmon","year":"2002","journal-title":"Building the data warehouse"},{"key":"jdwm.2013070103-9","doi-asserted-by":"publisher","DOI":"10.1016\/j.dss.2006.12.003"},{"key":"jdwm.2013070103-10","doi-asserted-by":"crossref","unstructured":"Mu\u00f1oz, L., Maz\u00f3n, J.-N., & Trujillo, J.-C. (2009). Automatic generation of ETL processes from conceptual models. In I. Song & E. Zim\u00e1nyi (Eds.), Proceedings of the 12th ACM International Workshop on Data Warehousing and OLAP (DOLAP\u201909) (pp. 33\u201340). Hong Kong, China: ACM Press.","DOI":"10.1145\/1651291.1651298"},{"key":"jdwm.2013070103-11","doi-asserted-by":"publisher","DOI":"10.1016\/j.infsof.2010.06.003"},{"key":"jdwm.2013070103-12","doi-asserted-by":"crossref","unstructured":"Papastefanatos, G., Vassiliadis, P., Simitsis, A., & Vassiliou, Y. (2008). Design metrics for data warehouse evolution. In Q. Li, S. Spaccapietra, E. Yu, & A. Oliv\u00e9, (Eds.), Proceedings of the 27th International Conference on Conceptual Modeling, (ER '08) (pp. 440-454). Berlin, Heidelberg: Springer.","DOI":"10.1007\/978-3-540-87877-3_32"},{"key":"jdwm.2013070103-13","first-page":"146","article-title":"Policy-regulated management of ETL evolution.","volume":"XIII","author":"G.Papastefanatos","year":"2009","journal-title":"Journal on Data Semantics"},{"key":"jdwm.2013070103-14","doi-asserted-by":"crossref","unstructured":"Romero, O., Simitsis, A., & Abell\u00f3, A. (2011). GEM: Requirement-driven generation of ETL and multidimensional conceptual designs. In A. Cuzzocrea & U. Dayal (Eds.), Proceedings of the 13th International Conference on Data Warehousing and Knowledge Discovery (DaWaK '11) (pp. 80\u201395). Toulouse, France: Springer.","DOI":"10.1007\/978-3-642-23544-3_7"},{"key":"jdwm.2013070103-15","doi-asserted-by":"publisher","DOI":"10.1016\/j.dss.2006.12.002"},{"key":"jdwm.2013070103-16","first-page":"122","article-title":"Ontology-driven conceptual design of ETL processes using graph transformations.","volume":"XIII","author":"D.Skoutas","year":"2009","journal-title":"Journal on Data Semantics"},{"key":"jdwm.2013070103-17","doi-asserted-by":"crossref","unstructured":"Thomsen, C., & Pedersen, T. B. (2011). Easy and effective parallel programmable ETL. In I. Song, A. Cuzzocrea & K. C. Davis (Eds.), Proceedings of the 14th ACM International Workshop on Data Warehousing and OLAP (DOLAP\u201911) (pp. 37\u201344). Glasgow, Scotland, UK: ACM Press.","DOI":"10.1145\/2064676.2064684"},{"key":"jdwm.2013070103-18","doi-asserted-by":"crossref","unstructured":"Trujillo, J.-C., & Luj\u00e1n-Mora, S. (2003). A UML based approach for modeling ETL processes in data warehouses. In I. Y. Song, S. W. Liddle, T. W. Ling & P. Scheuermann (Eds.), Proceedings of the 22nd International Conference on Conceptual Modeling (ER'03) (pp. 307\u2013320). Chicago, IL: Springer.","DOI":"10.1007\/978-3-540-39648-2_25"},{"key":"jdwm.2013070103-19","doi-asserted-by":"crossref","unstructured":"Tziovara, V., Vassiliadis, P., & Simitsis, A. (2007). Deciding the physical implementation of ETL workflows. In I. Song & T. Pedersen (Eds.), Proceedings of the 10th ACM International Workshop on Data Warehousing and OLAP (DOLAP\u201907) (pp. 49\u201356). Lisbon, Portugal: ACM Press.","DOI":"10.1145\/1317331.1317341"},{"key":"jdwm.2013070103-20","doi-asserted-by":"crossref","unstructured":"Vassiliadis, P., Simitsis, A., & Baikous, E. (2009). A taxonomy of ETL activities. In I. Song & E. Zim\u00e1nyi (Eds.), Proceedings of the 12th ACM International Workshop on Data Warehousing and OLAP (DOLAP\u201909) (pp. 25\u201332). Hong Kong, China: ACM Press.","DOI":"10.1145\/1651291.1651297"},{"key":"jdwm.2013070103-21","doi-asserted-by":"publisher","DOI":"10.1016\/j.is.2004.11.002"},{"key":"jdwm.2013070103-22","doi-asserted-by":"crossref","unstructured":"Wieringa, R. (2010). Design science methodology: principles and practice. In J. Kramer, J. Bishop, P. T. Devanbu, & S. Uchitel (Eds.), Proceedings of the 32nd International Conference on Software Engineering (ICSE\u201910) (pp. 493\u2013494). Cape Town, South Africa: ACM Press.","DOI":"10.1145\/1810295.1810446"},{"key":"jdwm.2013070103-23","doi-asserted-by":"crossref","unstructured":"Wilkinson, K., Simitsis, A., Castellanos, M., & Dayal, U. (2010). Leveraging Business process models for ETL design. In J. Parsons, M. Saeki, P. Shoval, C. Woo & Y. Wand (Eds.), Proceedings of the 29th International Conference on Conceptual Modeling (ER'10) (pp. 15\u201330). Vancouver, Canada: Springer.","DOI":"10.1007\/978-3-642-16373-9_2"},{"key":"jdwm.2013070103-24","unstructured":"Wyatt, L., Caufield, B., & Pol, D. (2009). Principles for an ETL benchmark. In R. Nambiar & M. Poess (Eds.), Proceedings of the First TPC Technology Conference, TPCTC 2009 (pp. 183\u2013198). Lyon, France: Springer."}],"container-title":["International Journal of Data Warehousing and Mining"],"original-title":[],"language":"ng","link":[{"URL":"https:\/\/www.igi-global.com\/viewtitle.aspx?TitleId=78375","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2022,6,1]],"date-time":"2022-06-01T20:23:33Z","timestamp":1654115013000},"score":1,"resource":{"primary":{"URL":"https:\/\/services.igi-global.com\/resolvedoi\/resolve.aspx?doi=10.4018\/jdwm.2013070103"}},"subtitle":[""],"short-title":[],"issued":{"date-parts":[[2013,7,1]]},"references-count":25,"journal-issue":{"issue":"3","published-print":{"date-parts":[[2013,7]]}},"URL":"https:\/\/doi.org\/10.4018\/jdwm.2013070103","relation":{},"ISSN":["1548-3924","1548-3932"],"issn-type":[{"value":"1548-3924","type":"print"},{"value":"1548-3932","type":"electronic"}],"subject":[],"published":{"date-parts":[[2013,7,1]]}}}