Essential Site Maintenance: Authorea-powered sites will be updated circa 15:00-17:00 Eastern on Tuesday 5 November.
There should be no interruption to normal services, but please contact us at [email protected] in case you face any issues.

loading page

Overcoming Traditional ETL Systems Architectural Problems Using a Service-Oriented Approach
  • Bruno Oliveira,
  • Óscar Oliveira,
  • Orlando Belo
Bruno Oliveira
Instituto Politecnico do Porto Escola Superior de Tecnologia e Gestao

Corresponding Author:[email protected]

Author Profile
Óscar Oliveira
Instituto Politecnico do Porto Escola Superior de Tecnologia e Gestao
Author Profile
Orlando Belo
Universidade do Minho Centro ALGORITMI
Author Profile

Abstract

Developing analytical systems imposes several challenges related not only to the amount and heterogeneity of the involved data but also to the constant need to readapt and evolve to overcome new business challenges. Data is a determinant factor in the success of analytical and decision-making applications, being its nature, availability, and quality, crucial aspects for planning and structuring populating analytical systems. Today’s users are more demanding, requiring adaptable and flexible analytical applications, which impose serious challenges on ETL systems design and development for ensuring flexible and robust data populating services, operating 24/7, and managing and processing large volumes of data. Thus, we should design and implement ETL processes using innovative and up-to-date approaches, having real application evidence. In this paper, we present a service-oriented implementation for ETL design and development. We mapped and implemented some of the most conventional ETL processes in a service-oriented architecture, for demonstrating the application and benefits that this kind of approach will provide to ETL systems project development.
16 Feb 2023Submitted to Expert Systems
16 Feb 2023Submission Checks Completed
16 Feb 2023Assigned to Editor
20 Feb 2023Reviewer(s) Assigned
20 Mar 2023Review(s) Completed, Editorial Evaluation Pending
23 May 2023Editorial Decision: Revise Major
30 May 20231st Revision Received
01 Jun 2023Submission Checks Completed
01 Jun 2023Assigned to Editor
05 Jun 2023Reviewer(s) Assigned
05 Jul 2023Review(s) Completed, Editorial Evaluation Pending
17 Aug 2023Editorial Decision: Accept