How Do I Choose the Best Data Warehousing Services?

ELT is the use of database processing power.

ELT

(database)

ELT is the use of database processing power.

Chinese name

Data extraction, loading and transformation

Foreign name

Extraction-Loading-Transformation

Features

Transforming data in temporary tables

Features

In the conversion server

ELT uses the processing power of the database, E = extracts data from the source database, L = loads the data into the temporary table of the target database, T = converts the data in the temporary table, and then loads it into the target database target table.

In the ELT architecture, ELT is only responsible for providing a graphical interface to design business rules. The entire processing process of data flows between the target and source databases. ELT coordinates related database systems to execute related applications. It can be executed on the source database side or the target data warehouse side (mainly depends on the system's architecture design and data attributes). When the ETL process needs to improve efficiency, it can be achieved by tuning the relevant database or changing the server that executes the processing. General database vendors will push the architecture, such as Oracle and Teradata are vigorously promoting the ELT architecture.

1. ELT mainly implements the scalability of the system through the database engine (especially when the data processing process is at night, the resources of the database engine can be fully utilized) ^[2]

Compared with tools based on ETL architecture (Kettle, Talend, Datastage, Informatica), there are not many tools based on ELT architecture (OWB, HaoheDI).