Archive - Minimal Modeling

October 2024

July 2024

Path dependence in relational design

Path dependence may be an important concern in relational table design.

Jul 2 •

Alexey Makhotkin

June 2024

April 2024

Modeling legal guardianship

Some notes on either/or/or in logical modeling.

Apr 3 •

Alexey Makhotkin

March 2024

"Documenting your database using Minimal Modeling" [video]

Mar 24 •

Alexey Makhotkin

February 2024

Designing database for Google Calendar, drafts

In the past couple of months I’ve been working on a longer text called “Database Design for Google Calendar”.

Feb 18 •

Alexey Makhotkin

January 2024

Minimal Modeling: processes and deliverables

A diagram of Minimal Modeling: textual descriptions → logical model → physical database schema → logical model → narratives and diagrams.

Jan 9 •

Alexey Makhotkin

December 2023

Sentinel-free schemas: a thought experiment

We systematically design a database schema that does not use NULLs and sentinel values. We look at the consequences of this design decisions and provide…

Dec 20, 2023 •

Alexey Makhotkin

#nojs-banner { position: fixed; bottom: 0; left: 0; padding: 16px 16px 16px 32px; width: 100%; box-sizing: border-box; background: red; color: white; font-family: -apple-system, "Segoe UI", Roboto, Helvetica, Arial, sans-serif, "Apple Color Emoji", "Segoe UI Emoji", "Segoe UI Symbol"; font-size: 13px; line-height: 13px; } #nojs-banner a { color: inherit; text-decoration: underline; } This site requires JavaScript to run correctly. Please turn on JavaScript or unblock scripts