Slide 1

Slide 2

The Old Way:
Fragmented Information Supply Chain

The New Way: Oracle9i

Oracle9i
Complete, Therefore Simple

Oracle9i Database
Single business-intelligence data server

Oracle9i Application Server
Runs All Your Business Intelligence Applications

Oracle Database for Data Warehousing
Continuous Innovation

New Oracle9i RDBMS features
Extending Oracle’s leadership

Real Application Clusters
(RAC)

Slide 11

Manage Large Volumes of Data

Managing Large Volumes of Data

How Parallel Execution Works

VLDB Manageability and Performance Constraints

Benefits of Partioning

Benefits of Partioning (2)

Partitioning Methods

Partitioned Indexes

Rolling Window Operations

Rolling Window Operations

Rolling Window Operations

Rolling Window Operations

Rolling Window Operations

List Partitioning

List Partitioning

List Partitioning

Table Compression:
What is it?

Table Compression:
What isn’t it?

Table Compression:
How it works

Table Compression:
Usage

Table Compression:
Performance Impact

Table Compression:
When to Use it

Manage large numbers of
concurrent users

Manage large numbers of users

Appropriate Resources to Each Query

Automatic Runtime Memory Tuning

Pro-active management of DW Workloads

Example Scenario

Fast Query Performance

Bitmap Indexes

Bitmap indexes introduction

Bitmap indexes characteristics

Bitmap join indexes

Bitmap join indexes

Bitmap join indexes

Materialized Views

SQL support for analytic calculations

Analytic Functions: Examples

Platform for Business Intelligence:
Data Warehousing

Platform for Business Intelligence:
ETL

Platform for Business Intelligence:
OLAP

Oracle9i OLAP Services

Platform for Business Intelligence:
Data Mining

Slide 55