build a SDB cache for Spatial Database based on postgis and postgresql
I am interesting in PostGis and postgreSQL and want to do something on
it. My idea is to build a Spatial Database Cache to accelerate GIS
applications .So I want to ask you some question and hope to get your
answer. 1. As we all know, PostGis is a Spatial extention for
PostGreSQL. And there are also some other products such as ArcSDE, Oracle
Spatial .Have you ever do some performance comparison between them.If you
have ever done such work,Could you give me some information on it. If not,
is it because that you team did not care about performance and just
concerned with correctness of the program. And if you can give me some
materials on performance comparison on such Spatial Database extention
including ArcSDE, Oracle Spatial ,MySQL ,etc.
2. Since Google Earth is lauched ,Many GIS systems are used by more and
more people,so the important features of Software becomes more and more
important,such as sacalibity, robust, stability,etc. Can you give me some
information and papers on the bottleneck of these applications.Especially,
are computing and I/O requirements very important and become bottlenecks,Of
course, If you know some related solutions , you can mail me.
I have searche lots of papers and get an overview of it. But I felt I did
not figure out the truth. So I want to get some more accurate information
on this field.
Zhang,
You'll have better luck posting this question on the postgis-users
mailing list; this list is for development of the core PostgreSQL
database. The subscription page for postgis-users is here:
http://postgis.refractions.net/mailman/listinfo/postgis-users
Briefly though, at least Oracle, PostgreSQL, IBM DB2, and Informix
can be configured to store, manipulate, and index geometry types in the
database. These are the key features of a spatial database. Support
for these capabilities in MySQL seems to be under development. ArcSDE
is middleware which is sometimes used to store spatial data in a
non-spatial database.
-Dave Fuhry
zhang Jackie wrote:
Show quoted text
I am interesting in PostGis and postgreSQL and want to do something
on it. My idea is to build a Spatial Database Cache to accelerate GIS
applications .So I want to ask you some question and hope to get your
answer.
1. As we all know, PostGis is a Spatial extention for PostGreSQL.
And there are also some other products such as ArcSDE, Oracle Spatial
.Have you ever do some performance comparison between them.If you have
ever done such work,Could you give me some information on it. If not, is
it because that you team did not care about performance and just
concerned with correctness of the program. And if you can give me some
materials on performance comparison on such Spatial Database extention
including ArcSDE, Oracle Spatial ,MySQL ,etc.
2. Since Google Earth is lauched ,Many GIS systems are used by more
and more people,so the important features of Software becomes more
and more important,such as sacalibity, robust, stability,etc. Can you
give me some information and papers on the bottleneck of these
applications.Especially, are computing and I/O requirements very
important and become bottlenecks,Of course, If you know some
related solutions , you can mail me.
I have searche lots of papers and get an overview of it. But I felt I
did not figure out the truth. So I want to get some more accurate
information on this field.
Jackie,
I am interesting in PostGis and postgreSQL and want to do something on
it. My idea is to build a Spatial Database Cache to accelerate GIS
applications .So I want to ask you some question and hope to get your
answer.
You should probably try the PostGIS mailing list:
http://postgis.refractions.net/mailman/listinfo/postgis-users
... I don't think that anyone here will be able to answer you.
--
Josh Berkus
PostgreSQL @ Sun
San Francisco