[MonetDB-users] Re: Support for group by <ordinal> and SQL OLAP functions
(I'm sending this to the monetdb-users list, as it might help some other people too)
Hi,
Thanks for your interest in MonetDB/SQL.
gustavo wrote:
... What I´m missing mostly is support for group by a number of a column. In this way it would be possible to group by na expression without the use of a derived table (select from select).
I don't exactly understand what you want to do. Can you give a concrete (SQL) example that shows what you want to do? I think that would help getting me to understand.
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. However, a concrete list of wishes is always welcome!
Thanks for your input!
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
Thanks very much.
Gustavo Hispagnol Millennium Network -----Original Message----- From: Fabian (MonetDB Project) [mailto:monet@cwi.nl] Sent: Friday, August 12, 2005 8:42 AM To: gustavo; monetdb-users@lists.sourceforge.net Subject: Re: Support for group by <ordinal> and SQL OLAP functions
(I'm sending this to the monetdb-users list, as it might help some other people too)
Hi,
Thanks for your interest in MonetDB/SQL.
gustavo wrote:
... What I´m missing mostly is support for group by a number of a column. In this way it would be possible to group by na expression without the use of a derived table (select from select).
I don't exactly understand what you want to do. Can you give a concrete (SQL) example that shows what you want to do? I think that would help getting me to understand.
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. However, a concrete list of wishes is always welcome!
Thanks for your input!
-- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.338 / Virus Database: 267.10.8/71 - Release Date: 12/08/2005
participants (3)
-
Fabian (MonetDB Project) -
gustavo -
Steffen Goeldner