Page 193 - DCAP603_DATAWARE_HOUSING_AND_DATAMINING
P. 193
Unit 10: Multi-dimensional Data Models and Aggregation
Sartaj Singh, Lovely Professional University
unit 10: Multi-dimensional Data Models and aggregation notes
contents
Objectives
Introduction
10.1 Multi-dimensional View of Information
10.2 The Logical Model for Multi-dimensional Information
10.3 Relational Implementation of the Model
10.3.1 Star Schema
10.3.2 Snowflake Schema
10.4 ROLAP Model
10.5 MOLAP Model
10.6 Conceptual Models for Multi-dimensional Information
10.7 Summary
10.8 Keywords
10.9 Self Assessment
10.10 Review Questions
10.11 Further Readings
objectives
After studying this unit, you will be able to:
l z Explain multi-dimensional view of information
l z Describe ROLAP data model
l z Describe MOLAP data model
l z Describe logical and conceptual model for multi-dimensional information
introduction
Metadata is used throughout Oracle OLAP to define a logical multidimensional model:
1. To describe the source data as multidimensional objects for use by the analytic workspace
build tools.
2. To identify the components of logical objects in an analytic workspace for use by the
refresh, aggregation, and enablement tools.
3. To describe relational views of analytic workspaces as multidimensional objects for use by
OLAP applications.
LoveLy professionaL university 187
