Search CTRL + K

extra, transform and load(ETL)

#CS/BigData

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]

IBM

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. https://www.ibm.com/topics/etl ↩︎