Data warehouse Design Using Oracle (view)

Units included with this Open Author resource:

Cover

Learning goals:

The objective of the text book is reader get benefit of designing data warehousing model and also they can implement the design using Oracle

Keywords:

Alter Dimension, Attribute, Compile_state, Create Dimension, Data Base, Data Warehousing, Data Warehousing Design, Dbms_mview, Dimension Table, Dr.girija, Dr.Girija Narasimhan, Fact Table, Hierarchy, Level, Materialized View, Mlog$, OLAP, Partition, Refresh Complete, Refresh Fast, Refresh Force, Rowid, Snowflakes Schema, SQL Model Clause, Star Schema, View

Lesson Plan

Unit 1 Schema Design

Learning goals:

This unit completely disucss data warehousing schema design such as star shcema, snow flakes schema, galaxy schema and fact table, dimension table etc., For practical implementation purpose oracle 11g sql statement are used.

Keywords:

Data Base, Data Warehousing, Data Warehousing Design, Dr.girija, Dr.Girija Narasimhan, Materialized View, OLAP, Partition, Snowflakes Schema, SQL Model Clause, Star Schema, fact table, dimension table, hierarchy, level, attribute, compile_state, alter dimension, create dimension

Unit 2  Materialized View

Learning goals:

Describe materialized view, various refresh method, materialized view log and with clauses. It also explains mv comments , views, aggregate function

Keywords:

Alter Dimension, Attribute, Compile_state, Create Dimension, Data Base, Data Warehousing, Data Warehousing Design, Dimension Table, Dr.girija, Dr.Girija Narasimhan, Fact Table, Hierarchy, Level, Materialized View, OLAP, Partition, Snowflakes Schema, SQL Model Clause, Star Schema, view, materialized view, refresh complete, refresh force, refresh fast, mlog$, rowid, dbms_mview

Unit 3 Online Analytical Processing(OLAP)

Unit 4 Partition

Unit 5 SQL Model Clause

Exercise Solution

Case Study