Upload

Loading icon Loading...

This video is unavailable.

The Thinking Persons Guide to Data Warehouse Design

Sign in to YouTube

Sign in with your Google Account (YouTube, Google+, Gmail, Orkut, Picasa, or Chrome) to like tcation's video.

Sign in to YouTube

Sign in with your Google Account (YouTube, Google+, Gmail, Orkut, Picasa, or Chrome) to dislike tcation's video.

Sign in to YouTube

Sign in with your Google Account (YouTube, Google+, Gmail, Orkut, Picasa, or Chrome) to add tcation's video to your playlist.

Uploaded on Apr 16, 2010

Robin Schumacher (Calpont) presents "The Thinking Person's Guide to Data Warehouse Design" at the 2010 MySQL User Conference and expo.

Slides: http://www.slideshare.net/calpont/the...

From the official description at: http://en.oreilly.com/mysql2010/publi...

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

Loading icon Loading...

Loading icon Loading...

Loading icon Loading...

The interactive transcript could not be loaded.

Loading icon Loading...

Loading icon Loading...

Ratings have been disabled for this video.
Rating is available when the video has been rented.
This feature is not available right now. Please try again later.

Loading icon Loading...

Suggestions

Loading...
Working...
to add this to Watch Later

Add to