Asee peer logo

An Interactive Courseware for Learning Data Warehousing on the Web

Download Paper |


2013 ASEE International Forum


Atlanta, Georgia

Publication Date

June 22, 2013

Start Date

June 22, 2013

End Date

June 22, 2013

Conference Session

Reception & Poster Session

Tagged Topic

ASEE International Forum

Page Count


Page Numbers

21.12.1 - 21.12.9

Permanent URL

Download Count


Request a correction

Paper Authors


Meiliu Lu California State University at Sacramento

visit author page

Meiliu Lu, a professor of Computer Science Department, College of Engineering and Computer Science, California State University at Sacramento since 1987. She received her Ph.D. in Computer Science, University of Illinois, 1987. Meiliu Lu has published in research areas such as web applications for user-paced learning, machine learning applications, bioinformatics, data mining and data warehousing, and distributed algorithms. She has taught both undergraduate and graduate level courses in areas such as Data Warehousing and Data mining, Computing Theory and Programming Languages, Introduction to Computer Programming, Machine Learning, Knowledge-based Systems, Artificial Intelligence, Web Database Applications, Data structures and Algorithms, and Algorithms and Paradigms.

visit author page

Download Paper |


An Interactive Courseware for Learning Data Warehousing on the WebData analytics is playing a significant role in today’s science and engineering education. Datawarehouses provide online analytical processing tools for the interactive analysis ofmultidimensional data of various granularities. The objective of this project is to develop a web-based interactive courseware to help students or beginning data warehouse designers worldwidein learning data warehousing. Contributors of this project include Computer Scienceinternational graduate students from India. The end user of the courseware can be anyone whohas access to internet.In this project we have developed a courseware to reinforce learning of the key concepts of thedata warehousing using a case study approach. The courseware now contains two working sub-systems: (1) data warehousing courseware; and (2) ETL (Extraction, Transformation, and Load)courseware. We have been using this courseware in a Data Warehousing and Data Mining courseat California State University in past two years. Students had very positive feedback on theirlearning experiences with the tool. We are now in the process of expanding to include one moresub-system, OLAP (On Line Analytical Processing) cube courseware.The main advantages of using this web-based interactive courseware to supplement classroominstructions or textbook are as follows: (a) The contents of the courseware can be updated by the instructor periodically to keep up with the rapid development of the field of data warehousing and data mining. (b) The incremental developing courseware provides an ideal platform for the instructor to share latest research development results with students so that we can make the technology transfer a little faster to our students. (c) This project provides a self-paced interactive learning tool not only to the students taking a course on data warehousing but also to any engineer in the world who have to build a data warehouse from scratch and needs to learn fundamental concepts quickly. From schema design to OLAP query execution, we explain concepts step by step and illustrate implementation techniques with examples from our case study. An end user can run various demo queries interactively as he/she is making progress in his/her own pace. (d) Our digital courseware offers a low cost alternative to traditional expensive textbooks. Students usually do not want to buy additional reference books due to the high costs.In this paper, we will introduce the design and implementation of our data warehousingcourseware. Of course, we will also share the lessons that we had learned from this project. Themethod used in this project can be generalized to other engineering fields which has globeeducational needs on self-paced learning tools.

ASEE holds the copyright on this document. It may be read by the public free of charge. Authors may archive their work on personal websites or in institutional repositories with the following citation: © 2013 American Society for Engineering Education. Other scholars may excerpt or quote from these materials with the same citation. When excerpting or quoting from Conference Proceedings, authors should, in addition to noting the ASEE copyright, list all the original authors and their institutions and name the host city of the conference. - Last updated April 1, 2015