I know that MS-SQL2005Express is NOT opensource( despite it's a freeware), but last week I have installed this database with the spatial database extension MsSQLSpatial and I liked a lot too. Because this extension is OGC/SFS compliant, if you know how to user PostGIS, so you will feel comfortable to manage MsSqlSpatial too.
<br><br>The bad side is that it's still a very new project, so there's not much render-clients available. The only I know is SharpMap and MapServer - which can render MsSQLSpatial object using an OGR/ODBC connection.<br><br>
best regards,<br><br><br>Eduardo Patto Kanegae<br><a href="http://www.webmapit.com.br">http://www.webmapit.com.br</a>
<br><br><br><div><span class="gmail_quote">On 12/11/06, <b class="gmail_sendername"><a href="mailto:chenrg@lreis.ac.cn">chenrg@lreis.ac.cn</a></b> <<a href="mailto:chenrg@lreis.ac.cn">chenrg@lreis.ac.cn</a>> wrote:
</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">Dear all,<br>There are many comparisons about OSDBs, such as:<br><a href="http://www.geocities.com/mailsoftware42/db/">
http://www.geocities.com/mailsoftware42/db/</a><br><br><a href="http://www.fabalabs.org/research/papers/FabalabsResearchPaper-OSDBMS-Eval.pdf">http://www.fabalabs.org/research/papers/FabalabsResearchPaper-OSDBMS-Eval.pdf</a>
<br><br><br><a href="http://www.virtuas.com/files/osl-osrdb-01.pdf">http://www.virtuas.com/files/osl-osrdb-01.pdf</a><br><br><br><a href="http://www.osdbmigration.org:8080/osdb/osdb-features">http://www.osdbmigration.org:8080/osdb/osdb-features
</a><br><br>I'm not sure which will be the most promising enterprise OSDB for OSGIS.<br><br>(1) PostGIS is an excellent one, but its performance depends on PostgreSQL;<br><br>(2) MySQL Spatial Extension (MyGIS) faces the same problem.
<br><br>Another solution is to build a Spatial Data Engine (like ArcSDE) for FireBird or MaxDB or Ingres.<br><br>Checked the source codes of several OSDB:<br><br><br> MaxDB V7.6<br> PostgreSQL V8.2<br> FireBird
V2.0<br> MySQL V5.0<br> Ingres2006<br><br> Files<br> 1,203<br> 1,081<br> 913<br> 2,353<br> 5,696<br><br> Functions<br> 4,692<br> 9,506<br> 7,075<br> 30,994<br> 22,470
<br><br> Lines Code<br> 287,792<br> 374,124<br> 584,431<br> 890,415<br> 1,440,326<br><br> Lines Comment<br> 103,035<br> 155,720<br> 254,937<br> 286,385<br> 1,373,997<br><br>
Ratio Comment/Code<br> 0.36<br> 0.42<br> 0.44<br> 0.32<br> 0.95<br><br><br><br> It seems that Ingres is more powerful and has more enterprise functions. Further more, it has internal support for spatial extension.
<br><br>Is it a reasonable solution to choose it to build enterprise OSGIS? Any advice and suggestions?<br><br><br><br>Regards.<br><br>Chen<br>--------------------------------------------------------------------------------------------------------------------------
<br> Rongguo Chen, Prof., Ph.D<br> Representative of China OSGeo Chapter (<a href="http://wiki.osgeo.org/index.php/China">http://wiki.osgeo.org/index.php/China</a>, <a href="https://china.osgeo.org">https://china.osgeo.org
</a>)<br> State Key Laboratory of Resources & Environmental Information System (LREIS, <a href="http://www.lreis.ac.cn">http://www.lreis.ac.cn</a>)<br> Email: <a href="mailto:chenrg@lreis.ac.cn">chenrg@lreis.ac.cn</a>
, <a href="mailto:chenrg@igsnrr.ac.cn">chenrg@igsnrr.ac.cn</a><br> Tel: (86-10)64888963, 13911825587<br> Fax: (86-10)64889630</blockquote></div><br><br clear="all"><br>--