{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2025,3,28]],"date-time":"2025-03-28T01:48:20Z","timestamp":1743126500780,"version":"3.40.3"},"publisher-location":"Cham","reference-count":18,"publisher":"Springer International Publishing","isbn-type":[{"type":"print","value":"9783319237800"},{"type":"electronic","value":"9783319237817"}],"license":[{"start":{"date-parts":[[2015,1,1]],"date-time":"2015-01-01T00:00:00Z","timestamp":1420070400000},"content-version":"tdm","delay-in-days":0,"URL":"https:\/\/www.springernature.com\/gp\/researchers\/text-and-data-mining"},{"start":{"date-parts":[[2015,1,1]],"date-time":"2015-01-01T00:00:00Z","timestamp":1420070400000},"content-version":"vor","delay-in-days":0,"URL":"https:\/\/www.springernature.com\/gp\/researchers\/text-and-data-mining"}],"content-domain":{"domain":["link.springer.com"],"crossmark-restriction":false},"short-container-title":[],"published-print":{"date-parts":[[2015]]},"DOI":"10.1007\/978-3-319-23781-7_19","type":"book-chapter","created":{"date-parts":[[2015,9,28]],"date-time":"2015-09-28T12:52:22Z","timestamp":1443444742000},"page":"239-247","update-policy":"https:\/\/doi.org\/10.1007\/springer_crossmark_policy","source":"Crossref","is-referenced-by-count":3,"title":["Automatic Generation of ETL Physical Systems from BPMN Conceptual Models"],"prefix":"10.1007","author":[{"given":"Orlando","family":"Belo","sequence":"first","affiliation":[]},{"given":"Claudia","family":"Gomes","sequence":"additional","affiliation":[]},{"given":"Bruno","family":"Oliveira","sequence":"additional","affiliation":[]},{"given":"Ricardo","family":"Marques","sequence":"additional","affiliation":[]},{"given":"Vasco","family":"Santos","sequence":"additional","affiliation":[]}],"member":"297","published-online":{"date-parts":[[2015,9,29]]},"reference":[{"key":"19_CR1","doi-asserted-by":"crossref","unstructured":"El Akkaoui, Z., Zimanyi, E.: Defining ETL worfklows using BPMN and BPEL. In: DOLAP 2009 Proceedings of the ACM Twelfth International Workshop on Data warehousing and OLAP, pp. 41\u201348 (2009)","DOI":"10.1145\/1651291.1651299"},{"key":"19_CR2","doi-asserted-by":"crossref","unstructured":"El Akkaoui, Z., Zim\u00e0nyi, E., Maz\u00f3n, J.-N., Trujillo, J.: A model-driven framework for ETL process development. In: Proceedings of the ACM 14th International Workshop on Data Warehousing and OLAP, DOLAP 2011, pp. 45\u201352 (2011)","DOI":"10.1145\/2064676.2064685"},{"key":"19_CR3","doi-asserted-by":"publisher","first-page":"46","DOI":"10.4018\/jdwm.2013070103","volume":"9","author":"Z El Akkaoui","year":"2013","unstructured":"El Akkaoui, Z., Zim\u00e1nyi, E., Maz\u00f3n, J.-N., Trujillo, J.: A BPMN-based design and maintenance framework for ETL processes. Int. J. Data Warehouse. Min. 9, 46\u201372 (2013)","journal-title":"Int. J. Data Warehouse. Min."},{"key":"19_CR4","first-page":"638","volume-title":"Encyclopedia of Data Warehousing and Mining","author":"M Golfarelli","year":"2008","unstructured":"Golfarelli, M.: The DFM: a conceptual model for data warehouse. In: Wang, J. (ed.) Encyclopedia of Data Warehousing and Mining, 2nd edn, pp. 638\u2013645. IGI Global, Hershey (2008)","edition":"2"},{"key":"19_CR5","volume-title":"The Data Warehouse ETL Toolkit: Practical Techniques for Extracting, Cleaning, Conforming, and Delivering Data","author":"R Kimball","year":"2004","unstructured":"Kimball, R., Caserta, J.: The Data Warehouse ETL Toolkit: Practical Techniques for Extracting, Cleaning, Conforming, and Delivering Data. Wiley, New York (2004)"},{"issue":"3","key":"19_CR6","first-page":"49","volume":"XII","author":"V K\u00f6ppen","year":"2011","unstructured":"K\u00f6ppen, V., Br\u00fcggemann, B., Berendt, B.: Designing data integration: the ETL pattern approach. Eur. J. Inform. Prof. XII(3), 49\u201355 (2011)","journal-title":"Eur. J. Inform. Prof."},{"key":"19_CR7","unstructured":"Oliveira, B., Belo, O.: BPMN patterns for ETL conceptual modelling and validation. In: Proceedings of the 20th International Symposium on Methodologies for Intelligent Systems (ISMIS 2012), Macau, 4\u20137 December 2012"},{"key":"19_CR8","unstructured":"Oliveira, B., Belo, O.: ETL standard processes modelling - a novel BPMN approach. In: Proceedings of 5th International Conference on Enterprise Information Systems (ICEIS 2013), Angers, France, 4\u20137 July 2013"},{"key":"19_CR9","unstructured":"OMG: Documents Associated With Business Process Model and Notation (BPMN) Version 2.0 (2011)"},{"key":"19_CR10","unstructured":"Pentaho: Pentaho data integration. http:\/\/www.pentaho.com\/product\/data-integration. Accessed 16 March 2015"},{"key":"19_CR11","doi-asserted-by":"crossref","unstructured":"Simitsis, A.: Mapping conceptual to logical models for ETL processes. In: Proceedings of the 8th ACM international workshop on Data warehousing and OLAP, Bremen, Germany, pp. 67\u201376 (2005)","DOI":"10.1145\/1097002.1097014"},{"key":"19_CR12","unstructured":"Simitsis, A., Vassiliadis, P., Sellis, T.: Logical optimization of ETL workflows. In: Proceedings of the 4th Hellenic Data Management Symposium, Athens, Greece, pp. 55\u201365 (2005)"},{"key":"19_CR13","doi-asserted-by":"publisher","first-page":"1404","DOI":"10.1109\/TKDE.2005.169","volume":"17","author":"A Simitsis","year":"2005","unstructured":"Simitsis, A., Vassiliadis, P., Sellis, T.: State-space optimization of ETL workflows. IEEE Trans. Knowl. Data Eng. 17, 1404\u20131419 (2005)","journal-title":"IEEE Trans. Knowl. Data Eng."},{"key":"19_CR14","series-title":"Lecture Notes in Computer Science","doi-asserted-by":"publisher","first-page":"307","DOI":"10.1007\/978-3-540-39648-2_25","volume-title":"Conceptual Modeling - ER 2003","author":"J Trujillo","year":"2003","unstructured":"Trujillo, J., Luj\u00e1n-Mora, S.: A UML based approach for modeling ETL processes in data warehouses. In: Song, I.-Y., Liddle, S.W., Ling, T.-W., Scheuermann, P. (eds.) ER 2003. LNCS, vol. 2813, pp. 307\u2013320. Springer, Heidelberg (2003)"},{"key":"19_CR15","unstructured":"Vassiliadis, P., Simitsis, A., Skiadopoulos, S.: Modeling ETL activities as graphs. In: Proceedings of the 4th International Workshop on Design and Management of Data Warehouses 2002, DMDW\u20192002, Toronto, Canada, pp. 52\u201361 (2002)"},{"key":"19_CR16","series-title":"Lecture Notes in Computer Science","doi-asserted-by":"publisher","first-page":"782","DOI":"10.1007\/3-540-47961-9_67","volume-title":"Advanced Information Systems Engineering","author":"P Vassiliadis","year":"2002","unstructured":"Vassiliadis, P., Simitsis, A., Skiadopoulos, S.: On the logical modeling of ETL processes. In: Pidduck, A.B., Mylopoulos, J., Woo, C.C., Ozsu, M.T. (eds.) CAiSE 2002. LNCS, vol. 2348, pp. 782\u2013786. Springer, Heidelberg (2002)"},{"issue":"3","key":"19_CR17","doi-asserted-by":"publisher","first-page":"1","DOI":"10.4018\/jdwm.2009070101","volume":"5","author":"P Vassiliadis","year":"2009","unstructured":"Vassiliadis, P.: A survey of extract\u2013transform\u2013load technology. Int. J. Data Warehouse. Min. 5(3), 1\u201327 (2009)","journal-title":"Int. J. Data Warehouse. Min."},{"key":"19_CR18","series-title":"Lecture Notes in Computer Science","doi-asserted-by":"publisher","first-page":"161","DOI":"10.1007\/11841760_12","volume-title":"Business Process Management","author":"P Wohed","year":"2006","unstructured":"Wohed, P., van der Aalst, W.M.P., Dumas, M., ter Hofstede, A.H.M., Russell, N.: On the suitability of BPMN for business process modelling. In: Dustdar, S., Fiadeiro, J.L., Sheth, A.P. (eds.) BPM 2006. LNCS, vol. 4102, pp. 161\u2013176. Springer, Heidelberg (2006)"}],"container-title":["Lecture Notes in Computer Science","Model and Data Engineering"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/link.springer.com\/content\/pdf\/10.1007\/978-3-319-23781-7_19","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2023,2,16]],"date-time":"2023-02-16T22:00:58Z","timestamp":1676584858000},"score":1,"resource":{"primary":{"URL":"https:\/\/link.springer.com\/10.1007\/978-3-319-23781-7_19"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2015]]},"ISBN":["9783319237800","9783319237817"],"references-count":18,"URL":"https:\/\/doi.org\/10.1007\/978-3-319-23781-7_19","relation":{},"ISSN":["0302-9743","1611-3349"],"issn-type":[{"type":"print","value":"0302-9743"},{"type":"electronic","value":"1611-3349"}],"subject":[],"published":{"date-parts":[[2015]]},"assertion":[{"value":"29 September 2015","order":1,"name":"first_online","label":"First Online","group":{"name":"ChapterHistory","label":"Chapter History"}}]}}