Oracle DBA Guide to Data Warehousing and Star Schemas
Books / Paperback
Books › Computers › Databases › General
ISBN: 0130325848 / Publisher: Prentice Hall, June 2003
Oracle DBA Guide to Data Warehousing and Star Schemas is the definitiveguide to maximizing the performance, flexibility, and manageability ofany Oracle 8i/9i data warehouse. Legendary Oracle data warehouse expertBert Scalzo offers hard-won lessons and proven techniques for designing,constructing, tuning, and maintaining star schema data warehouses inreal production environments. Coverage includes: planning hardware andsoftware architectures; star schema design; data loading; queryoptimization; partitioning; administration; and much more.
Read More
Offering a radical approach for maximizing data warehousing performance and flexibility, this book teaches every aspect of designing, building, tuning, and maintaining star schema data warehouses using Oracle 8I and 9i. Scalzo (designer of 7-Eleven's multi-terabyte star schema data warehouse) explains the difference between a database and a data warehouse and encourages readers to let go of their Oracle DBA baggage and embrace seemingly outlandish concepts including creating bitmap indexes on every column of every table, and not normalizing database designs. Topics include the right way to partition, tuning ad-hoc queries for lightning speed, and industrial-strength data loading techniques. Annotation (c) Book News, Inc., Portland, OR (booknews.com)
Read Less