Download What is a Data Warehouse PDF

TitleWhat is a Data Warehouse
File Size375.0 KB
Total Pages46
Table of Contents
                            What is a Data Warehouse?
	Figure 1-1 Contrasting OLTP and Data Warehousing Environments
	Architecture of a Data Warehouse with a Staging Area
	Architecture of a Data Warehouse with a Staging Area and Data Marts
	Logical Design :  Physical Design

Creating a Logical Design
Data Warehousing Schemas
	Star Schemas
		Figure 2-1 Star Schema
	Other Schemas
Another schema that is sometimes useful is the snowflake schema, which is a star schema with normalized dimensions in a tree structure.
Data Warehousing Objects
	Typical Data Warehousing Objects
	Fact Tables
	Dimension Tables
			Level Relationships
		Typical Dimension Hierarchy
	Unique Identifiers
	When to Implement Parallel Execution
	Partition Pruning
		Partitioning Methods
			Hash Partitioning
			List Partitioning : discrete values
		Range and Hash Partitions of a Composite Table
	Partition Pruning
		Adding a Partition to a Range-Partitioned Table
		Adding a Partition to a Hash-Partitioned Table
	Dropping Partitions
		Dropping a Table Partition
	Exchanging Partitions
	Splitting and Merging Partitions
	Truncating Partitions
	Executing a Query Using Bitmap Indexes
	Bitmap Indexes and Nulls
	Example 6-2 Bitmap Index
	Bitmap Join Indexes
	Bitmap Join Indexes
		Example 6-3 Bitmap Join Index: Example 1
			Table 6-2 Sample Bitmap Join Index
		Example 6-4 Bitmap Join Index: Example 2
		Example 6-5 Bitmap Join Index: Example 3
		Example 6-6 Bitmap Join Index: Example 4
		Bitmap Join Index Restrictions
	Typical Data Warehouse Integrity Constraints
		RELY Constraints
		Integrity Constraints and Parallelism
		Build Methods
			Refresh Modes
			Refresh Options
		Materialized View Logs
		Using Oracle Enterprise Manager
	Enabling Query Rewrite
	Types of Materialized Views
		Example 8-1 Creating a Materialized View: Example 1
		Creating a Materialized View: Example 2
		Materialized View Containing Only Joins
	Registering Existing Materialized Views
	Partitioning and Materialized Views
		Partitioning a Materialized View
		Partitioning a Prebuilt Table
	Overview of Query Rewrite
		Transparent Query Rewrite
		The Query Rewrite Process
	Enabling Query Rewrite
	How Oracle Rewrites Queries
		Text Match Rewrite Methods
			Text Match Capabilities
		General Query Rewrite Methods
			Materialized View Types and General Query Rewrite Methods
			Materialized View Restrictions
			General Query Rewrite Restrictions
	Extraction, Transformation, and Loading
		Logical Extraction Methods
	Physical Extraction Methods :
		Online Extraction
		Offline Extraction
		Extraction Via Distributed Operations
		Transformation Flow
			Multistage Data Transformation
			Pipelined Data Transformation
	Loading Mechanisms
	Transformation Mechanisms
		When to Use Merge
		Performance will improve because you Merge Operation Using SQL in Oracle9i
		Transformation Using Multitable INSERT :
		Transformation Using Table Functions
			Table Function Example
			Pipelined Parallel Transformation with Fanout
		Pivoting Scenarios
			Interoperation Parallelism and Dynamic Partitioning

Similer Documents