Universal Relation Data Modelling Considered Harmful

Universal Relation Data Modelling Considered Harmful

As part of a continued series of blog posts themed about “Relational databases and NoSQL”, Dr. Michael Stonebraker and I co-authored a new blog post just published on EnterpriseDB’s blog.

This post discusses the “Universal Relation” data model, which has become trendier recently under the name of “Single Table Design”, and is frequently used and recommended in DynamoDB. We discuss a sample DynamoDB application, and run a benchmark analyzing potential conflicts with DynamoDB transactions. All source code is open source and public. The source also contains a trivial exercise, not detailed in the blog post, on how to emulate Single Table Design with Postgres views. Not of real utility, but shows Postgres flexibility.

Previous post on this serie are: