A bit of advice on extracting the logical schema from database tables
1
1
Is data duplication always bad? How to deal with the additional invariants in the relational table design?
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…
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. 
9
Structural data types: Introduction to design space of physical representation.
2
Let's discuss the SQL LEFT JOIN operator and the idea of left join.
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.
From a certain angle database modeling looks just like the game of poker.
Today I’d like to talk about the principle of concatenability in software architecture. The general idea behind it could be easily recognized…
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…
1
2
UNION ALL as a natural counterpart to LEFT JOIN.
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…
1
2