Minimal Modeling
Subscribe
Sign in
Home
Notes
Archive
About
Latest
Top
Discussions
Documenting your data: WordPress case study, pt. 1
240 tables and no documentation: making sense of your database
Oct 1
•
Alexey Makhotkin
3
August 2025
Virtual 6NF
Decomposing any database into minimal elements
Aug 8
•
Alexey Makhotkin
2
1
1
June 2025
Multi-join queries design: investigation
From the ground up: studying multi-join queries.
Jun 9
•
Alexey Makhotkin
6
1
May 2025
Systematic design of multi-join GROUP BY queries
I wrote a long-ish (5000+ words) tutorial on systematic design of complex analytical SQL queries.
May 25
•
Alexey Makhotkin
2
April 2025
Database Design Book released!
137-page PDF, €32. See table of contents and sample chapters.
Apr 21
•
Alexey Makhotkin
2
February 2025
Relational modeling challenge
"Make invalid states unrepresentable" and the relational model
Feb 2
•
Alexey Makhotkin
7
13
1
December 2024
Podcast guest appearance
Looking for some podcast collaboration opportunities
Dec 23, 2024
•
Alexey Makhotkin
2
Historically, 4NF explanations are needlessly confusing
4NF presented in a straightforward way, with some investigation of history of teaching 4NF.
Dec 5, 2024
•
Alexey Makhotkin
6
20
October 2024
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, 2024
•
Alexey Makhotkin
Minimal Modeling and GenAI
Minimal model could be used as a source of high quality textual content to feed into your LLM.
Oct 2, 2024
•
Alexey Makhotkin
3
July 2024
Path dependence in relational design
Path dependence may be an important concern in relational table design.
Jul 2, 2024
•
Alexey Makhotkin
2
7
June 2024
Speaking at the Data Vault User Group 2024 Conference
Hello all,
Jun 28, 2024
•
Alexey Makhotkin
This site requires JavaScript to run correctly. Please
turn on JavaScript
or unblock scripts
