Data Warehouse Back-End Tools

doi:https://doi.org/10.4018/978-1-59140-557-3.ch060

Book Chapter10.4018/978-1-59140-557-3.ch060

Data Warehouse Back-End Tools

Alkis Simitsis,Dimitri Theodoratos-2005-01-01-IGI Global eBooks

3

TL;DRAbstract

The back-end tools of a data warehouse are pieces of software responsible for the extraction of data from several sources, their cleansing, customization, and insertion into a data warehouse. They are known under the general term extraction, transformation and loading (ETL) tools. In all the phases of an ETL process (extraction and exportation, transformation and cleaning, and loading), individual issues arise and, along with the problems and constraints that concern the overall ETL process, make its lifecycle a very complex task.

Chat with Paper

AI Agents for this Paper

The back-end tools of a data warehouse are pieces of software responsible for the extraction of data from several sources, their cleansing, customization, and insertion into a data warehouse. They are known under the general term extraction, transformation and loading (ETL) tools. In all the phases of an ETL process (extraction and exportation, transformation and cleaning, and loading), individual issues arise and, along with the problems and constraints that concern the overall ETL process, make its lifecycle a very complex task.

Keywords

Data warehouseDatabaseData transformationComputer scienceProcess (computing)Task (project management)WarehouseTransformation (genetics)

Chat

Click to start Chat