[OSGeo-Discuss] Enterprise OSDB for OSGIS

[Stephen Woodbridge]

Greetings,

Why would you not want to build on all the work that has already been 
done with postGIS? I confess I have not read all the comparisons that 
you posted, but I will when I have a chance.

postGIS provides good spatial support for postgreSQL
postGIS is integrated with mapserver, and a long list of other OSGEO 
related projects.
There is currently a design discussion on postGIS to to add raster support.
postGIS has an active community of developers and users.
I'm sure the postGIS team would value additional support from staff to 
grow and enhance postGIS.

While these other databases may very well be excellent packages, this 
seems to be counter to the trend of trying to get more people to focus 
on less projects to make those projects move faster and be better. I 
would think that there should be pretty compelling reason to go in 
another direction rather than push an existing solution forward.

Do you have a list of features that you feel are needed?
How does that list compare to postGIS/postgreSQL?
Is there any reason that the features not available could not be added 
to postGIS/postgreSQL to achieve your requirements?

I'm sure you have done much more research into this than you have 
presented in your post below and I think it would help me and others to 
understand and to be able to discuss what the requirements and features are.

Best regards,
   -Stephen Woodbridge

chenrg at lreis.ac.cn wrote:
> 
> Dear all,
> There are many comparisons about OSDBs, such as:
> http://www.geocities.com/mailsoftware42/db/ 
> <http://www.geocities.com/mailsoftware42/db/>
> http://www.fabalabs.org/research/papers/FabalabsResearchPaper-OSDBMS-Eval.pdf 
> <http://www.fabalabs.org/research/papers/FabalabsResearchPaper-OSDBMS-Eval.pdf>
> http://www.virtuas.com/files/osl-osrdb-01.pdf 
> <http://www.virtuas.com/files/osl-osrdb-01.pdf>
> http://www.osdbmigration.org:8080/osdb/osdb-features 
> <http://www.osdbmigration.org:8080/osdb/osdb-features>
> I'm not sure which will be the most promising enterprise OSDB for OSGIS.
> (1) PostGIS is an excellent one, but its performance depends on PostgreSQL;
> (2) MySQL Spatial Extension (MyGIS) faces the same problem.
> Another solution is to build a Spatial Data Engine (like ArcSDE) for 
> FireBird or MaxDB or Ingres. 
> Checked the source codes of several OSDB:
> 
>  
> 
> 	
> 
> MaxDB V7.6
> 
> 	
> 
> PostgreSQL V8.2
> 
> 	
> 
> FireBird V2.0
> 
> 	
> 
> MySQL V5.0
> 
> 	
> 
> Ingres2006
> 
> Files
> 
> 	
> 
> 1,203
> 
> 	
> 
> 1,081
> 
> 	
> 
> 913
> 
> 	
> 
> 2,353
> 
> 	
> 
> 5,696
> 
> Functions
> 
> 	
> 
> 4,692
> 
> 	
> 
> 9,506
> 
> 	
> 
> 7,075
> 
> 	
> 
> 30,994
> 
> 	
> 
> 22,470
> 
> Lines Code
> 
> 	
> 
> 287,792
> 
> 	
> 
> 374,124
> 
> 	
> 
> 584,431
> 
> 	
> 
> 890,415
> 
> 	
> 
> 1,440,326
> 
> Lines Comment
> 
> 	
> 
> 103,035
> 
> 	
> 
> 155,720
> 
> 	
> 
> 254,937
> 
> 	
> 
> 286,385
> 
> 	
> 
> 1,373,997
> 
> Ratio Comment/Code
> 
> 	
> 
> 0.36
> 
> 	
> 
> 0.42
> 
> 	
> 
> 0.44
> 
> 	
> 
> 0.32
> 
> 	
> 
> 0.95
> 
> 
> It seems that Ingres is more powerful and has more enterprise functions. 
> Further more, it has internal support for spatial extension. 
> Is it a reasonable solution to choose it to build enterprise OSGIS? Any 
> advice and suggestions?
> 
> 
> Regards.
>  
> Chen
> --------------------------------------------------------------------------------------------------------------------------
> Rongguo Chen, Prof., Ph.D
> Representative of China OSGeo Chapter ( 
> http://wiki.osgeo.org/index.php/China 
> <http://wiki.osgeo.org/index.php/China> , https://china.osgeo.org 
> <https://china.osgeo.org> )
> State Key Laboratory of Resources & Environmental Information System 
> (LREIS, http://www.lreis.ac.cn <http://www.lreis.ac.cn> )
> Email: chenrg at lreis.ac.cn <mailto:chenrg at lreis.ac.cn> , 
> chenrg at igsnrr.ac.cn <mailto:chenrg at igsnrr.ac.cn>
> Tel:   (86-10)64888963, 13911825587
> Fax:   (86-10)64889630