Welcome to the InfoSci Platform
Reference Hub7
Extraction, Transformation, and Loading Processes

Extraction, Transformation, and Loading Processes

Jovanka Adzic, Valter Fiore, Luisella Sisto
Copyright: © 2007 |Pages: 23
ISBN13: 9781599043647|ISBN10: 1599043645|ISBN13 Softcover: 9781599043654|EISBN13: 9781599043661
DOI: 10.4018/987-1-59904-364-7.ch004
Cite Chapter Cite Chapter

MLA

Adzic, Jovanka, et al. "Extraction, Transformation, and Loading Processes." Data Warehouses and OLAP: Concepts, Architectures and Solutions, edited by Robert Wrembel and Christian Koncilia, IGI Global, 2007, pp. 88-110. https://doi.org/10.4018/987-1-59904-364-7.ch004

APA

Adzic, J., Fiore, V., & Sisto, L. (2007). Extraction, Transformation, and Loading Processes. In R. Wrembel & C. Koncilia (Eds.), Data Warehouses and OLAP: Concepts, Architectures and Solutions (pp. 88-110). IGI Global. https://doi.org/10.4018/987-1-59904-364-7.ch004

Chicago

Adzic, Jovanka, Valter Fiore, and Luisella Sisto. "Extraction, Transformation, and Loading Processes." In Data Warehouses and OLAP: Concepts, Architectures and Solutions, edited by Robert Wrembel and Christian Koncilia, 88-110. Hershey, PA: IGI Global, 2007. https://doi.org/10.4018/987-1-59904-364-7.ch004

Export Reference

Mendeley
Favorite

Abstract

ETL stands for Extraction, Transformation, and Loading: in other words, for the Data Warehouse (DW) backstage. The main focus of our exposition here is the practical application of the ETL process in real world cases with extra problems and strong requirements, particularly performance issues related to population of large Data Warehouse. In a context of ETL/DW with strong requirements, we can individuate the most common constraints and criticalities that one can meet in developing an ETL system. We will describe some techniques related to the physical data base design, pipelining, and parallelism which are crucial for the whole ETL process. We will propose our practical approach “infrastructure based ETL”: it is not a tool but a set of functionalities and/or services that the experience has proved to be useful and enough widespread in the ETL scenario and one can build the application on top of it.

Request Access

You do not own this content. Please login to recommend this title to your institution's librarian or purchase it from the IGI Global bookstore.