HIGH PERFOMANCE ORACLE DATA WAREHOUSING
(Imprint: CORIOLIS)
(Imprint: CORIOLIS GROUP)
Author: DONALD BURLESON
Publication Date: 1997
ISBN: 1576101541

Contents
CHAPTER 1 - The Evolution Of The Data Warehouse

• The Evolution Of Data Management Platforms

• Pre-Disk Data Storage

• Early Disk-Based Data Storage

• Early Commercial Databases

• The CODASYL Generation Of Database Management

• Introduction Of The Relational Model

• Database Architectures For The 1990s

• Abstract Data Typing (ADTs)

• Definition Of Aggregate Objects

• Coupling Of Data And Behavior

• Abstraction

• Inheritance

• Important Facts About Inheritance

• Polymorphism

• Encapsulation

• Extensibility

• The IS-A Construct

• Decision Support Systems And Expert Systems

• Expert Systems And Data Warehouses

• Decision Support Systems And Data Warehouses

• Data Warehouses And Multidimensional Databases

• Data Extraction For The Oracle Warehouse

• Data Aggregation

• Economic Factors

• Metadata And The Oracle Warehouse

• ROLAP And Oracle Warehouses

• Problem Solving For The Oracle Warehouse

• Statistical Analysis And Oracle

• Multivariate Analysis

• Simulation And Modeling

• Forecasting

• Aggregation

• Summary

CHAPTER 02 - The Data Warehouse Development Life Cycle

• The Evolution Of Database Development

• Data Warehouse Development Methods

  • Phase 1: Feasibility Study

  • Phase 2: Systems Analysis

  • Phase 3: Systems Design

  • Phase 4: Implementation

  • Phase 5: Ongoing Maintenance

  • Warehouse End-User Requirements

• The Feasibility Study

  • Technological Feasibility

  • Economic Feasibility

    • Development Costs

    • Warehouse Benefits

    • Computing Return On Investment (ROI)

    • Data Warehouses And ROI

• Warehouse Project Management

  • Basic Project Management

  • Effective Project Management

• The Scope Of Work Agreement

• The Data Warehouse Team

• The Organizational Framework

• The Project Delivery Schedule

• Data Warehouse Project Tracking

• Warehouse Project Model

• Risk Management And Data Warehouse Projects

• Summary

CHAPTER 03 - Data Warehouse Analysis

• Traditional Systems Analysis

• The Structured Specification

• The Role Of Functional Decomposition

• Data Warehouse Analysis

  • Data Warehouse Process Analysis

  • Data Warehouse Source Analysis

    • Analyzing Source Document Input

    • Guttbaum's Grocery Stores

    • Guttbaum's Grocery Club Card

    • Grocery Club Application Form

    • Product Description Sheet

    • Product Invoice

    • Customer Transaction

    • Advertising Data Sources

    • Identifying External Data Requirements

    • Legacy Data Analysis

  • Data Warehouse Loading Analysis

  • Data Warehouse Query Analysis

    • Ad Hoc Classification

    • An Example Of Ad Hoc Classification

    • Data Transformation Analysis

• Summary

CHAPTER 04 - Oracle Data Warehouse Design

• Normalization And Modeling Theory

• Unnormalized Form

• First Normal Form

• Second Normal Form

• Third Normal Form

• Entity/Relation Modeling

  • Introducing Redundancy Into An Entity/Relation Model

    • Denormalizing One-To-Many Data Relationships

    • Denormalizing 3NF Relationships

    • Denormalizing Many-To-Many Data Relationships

  • Dealing With Recursive Data Relationships

• Massive Denormalization: STAR Schema Design

  • Populating STAR Schemas With Distributed SQL

  • Table Partitioning

  • Denormalization And Data Warehouse Sizing

  • Handling Attribute Classification

    • Choose-One And Finite Value Attributes

    • Hierarchical Attribute Design

• Data Warehouse Input Screen Design

  • Creating An SQL Generating Front End

  CHAPTER 05 - Online Analytical Processing And Oracle

  • OLAP Fundamentals

  • Using Excel Pivot Tables For OLAP

  • Step 1: Load The Sample Spreadsheet

  • Step 2: Invoke The PivotTable Wizard

• Data Warehouses And Multidimensional Databases

  • Simulation Of Cubic Databases (Dimensionality)

