The Thinking Person’s Guide to Data Warehouse Design

Poor database design is the number one cause of both database downtime and bad performance, and is especially an issue with large data warehouses. This session will teach you how to navigate down through the process of building an analytic database design that will hold up under pressure. Topics covered include:

Building the logical design: -Moving from transactional to analytic schemas -Stars, snowflakes, and more -Vertical and horizontal partitioning model trade-off’s -Quick note on using MySQL Workbench to design data warehouses

Transitioning to the physical design: -How to decide on the right storage engine(s) -When to/not to use row and column-oriented storage engines -How to decide on a partitioning strategy -Optimizing for fast data loads -The love-hate relationship with indexes -Hardware architectures: SMP, MPP, or both? -Use case benchmarks for the above designs

Monitoring and tuning the design: -Monitoring checklist (database, OS, and storage) -SQL diagnostic troubleshooting best practices -When to quit and start over