Catalog Course Description
Covers principles and techniques related to data warehousing & online analytic processing (OLAP) as well as advanced database programming.  Discusses dimensional modeling and design, OLAP, ROLAP, MOLAP, aggregation, ETL, physical data warehouse design, optimization techniques such as partitioning, bit map indexing, multi-table join indexing, star schema query optimization, and materialized views.  Advanced database programming includes stored procedures, functions, and triggers in Oracle PL/SQL.

Pre-requisites and Co-requisites
INFO 606  Database Management II
INFO 620  Information Systems Analysis and Design (Prerequisite or co-requisite)

Curriculum Role
This is a distribution elective in the MSIS curriculum.n elective course. 

Course Rationale
This course is offered to provide students with both principles and programming backgrounds for data warehousing and OLAP technologies. This course is offered forwould be of interest to students who want to be database professionals who want to work in data warehousing areas and wants to learn advanced database programming. in business intelligence areasin the areas of competitive intelligence and knowledge management  .

Course Outcomes
Upon successful completion of this course, a student will be able to:
• Explain database trends in research community and industry
• Apply database programming techniques including PL/SQL with stored procedures and triggers to      applications
• Explain data warehousing and online analytic processing (OLAP) technologies
• Demonstrate the design of dimensional models for data warehouse
• Demonstrate physical design of data warehouse systems

Course Content
Principal topics and the approximate number of weeks devoted to each are:
• Database research and industry trends (0.5)
• Data warehouse principles and architectures (1)
• Dimensional modeling (2)
• PL/SQL programming (3)
• Online analytical processing (1)
• ETL and Data warehouse optimization (1.5)
•Physical data warehouse design (1.5)

Presentation
Note: Presentation method may vary somewhat from section to section.
Presentation will be by lecture.

Assessment
Note: Assessment method may vary somewhat from section to section.
Evaluation is based on assignments, project, and examination.