Search CTRL + K

extra, transform and load(ETL)

ETL 是指从源端读取(Extra)、转换(Transform)和加载(Load)到目的端的过程,其中目的端往往是 数据仓库

Database System Concepts

These steps of collecting data, cleaning/deduplicating the data, and loading the data into a warehouse are referred to as extract, transform and load (ETL) tasks.[1]


ETL, which stands for extract, transform and load, is a data integration process that combines data from multiple data sources into a single, consistent data store that is loaded into a data warehouse or other target system.[2]

  1. Abraham Silberschatz, Henry F. Korth, and S. Sudarshan, Database System Concepts, Seventh edition (New York, NY: McGraw-Hill, 2020). P520 ↩︎

  2. ↩︎