{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2025,3,27]],"date-time":"2025-03-27T05:00:57Z","timestamp":1743051657317,"version":"3.40.3"},"publisher-location":"Cham","reference-count":23,"publisher":"Springer International Publishing","isbn-type":[{"type":"print","value":"9783031164736"},{"type":"electronic","value":"9783031164743"}],"license":[{"start":{"date-parts":[[2022,1,1]],"date-time":"2022-01-01T00:00:00Z","timestamp":1640995200000},"content-version":"tdm","delay-in-days":0,"URL":"https:\/\/www.springer.com\/tdm"},{"start":{"date-parts":[[2022,1,1]],"date-time":"2022-01-01T00:00:00Z","timestamp":1640995200000},"content-version":"vor","delay-in-days":0,"URL":"https:\/\/www.springer.com\/tdm"}],"content-domain":{"domain":["link.springer.com"],"crossmark-restriction":false},"short-container-title":[],"published-print":{"date-parts":[[2022]]},"DOI":"10.1007\/978-3-031-16474-3_52","type":"book-chapter","created":{"date-parts":[[2022,9,12]],"date-time":"2022-09-12T14:16:28Z","timestamp":1662992188000},"page":"636-647","update-policy":"https:\/\/doi.org\/10.1007\/springer_crossmark_policy","source":"Crossref","is-referenced-by-count":1,"title":["A Service-Oriented Framework for ETL Implementation"],"prefix":"10.1007","author":[{"ORCID":"https:\/\/orcid.org\/0000-0001-9138-9143","authenticated-orcid":false,"given":"Bruno","family":"Oliveira","sequence":"first","affiliation":[]},{"given":"M\u00e1rio","family":"Leite","sequence":"additional","affiliation":[]},{"ORCID":"https:\/\/orcid.org\/0000-0003-3807-7292","authenticated-orcid":false,"given":"\u00d3scar","family":"Oliveira","sequence":"additional","affiliation":[]},{"ORCID":"https:\/\/orcid.org\/0000-0003-2157-8891","authenticated-orcid":false,"given":"Orlando","family":"Belo","sequence":"additional","affiliation":[]}],"member":"297","published-online":{"date-parts":[[2022,9,13]]},"reference":[{"key":"52_CR1","volume-title":"Building Microservices: Designing Fine-Grained Systems","author":"S Newman","year":"2015","unstructured":"Newman, S.: Building Microservices: Designing Fine-Grained Systems. O\u2019Reilly Media, Newton (2015)"},{"key":"52_CR2","volume-title":"Data Mesh","author":"Z Dehghani","year":"2021","unstructured":"Dehghani, Z.: Data Mesh. O\u2019Reilly Media, Inc., Newton (2021)"},{"key":"52_CR3","unstructured":"Armbrust, M., Ghodsi, A., Xin, R., Zaharia, M.: Lakehouse: a new generation of open platforms that unify data warehousing and advanced analytics. In: Conference on Innovative Data Systems Research (CIDR) (2021)"},{"key":"52_CR4","doi-asserted-by":"publisher","unstructured":"Oliveira, B., Oliveira, \u00d3., Santos, V., Belo, O.: ETL development using patterns: a service-oriented approach. In: Filipe, J., Smialek, M., Brodsky, A., and Hammoudi, S. (eds.) Proceedings of the 21st International Conference on Enterprise Information Systems. pp. 216\u2013222. SCITEPRESS - Science and Technology Publications, Crete, Greece (2019). https:\/\/doi.org\/10.5220\/0007727502160222","DOI":"10.5220\/0007727502160222"},{"key":"52_CR5","doi-asserted-by":"publisher","unstructured":"Oliveira, B., Belo, O.: On the specification of extract, transform, and load patterns behavior: a domain-specific language approach. Expert Syst. 34, e12168 (2017). https:\/\/doi.org\/10.1111\/exsy.12168","DOI":"10.1111\/exsy.12168"},{"key":"52_CR6","series-title":"Lecture Notes in Computer Science","doi-asserted-by":"publisher","first-page":"1","DOI":"10.1007\/978-3-642-32584-7_1","volume-title":"Data Warehousing and Knowledge Discovery","author":"Z El Akkaoui","year":"2012","unstructured":"El Akkaoui, Z., Maz\u00f3n, J.-N., Vaisman, A., Zim\u00e1nyi, E.: BPMN-based conceptual modeling of ETL processes. In: Cuzzocrea, A., Dayal, U. (eds.) DaWaK 2012. LNCS, vol. 7448, pp. 1\u201314. Springer, Heidelberg (2012). https:\/\/doi.org\/10.1007\/978-3-642-32584-7_1"},{"key":"52_CR7","doi-asserted-by":"publisher","unstructured":"Liu, Y., Vitolo, T.M.: Graph data warehouse: steps to integrating graph databases into the traditional conceptual structure of a data warehouse. In: 2013 IEEE International Congress on Big Data, pp. 433\u2013434 (2013). https:\/\/doi.org\/10.1109\/BigData.Congress.2013.72","DOI":"10.1109\/BigData.Congress.2013.72"},{"key":"52_CR8","doi-asserted-by":"publisher","unstructured":"Chevalier, M., El Malki, M., Kopliku, A., Teste, O., Tournier, R.: Implementing multidimensional data warehouses into NoSQL. In: Proceedings of the 17th International Conference on Enterprise Information Systems, vol. 1. pp. 172\u2013183. SCITEPRESS - Science and Technology Publications, Lda (2015). https:\/\/doi.org\/10.5220\/0005379801720183","DOI":"10.5220\/0005379801720183"},{"key":"52_CR9","series-title":"Lecture Notes in Business Information Processing","doi-asserted-by":"publisher","first-page":"40","DOI":"10.1007\/978-3-319-65930-5_4","volume-title":"Information Systems","author":"R Yangui","year":"2017","unstructured":"Yangui, R., Nabli, A., Gargouri, F.: ETL based framework for NoSQL warehousing. In: Themistocleous, M., Morabito, V. (eds.) EMCIS 2017. LNBIP, vol. 299, pp. 40\u201353. Springer, Cham (2017). https:\/\/doi.org\/10.1007\/978-3-319-65930-5_4"},{"key":"52_CR10","unstructured":"Ali, S.M.F.: Next-generation ETL Framework to address the challenges posed by Big Data. In: CEUR Workshop Proceedings, vol. 2062 (2018)"},{"issue":"1","key":"52_CR11","doi-asserted-by":"publisher","first-page":"1","DOI":"10.1186\/s13174-019-0121-z","volume":"10","author":"GV Machado","year":"2019","unstructured":"Machado, G.V., Cunha, \u00cd., Pereira, A.C.M., Oliveira, L.B.: DOD-ETL: distributed on-demand ETL for near real-time business intelligence. J. Internet Serv. Appl. 10(1), 1\u201315 (2019). https:\/\/doi.org\/10.1186\/s13174-019-0121-z","journal-title":"J. Internet Serv. Appl."},{"key":"52_CR12","doi-asserted-by":"publisher","unstructured":"Debroy, V., Brimble, L., Yost, M.: NewTL: engineering an extract, transform, load (ETL) software system for business on a very large scale. In: Proceedings of ACM Symposium Applied Computing, pp. 1568\u20131575 (2018). https:\/\/doi.org\/10.1145\/3167132.3167300","DOI":"10.1145\/3167132.3167300"},{"key":"52_CR13","doi-asserted-by":"publisher","first-page":"1","DOI":"10.1093\/database\/bay130","volume":"2018","author":"IB Ozyurt","year":"2018","unstructured":"Ozyurt, I.B., Grethe, J.S.: Foundry: a message-oriented, horizontally scalable ETL system for scientific data integration and enhancement. Database (Oxford) 2018, 1\u201313 (2018). https:\/\/doi.org\/10.1093\/database\/bay130","journal-title":"Database (Oxford)"},{"key":"52_CR14","doi-asserted-by":"publisher","first-page":"110","DOI":"10.1016\/j.procs.2010.12.019","volume":"3","author":"MMI Awad","year":"2011","unstructured":"Awad, M.M.I., Abdullah, M.S., Ali, A.B.M.: Extending ETL framework using service oriented architecture. Procedia Comput. Sci. 3, 110\u2013114 (2011). https:\/\/doi.org\/10.1016\/j.procs.2010.12.019","journal-title":"Procedia Comput. Sci."},{"key":"52_CR15","doi-asserted-by":"publisher","unstructured":"Akkaoui, Z., El Zimanyi, E.: Defining ETL worfklows using BPMN and BPEL. In: Proceeding of the ACM Twelfth International Workshop on Data Warehousing and OLAP DOLAP 2009, pp. 41\u201348. ACM, Hong Kong (2009). https:\/\/doi.org\/10.1145\/1651291.1651299","DOI":"10.1145\/1651291.1651299"},{"key":"52_CR16","doi-asserted-by":"publisher","unstructured":"Wang, H., Ye, Z.: An ETL services framework based on metadata. In: Proceedings - 2010 2nd International Working on Intelligent System Application, ISA 2010, pp. 0\u20133 (2010). https:\/\/doi.org\/10.1109\/IWISA.2010.5473575","DOI":"10.1109\/IWISA.2010.5473575"},{"key":"52_CR17","doi-asserted-by":"publisher","unstructured":"Laigner, R., et al.: From a monolithic big data system to a microservices event-driven architecture. In: Proceedings - 46th Euromicro Conference Software Engineering Advances Application SEAA 2020, pp. 213\u2013220 (2020). https:\/\/doi.org\/10.1109\/SEAA51224.2020.00045","DOI":"10.1109\/SEAA51224.2020.00045"},{"key":"52_CR18","doi-asserted-by":"publisher","unstructured":"Shakir, A., Staegemann, D., Volk, M., Jamous, N., Turowski, K.: Towards a concept for building a big data architecture with microservices. In: Business Information System, pp. 83\u201394 (2021). https:\/\/doi.org\/10.52825\/bis.v1i.67","DOI":"10.52825\/bis.v1i.67"},{"key":"52_CR19","doi-asserted-by":"publisher","unstructured":"Zhelev, S., Rozeva, A.: Using microservices and event driven architecture for big data stream processing. In: AIP Conference Proceedings, vol. 2172 (2019). https:\/\/doi.org\/10.1063\/1.5133587","DOI":"10.1063\/1.5133587"},{"key":"52_CR20","doi-asserted-by":"publisher","first-page":"395","DOI":"10.1093\/carcin\/bgs084","volume":"206","author":"E Gamma","year":"1995","unstructured":"Gamma, E., Helm, R., Johnson, R.E., Vlissides, J.: Design patterns: elements of reusable object-oriented software. Design 206, 395 (1995). https:\/\/doi.org\/10.1093\/carcin\/bgs084","journal-title":"Design"},{"key":"52_CR21","volume-title":"The Data Warehouse Toolkit","author":"K Ralph","year":"2013","unstructured":"Ralph, K., Margy, R.: The Data Warehouse Toolkit. John Wiley & Sons, Inc., Hoboken (2013)"},{"key":"52_CR22","doi-asserted-by":"publisher","unstructured":"Oliveira, B., Belo, O.: An ontology for describing ETL patterns behavior. In: Francalanci, C., Helfert, M. (eds.) Proceedings of the 5th International Conference on Data Management Technologies and Applications, pp. 102\u2013109. SCITEPRESS - Science and Technology Publications, Lisboa (2016). https:\/\/doi.org\/10.5220\/0005974001020109","DOI":"10.5220\/0005974001020109"},{"key":"52_CR23","unstructured":"Lewis, J., Fowler, M.: Microservices. http:\/\/martinfowler.com\/articles\/microservices.html, Accessed 02 Dec 2019"}],"container-title":["Lecture Notes in Computer Science","Progress in Artificial Intelligence"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/link.springer.com\/content\/pdf\/10.1007\/978-3-031-16474-3_52","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2022,9,12]],"date-time":"2022-09-12T14:23:32Z","timestamp":1662992612000},"score":1,"resource":{"primary":{"URL":"https:\/\/link.springer.com\/10.1007\/978-3-031-16474-3_52"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2022]]},"ISBN":["9783031164736","9783031164743"],"references-count":23,"URL":"https:\/\/doi.org\/10.1007\/978-3-031-16474-3_52","relation":{},"ISSN":["0302-9743","1611-3349"],"issn-type":[{"type":"print","value":"0302-9743"},{"type":"electronic","value":"1611-3349"}],"subject":[],"published":{"date-parts":[[2022]]},"assertion":[{"value":"13 September 2022","order":1,"name":"first_online","label":"First Online","group":{"name":"ChapterHistory","label":"Chapter History"}},{"value":"EPIA","order":1,"name":"conference_acronym","label":"Conference Acronym","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"EPIA Conference on Artificial Intelligence","order":2,"name":"conference_name","label":"Conference Name","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"Lisbon","order":3,"name":"conference_city","label":"Conference City","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"Portugal","order":4,"name":"conference_country","label":"Conference Country","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"2022","order":5,"name":"conference_year","label":"Conference Year","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"31 August 2022","order":7,"name":"conference_start_date","label":"Conference Start Date","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"2 September 2022","order":8,"name":"conference_end_date","label":"Conference End Date","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"21","order":9,"name":"conference_number","label":"Conference Number","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"epia2022","order":10,"name":"conference_id","label":"Conference ID","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"https:\/\/epia2022.inesc-id.pt\/","order":11,"name":"conference_url","label":"Conference URL","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"Double-blind","order":1,"name":"type","label":"Type","group":{"name":"ConfEventPeerReviewInformation","label":"Peer Review Information (provided by the conference organizers)"}},{"value":"Easychair","order":2,"name":"conference_management_system","label":"Conference Management System","group":{"name":"ConfEventPeerReviewInformation","label":"Peer Review Information (provided by the conference organizers)"}},{"value":"85","order":3,"name":"number_of_submissions_sent_for_review","label":"Number of Submissions Sent for Review","group":{"name":"ConfEventPeerReviewInformation","label":"Peer Review Information (provided by the conference organizers)"}},{"value":"64","order":4,"name":"number_of_full_papers_accepted","label":"Number of Full Papers Accepted","group":{"name":"ConfEventPeerReviewInformation","label":"Peer Review Information (provided by the conference organizers)"}},{"value":"0","order":5,"name":"number_of_short_papers_accepted","label":"Number of Short Papers Accepted","group":{"name":"ConfEventPeerReviewInformation","label":"Peer Review Information (provided by the conference organizers)"}},{"value":"75% - The value is computed by the equation \"Number of Full Papers Accepted \/ Number of Submissions Sent for Review * 100\" and then rounded to a whole number.","order":6,"name":"acceptance_rate_of_full_papers","label":"Acceptance Rate of Full Papers","group":{"name":"ConfEventPeerReviewInformation","label":"Peer Review Information (provided by the conference organizers)"}},{"value":"3,7","order":7,"name":"average_number_of_reviews_per_paper","label":"Average Number of Reviews per Paper","group":{"name":"ConfEventPeerReviewInformation","label":"Peer Review Information (provided by the conference organizers)"}},{"value":"0,9","order":8,"name":"average_number_of_papers_per_reviewer","label":"Average Number of Papers per Reviewer","group":{"name":"ConfEventPeerReviewInformation","label":"Peer Review Information (provided by the conference organizers)"}},{"value":"Yes","order":9,"name":"external_reviewers_involved","label":"External Reviewers Involved","group":{"name":"ConfEventPeerReviewInformation","label":"Peer Review Information (provided by the conference organizers)"}}]}}