DB2 UDB ESE and Postgress

IGhipp wrote:
> Hello gurus,
>
> In our env, developers are pushing hard to replace DB2 multicluster
> partitioning database with Postgress db , they are claiming is the only
> RDBMS beside DB2 UDB EEE which has the the multidimensional MDSC index
> ........The cost of DB2 license been one of the reason..
> I don't know to much about Postgress and not to exiting about this
> option, I need some input from other DBA's in using Postgress vs DB2 UDB
> ESE...

I did some searching at postgresql.org, but couldn't find anything that
looks like Multidimensional Clustering (MDC) in DB2.

What feature (and release of pgsql) are they talking about?

Hello Ian,

here is what I know so far :
There is a GIS-based extension to postgres, called PostGIS, which
implements spatial operations on a sphere.

MySQL has GIS extensions, but does not yet have the ability to do point
and polygon searches on a sphere (only on a plane).


This what they think is close to DB2UDB MDC index
Isabella

Ian wrote:
> IGhipp wrote:
>> Hello gurus,
>>
>> In our env, developers are pushing hard to replace DB2 multicluster
>> partitioning database with Postgress db , they are claiming is the
>> only RDBMS beside DB2 UDB EEE which has the the multidimensional MDSC
>> index ........The cost of DB2 license been one of the reason..
>> I don't know to much about Postgress and not to exiting about this
>> option, I need some input from other DBA's in using Postgress vs DB2
>> UDB ESE...
>
> I did some searching at postgresql.org, but couldn't find anything that
> looks like Multidimensional Clustering (MDC) in DB2.
>
> What feature (and release of pgsql) are they talking about?
>
>

IGhipp wrote:
> Hello Ian,
>
> here is what I know so far :
> There is a GIS-based extension to postgres, called PostGIS, which
> implements spatial operations on a sphere.
>
> MySQL has GIS extensions, but does not yet have the ability to do point
> and polygon searches on a sphere (only on a plane).

This would be covered by the DB2 Spatial Extender, not MDC.

> This what they think is close to DB2UDB MDC index

MDC effectively allows you to define multiple clustering indexes on a
single table, and guarantees that data remains clustered (unlike a
normal clustering index).


Ian