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
Image Processing with LabVIEW and IMAQ Vision
Introduction to IMAQ Vision Builder
NI Vision Builder for Automated Inspection
Color Images
Morphology Functions
Character Recognition
Systematic Software Testing (Artech House Computer Library)
Test Execution
The Test Organization
Appendix C IEEE Templates
Appendix E Simplified Unit Test Plan
Appendix F Process Diagrams
Postfix: The Definitive Guide
General Configuration and Administration
Hosting Multiple Domains
Separate Domains with Virtual Accounts
Backup MX
Postfix Anti-Spam Example
Cisco IOS Cookbook (Cookbooks (OReilly))
Adjusting Local Preference Values
Using Custom Queues with Priority Queues
Aggregating RSVP Reservations
Setting the Time Zone
Converting Broadcasts to Multicasts
Web Systems Design and Online Consumer Behavior
Chapter III Two Models of Online Patronage: Why Do Consumers Shop on the Internet?
Chapter IX Extrinsic Plus Intrinsic Human Factors Influencing the Web Usage
Chapter XII Web Design and E-Commerce
Chapter XV Customer Trust in Online Commerce
Chapter XVI Turning Web Surfers into Loyal Customers: Cognitive Lock-In Through Interface Design and Web Site Usability
What is Lean Six Sigma
The Four Keys to Lean Six Sigma
Key #1: Delight Your Customers with Speed and Quality
Key #2: Improve Your Processes
Beyond the Basics: The Five Laws of Lean Six Sigma
When Companies Start Using Lean Six Sigma
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