Re: [Monetdb-developers] monetdb/SQL development plan
Hi Michael, Thank you for your interest in MonetDB. Since I'm not involved with the core MonetDB development, I forward this email to the monetdb-developers list. I'm sure the guys over there will be able to help you. All the best, Marcin Michael Yang wrote:
Hi Marcin,
I saw that you're one of Peter's PhD students. I just got introduced to MonetDB as a possible column-store solution for some time series I work with. I'm in financial mathematics here at Princeton in the Operations Research department.
I am a heavy user of MS SQL Server and I use aggregate ranking functions a lot - row_number(), rank(), etc. Could you give me a rough estimate as to when MonetDB might add support for these functions - LEAD(), LAG(), and X() over (partition by ... order by ...). I see that it's in the development plan, but will it take 1 year? 1 month? many years?
Also, in the meantime is there a way you know to emulate these aggregate functions using local variables in monetdb?
thanks, Michael Yang
Princeton University Operations Research and Financial Engineering
On Mon, Feb 11, 2008 at 11:57:16PM +0100, Marcin Zukowski wrote:
Hi Michael,
Thank you for your interest in MonetDB. Since I'm not involved with the core MonetDB development, I forward this email to the monetdb-developers list. I'm sure the guys over there will be able to help you.
All the best, Marcin
Michael Adding the rank, row_number and possibly dense rank is high on the list. These will include the partition by and order functionality. It will however not be in the up coming release (any day now). The LEAD(), LAG() and X() may follow (no idea how much work these are). Niels
Michael Yang wrote:
Hi Marcin,
I saw that you're one of Peter's PhD students. I just got introduced to MonetDB as a possible column-store solution for some time series I work with. I'm in financial mathematics here at Princeton in the Operations Research department.
I am a heavy user of MS SQL Server and I use aggregate ranking functions a lot - row_number(), rank(), etc. Could you give me a rough estimate as to when MonetDB might add support for these functions - LEAD(), LAG(), and X() over (partition by ... order by ...). I see that it's in the development plan, but will it take 1 year? 1 month? many years?
Also, in the meantime is there a way you know to emulate these aggregate functions using local variables in monetdb?
thanks, Michael Yang
Princeton University Operations Research and Financial Engineering
------------------------------------------------------------------------- This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ _______________________________________________ Monetdb-developers mailing list Monetdb-developers@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-developers
-- Niels Nes, Centre for Mathematics and Computer Science (CWI) Kruislaan 413, 1098 SJ Amsterdam, The Netherlands room C0.02, phone ++31 20 592-4098, fax ++31 20 592-4312 url: http://www.cwi.nl/~niels e-mail: Niels.Nes@cwi.nl
participants (2)
-
Marcin Zukowski -
Niels Nes