Flylib.com
Oracle DBA Guide to Data Warehousing and Star Schemas
Oracle DBA Guide to Data Warehousing and Star Schemas
ISBN: 0130325848
EAN: 2147483647
Year: 2003
Pages: 79
Authors:
Bert Scalzo
BUY ON AMAZON
Main Page
Table of content
Copyright
The Prentice Hall PTR Oracle Series
About Prentice Hall Professional Technical Reference
Acknowledgments
Introduction
Purpose
Audience
Chapter 1. What Is a Data Warehouse?
The Nature of the Beast
Data Warehouse vs. Big Database
Operational Data Stores Don t Count
Executive Information Systems Don t Count
Warehouses Evolve without Phases
The Warehouse Roller Coaster
Chapter 2. Software Architecture
Business Intelligence Options
Oracle Version Options
Oracle Instance OptionsQuerying
Oracle Instance OptionsLoading
Recommended Oracle Architecture
Great Operating System Debate
The Great Programming Language Debate
The Serial vs. Parallel Programming Debate
Chapter 3. Hardware Architecture
Four Basic Questions
How Many CPUs?
How Much Memory?
How Many of What Disks?
Recommended Hardware Architecture
The Great Vendor Debate
The 32- vs. 64-Bit Oracle Debate
The Raw vs. Cooked Files Debate
The Need for Logical Volume Managers
Chapter 4. Star Schema Universe
The Rationale for Stars
Star Schema Challenges
Modeling Star Schemas
Avoid Snowflakes
Dimensional Hierarchies
Querying Star Schemas
Fact Table Options
When Stars Implode
Chapter 5. Tuning Ad-Hoc Queries
Key Tuning Requirements
Star Optimization Evolution
Star Transformation Questions
Initialization Parameters
Star Schema Index Design
Cost-Based Optimizer
Some Parting Thoughts
Chapter 6. Loading the Warehouse
What About ETL Tools?
Loading Architecture
Upstream Source Data
Transformation Requirements
Method 1: Transform, Then Load
Method 2: Load, Then Transform
Deploying the Loading Architecture
Chapter 7. Implementing Aggregates
What Aggregates to Build?
Loading Architecture
Aggregation by Itself
Use Materialized Views
Chapter 8. Partitioning for Manageability
A Plethora of Design Options
Logical Partitioning Design
Simple Partitioning in 8i
Simple Partitioning in 9i
Complex Partitioning in 8i
Complex Partitioning in 9i
Partition Option Benchmarks
Chapter 9. Operational Issues and More
Backup and Recovery
Space Management
Extent Management
Updates and Patches
Oracle DBA Guide to Data Warehousing and Star Schemas
ISBN: 0130325848
EAN: 2147483647
Year: 2003
Pages: 79
Authors:
Bert Scalzo
BUY ON AMAZON
Absolute Beginner[ap]s Guide to Project Management
Next Step in the Schedule Development Process
The Impact of the Project Schedule
Creating a Schedule
Why Communicating Can Be Tough
Special Situations
The New Solution Selling: The Revolutionary Sales Process That Is Changing the Way People Sell [NEW SOLUTION SELLING 2/E]
Chapter Four Precall Planning and Research
Chapter Six Defining Pain or Critical Business Issue
Chapter Seven Diagnose Before You Prescribe
Chapter Eight Creating Visions Biased to Your Solution
Chapter Nine Selling When You re Not First
Practical Intrusion Analysis: Prevention and Detection for the Twenty-First Century: Prevention and Detection for the Twenty-First Century
Unauthorized Activity II
Tcpdump
Data Correlation
Laws, Standards, and Organizations
Security Business Issues
Special Edition Using Crystal Reports 10
Understanding the Importance of Reuse in Reporting
Ad-Hoc Application and Excel Plug-in for Ad-Hoc and Analytic Reporting
Establishing Project Requirements
Understanding Firewall Types
Understanding Crystal Enterprise Embedded Edition
File System Forensic Analysis
Apple Partitions
Content Category
Boot Sector
Long File Name Directory Entries
Ext2 and Ext3 Concepts and Analysis
User Interfaces in C#: Windows Forms and Custom Controls
Classic Controls
Custom Controls
GDI+ Basics
GDI+ Controls
Help and Application-Embedded Support
flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net
Privacy policy
This website uses cookies. Click
here
to find out more.
Accept cookies