AN OVERVIEW ON PHYSICAL IMPLEMENTATION OF SECURE ETL WORKFLOW

[摘要] Extraction-transformation-loading (ETL) tools are pieces of software responsible for the extraction of data from several sources, their cleansing, customization and insertion into a data warehouse. The main focus is on logical optimization of ETL processes. We consider each ETL workflow as a state and fabricate the state space through a set of correct state transition.

[关键词] Data warehousing;Extraction-transformation-loading (ETL), Data Extraction;Security