A survey of extract–transform–load technology

P Vassiliadis - International Journal of Data Warehousing and Mining …, 2009 - igi-global.com
The software processes that facilitate the original loading and the periodic refreshment of the
data warehouse contents are commonly known as Extraction-Transformation-Loading (ETL) …

[PDF][PDF] The history, present, and future of ETL technology

A Simitsis, S Skiadopoulos, P Vassiliadis - DOLAP, 2023 - cs.uoi.gr
There is an abundance of data, but a large volume of it is unusable. Data may be noisy,
unstructured, stored in incompatible for direct analysis medium or format, and often …

Towards generating ETL processes for incremental loading

T Jörg, S Deßloch - Proceedings of the 2008 international symposium …, 2008 - dl.acm.org
Extract, Transform, and Load (ETL) processes physically integrate data from multiple,
heterogeneous sources in a central repository referred to as data warehouse. Physically …

Hyppo: using equivalences to optimize pipelines in exploratory machine learning

A Kontaxakis, D Sacharidis, A Simitsis… - 2024 IEEE 40th …, 2024 - ieeexplore.ieee.org
We present HYPPO, a novel system to optimize pipelines encountered in exploratory
machine learning. HYPPO exploits alternative computational paths of artifacts from past …

Modelling ETL processes of data warehouses with UML activity diagrams

L Muñoz, JN Mazón, J Pardillo, J Trujillo - OTM Confederated International …, 2008 - Springer
Abstract Extraction-transformation-loading (ETL) processes play an important role in a data
warehouse (DW) architecture because they are responsible of integrating data from …

pygrametl: A powerful programming framework for extract-transform-load programmers

C Thomsen, T Bach Pedersen - Proceedings of the ACM twelfth …, 2009 - dl.acm.org
Extract-Transform-Load (ETL) processes are used for extracting data, transforming it and
loading it into data warehouses (DWs). Many tools for creating ETL processes exist. The …

Policy-regulated management of ETL evolution

G Papastefanatos, P Vassiliadis, A Simitsis… - Journal on Data …, 2009 - Springer
In this paper, we discuss the problem of performing impact prediction for changes that occur
in the schema/structure of the data warehouse sources. We abstract Extract-Transform-Load …

Formalizing ETL jobs for incremental loading of data warehouses

T Jörg, S Dessloch - Datenbanksysteme in Business, Technologie und Web …, 2009 - dl.gi.de
Extract-transform-load (ETL) tools are primarily designed for data warehouse loading, ie to
perform physical data integration. When the operational data sources happen to change, the …

Research on extract, transform and load (ETL) in land and resources star schema data warehouse

Q Hanlin, J **anzhen, Z **anrong - 2012 Fifth International …, 2012 - ieeexplore.ieee.org
The extract, transform and Load (ETL) tool is extracting data from multiple, heterogeneous
data source, transforming data, and finally loading data into the data warehouse. It is the …

What-if analysis for data warehouse evolution

G Papastefanatos, P Vassiliadis, A Simitsis… - Data Warehousing and …, 2007 - Springer
In this paper, we deal with the problem of performing what-if analysis for changes that occur
in the schema/structure of the data warehouse sources. We abstract software modules …