DW Lecture V (2)

DW Lecture V (2) - Datawarehousing and (LectureV By Dr...

Info iconThis preview shows pages 1–11. Sign up to view the full content.

View Full Document Right Arrow Icon
By Dr. Atanu Rakshit Data warehousing   and  Business Intelligence using SAS (Lecture V)
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
2 Course Overview The course: what and how 0. Introduction: The Past and The  Problem I. Data Warehousing II. Decision Support and OLAP III. Data Mining IV. Usage of SAS for DW and DM V.  Business Intelligence and its use VI. Looking Ahead
Background image of page 2
3 Introduction The Past and The Problem
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
4 Process Model for Data Warehouse Design Requirement analysis and specification Conceptual Design Logical Design Physical Design Operational Database / Schema Semi-formal Business Concepts Formal conceptual Schema Formal Logical Schema Physical database / Schema
Background image of page 4
5 Some Basic Multidimensional structure and  Terminologies  Fact – represent atomic information in a  multidimensional database. A fact consists of  qualifying values stored in measures and  qualifying context which is determined through  terminal dimension levels Attributes – Measure , Dimension or Property Property Attributes – describe the additional  information like – customer name etc. Optional Property Attributes – An optional  property attribute need not be specified
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
6 Summarizability and Multidimensional Normal  Form Summarizability refers to the possibility to  compute aggregate value with a lower level  detail from aggregate value with a higher level  of details Generalized Multidimensional Normal Form  (GMNF) ensures Summarizability in the  presence of optional dimension levels in a  context sensitive manner and supports an  efficient physical database design
Background image of page 6
7 Let F be a fact schema, we call the attributes  occurring in F the universe of F, denoted by Uf There is a set of functional dependencies over  Uf, called the functional dependencies implied  by F, denoted by FDf Let FDu be a set of functional dependencies  over Uf that can be observed in the application  domain Summarizability and Multidimensional Normal  Form
Background image of page 7

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
8 First Multidimensional Normal Form (1  MNF) – demands The functional dependencies FDf do occur in  the application domain The potential for roll-up and drill-down  operations available in the application domain  is preserved in the fact schema The fact schema embodies the  multidimensional context of measure Summarizability and Multidimensional Normal  Form
Background image of page 8
9 Observations: First option ensures completeness aspect  with respect to coverage of the underlying  application domain It should avoids certain kinds of redundancies  that arise due to transitive dependencies Summarizability and Multidimensional Normal  Form
Background image of page 9

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
10 2 MNF – It strengthen 1 MNF by taking care of  optional dimension levels in order to guarantee 
Background image of page 10
Image of page 11
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 07/15/2011 for the course ECO 2023 taught by Professor Mr.raza during the Summer '10 term at FAU.

Page1 / 35

DW Lecture V (2) - Datawarehousing and (LectureV By Dr...

This preview shows document pages 1 - 11. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online