4 ms·
So does this mean I could use pg instead is SSAS for cube analysis?
by ryanmarsh 11y ago
So does this mean I could use pg instead is SSAS for cube analysis?
- greggyb 11y agoYou could before. The benefit of OLAP databases and other analytical engines is only partly due to the focus of the query languages. Storage format, and calculation engine requirements are vastly different between OLTP and OLAP. While the constructs in the linked article increase the expressive power of SQL, they are more icing than cake for an OLAP load.
- notarget 11y agoSSAS and other cube (MOLAP) tools create persistent cubes as materialized views. Databases that do ROLAP processing create "cubes on the fly" which persist for the duration of the query. If PG adopts a materialized view that supports controlled automatic maintenance, then you'd have something similar to what the MOLAP tools do. Note that MOLAP is a trap of sorts (no pun intended).
- felixgallo 11y agoApart from the complexity of cube updating, why do you say that?
- ryanmarsh 11y agoWhat makes MOLAP a trap? I'm only generally acquainted with cube analysis.