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
Professional Java Native Interfaces with SWT/JFace (Programmer to Programmer)
Overview of Java UI Toolkits and SWT/JFace
SWT/JFace Mechanisms
Tables
Scales, Sliders, and Progress Bars
JFace Wizards
Introducing Microsoft ASP.NET AJAX (Pro - Developer)
The AJAX Revolution
The Microsoft Client Library for AJAX
The AJAX Control Toolkit
Built-in Application Services
Building AJAX Applications with ASP.NET
802.11 Wireless Networks: The Definitive Guide, Second Edition
Encapsulation of Higher-Layer Protocols Within 802.11
Dynamic WEP
Common Features
Linux Wireless Extensions and Tools
Tunable 802.11 Parameters
Lean Six Sigma for Service : How to Use Lean Speed and Six Sigma Quality to Improve Services and Transactions
Success Story #2 Bank One Bigger… Now Better
Success Story #3 Fort Wayne, Indiana From 0 to 60 in nothing flat
The Value in Conquering Complexity
Phase 4 Performance and Control
First Wave Service Projects
The Lean Six Sigma Pocket Toolbook. A Quick Reference Guide to Nearly 100 Tools for Improving Process Quality, Speed, and Complexity
Value Stream Mapping and Process Flow Tools
Voice of the Customer (VOC)
Data Collection
Identifying and Verifying Causes
Complexity Value Stream Mapping and Complexity Analysis
Microsoft Visual Basic .NET Programmers Cookbook (Pro-Developer)
Objects, Interfaces, and Patterns
Windows Programming
ADO.NET
Web Services
Remoting and Enterprise Services
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