3 ms·
Personally, when it comes to denormalisation, my preference is that it be done in a semi-structured way such as dimensional modelling. And that's exactly what
by jacques_chester 16y ago
Personally, when it comes to denormalisation, my preference is that it be done in a semi-structured way such as dimensional modelling.
And that's exactly what I was talking about: a key purpose for DM is to make the database more accessible for fast bulk queries at the cost of duplicate data.
Whereas normalisation drives out duplication in order to maximise transactional performance and space efficiency.
In your case, you start with the OLTP/normalised model, then devolve to what is actually a kind of OLAP/denormalised model.
Write-oriented vs read-oriented.
Maybe the missing link for relational databases in a web world is actually some kind of real-time ETL?