News for hackers. Stuff that matters.

A comment on Pgsql: Support Grouping Sets, Cube, and Rollup. Parent comment

Re:Pgsql: Support Grouping Sets, Cube, and Rollup by notarget on Saturday May 16, 2015 @12:42PM (#9556716)
SSAS 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).

[ Parent | on HN ]
Re:Pgsql: Support Grouping Sets, Cube, and Rollup by ryanmarsh on Saturday May 16, 2015 @12:58PM (#9556796)
What makes MOLAP a trap? I'm only generally acquainted with cube analysis.
[ Parent | on HN ]
Re:Pgsql: Support Grouping Sets, Cube, and Rollup by felixgallo on Saturday May 16, 2015 @12:49PM (#9556743)
Apart from the complexity of cube updating, why do you say that?
[ Parent | on HN ]