Data Warehouse Back-End Tools

Alkis Simitsis; Dimitri Theodoratos

doi:10.4018/978-1-60566-010-3.ch090

Data Warehouse Back-End Tools

Alkis Simitsis
, Dimitri Theodoratos

Computer Science

Research output: Chapter in Book/Report/Conference proceeding › Chapter

4 Scopus citations

Abstract

The back-end tools of a data warehouse are pieces of software responsible for the extraction of data from several sources, their cleansing, customization, and insertion into a data warehouse. In general, these tools are known as Extract - Transformation - Load (ETL) tools and the process that describes the population of a data warehouse from its sources is called ETL process. In all the phases of an ETL process (extraction and transportation, transformation and cleaning, and loading), individual issues arise, and, along with the problems and constraints that concern the overall ETL process, make its lifecycle a very complex task.

Original language	English (US)
Title of host publication	Encyclopedia of Data Warehousing and Mining
Subtitle of host publication	Second Edition
Publisher	IGI Global
Pages	572-579
Number of pages	8
ISBN (Electronic)	9781605660110
ISBN (Print)	9781605660103
DOIs	https://doi.org/10.4018/978-1-60566-010-3.ch090
State	Published - Jan 1 2008

All Science Journal Classification (ASJC) codes

General Economics, Econometrics and Finance
General Business, Management and Accounting
General Computer Science

Access to Document

10.4018/978-1-60566-010-3.ch090

Cite this

@inbook{377cc0074cf648bcacb31ef038d7630c,

title = "Data Warehouse Back-End Tools",

abstract = "The back-end tools of a data warehouse are pieces of software responsible for the extraction of data from several sources, their cleansing, customization, and insertion into a data warehouse. In general, these tools are known as Extract - Transformation - Load (ETL) tools and the process that describes the population of a data warehouse from its sources is called ETL process. In all the phases of an ETL process (extraction and transportation, transformation and cleaning, and loading), individual issues arise, and, along with the problems and constraints that concern the overall ETL process, make its lifecycle a very complex task.",

author = "Alkis Simitsis and Dimitri Theodoratos",

note = "Publisher Copyright: {\textcopyright} 2009 by IGI Global.",

year = "2008",

month = jan,

day = "1",

doi = "10.4018/978-1-60566-010-3.ch090",

language = "English (US)",

isbn = "9781605660103",

pages = "572--579",

booktitle = "Encyclopedia of Data Warehousing and Mining",

publisher = "IGI Global",

}

TY - CHAP

T1 - Data Warehouse Back-End Tools

AU - Simitsis, Alkis

AU - Theodoratos, Dimitri

PY - 2008/1/1

Y1 - 2008/1/1

N2 - The back-end tools of a data warehouse are pieces of software responsible for the extraction of data from several sources, their cleansing, customization, and insertion into a data warehouse. In general, these tools are known as Extract - Transformation - Load (ETL) tools and the process that describes the population of a data warehouse from its sources is called ETL process. In all the phases of an ETL process (extraction and transportation, transformation and cleaning, and loading), individual issues arise, and, along with the problems and constraints that concern the overall ETL process, make its lifecycle a very complex task.

AB - The back-end tools of a data warehouse are pieces of software responsible for the extraction of data from several sources, their cleansing, customization, and insertion into a data warehouse. In general, these tools are known as Extract - Transformation - Load (ETL) tools and the process that describes the population of a data warehouse from its sources is called ETL process. In all the phases of an ETL process (extraction and transportation, transformation and cleaning, and loading), individual issues arise, and, along with the problems and constraints that concern the overall ETL process, make its lifecycle a very complex task.

UR - https://www.scopus.com/pages/publications/105011906757

UR - https://www.scopus.com/pages/publications/105011906757#tab=citedBy

U2 - 10.4018/978-1-60566-010-3.ch090

DO - 10.4018/978-1-60566-010-3.ch090

M3 - Chapter

AN - SCOPUS:105011906757

SN - 9781605660103

SP - 572

EP - 579

BT - Encyclopedia of Data Warehousing and Mining

PB - IGI Global

ER -

Data Warehouse Back-End Tools

Abstract

All Science Journal Classification (ASJC) codes

Access to Document

Other files and links

Fingerprint

Cite this