• OLAP, ROLAP, And MOLAP

  • Speed Vs. Flexibility

  • Multidimensional OLAP (MOLAP)

  • Relational OLAP (ROLAP)

  • OLAP Hybrids

• Alternatives To OLAP Data Representation

• Summary

CHAPTER 06 - Aggregating Data For The Oracle Warehouse

• Data Aggregation And Drill-Down

• Aggregation, Roll-Ups, And STAR Schemas

• Alternate Summary Data Formats

• Data Aggregation And Data Redundancy

• A Method For Pre-Calculating And Storing Summary Data

  • Determining The Number Of Aggregate Tables

  • Using SQL To Create Summary Tables

• Summary

CHAPTER 07 - Parallelism And Oracle Data Warehousing

• Parallel Processing

  • SMP And MPP Processing

  • Coordination Of Concurrent Tasks

• Oracle Parallel Database And Server

  • The Distributed Lock Manager

  • Tuning The Parallel Server

  • Free Lists And Oracle Parallel Server Contention

  • The V$LOCK_ACTIVITY View

  • The V$SYSSTAT View

• Oracle Parallel Query

• Parallel Create Table As Select

• Parallel Index Building

• Summary

CHAPTER 08 - Oracle Features For The Data Warehouse

• Oracle Tables In The Data Warehouse

  • Table Maintenance

  • Oracle's Table Cache Option

    • Table Caching Setup

    • Turning On The Table Cache Option

• Understanding Oracle Indexes

  • Clustered Indexes

    • How To Create A Clustered Index

  • Determining When To Rebuild Indexes

    • Index Tablespace Issues

    • Rebuilding Unbalanced Indexes

  • Oracle Bitmapped Indexes

• Referential Integrity AndWarehouse Performance

• Using Oracle's Unrecoverable Option

• Oracle Tablespace Management

  • Reserving Tablespace Using PCTFREE

  • Sizing Oracle Data Blocks

    With db_block_size

  • Oracle Tablespace Considerations

  • Tablespace Fragmentation

  • Tablespace Reorganization

    • Manual Tablespace Coalescing

  • Using Oracle's Read-Only Tablespaces

    • Read-Only Tablespaces In The Real World

  • Oracle And CD-ROM Media

• Oracle's 64-Bit Option—A Look Into The Future

  • SQL Complexity And Response Time

  • What About BOB?

• Summary

CHAPTER 09 - Distributed Oracle Data Warehouses

• A Definition Of Distributed Databases

  • Local Autonomy

  • No Reliance On A Central Site

  • Continuous Operation

  • Location Independence

  • Fragmentation Independence

  • Replication Independence

  • Distributed Query Processing

  • Distributed Transaction Management (Update Processing)

  • Hardware Independence

  • Operating System Independence

  • Network Independence

  • Database Independence

• Types Of Database Distribution

  • Geographical Distribution (Horizontal Distribution)

  • Platform Distribution (Vertical Distribution)

  • Architectural Distribution

• Data Integrity And Distributed Databases

• Data Partitioning

• Location Transparency

  • Implementing Location Transparency With Oracle

  • Oracle Domains And Location Transparency

• Table Replication Techniques

  • Master-Slave Oracle Replication

    • Replication And Referential Integrity

    • Realtime Table Updates

  • Table Replication With Oracle Snapshots

    • How Oracle Snapshots Work

    • Real-World Tips And Techniques For Oracle Snapshots

    • Using Triggers To Update Snapshots

    • Using Snapshots To Propagate Subsets Of Master Tables

• Warehouse Table Partitioning And Distributed Oracle

• The Internals Of Oracle's SQL*Net

  • Establishing SQL*Net Sessions

  • Application Connection With SQL*Net

  • SQL*Net For Oracle Distributed Data Warehouses

  • Understanding The SQL*Net Listener

  • Managing SQL*Net Connections

    • Managing A Multithreaded Server (MTS)

    • Managing The Listener Process

  • Managing Two-Phase Commits (2PCs) With SQL*Net

• Summary

CHAPTER 10 - Oracle Data Warehouse Utilities

• Oracle's Import/Export Utilities

  • Table Row Fragmentation Utilities

  • Table Fragmentation Utilities

• Warehouse Backups Using Oracle's Export/Import Utilities

