This course teaches the design and development of data warehouses. The OLTP and OLAP needs of businesses are analyzed to rationalize the need of data warehouses and corresponding data models. Data warehouse architectures ranging from ROLAP to MOLAP are developed and evaluated. Data models conducive to such needs are studied. Tools to develop in-house data warehouses are identified and practiced along with off-the-shelf data warehouse solutions including cloud based services. Role of competing concepts such as data lakes and big data is evaluated in the context of data warehousing.
If you have a comment or question about this course, please complete and submit the form below.
Interested in being notified about future offerings of COMP 8071 - Advanced Database Application?
If so, fill out the information below and we'll notify you by email when courses for each new term are displayed here.