Re:Why you should never use MongoDB (2013)
by nurettin on Monday August 15, 2016 @11:49AM
(#12291206)
If you excuse the buzzword, data warehouses are built for this very reason. So you are right in the sense that cache invalidation and denormalization are problems in sql based large scale systems, but they are largely solved problems whereas in mongodb you would need to do this work manually.
[ Parent
| on HN ]
> [...] data warehouses are built for this very reason. [...] [cache invalidation and denormalization] are largely solved problems [...]
Uhm, no. Data warehouse is not a database with operational (i.e. current) data, it's a database with historical data. If it is out of sync with production for a day or a week, it's totally OK, depending on its design.
So no, cache invalidation is not a solved problem there.