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
Beginners Guide to DarkBASIC Game Programming (Premier Press Game Development)
Basic Commands, Variables, and Data Types
Characters, Strings, and Text Output
More Power to the Numbers Data Sequences and Arrays
Game Graphics Learning to Use Bitmaps
Multiplayer Programming The Crazy Carnage Game
101 Microsoft Visual Basic .NET Applications
Working with Microsoft Visual Studio .NET 2003 and Microsoft .NET Framework 1.1
Working with Console Applications
Interacting with the Operating System
Building Enterprise Services Applications
Visual Studio .NET
Google Maps Hacks: Tips & Tools for Geographic Searching and Remixing
Hack 6. Share Google Maps
Hack 26. Follow Your Packets Across the Internet
Hack 32. Locate a Phone Number
Hack 46. Browse Photography by Shooting Location
Hacks 5161: Introduction
Microsoft WSH and VBScript Programming for the Absolute Beginner
VBScript Basics
Constants, Variables, and Arrays
Conditional Logic
Handling Script Errors
Appendix C Whats on the CD-ROM?
Web Systems Design and Online Consumer Behavior
Chapter III Two Models of Online Patronage: Why Do Consumers Shop on the Internet?
Chapter V Consumer Complaint Behavior in the Online Environment
Chapter XIII Shopping Agent Web Sites: A Comparative Shopping Environment
Chapter XVI Turning Web Surfers into Loyal Customers: Cognitive Lock-In Through Interface Design and Web Site Usability
Chapter XVII Internet Markets and E-Loyalty
Telecommunications Essentials, Second Edition: The Complete Global Source (2nd Edition)
Signaling Systems
Wide Area Networking
Packet-Switched Networks
Beyond 3G
Mobile Content
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