DB2 UDB ESE and Postgress

[IGhipp]

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...

thank you,
Isabella

[Ian]

Post by IGhipp
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]

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

Post by Ian

Post by IGhipp
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?

[Ian]

Post by IGhipp
Hello Ian,
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.

Post by IGhipp
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