The Proceedings of the Information Systems Education Conference 2001: §35c Home Papers/Indices prev (§35b) Next (§36a)

Paper (refereed) Information Systems Curriculum

Recommended Citation: Seyed-Abbassi, B. Teaching Effective Methodologies to Design a Data Warehouse. In The Proceedings of the Information Systems Education Conference 2001, v 18 (Cincinnati): §35c.

Teaching Effective Methodologies to Design a Data Warehouse

Refereed

Behrooz Seyed-Abbassi    [a1] [a2]
Department of Computer and Information Sciences
University of North Florida    [u1] [u2]
Jacksonville, Florida, USA    [c1] [c2]

An important component for the students in the advanced database class at the University of North Florida involves the development of a data warehouse that is efficiently designed and effectively optimized for data retrieval and statistical analysis for Decision Support Systems (DSS) and Executive Information Systems (EIS). This paper describes the methods utilized to help students understand the considerations in the design process of a data warehouse. The methodologies involve the commonly used star schema and the snowflake schema as well as other alternative techniques to teach students about the essential factors to consider when designing a data warehouse.

Keywords: teaching methods, data warehouse, database design, star schema, snowflake schema, SQL

Read this refereed paper in Adobe Portable Document (PDF) format. (146 K bytes)
Preview this refereed paper in Plain Text (TXT) format. (26 K bytes)

CDpic
Comments and corrections to
webmaster@isedj.org