The course is divided into the following three parts: 1. Fundamentals of designing large data warehouses 2. Design of a Data Warehouse using Oracle Warehouse Builder (OWB) 3. Discussion of different high performance data analysis techniques.
Hybrid delivery format. This course will be a combination of in-class sessions (15 hours) AND online instruction (30 hours). Classroom sessions will be held on the following Tuesdays at the Downtown campus: January 8, February 5 and March 5. The final exam will be held on Tuesday, March 26 at the Downtown campus. All sessions will be from 18:30-22:15. ***This is not a self-paced course. There will be specific timelines for assignments and exams.*** Course content, kind and quality of assignments and general standards for this course are the same as classroom courses. You must have an email address and access to a computer capable of downloading basic documents.
Upon successful completion, the student will be able to:
Discuss data warehousing concepts and the design process.
Develop a data warehouse for a real-world example system using Oracle OWB.
Discuss data load and transformation issues.
Explain what causes good or bad performance.
Describe Data Mining.
Describe ROLAP and MOLAP and OLAP specifics to Oracle architecture.
Effective as of Fall 2009
COMP 8071 is offered as a part of the following programs:
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.