ETL

Publikation: Bidrag til bog/antologi/rapport/konference proceedingEncyclopædiartikelForskningpeer review

Resumé

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.
OriginalsprogEngelsk
TitelEncyclopedia of Big Data Technologies
RedaktørerSherif Sakr, Albert Zomaya
Antal sider5
ForlagSpringer Publishing Company
Publikationsdato6 maj 2018
ISBN (Elektronisk)978-3-319-63962-8
DOI
StatusUdgivet - 6 maj 2018

Fingerprint

Mathematical transformations

Citer dette

Thomsen, C. (2018). ETL. I S. Sakr, & A. Zomaya (red.), Encyclopedia of Big Data Technologies Springer Publishing Company. https://doi.org/10.1007/978-3-319-63962-8_11-1
Thomsen, Christian. / ETL. Encyclopedia of Big Data Technologies. red. / Sherif Sakr ; Albert Zomaya. Springer Publishing Company, 2018.
@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 = "5",
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",

}

Thomsen, C 2018, ETL. i S Sakr & A Zomaya (red), Encyclopedia of Big Data Technologies. Springer Publishing Company. https://doi.org/10.1007/978-3-319-63962-8_11-1

ETL. / Thomsen, Christian.

Encyclopedia of Big Data Technologies. red. / Sherif Sakr; Albert Zomaya. Springer Publishing Company, 2018.

Publikation: Bidrag til bog/antologi/rapport/konference proceedingEncyclopædiartikelForskningpeer review

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 -

Thomsen C. ETL. I Sakr S, Zomaya A, red., Encyclopedia of Big Data Technologies. Springer Publishing Company. 2018 https://doi.org/10.1007/978-3-319-63962-8_11-1