Обсуждение: 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.
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
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.