- Paperback: 240 pages
- Publisher: Prentice Hall; 1 edition (4 Jun 2003)
- Language English
- ISBN-10: 0130325848
- ISBN-13: 978-0130325846
- Product Dimensions: 23.7 x 18 x 1.7 cm
-
Amazon Bestsellers Rank:
1,168,605 in Books (See Top 100 in Books)
- #13 in Books > Computers & Internet > Computer Science > Databases > Applications > Oracle > DBA
- See Complete Table of Contents
Did you know you can trade in your old books for an Amazon.co.uk Gift Card to spend on the things you want? Plus, get an extra £5 Gift Certificate when you trade in books worth £10 or more before June 30, 2012. Visit the Books Trade-In Store for more details. |
Product details |
More About the Author
Product Description
Product Description
This book addresses all aspects of constructing star schemas within Oracle data warehouses, from modeling and design through high-speed loads and lightning fast queries. The book delivers meaningful examples complemented by empirical samples and benchmarks, such that readers will learn more than just the mechanics. This book transforms readers into subject matter experts for dimensional modeling, star schemas and data warehousing in general for the Oracle database environment. This book is based on research conducted for the multi-terabyte data warehouse for the 7-Eleven Corporation. Star schema: a data warehouse design that enhances the performance of multidimensional queries on traditional relational databases. One fact table is surrounded by a series of related tables. Data is joined from one of the points to the center, providing a so called "star query." Previously announced in 2/2003 PTG catalog.
From the Back Cover
- 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
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
Tag this product(What's this?)Think of a tag as a keyword or label you consider is strongly related to this product.
Tags will help all customers organise and find favourite items. |
Sell a Digital Version of This Book in the Kindle Store
If you are a publisher or author and hold the digital rights to a book, you can sell a digital version of it in our Kindle Store.
Learn more
Customer Reviews
There are no customer reviews yet on Amazon.co.uk.
5 star
4 star
3 star
2 star
1 star
Most Helpful Customer Reviews on Amazon.com (beta)
Amazon.com:
11 reviews
13 of 14 people found the following review helpful
Pretty good if you can get past the attitude
4 Oct 2003
Format:Paperback|Amazon Verified Purchase
The book offers a number of detailed tuning tips and insights from Mr. Scalzo's real world experience. That being said, the tone of the writing is really annoying. Mr. Scalzo's condescending style is unnecessary and takes away from what could be a very good book. At points, I actually broke out in laughter at his arrogance. However, if you can get past the author's attitude the content of the book seems to be quite helpful.
5 of 5 people found the following review helpful
A Veritable Gold Mine of Practical Hints and Tips!
18 Feb 2004
Format:Paperback
As an Oracle DBA transitioning from the OLTP world to the warehousing arena, I found this book enormously helpful. In a mere 200 pages, Mr. Scalzo has elaborated on an extensive range of data warehousing topics, including: star-schemas, dimension hierarchies, SQL-tuning, partitioning and parallel loading to name a few. His style is informative and direct; his examples are meaningful and clear!
This is a must-have book for all DBA's serious about designing and managing large-scale, lightning-fast data warehousing systems.
6 of 7 people found the following review helpful
A Recipe for Success
21 Aug 2004
Format:Paperback
Allow me to bestow some well-deserved praise upon Bert Scalzo's terrific "Oracle DBA Guide to Data Warehousing and Star Schemas". A true gem - I won't go on another Oracle project without it.
What Bert provides here is nothing short of a clear and crisp recipe for success for implementing Oracle-based data warehouses. It fills in a much-needed area of dimensional data warehousing best practices, by describing precisely how to coax the best achieveable Oracle performance from dimensional data models.
I can't tell you how many projects I've been on where I've had to compromise physical data models in order to address perceived "shortcomings" in Oracle's ability to efficiently service dimensional queries. Using Bert's book on my most recent project, we followed his "recipe", and were able to consistently achieve the ideal query optimization plans and aggregate navigation behaviors - simply - without any of the usual hassles that I have (unfairly) come to associate with large scale Oracle data warehousing.
To data warehousing newbies I humbly suggest: pick up any one of Ralph Kimball's terrific texts on data warehouse design, and then if you are rendering it in Oracle, buy this book and follow its advice. The resultant system will be simple, powerful, and fast.
Bravo Bert - a great contribution to the field.
Jim Stagnitto
Llumino, Inc (www.llumino.com)
What Bert provides here is nothing short of a clear and crisp recipe for success for implementing Oracle-based data warehouses. It fills in a much-needed area of dimensional data warehousing best practices, by describing precisely how to coax the best achieveable Oracle performance from dimensional data models.
I can't tell you how many projects I've been on where I've had to compromise physical data models in order to address perceived "shortcomings" in Oracle's ability to efficiently service dimensional queries. Using Bert's book on my most recent project, we followed his "recipe", and were able to consistently achieve the ideal query optimization plans and aggregate navigation behaviors - simply - without any of the usual hassles that I have (unfairly) come to associate with large scale Oracle data warehousing.
To data warehousing newbies I humbly suggest: pick up any one of Ralph Kimball's terrific texts on data warehouse design, and then if you are rendering it in Oracle, buy this book and follow its advice. The resultant system will be simple, powerful, and fast.
Bravo Bert - a great contribution to the field.
Jim Stagnitto
Llumino, Inc (www.llumino.com)
Were these reviews helpful?
Let us know
Listmania!
Look for similar items by category
- Books > Computing & Internet > Databases > Data Storage & Management > Data Warehousing
- Books > Computing & Internet > Databases > Data Storage & Management > Database Management Systems
- Books > Computing & Internet > Databases > Database Design & Theory
- Books > Computing & Internet > Databases > Oracle > DBA
- Books > Computing & Internet > Hardware
Look for similar items by subject
Feedback
- Would you like to update product info or give feedback on images?
- I am the Author, and I want to comment on my book.
- I am the Publisher, and I want to comment on this book.
