OLAP๎and๎its๎Types
docsity.com
Prepare for your exams
Study with the several resources on Docsity
Earn points to download
Earn points by helping other students or get them with a premium plan
Guidelines and tips
Prepare for your exams
Study with the several resources on Docsity
Earn points to download
Earn points by helping other students or get them with a premium plan
OLAP and its Types-Data Warehouse-Lecture Slides, Slides of Data Warehousing
Topics include in this course are Data Warehousing Concepts, Design and Development, Extraction, Transformation and Loading, OLAP Technology, Data Mining Techniques: Classification, Clustering and Decision Tree, Advanced Topics. This lecture includes: OLAP, Types, Analysis, Service, Architecture, Decision, Support, Systems, Model, Compare, Contrast, Star, Schema
Typology: Slides
2011/2012
1 / 45
This page cannot be seen from the preview
Don't miss anything!
Related documents
Partial preview of the text
Download OLAP and its Types-Data Warehouse-Lecture Slides and more Slides Data Warehousing in PDF only on Docsity!
OLAP
and
its
Types
Contents
**1. Analysis Service Architecture/Three โ tier Decision Support Systems
Approaches to OLAP servers
Multi โ dimensional data model
ROLAP, MOLAP, HOLAP
Which to choose: Compare and Contrast**
The
Complete
Decision
Support
System
Information Sources Data Warehouse Server(Tier 1) OLAP Servers (Tier 2) Clients(Tier 3) Operational DBโs Semistructured Sources extracttransformloadrefreshetc. Data Marts Data Warehouse e.g., MOLAP e.g., ROLAP serve OLAP Query/Reporting Data Mining serve serve
Three
Tier
Decision
Support
Systems
Warehouse
database
server
Almost always a relational
DBMS
OLAP
servers
Relational
OLAP
(ROLAP):
extended relational
DBMS
that maps operations on multidimensional data to standard relational operators
Multidimensional
OLAP
(MOLAP):
special
purpose server that directly implements multidimensional data and operations
Clients
Query and reporting tools
Analysis tools - Data mining tools
OLAP
โ What
is
it?
The
activity
of
interactively analyzing business transaction data ๏
stored in the dimensional data warehouse
to make tactical and strategic business decisions
Examples:
analyzing the effectiveness of a marketing campaign bymeasuring sales growth over a certain period
analyzing the impact of a price increase on the productsales in different regions and product groups during thesame period of time
Cube
logical
design
by
which
the
data
is
referenced
underlying
data
might
be
stored
using
a
number
of
different
methods
OLAP: Revision of Important Concepts