News for hackers. Stuff that matters.
Re:MonetDB – Column-store database by blahi on Tuesday June 14, 2016 @03:01AM (#11900282)
Thanks for the answers. Really appreciated! I am analyst and I deal with databases, but in a very specific way. The way I tried to explain to myself the difference is that OLAP is used if you have a lot of fine-grained hierarchies accessed by a big number of people. In this scenario it would make sense to make all those aggregations ahead of time because a columnar store would have to calculate them each time somebody slices and that would be waay to expensive, even if you have state of the art caching.
Re:MonetDB – Column-store database by greggyb on Tuesday June 14, 2016 @10:02AM (#11902059)
That is a useful distinction to make, but as in all programming tasks, profiling will get you further than intuition when tuning for performance.