Fluency With Information Technology CSE100/IMT100
Enterprise Database Systems Learning Objectives
Data Warehousing Overview
The Need for Data Analysis
Decision Support Systems (DSS)
Decision Support Systems
Main Components of a DSS
The Data Warehouse
Creating a Data Warehouse
The Data Mart
On-Line Analytical Processing
On-Line Analytical Processing (OLAP)
OLAP Client/Server Architecture
OLAP Server Arrangement
OLAP Server with Local Data Marts
Star Schema
A Simple Star Schema
A Three-Dimensional View of Sales
Slice and Dice View of Sales
A Location Attribute Hierarchy
Attribute Hierarchies in Multidimensional Analysis
Data Warehouse Implementation
Data Mining
Email: melo@u.washington.edu