An Interactive Courseware for Learning Data Warehousing on the Web

Meiliu Lu

Download Paper | Permalink

Conference: 2013 ASEE International Forum
Location: 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: 9
Page Numbers: 21.12.1 - 21.12.9
DOI: 10.18260/1-2--17217
Permanent URL: https://peer.asee.org/17217
Download Count: 504

Paper Authors

biography

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 | Permalink

Abstract

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.

Citation
Format

Lu, M. (2013, June), An Interactive Courseware for Learning Data Warehousing on the Web Paper presented at 2013 ASEE International Forum, Atlanta, Georgia. 10.18260/1-2--17217

TY - CPAPER
AB - 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.
AU - Meiliu Lu
CY - Atlanta, Georgia
DA - 2013/06/22
PB - ASEE Conferences
TI - An Interactive Courseware for Learning Data Warehousing on the Web
UR - https://peer.asee.org/17217
DO - 10.18260/1-2--17217
ER -