Minimal Modeling
Subscribe
Sign in
Home
Notes
Archive
About
Latest
Top
Discussions
Date's demon
I’d like to introduce an idea of “Date’s demon” (named in honor of Chris Date). Postulating the existence of this imaginary being, we can describe some…
Oct 26
•
Alexey Makhotkin
Share this post
Minimal Modeling
Date's demon
Copy link
Facebook
Email
Notes
More
Minimal Modeling and GenAI
Minimal model could be used as a source of high quality textual content to feed into your LLM.
Oct 2
•
Alexey Makhotkin
2
Share this post
Minimal Modeling
Minimal Modeling and GenAI
Copy link
Facebook
Email
Notes
More
July 2024
Path dependence in relational design
Path dependence may be an important concern in relational table design.
Jul 2
•
Alexey Makhotkin
2
Share this post
Minimal Modeling
Path dependence in relational design
Copy link
Facebook
Email
Notes
More
7
June 2024
Speaking at the Data Vault User Group 2024 Conference
Hello all,
Jun 28
•
Alexey Makhotkin
Share this post
Minimal Modeling
Speaking at the Data Vault User Group 2024 Conference
Copy link
Facebook
Email
Notes
More
Two draft chapters for the book
Hello all,
Jun 24
•
Alexey Makhotkin
1
Share this post
Minimal Modeling
Two draft chapters for the book
Copy link
Facebook
Email
Notes
More
April 2024
Modeling legal guardianship
Some notes on either/or/or in logical modeling.
Apr 3
•
Alexey Makhotkin
4
Share this post
Minimal Modeling
Modeling legal guardianship
Copy link
Facebook
Email
Notes
More
March 2024
"Documenting your database using Minimal Modeling" [video]
Hello all,
Mar 24
•
Alexey Makhotkin
2
Share this post
Minimal Modeling
"Documenting your database using Minimal Modeling" [video]
Copy link
Facebook
Email
Notes
More
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
1
Share this post
Minimal Modeling
Designing database for Google Calendar, drafts
Copy link
Facebook
Email
Notes
More
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
1
Share this post
Minimal Modeling
Minimal Modeling: processes and deliverables
Copy link
Facebook
Email
Notes
More
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
6
Share this post
Minimal Modeling
Sentinel-free schemas: a thought experiment
Copy link
Facebook
Email
Notes
More
Designing database for Google Calendar, pt. I
Here is the first post in new “Designing database for Google Calendar” series. We show how the method explained in the book works in practice, for a…
Dec 15, 2023
•
Alexey Makhotkin
1
Share this post
Minimal Modeling
Designing database for Google Calendar, pt. I
Copy link
Facebook
Email
Notes
More
November 2023
Many explanations of JOIN are wrong, and people get confused
Most common explanations of JOIN are incomplete and build the wrong mental model. As the result, people get confused. In this post we discuss the…
Nov 25, 2023
•
Alexey Makhotkin
14
Share this post
Minimal Modeling
Many explanations of JOIN are wrong, and people get confused
Copy link
Facebook
Email
Notes
More
Share
Copy link
Facebook
Email
Notes
More
This site requires JavaScript to run correctly. Please
turn on JavaScript
or unblock scripts