Ruby on Rails migrations were a revelation when Rails came out, as it provided a way to manage your database schema, but also included many wonderful defaults that made all Rails developers pretty good at database schema design! But these defaults are just the beginning.
If you’re a data architect, you’ve heard it all from ‘data management is the sexiest job of the 21st century’ to ‘data management is dead’. The truth almost certainly lies somewhere in the middle of the extremes, but how can you make sense of the true future of the data …
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.
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 …
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 …
This presentation covers the C* schema design concepts of the Cassandra database. This presentation goes in depth on the following topics schema design, best practices, capacity planning and provides real world examples.
