Re: PostgreSQL - 'SKYLINE OF' clause added!

ranbeer makin wrote:
> We at International Institute of Information Technology (IIIT) Hyderabad,
> India, have extended the Postgres database
> system with the skyline operation. For this work, we were guided by our
> Prof. Kamalakar Karlapalem
> (http://www.iiit.ac.in/~kamal/).
> 
> We have extended SQL 'SELECT' clause by an optional 'SKYLINE OF' clause in
> version 8.0.3. The changes are done in parser, transformation,
> planner/optimizer (a bit) and executor stages. For its execution, two novel
> algorithms  - BNL (Block Nested Loop) and SFS
> (Sort Filter Skyline) - are also implemented.
From what I read on your web pages it sounds interesting and may be a 
worthwhile addition to PostgreSQL. I'll have a look at it when it is 
available.

> Can this piece of work contribute to PostgreSQL? If yes, then we'll send 
> out
> a detailed report of this project including changes
> made, issues involved/need to be solved, limitations, future work, and the
> source code etc.

I am not one making the choice of accepting your work but from what I 
know you would want to make your patch available so others can review 
the stability/quality of your work and decide whether there is enough 
demand for the feature to have it included in the main distribution 
either as part of the main code or within the contrib section.

One option you have is to start a project at pgfoundry.org so others can 
access and try your contribution. This will allow your work to be 
available and to be tested by those interested in this feature. If your 
work proves to be worthwhile and in demand it can progress from there 
into the main distribution.

You most probably want to look at porting your changes to the latest 
postgresql release as well.

> Thanks very much.
> 
> Regards,
> Nikita
> Ranbeer
> 
> -- 
> http://students.iiit.ac.in/~nikita/
> http://students.iiit.ac.in/~ranbeer/
> 


-- 

Shane Ambler
pgSQL@Sheeky.Biz

Get Sheeky @ http://Sheeky.Biz