Overcoming traditional ETL systems architectural problems using a service‐oriented approach
Year: 2023
Type: article
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 are 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 extract‐transform‐load (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, to demonstrate the application and benefits that this kind of approach will provide to ETL systems project development.
Source: Expert Systems
DOI: 10.1111/exsy.13442
Authors: Bruno Oliveira, Óscar Oliveira, Orlando Belo
Language: English
Subfield: Information Systems
Field: Computer Science
Domain: Physical Sciences
Open Access status: green
OpenAlex ID: W4386201031