build a SDB cache for Spatial Database based on postgis and postgresql

From: "zhang Jackie" <jackieict(at)gmail(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: build a SDB cache for Spatial Database based on postgis and postgresql
Date: 2006-11-22 04:32:25
Message-ID: 13432ab00611212032t5e6f62c3v46a6167d855f3a4e@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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.

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message David Fuhry 2006-11-22 05:25:44 Re: build a SDB cache for Spatial Database based on postgis
Previous Message Tom Lane 2006-11-22 03:51:24 Re: bad plan with custom data types