Oracle Data Warehouse Tuning for 10g

✍ Scribed by Gavin Powell (Auth.)

• Publisher: Digital Press
• Year: 2005
• Tongue: English
• Leaves: 464
• Category: Library

✦ Table of Contents

Content:
Preface, Pages xix-xxii
Introduction to data warehouse tuning, Pages xxiii-xxx
chapter 1 - The basics of data warehouse data Modeling, Pages 3-29
chapter 2 - Introducing data warehouse tuning, Pages 31-47
chapter 3 - Effective data warehouse indexing, Pages 49-77
chapter 4 - Materialized views and query rewrite, Pages 79-112
chapter 5 - Oracle dimension objects, Pages 113-136
chapter 6 - Partitioning and basic parallel processing, Pages 137-159
chapter 7 - The basics of sql query code tuning, Pages 163-213
chapter 8 - Aggregation using group by clause extensions, Pages 215-247
chapter 9 - Analysis reporting, Pages 249-279
chapter 10 - Modeling with the model clause, Pages 281-316
chapter 11 - Query rewrite, Pages 319-333
chapter 12 - Parallel processing, Pages 335-349
chapter 13 - Data loading, Pages 351-384
chapter 14 - Data warehouse architecture, Pages 385-422
chapter A - New data warehouse features in oracle Database l0g, Page 423
chapter B - Sample schemas, Pages 425-430
chapter C - Sample scripting, Pages 431-446
chapter D - Syntax conventions, Pages 447-448
chapter E - Sources of information, Pages 449-450
Index, Pages 451-468