The Proceedings of the Information Systems Education Conference 2003: §3521    Home    Papers/Indices    prev (§3515)    Next (§3522)
Sat, Nov 8, 4:30 - 5:00, Balboa 2     Paper (refereed)
Recommended Citation: Boyno, E A.  Extraction, Transformation, and Loading in a Data Warehouse Course.  In The Proceedings of the Information Systems Education Conference 2003, v 20 (San Diego): §3521. ISSN: 1542-7382. (A later version appears in Information Systems Education Journal 1(10). ISSN: 1545-679X.)
 
Recipient of Meritorious Paper Award
 
CDpic

Extraction, Transformation, and Loading in a Data Warehouse Course

thumb
Refereed7 pages
Edward A. Boyno    [a1] [a2]
Montclair State University    [u1] [u2]
Upper Montclair, New Jersey, USA    [c1] [c2]

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 refereed paper in Adobe Portable Document (PDF) format. (7 pages, 411 K bytes)
Preview this refereed paper in Plain Text (TXT) format. (22 K bytes)

CDpic
Comments and corrections to
webmaster@isedj.org