Minimal Modeling
Subscribe
Sign in
Home
Notes
Archive
About
Latest
Top
Discussions
Path dependence in relational design
Path dependence may be an important concern in relational table design.
Jul 2
•
Alexey Makhotkin
2
Share this post
Path dependence in relational design
minimalmodeling.substack.com
Copy link
Facebook
Email
Note
Other
7
June 2024
Speaking at the Data Vault User Group 2024 Conference
Hello all,
Jun 28
•
Alexey Makhotkin
Share this post
Speaking at the Data Vault User Group 2024 Conference
minimalmodeling.substack.com
Copy link
Facebook
Email
Note
Other
Two draft chapters for the book
Hello all, I’ve been busy with some material for the book, here are two draft chapters: 1/ “Many yes/no attributes: table design study” (~2600 words…
Jun 24
•
Alexey Makhotkin
1
Share this post
Two draft chapters for the book
minimalmodeling.substack.com
Copy link
Facebook
Email
Note
Other
April 2024
Modeling legal guardianship
Some notes on either/or/or in logical modeling.
Apr 3
•
Alexey Makhotkin
3
Share this post
Modeling legal guardianship
minimalmodeling.substack.com
Copy link
Facebook
Email
Note
Other
March 2024
"Documenting your database using Minimal Modeling" [video]
Hello all,
Mar 24
•
Alexey Makhotkin
1
Share this post
"Documenting your database using Minimal Modeling" [video]
minimalmodeling.substack.com
Copy link
Facebook
Email
Note
Other
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”. It illustrates the approach from the…
Feb 18
•
Alexey Makhotkin
1
Share this post
Designing database for Google Calendar, drafts
minimalmodeling.substack.com
Copy link
Facebook
Email
Note
Other
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
Share this post
Minimal Modeling: processes and deliverables
minimalmodeling.substack.com
Copy link
Facebook
Email
Note
Other
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
5
Share this post
Sentinel-free schemas: a thought experiment
minimalmodeling.substack.com
Copy link
Facebook
Email
Note
Other
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
Designing database for Google Calendar, pt. I
minimalmodeling.substack.com
Copy link
Facebook
Email
Note
Other
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
12
Share this post
Many explanations of JOIN are wrong, and people get confused
minimalmodeling.substack.com
Copy link
Facebook
Email
Note
Other
Book update
I'm working on a book: “Database Design with Minimal Modeling”.
Nov 21, 2023
•
Alexey Makhotkin
1
Share this post
Book update
minimalmodeling.substack.com
Copy link
Facebook
Email
Note
Other
An algebraic curiosity
There is one non-1NF relation in every real-world database, no matter how well designed.
Nov 18, 2023
•
Alexey Makhotkin
Share this post
An algebraic curiosity
minimalmodeling.substack.com
Copy link
Facebook
Email
Note
Other
2
Share
Copy link
Facebook
Email
Note
Other
This site requires JavaScript to run correctly. Please
turn on JavaScript
or unblock scripts