Navegando por Autor "Santos, Pedro Bezerra dos"

Filtrar resultados informando as primeiras letras
Agora exibindo 1 - 1 de 1
  • Nenhuma Miniatura disponível
    Item
    Comparação de práticas e ferramentas de integração de dados utilizando o banco de dados amostral adventureworks
    (Centro Universitário do Estado do Pará, 2023-12-15) Bessa, Arthur Ferreira; Santos, Pedro Bezerra dos; Elgrably, Isaac Souza; http://lattes.cnpq.br/7590598824563858; Girotto, Pedro Henrique Sales; http://lattes.cnpq.br/0421749067951878; Araújo, Fábio Rocha de; http://lattes.cnpq.br/2407240421934932
    In the “Information Era”, companies deal with vast volumes of data. Information overload hampers decision-making. Digital transformation is pivotal, involving data integration through data pipelines. These processes convert raw data into actionable insights for business analysis. This study aims to compare the performance of different pipelines, ETL and ELT, analyzing data transformation time to ensure availability and decision-making efficiency. The comparison between ELT and ETL shows the significance of each method's specific application. In this study using AdventureWorks, ETL outperformed by transforming data before loading, unlike ELT. The difference between code usage and tools like Pentaho highlights a trade-off between performance and accessibility. Choosing between ELT and ETL should account for project needs, while future studies may deepen the understanding of these processes.