Enterprise OSDB for OSGIS

chenrg at lreis.ac.cn chenrg at lreis.ac.cn
Sun Dec 10 18:34:38 PST 2006


Dear all,
There are many comparisons about OSDBs, such as:
http://www.geocities.com/mailsoftware42/db/
http://www.fabalabs.org/research/papers/FabalabsResearchPaper-OSDBMS-Eval.pdf
http://www.virtuas.com/files/osl-osrdb-01.pdf
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, https://china.osgeo.org)
State Key Laboratory of Resources & Environmental Information System (LREIS, http://www.lreis.ac.cn)
Email: chenrg at lreis.ac.cn, chenrg at igsnrr.ac.cn
Tel:   (86-10)64888963, 13911825587
Fax:   (86-10)64889630
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/discuss/attachments/20061211/65892314/attachment-0001.html>


More information about the Discuss mailing list