數據倉庫和OLAP技術講座培訓(PPT 66頁)

數據倉庫和OLAP技術
數據庫的定義
兩種不同的數據處理需求
為什麼要建立數據倉庫？
What is Data Warehouse?
Data Warehouse—Subject-Oriented
麵向應用舉例
麵向主題舉例
Data Warehouse—Integrated
Data Warehouse—Time Variant
Data Warehouse—Non-Volatile
Data Warehouse vs. Heterogeneous DBMS
Data Warehouse vs. Operational DBMS
OLTP vs. OLAP
Why Separate Data Warehouse?
Data Warehousing and OLAPTechnology
From Tables and Spreadsheets to Data Cubes
Cube: A Lattice of Cuboids
Conceptual Modeling of Data Warehouses
Example of Star Schema
Example of Snowflake Schema
Example of Fact Constellation
A Data Mining Query Language,DMQL: Language Primitives
Defining a Star Schema in DMQL
Defining a Snowflake Schema in DMQL
Defining a Fact Constellation in DMQL
Measures: Three Categories
A Concept Hierarchy: Dimension (location)
View of Warehouses and Hierarchies
Multidimensional Data
A Sample Data Cube
Cuboids Corresponding to the Cube
Browsing a Data Cube
Typical OLAP Operations
A Star-Net Query Model
Data Warehousing and OLAP Technology for Data Mining
Design of a Data Warehouse: A Business Analysis Framework
Data Warehouse Design Process
Multi-Tiered Architecture
體係結構 [ Pieter ,1998 ]
數據倉庫的焦點問題
ETL 工具
Three Data Warehouse Models
Data Warehouse Development:A Recommended Approach
OLAP Server Architectures
Data Warehousing and OLAP Technology for Data Mining
Efficient Data Cube Computation
Cube Operation
Cube Computation: ROLAP-Based Method
Multi-way Array Aggregation for Cube Computation
Indexing OLAP Data: Bitmap Index
Indexing OLAP Data: Join Indices
Efficient Processing OLAP Queries
Metadata Repository
Data Warehouse Back-End Tools and Utilities
Examples: Discovery-Driven Data Cubes
Data Warehouse Usage
An OLAM Architecture
Summary
..............................