Minimal Modeling

Home
Archive
About
NewTopDiscussion
A bit of advice on extracting the logical schema from database tables
Alexey Makhotkin
1
1
Is data duplication always bad? How to deal with the additional invariants in the relational table design?
Alexey Makhotkin
1
1
Before we can continue the discussion of physical representation of either/or data, we need to discuss the idea of erasure. In computer science you most…
Alexey Makhotkin
If you need to delete millions of rows and you're not careful, you can cause a database outage. Here is what you have to think about to solve this. 
Alexey Makhotkin
9
Structural data types: Introduction to design space of physical representation.
Alexey Makhotkin
2
Let's discuss the SQL LEFT JOIN operator and the idea of left join.
Alexey Makhotkin
Today I’d like to talk about the spectrum between narrow and wide tables, and how both kinds of tables are connected via left join.
Alexey Makhotkin
From a certain angle database modeling looks just like the game of poker.
Alexey Makhotkin
Today I’d like to talk about the principle of concatenability in software architecture. The general idea behind it could be easily recognized…
Alexey Makhotkin
1
Let's continue exploring the design space of storing either/or data. In this part we discuss three arrangements: main table, side-table and…
Alexey Makhotkin
1
2
UNION ALL as a natural counterpart to LEFT JOIN.
Alexey Makhotkin
2
In the previous post we discussed simple approaches and pointed out why they could cause problems and even outages. Now let's discuss more complete…
Alexey Makhotkin
1
2
© 2022 Alexey Makhotkin
Privacy ∙ Terms ∙ Collection notice
Publish on Substack Get the app
Substack is the home for great writing