[Monetdb-developers] monetdb/SQL development plan

Niels Nes Niels.Nes at cwi.nl
Tue Feb 12 20:35:39 CET 2008


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 at 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 at cwi.nl




More information about the developers-list mailing list