Engineering trade study: extract, transform, load tools for data migration

Author

Henry, Sebastien ; Hoon, Slerlynn ; Hwang, Meeky ; Lee, Diane ; DeVore, Michael D.

Author_Institution

Dept. of Syst. & Inf. Eng., Virginia Univ., Charlottesville, VA, USA

fYear

2005

fDate

4/29/2005 12:00:00 AM

Firstpage

1

Lastpage

8

Abstract

The widespread need within corporate information systems (IS) divisions to migrate large quantities of data between data stores has spawned a family of commercial products, which are commonly referred to as extract-transform-load (ETL) tools. The focus of this paper is the development of engineering trade studies to be used for ETL tool evaluation. This approach: (1) Identifies selection criteria that are essential in the evaluation of an ETL tool, (2) Develops scenarios that examine each criterion, and (3) Develops quantitative measures useful for evaluating the various aspects of ETL usage. This approach generates replicable evaluation methods that can be used and modified by companies to address their own ETL product needs. With the results generated through such evaluations, companies will be able to make informed decisions and choose the best ETL tool for their purposes.

Keywords

data handling; information systems; ETL tool evaluation; corporate information systems; data migration; data stores; engineering trade study; extract-transform-load tool; selection criteria; Application software; Bismuth; Business; Companies; Data analysis; Data engineering; Data mining; Relational databases; Systems engineering and theory; Testing;

fLanguage

English

Publisher

ieee

Conference_Titel

Systems and Information Engineering Design Symposium, 2005 IEEE

Print_ISBN

0-9744559-4-6

Type

conf

DOI

10.1109/SIEDS.2005.193231

Filename

1497124