TDWI World Conference

Prerequisite: This course assumes database and systems knowledge.

Stephen Brobst

A remarkable number of new features and functions have been introduced in the high-end database products specifically aimed at decision support workloads. This course will look at the latest developments in optimizer technology, index structures, OLAP database engines, and data mining techniques for delivering high performance in large-scale decision support environments. These innovations in high-end database functionality lead to new approaches for designing decision support system (DSS) database structures and sizing machines for supporting DSS workloads.

Stephen will share his benchmarking experiences and impart design techniques for designing DW environments for scalability and high performance. The content of this course is based on experience with some of the largest commercial and government databases in the world. The course also will discuss advanced topics such as issues in object-relational performance management and the architectural frameworks for deployment of data marts and operational data stores.

You Will Learn

• Advanced optimization techniques and how they impact DSS database performance
• Database design techniques such as star schemas, selective denormalization, partitioning, etc., in terms of trade-offs related to performance, usability, and flexibility
• New indexing strategies and how they impact workload balance and capacity planning
• OLAP design and the trade-offs between MOLAP, ROLAP, and HOLAP
• The role of data marts and operational data stores

Geared To

• Technical architects; database administrators; data warehouse administrators