{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"institution":[{"name":"Authorea, Inc."}],"indexed":{"date-parts":[[2025,6,3]],"date-time":"2025-06-03T16:37:52Z","timestamp":1748968672816,"version":"3.41.0"},"posted":{"date-parts":[[2023,1,6]]},"group-title":"Preprints","reference-count":0,"publisher":"Wiley","content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":[],"accepted":{"date-parts":[[2023,1,6]]},"abstract":"<jats:p id=\"p1\">Developing analytical systems imposes several challenges related not\nonly to the amount and heterogeneity of the involved data but also to\nthe constant need to readapt and evolve to overcome new business\nchallenges. Data is a determinant factor in the success of analytical\nand decision-making applications, being its nature, availability, and\nquality, crucial aspects for planning and structuring populating\nanalytical systems. Today\u2019s users are more demanding, requiring\nadaptable and flexible analytical applications, which impose serious\nchallenges on ETL systems design and development for ensuring flexible\nand robust data populating services, operating 24\/7, and managing and\nprocessing large volumes of data. Thus, we should design and implement\nETL processes using innovative and up-to-date approaches, having real\napplication evidence. In this paper, we present a service-oriented\nimplementation for ETL design and development. We mapped and implemented\nsome of the most conventional ETL processes in a service-oriented\narchitecture, for demonstrating the application and benefits that this\nkind of approach will provide to ETL systems project development.<\/jats:p>","DOI":"10.22541\/au.167303798.86222074\/v1","type":"posted-content","created":{"date-parts":[[2023,1,6]],"date-time":"2023-01-06T20:46:34Z","timestamp":1673037994000},"source":"Crossref","is-referenced-by-count":0,"title":["Overcoming Traditional ETL Systems Architectural Problems Using a Service-Oriented Approach"],"prefix":"10.22541","author":[{"ORCID":"https:\/\/orcid.org\/0000-0001-9138-9143","authenticated-orcid":true,"given":"Bruno","family":"Oliveira","sequence":"first","affiliation":[{"name":"Instituto Politecnico do Porto Escola Superior de Tecnologia e Gestao"}]},{"ORCID":"https:\/\/orcid.org\/0000-0003-3807-7292","authenticated-orcid":true,"given":"\u00d3scar","family":"Oliveira","sequence":"additional","affiliation":[{"name":"Instituto Politecnico do Porto Escola Superior de Tecnologia e Gestao"}]},{"given":"Orlando","family":"Belo","sequence":"additional","affiliation":[{"name":"Universidade do Minho Centro ALGORITMI"}]}],"member":"311","container-title":[],"original-title":[],"deposited":{"date-parts":[[2023,1,6]],"date-time":"2023-01-06T20:46:35Z","timestamp":1673037995000},"score":1,"resource":{"primary":{"URL":"https:\/\/www.authorea.com\/users\/572893\/articles\/617527-overcoming-traditional-etl-systems-architectural-problems-using-a-service-oriented-approach?commit=b5213f4dc1f39b615dcedce8659bfb6eacf9f467"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2023,1,6]]},"references-count":0,"URL":"https:\/\/doi.org\/10.22541\/au.167303798.86222074\/v1","relation":{},"subject":[],"published":{"date-parts":[[2023,1,6]]},"subtype":"preprint"}}