Log in to track your reading progress.
Overview
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.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.
Book Details
Published
April 8, 1998
Publisher
John Wiley & Sons
Pages
672
Format
Paperback
ISBN
9780471199526