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
Similar book on Amazon
Oracle SQL*Plus: The Definitive Guide (Definitive Guides)
The Data Warehouse ETL Toolkit: Practical Techniques for Extracting, Cleanin
Star Schema The Complete Reference
Oracle Data Warehouse Tuning for 10g
The Data Warehouse Lifecycle Toolkit
The CISSP and CAP Prep Guide: Platinum Edition
CompTIA Project+ Study Guide: Exam PK0-003
Answers to Assessment Test
IT Project Management Overview
Scope Planning
Project Execution
Appendix A Systems Development Life Cycle
Network Security Architectures
Confidentiality and Security Are Not the Same
HTTP/HTTPS
Identity Technology Guidelines
What Is the Edge?
High-End Resilient Edge Security Design
Microsoft Windows Server 2003(c) TCP/IP Protocols and Services (c) Technical Reference
Wide Area Network (WAN) Technologies
Address Resolution Protocol (ARP)
Point-to-Point Protocol (PPP)
User Datagram Protocol
RADIUS and Internet Authentication Service
Introduction to 80x86 Assembly Language and Computer Architecture
Representing Data in a Computer
Basic Instructions
Appendix A Hexadecimal/ASCII conversion
Appendix B Useful MS-DOS Commands
Appendix C MASM 6.11 Reserved Words
Making Sense of Change Management: A Complete Guide to the Models, Tools and Techniques of Organizational Change
Individual change
Team change
Leading change
Restructuring
IT-based process change
Quantitative Methods in Project Management
Project Value: The Source of all Quantitative Measures
Organizing and Estimating the Work
Making Quantitative Decisions
Quantitative Time Management
Special Topics in Quantitative Management
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