A Survey of Real-Time ETL Process Applied to Data Warehousing Environments

A Survey of Real-Time ETL Process Applied to Data Warehousing Environments

연구 분야: Databases

학회: Home

ETL (Extract, Transform, and Load) is an essential process required to perform data extraction from data sources, transforming the extracted data into an integrated format and loading the integrated data into a data warehouse. Moreover, the ETL process can be performed in a real-time way. This paper presents a survey of real-time ETL process applied to data warehousing environments. The related studies were collected by means of a systematic review conducted by a methodological protocol. Moreover, we grouped the studies by categories, which had not been made before in the literature. The results showed that we have a wide range of opening opportunities of original research, as there are a lot of initial ideas and in turn they have not yet been tested, validated, and compared to related work.