From: | David Fuhry <dfuhry(at)cs(dot)kent(dot)edu> |
---|---|
To: | zhang Jackie <jackieict(at)gmail(dot)com> |
Cc: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: build a SDB cache for Spatial Database based on postgis |
Date: | 2006-11-22 05:25:44 |
Message-ID: | 4563DF58.2010208@cs.kent.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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:
> 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.
From | Date | Subject | |
---|---|---|---|
Next Message | zhang Jackie | 2006-11-22 05:45:59 | how to profile PostGreSQL |
Previous Message | zhang Jackie | 2006-11-22 04:32:25 | build a SDB cache for Spatial Database based on postgis and postgresql |