Book description
The definitive, real-world guide to Oracle data warehousing
Maximizing performance, flexibility, and manageability in production environments
Hardware/software architectures, star schema design, partitioning, and more
Industrial strength data loading and query optimization techniques
By the world-renowned architect of 7-Eleven's multi-terabyte datawarehouse
Maximize Oracle data warehouse performance, flexibility, and manageability
Oracle DBAs finally have a definitive guide to every aspect of designing, constructing, tuning, and maintaining star schema data warehouses with Oracle 8i and 9i. Bert Scalzo, one of the world's leading Oracle data warehousing experts, offers practical, hard-won lessons and breakthrough techniques for maximizing performance, flexibility, and manageability in any production environment. Coverage includes:
Data warehousing fundamentals for DBAs--including what a data warehouse isn't
Planning software architecture: business intelligence, user interfaces, Oracle versions, OS platforms, and more
Planning hardware architecture: CPUs, memory, disk space, and configuration
Radically different star schema design for radically improved performance
Tuning ad-hoc queries for lightning speed Industrial-strength data loading techniques
Aggregate tables: maximizing performance benefits, minimizing complexity tradeoffs
Improving manageability: The right ways to partition
Data warehouse administration: Backup/recovery, space and extent management, updates, patches, and more
Table of contents
- Copyright
- The Prentice Hall PTR Oracle Series
- About Prentice Hall Professional Technical Reference
- Acknowledgments
- Introduction
- What Is a Data Warehouse?
- Software Architecture
- Hardware Architecture
- Star Schema Universe
- Tuning Ad-Hoc Queries
- Loading the Warehouse
- Implementing Aggregates
- Partitioning for Manageability
- Operational Issues and More
Product information
- Title: Oracle® DBA Guide to Data Warehousing and Star Schemas
- Author(s):
- Release date: June 2003
- Publisher(s): Pearson
- ISBN: 0130325848
You might also like
video
Strata Data Superstream Series: Data Warehouses, Data Lakes, and Data Lakehouses
Storing, processing, and moving data in the cloud efficiently and cost-effectively is a must for working …
book
The Microsoft® Data Warehouse Toolkit: With SQL Server 2008 R2 and the Microsoft® Business Intelligence Toolset, Second Edition
Best practices and invaluable advice from world-renowned data warehouse experts In this book, leading data warehouse …
book
Oracle SQL Revealed: Executing Business Logic in the Database Engine
Write queries using little-known, but powerful, SQL features implemented in Oracle's database engine. You will be …
book
SQL Clearly Explained, 2nd Edition
This is the second edition of the popular practitioner's guide to SQL, the industry-standard database query …