Recent Posts
Many yes/no attributes: table design study
Author: Alexey Makhotkin squadette@gmail.com.
I wanted to demonstrate the relationship between the logical model and a physical model. We’re going to design a commonly seen use case: many yes/no attributes of a single anchor (in our case, Restaurant). Then we’ll discuss how the physical tables would be designed. We’ll see that sometimes physical design strategy changes as the system becomes more mature. At the same time, logical design elements never change if the business requirement is still relevant.
read more
Database Design for Google Calendar: a tutorial
Author: Alexey Makhotkin squadette@gmail.com.
Introduction In this database design tutorial (~9000 words) I’m going to show how to design the database tables for a real-world project of substantial complexity.
We’ll design a clone of Google Calendar. We will model as much as possible of the functionality that is directly related to the calendar.
This series illustrates an approach explained in the book called “Database Design using Minimal Modeling”, scheduled to be released in Summer 2024.
read more