ETL

Christian Thomsen

doi:10.1007/978-3-319-63962-8_11-1

ETL

Research output: Contribution to book/anthology/report/conference proceeding › Encyclopedia chapter › Research › peer-review

Abstract

ETL is short for Extract-Transform-Load. The ETL process extracts data from operational source systems, transforms the data, and loads the data into a target. The transformations to perform on the data can involve a plethora of different activities, e.g., filtering, normalization or de-normalization to a desired form, joins, conversion, and cleansing to remove bad or dirty
data. In the ELT variant, the data is extracted from the source systems, loaded in its raw form into the target, and then transformed.

Original language	English
Title of host publication	Encyclopedia of Big Data Technologies
Editors	Sherif Sakr, Albert Zomaya
Number of pages	5
Publisher	Springer Publishing Company
Publication date	6 May 2018
ISBN (Electronic)	978-3-319-63962-8
DOIs	https://doi.org/10.1007/978-3-319-63962-8_11-1
Publication status	Published - 6 May 2018

Keywords

Extract-Transform-Load
ETL

Access to Document

10.1007/978-3-319-63962-8_11-1

AUB Link

Search for the material in Aalborg University Library's search engine

Cite this

@inbook{7757f2da5e39449cbfb6f3bd40da4b15,

title = "ETL",

abstract = "ETL is short for Extract-Transform-Load. The ETL process extracts data from operational source systems, transforms the data, and loads the data into a target. The transformations to perform on the data can involve a plethora of different activities, e.g., filtering, normalization or de-normalization to a desired form, joins, conversion, and cleansing to remove bad or dirtydata. In the ELT variant, the data is extracted from the source systems, loaded in its raw form into the target, and then transformed.",

keywords = "Extract-Transform-Load, ETL",

author = "Christian Thomsen",

year = "2018",

month = may,

day = "6",

doi = "10.1007/978-3-319-63962-8_11-1",

language = "English",

editor = "Sherif Sakr and Albert Zomaya",

booktitle = "Encyclopedia of Big Data Technologies",

publisher = "Springer Publishing Company",

address = "United States",

}

TY - ENCYC

T1 - ETL

AU - Thomsen, Christian

PY - 2018/5/6

Y1 - 2018/5/6

N2 - ETL is short for Extract-Transform-Load. The ETL process extracts data from operational source systems, transforms the data, and loads the data into a target. The transformations to perform on the data can involve a plethora of different activities, e.g., filtering, normalization or de-normalization to a desired form, joins, conversion, and cleansing to remove bad or dirtydata. In the ELT variant, the data is extracted from the source systems, loaded in its raw form into the target, and then transformed.

AB - ETL is short for Extract-Transform-Load. The ETL process extracts data from operational source systems, transforms the data, and loads the data into a target. The transformations to perform on the data can involve a plethora of different activities, e.g., filtering, normalization or de-normalization to a desired form, joins, conversion, and cleansing to remove bad or dirtydata. In the ELT variant, the data is extracted from the source systems, loaded in its raw form into the target, and then transformed.

KW - Extract-Transform-Load

KW - ETL

U2 - 10.1007/978-3-319-63962-8_11-1

DO - 10.1007/978-3-319-63962-8_11-1

M3 - Encyclopedia chapter

BT - Encyclopedia of Big Data Technologies

A2 - Sakr, Sherif

A2 - Zomaya, Albert

PB - Springer Publishing Company

ER -

ETL

Abstract

Keywords

Access to Document

AUB Link

Fingerprint

Cite this