4 ms·
I’m not a big fan of OLAP cubes / data warehouses but it should be noted that these aren’t always just about scale and speed. They also serve to provide a singl
by unklefolk 5y ago
I’m not a big fan of OLAP cubes / data warehouses but it should be noted that these aren’t always just about scale and speed. They also serve to provide a single view of the data when the data is held across multiple databases / systems. You’re orders may be in PostgreSQL, your inventory tracked in MySQL etc. So bringing all that data into a single database for analytics can be valuable.
- chipsa 5y agoThis isn't against data warehouses, but just the cubes. Bringing everything into a single database for analysis is still required. But you extract load then transform, instead of extract transform load.
- rossdavidh 5y agoWhile that's true, it feels to me that your comment made this point a lot more clearly than the article did.
- AtlasBarfed 5y agoWhich is why hadoop took off?