The Proceedings of ISECON 2003: §3521    Home    Papers/Indices    prev (§3515)    Next (§3522) Sat, Nov 8, 4:30 - 5:00, Balboa 2     Work in Progress Recommended Citation: Boyno, E A.  Extraction, Transformation, and Loading in a Data Warehouse Course.  In The Proceedings of ISECON 2003, v 20 (San Diego): §3521. ISSN: 1542-7382.   Recipient of Meritorious Paper Award

Extraction, Transformation, and Loading in a Data Warehouse Course

This paper describes my experiences teaching a unit on Extraction, Transformation and Loading as part of a course on Data Warehousing. After a brief discussion of the process in general, it concentrates on one of the more interesting parts of that process, Data Cleansing. Some of the problems that may occur during Data Cleansing are discussed as well as some of the techniques that might be used to address them. Student exercises, some elementary, some more challenging, are presented and discussed. Finally, the paper addresses some of the problems I encountered and possible future work.

Keywords: extraction, transformation, loading, ETL, data warehouse, data cleansing, data scrubbing, CS education, IS education

Read this presentation handout (non-refereed) in Adobe Portable Document (PDF) format. (7 pages, 408 K bytes)
Preview this presentation handout (non-refereed) in Plain Text (TXT) format. (22 K bytes)

Comments and corrections to
webmaster@isedj.org