ETL

Research output: Contribution to book/anthology/report/conference proceedingEncyclopedia chapterResearchpeer-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 languageEnglish
Title of host publicationEncyclopedia of Big Data Technologies
EditorsSherif Sakr, Albert Zomaya
Number of pages5
PublisherSpringer Publishing Company
Publication date6 May 2018
ISBN (Electronic)978-3-319-63962-8
DOIs
Publication statusPublished - 6 May 2018

Fingerprint

Mathematical transformations

Keywords

  • Extract-Transform-Load
  • ETL

Cite this

Thomsen, C. (2018). ETL. In S. Sakr, & A. Zomaya (Eds.), 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. editor / 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. in S Sakr & A Zomaya (eds), 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. ed. / Sherif Sakr; Albert Zomaya. Springer Publishing Company, 2018.

Research output: Contribution to book/anthology/report/conference proceedingEncyclopedia chapterResearchpeer-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. In Sakr S, Zomaya A, editors, Encyclopedia of Big Data Technologies. Springer Publishing Company. 2018 https://doi.org/10.1007/978-3-319-63962-8_11-1