Fabian (MonetDB Project) wrote:
gustavo wrote:
[...]
Another thing that could boost MonetDb usage is SQL OLAP support like stddev, ranks, running sums/averages, windowing support, rollup and cube.
Most of what you mention require a different approach to the data I think. Like running sums or windowing support somehow require you to examine 'streams' of data, thus acting on data as soon as it comes in. I don't think SQL is yet up for this job, the best you can do is simply simulate it. I think CUBE was added to SQL-2003 and therefore might get included, but I don't think on the short term.
FYI, SQL/OLAP was pushed by IBM and Oracle in 1999 or so, see e.g.:
http://www.sigmod.org/sigmod/record/issues/0003/standards.pdf#page=3 http://www.oracle.com/technology/products/oracle8i/pdf/8ifunctions.pdf
It's now (yes, sometimes, committees can be really fast!) part of SQL/Foundation, see e.g.:
http://savage.net.au/SQL/sql-2003-2.bnf.html#rollup%20list http://savage.net.au/SQL/sql-2003-2.bnf.html#cube%20list http://savage.net.au/SQL/sql-2003-2.bnf.html#window%20function
Steffen