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.possible, though, to generate a aquot;quick and dirtyaquot; set of test data for your data warehouse using PL/SQL. ... The first step in the PL/SQL routine will be to create CURSOR FOR LOOPS that reference each dimension table and column. ... Summary This chapter introduced several features of the SQLa#39;Plus environment that can be exploited by the administrator of an Oracle data warehouse to make life simpier.
|Title||:||Oracle8 Data Warehousing|
|Author||:||Gary Dodge, Tim Gorman|
|Publisher||:||Wiley - 1998-03-30|