4 ms·
Unrelated to the subject of the article, but this I find questionable: > Once, if you had lots of data, you had to store it in fully normalised form, because s
by rytis 6y ago
Unrelated to the subject of the article, but this I find questionable:
> Once, if you had lots of data, you had to store it in fully normalised form, because storage was expensive.
First time I heard that NF's were considered to save space...
- AndrewDucker 6y agoIf you only store a customer's address once, rather than having a separate copy everywhere you store the customer, then that saves a lot of space (as well as ensuring that different instances don't contradict each other).
- rendall 6y agoYes, that is surprising to hear the first time, but it's true. Space saving is one of the primary advantages of relational databases, the other being tracking complex data relationships Nowadays, it's not storage that is expensive, but CPU cycles, and RDBMS are processor expensive relative to NOSQLs I advise clients to avoid RDBMS without a very specific need for complex data relationships
- marcosdumay 6y agoAFAIK, old hierarchical databases had a very similar space usage as relational ones. I do think people adopt the modern theory because of its flexibility.