• Oracle Export/Import DataWarehouse Issues

  • Issues Of Scale With Export/Import

    • Exporting To Tape

    • Compressing Oracle Exports

    • Partitioning Oracle Exports

  • Loading Export Files Using The SQL*Loader Utility

    • Conventional Path Loading

    • Direct Path Loading

    • Using The SQL*Loader Control File

    • Improving Loading Speed

• Linking Oracle Warehouses With Other Databases

  • Oracle Gateway Utilities

    • Gateway Utilities—Phase One

    • Gateway Utilities—Phase Two

    • Gateway Utilities—Phase Three

  • Middleware Solutions

• Summary

CHAPTER 11 - Tuning The Oracle Warehouse Architecture

• The Oracle Architecture

• Oracle's Internal Structures

  • SGA And PGA

  • The Oracle V$ Views

• Interoperability Facilities

  • Creating Batch-Oriented Oracle Instances

  • Oracle Stored Procedures

    • When To Use Oracle Stored Procedures

  • Pinning Oracle Packages In The SGA

    • Automatic Re-Pinning Of Packages

    • How To Measure Pinned Packages

  • Oracle Triggers

    • Deciding When To Use A Trigger

  • Oracle Hash Tables

  • Oracle Clusters

• Tuning Oracle Memory

  • Sizing The System Global Area (SGA)

  • Using The db_block_size With db_file_multiblock_read_count

  • Tuning Oracle Sorting

  • The Oracle Program Global Area (PGA)

  • Tuning The shared_pool_size

    • Tuning The Oracle Library Cache

    • Tuning The Oracle Dictionary Cache

  • Multithreaded Server Tuning

  • Tuning The db_block_buffers Parameter

  • Predicting The Benefit Of Adding Additional Block Buffers

  • Memory Cache Tuning

  • I/O-Based Tuning

    • Disk Striping

  • Simulating The Pinning Of Database Rows

• Summary

CHAPTER 12 - Tuning Oracle SQL

• Tuning Oracle SQL Syntax

• General Tips For Efficient Oracle SQL

• Tuning SQL With Indexes

  • Concatenated Indexes

• Using Oracle's Explain Plan Utility

  • Using Temporary Tables To Improve Performance

• Tuning The Rule-Based Optimizer

• Tuning The Cost-Based Optimizer

• Tuning PL/SQL

• New Oracle SQL Tuning Features

  • STAR Queries With Oracle 7.3

  • Using Oracle's Bitmap Indexes

  • Oracle Hash Joins

• Summary

CHAPTER 13 - Monitoring The Oracle Data Warehouse

• Oracle Enterprise Manager

  • Oracle Enterprise Manager—Standard Tools

    • Oracle Schema Manager

    • Oracle Security Manager

    • Oracle Replication Manager

    • Oracle Data Manager

    • Oracle Storage Manager

    • Oracle Backup Manager

    • Oracle Enterprise Manager Console

    • Oracle SQL Worksheet

    • Oracle Instance Manager

  • Oracle Enterprise Manager On The Web

• Oracle Performance Pack

  • Top Sessions

  • Oracle Expert

  • Oracle Performance Manager

  • Oracle Trace

  • Oracle Tablespace Manager

• The OEM And OPP Toolbar

• Summary

CHAPTER 14 - Oracle8 For The Warehouse

• Table And Index Partitioning

  • Increased Availability

  • Increased Performance

  • Table Partitioning With Oracle8

    • Partitioning Syntax

    • Migration Into Partitioned Table Structures

  • Index Partitioning With Oracle8

    • Local Partitioned Indexes

    • Global Partitioned Indexes

• New Parallel Operations

• Improved Join Optimization

• Summary

CHAPTER 15 - Data Mining And Oracle

• Defining Data Mining

• Data Mining And Data Warehouses

  • Supervised Learning

  • Unsupervised Learning

  • Reinforcement Learning

• Information Classifications

  • Association

  • Classification

  • Clustering

  • Modeling

  • Forecasting

  • Pattern Identification

• Data Mining Tools In The Marketplace

• Moral And Ethical Issues In Data Mining

• Summary

CHAPTER 16 - Oracle Warehouses And The Year 2000

• Oracle Date Overview

  • Date Display

  • Date Insertion

  • Checking Existing Century Values

  • A Suggested Implementation Plan

    • Option One: Do Nothing

    • Option Two: Change The nls_date_formatTo DD-MON-RR

    • Option Three: Change The nls_date_formatTo DD-MON-YYYY

• Summary

About this book
[an error occurred while processing this directive]