This is a crash course in the Cassandra storage model. We will start with how data is laid out on disk to understand why it’s fast for real time workloads, and finish with an introduction to CQL, which we’ll use to query Cassandra.
Non-technical people in companies need data, but don’t have the programming skills to get it themselves. So, it becomes your part-time job to get them data. As your company grows, this problem only gets worse. We built a (soon to be released as open source) Ruby on Rails app that has completely transformed the way […]
This discussion examines the schema design insights and trade-offs using real world examples. We looks at three example applications: building an email inbox, selecting a shard key for a large scale web application, and using MongoDB to store user profiles. From these examples you should get an idea of the advantages and disadvantages of various […]
MySQL 5.6 was released in February 2013. It is the largest release of MySQL in history (measured by code size increase) and contains a number of very useful enhancements to replication, performance and security. What I want to talk about however is how it’s now much easier to run in production with features like online […]
Many expert programmers who write complex SQL without a second thought still struggle with database design. Unfortunately, many introductory topics cause eyes to glaze over when we read “transitive dependencies” and “Boyce-Codd normal form”. When you’re done with this talk, you’ll understand the basics of creating a database that won’t make a DBA yell at […]
Azure DocumentDB is a fully-managed NoSQL document database service. This video demonstrates how Azure DocumentDB can integrate with your modern applications to provide a highly-scalable, queryable, and schema-free JSON-based document database solution.