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.
"synopsis" may belong to another edition of this title.
Oracle DBA Guide to Data Warehousing and Star Schemas This book gives the reader best practices for implementing and managing a datawarehouse on the Oracle Platform. This book tells datawarehousing professionals what they need to totally change the way they manage databases and to use star schemas to run an efficient datawarehouse. Full descriptionFrom the Back Cover:
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:
"About this title" may belong to another edition of this title.
Book Description Prentice Hall. Book Condition: New. Brand New. Bookseller Inventory # 0130325848
Book Description Prentice Hall, 2003. Paperback. Book Condition: New. Bookseller Inventory # P110130325848
Book Description Prentice Hall, 2003. Paperback. Book Condition: New. 1. Bookseller Inventory # DADAX0130325848
Book Description Prentice Hall, 2003. Paperback. Book Condition: New. book. Bookseller Inventory # 0130325848
Book Description Prentice Hall. PAPERBACK. Book Condition: New. 0130325848 New Condition. Bookseller Inventory # NEW6.0043381
Book Description Prentice Hall, 2003. Book Condition: New. Brand new! Please provide a physical shipping address. Bookseller Inventory # 9780130325846
Book Description Book Condition: Brand New. Book Condition: Brand New. Bookseller Inventory # 97801303258461.0