Oracle Data Warehouse Design

Currency: 10g & 11g Audience: DW architects and DBAs. Prerequisites: Completion of our course Data Warehouse Terms, Concepts & Architecture or equivalent knowledge. Summary: After presenting entity relationship (ER) and dimensional modelling (DM) as competing alternatives, the presentation will focus on the use of DM techniques when developing and implementing a very large data warehouse. Using real-world business scenarios, SALES, for example, the instructor will coach the participants from logical through physical design of a data warehouse involving at least five dimensions and one-or-more star schemas.
Thus hands-on exercises include:

• Design and creation of dimensions
• Design and creation of star schemas
• Design and creation of hierarchies
• Design and creation of indexes
• Design and creation of integrity constraints
• Extract, Transform and Load (ETL) options
• Parallelism
• Design and create materialized views (summary tables)

Throughout the foregoing, best practices and performance issues are discussed. Objectives: Upon completion of this course, the participant should be able to monitor and tune large data warehouses in a BI (Business Intelligence) or DS (Decision Support) environment.