From the ground up: studying multi-join queries.| Minimal Modeling
I wrote a long-ish (5000+ words) tutorial on systematic design of complex analytical SQL queries.| Minimal Modeling
137-page PDF, €32. See table of contents and sample chapters.| Minimal Modeling
"Make invalid states unrepresentable" and the relational model| Minimal Modeling
4NF presented in a straightforward way, with some investigation of history of teaching 4NF.| Minimal Modeling
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 of the long-term dynamics of database design, implementation and maintenance process. In a sense, Date’s demon is also your adversary in| Minimal Modeling
Path dependence may be an important concern in relational table design.| Minimal Modeling
Hello all,| Minimal Modeling
Hello all,| Minimal Modeling
Hello all,| Minimal Modeling
In the past couple of months I’ve been working on a longer text called “Database Design for Google Calendar”.| Minimal Modeling
A diagram of Minimal Modeling: textual descriptions → logical model → physical database schema → logical model → narratives and diagrams.| Minimal Modeling
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 some guidance on designing the schemas that way.| Minimal Modeling
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 non-trivial real-world application.| Minimal Modeling
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 generalized case of LEFT JOIN.| Minimal Modeling
I'm working on a book: “Database Design with Minimal Modeling”.| minimalmodeling.substack.com
Minimal model could be used as a source of high quality textual content to feed into your LLM.| minimalmodeling.substack.com
Decomposing any database into minimal elements| minimalmodeling.substack.com
Rewatching Chris Date's talk from 1983 today. Introduction and Pt. I, “The relational model”| minimalmodeling.substack.com
We discuss the minimal model of “User buys an Item as a gift to another User” scenario; point out false links; try to make another step towards understanding 4NF and 5NF.| minimalmodeling.substack.com
Minimal model is immediately useful for people who want to get some data out of it: data analysts, data scientists, software developers. Minimal model can tell you how to query the existing data.| minimalmodeling.substack.com
How Minimal Modeling helps with visualizing databases in terms of links between the data, and how it helps describe underlying business processes.| minimalmodeling.substack.com
