Complex normalized schemas can make database systems slow and inefficient. This presentation explores a storage layer that eliminates most joins in such systems by pre-joining the data. Data in this storage layer can be accessed using an object API without the overhead of an object-relational mapping layer. It can also be accessed using standard SQL for efficient complex multi-table reporting.
In this presentation, we will cover how to easily deploy MySQL and
Drizzle databases on Amazon and the Rackspace cloud using chef. In
particular, Drizzle is a database designed specifically for the cloud
and we will discuss how its modular architecture benefits deployment.
This talk shows you how to gather the correct data for performance forecasting and capacity planning. You will learn how to apply mathematical models to the data, and get meaningful answers that are likely to resemble reality.
We present some simple rules to understand effective indexing techniques without requiring an understanding of the underlying data structures that store the data.