Book Description
The latest technical methods for building and managing a high-performance Oracle(r) data warehouse.Oracle8TM Data Warehousing is the ideal A-to-Z guide to building and managing a high-performance data warehouse for veteran Oracle users and newcomers alike. Database developers will be briefed on the latest technical methods for designing and building an Oracle7TM or Oracle8 data warehouse, while administrators find out how to manage an Oracle data warehouse for maximum efficiency. This valuable guide is the only book that fully covers the data warehouse features of both Oracle7 and Oracle8.Packed with practical and proven techniques from Oracle8 insiders, the book begins with a concise yet thorough overview of data warehousing principles and practices. It then cuts to the chase with detailed, step-by-step advice and guidance on how to: Use and get the most from all of Oracle8 databases' new data warehousing features Select the right hardware architecture to support a data warehouse Design and build a data warehouse for optimum performance Load data into a data warehouse Aggregate data for improved processing performance Distribute and analyze data using advanced OLAP techniques Administer and maintain your data warehouse Monitor and fine-tune data warehouse performance.GARY DODGE and TIM GORMAN are technical managers within Oracle Consulting Services who design and build large Oracle data warehouses. They are also experienced trainers, teaching classes for Oracle Education.
The publisher, John Wiley & Sons
For those database developers and administrators unfamiliar with Oracle, this book explains how to design, build, and manage an Oracle data warehouse. It covers the basics of data warehousing, then moves into technical instructions on how to select the appropriate hardware architecture, design the warehouse for optimum performance, build the database, and run it.
From the Back Cover
The latest technical methods for building and managing a high-performance Oracle(r) data warehouse.Oracle8TM Data Warehousing is the ideal A-to-Z guide to building and managing a high-performance data warehouse for veteran Oracle users and newcomers alike. Database developers will be briefed on the latest technical methods for designing and building an Oracle7TM or Oracle8 data warehouse, while administrators find out how to manage an Oracle data warehouse for maximum efficiency. This valuable guide is the only book that fully covers the data warehouse features of both Oracle7 and Oracle8.Packed with practical and proven techniques from Oracle8 insiders, the book begins with a concise yet thorough overview of data warehousing principles and practices. It then cuts to the chase with detailed, step-by-step advice and guidance on how to: Use and get the most from all of Oracle8 databases' new data warehousing features Select the right hardware architecture to support a data warehouse Design and build a data warehouse for optimum performance Load data into a data warehouse Aggregate data for improved processing performance Distribute and analyze data using advanced OLAP techniques Administer and maintain your data warehouse Monitor and fine-tune data warehouse performance.
About the Author
GARY DODGE and TIM GORMAN are technical managers within Oracle Consulting Services who design and build large Oracle data warehouses. They are also experienced trainers, teaching classes for Oracle Education.
Oracle8 Data Warehousing ANNOTATION
This practical hands-on guide leads you through planning, construction and administration of a data warehouse based on the Oracle 7 or 8 RDBMS products. Familiarity with Oracle 7/8 and PL/SQL is assumed; this publication is designed for data warehouse or data mart development teams and managers. The authors discuss warehousing concepts, hardware architectures and software architectures. They guide you through the design and build processes, including local schema and schema object analysis. They also show how to create a database and populate your warehouse.
FROM THE PUBLISHER
Oracle8 Data Warehousing is the ideal A-to-Z guide to building and managing a high-performance data warehouse for veteran Oracle users and newcomers alike. Database developers will be briefed on the latest technical methods for designing and building an Oracle7 or Oracle8 data warehouse; while administrators find out how to manage an Oracle data warehouse for maximum efficiency. Packed with practical and proven techniques from Oracle insiders, the book begins with a concise yet thorough overview of data warehousing principles and practices. It then cuts to the chase with detailed, step-by-step advice and guidance on how to use and get the most from all of Oracle8 databases' new data warehousing features; select the right hardware architecture to support a data warehouse; design and build a data warehouse for optimum performance; load data into a data warehouse; aggregate data for improved processing performance; distribute and analyze data using advanced OLAP techniques; administer and maintain your data warehouse; and monitor and fine-tune data warehouse performance.