data model

Database Design for Beginners

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.

The Data Architect Career

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 architect’s role in the rapidly-changing …

The Data Architect Career Read More »

Introduction to Cassandra Data Modeling

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.

Data Modeling with MongoDB

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 …

Data Modeling with MongoDB Read More »

Faking a Database Design

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 …

Faking a Database Design Read More »

Practical Considerations for Cassandra Data Modeling

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.