The Thinking Persons Guide to Data Warehouse Design
Posted on 28 July 2010 by Abidoon
Robin Schumacher (Calpont) presents “The Thinking Person’s Guide to Data Warehouse Design” at the 2010 MySQL User Conference and expo. Slides: www.slideshare.net From the official description at: en.oreilly.com 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-offs -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