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(at)Sheeky(dot)Biz

Get Sheeky @ http://Sheeky.Biz