engleski

Proposed architecture for ETL workflow generator

The most important process, on which most time is spent, when building data warehouses is the Extract Transform Load (ETL) process. Automation of such process is an expected thing to do. In this work the focus is on automation for generating ETL workflows which is currently not very well researched. The idea is to build systems which model the ETL process based on semantics and suggest the needed transformation and mappings for automatic generation of ETL workflows. In this work an architecture is presented to automatically integrate the system which generates mappings and transformations based on ontologies and the traditional ETL tools. The architecture of the prototyped system is message based which enables parallel processing.

ETL ; data warehouse ; architecture ; generator ; ontologies ; message based

Hrvatska inačica rada: http://archive.ceciis.foi.hr/app/public/conferences/2019/Proceedings/Croatian/CECIIS-2019_paper_32-HR.pdf