blocks|key|3235967|text|当然是PostGis。这就是为什么。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3235968|3235969|Postgres在性能上远远优于MySQL。服务器容错能力更强，拥有开箱即用的负载平衡、缓存和optimization.|ordered-list-item|3235970|PostGIS工具，正在成为地理信息系统应用程序的标准。|3235971|它是免费的。|3235972|3235973|entityMap^0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|N|8|@]|9|@]|A|$]]|$1|C|3|D|5|E|7|O|8|@]|9|@]|A|$]]|$1|F|3|G|5|E|7|P|8|@]|9|@]|A|$]]|$1|H|3|I|5|E|7|Q|8|@]|9|@]|A|$]]|$1|J|3|-4|5|6|7|R|8|@]|9|@]|A|$]]|$1|K|3|-4|5|6|7|S|8|@]|9|@]|A|$]]]|L|$]]

PostGis definitely. Here's why. 

<ol>
<li>Postgres is far superior to MySQL in performance. Server is more fault tolerant, has out of the box tools for load-balancing, caching and optimization.</li>
<li>PostGIS is becoming a standard in GIS apps.</li>
<li>It's free.</li>
</ol>

blocks|key|3236099|text|如果您对彻底的比较感兴趣，我推荐波士顿GIS的"Cross+Compare+SQL+Server+2008+Spatial,+PostgreSQL/PostGIS+1.3-1.4,+MySQL+5-6"和/或"Compare+SQL+Server+2008+R2,+Oracle+11G+R2,+PostgreSQL/PostGIS+1.5+Spatial+Features"。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|3236100|考虑到你的观点：|3236101|3236102|I'm熟悉数据库管理系统:+too|unordered-list-item|style|BOLD|3236103|It在上建立PostGIS数据库很容易，使用PgAdmin3管理很简单。在查询方面做得很好：+PostGIS绝对是三者中最强大的只有Oracle+Spatial具有可比性，但如果考虑到其costs|3236104|Low成本，就会被取消资格:用于sure|3236105|Not的PostGIS的+%2B1与微软的.NET框架对抗：您至少应该能够通过PostGIS+(see+Postgres+wiki)|3236106|Compatible与R连接：应该不是三个|3236107|中的任何一个的问题|3236108|entityMap|0|LINK|mutability|MUTABLE|url|http://www.bostongis.com/PrinterFriendly.aspx?content_name=sqlserver2008_postgis_mysql_compare|1|http://www.bostongis.com/PrinterFriendly.aspx?content_name=sqlserver2008r2_oracle11gr2_postgis15_compare|2|http://wiki.postgresql.org/wiki/Using_Microsoft_.NET_with_the_PostgreSQL_Database_Server_via_ODBC^0|N|26|0|2W|2C|1|0|0|0|0|H|0|0|10|0|0|K|0|0|S|1A|H|2|0|0|F|0|0^^$0|@$1|2|3|4|5|6|7|17|8|@]|9|@$A|18|B|19|1|1A]|$A|1B|B|1C|1|1D]]|C|$]]|$1|D|3|E|5|6|7|1E|8|@]|9|@]|C|$]]|$1|F|3|-4|5|6|7|1F|8|@]|9|@]|C|$]]|$1|G|3|H|5|I|7|1G|8|@$A|1H|B|1I|J|K]]|9|@]|C|$]]|$1|L|3|M|5|I|7|1J|8|@$A|1K|B|1L|J|K]]|9|@]|C|$]]|$1|N|3|O|5|I|7|1M|8|@$A|1N|B|1O|J|K]]|9|@]|C|$]]|$1|P|3|Q|5|I|7|1P|8|@$A|1Q|B|1R|J|K]]|9|@$A|1S|B|1T|1|1U]]|C|$]]|$1|R|3|S|5|I|7|1V|8|@$A|1W|B|1X|J|K]]|9|@]|C|$]]|$1|T|3|U|5|6|7|1Y|8|@]|9|@]|C|$]]|$1|V|3|-4|5|6|7|1Z|8|@]|9|@]|C|$]]]|W|$X|$5|Y|Z|10|C|$11|12]]|13|$5|Y|Z|10|C|$11|14]]|15|$5|Y|Z|10|C|$11|16]]]]

If you are interested in a thorough comparison, I recommend <a href="http://www.bostongis.com/PrinterFriendly.aspx?content_name=sqlserver2008_postgis_mysql_compare" rel="noreferrer">"Cross Compare SQL Server 2008 Spatial, PostgreSQL/PostGIS 1.3-1.4, MySQL 5-6"</a> and/or <a href="http://www.bostongis.com/PrinterFriendly.aspx?content_name=sqlserver2008r2_oracle11gr2_postgis15_compare" rel="noreferrer">"Compare SQL Server 2008 R2, Oracle 11G R2, PostgreSQL/PostGIS 1.5 Spatial Features"</a> by Boston GIS.

Considering your points:

<ul>
<li>I'm familiar with the DBMS: setting up a PostGIS database on Windows is easy, using PgAdmin3 management is straight-forward too</li>
<li>It does well with GIS queries: PostGIS is definitely strongest of the three, only Oracle Spatial would be comparable but is disqualified if you consider its costs</li>
<li>Low cost: +1 for PostGIS for sure</li>
<li>Not antagonistic with Microsoft .NET Framework: You should at least be able to connect via ODBC (<a href="http://wiki.postgresql.org/wiki/Using_Microsoft_.NET_with_the_PostgreSQL_Database_Server_via_ODBC" rel="noreferrer">see Postgres wiki</a>)</li>
<li>Compatible with R: shouldn't be a problem with any of the three</li>
</ul>

blocks|key|296728|text|这只是MySQL最终在适当的地理信息系统逻辑中添加的一个注释。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|296729|http://dev.mysql.com/doc/refman/5.6/en/functions-for-testing-spatial-relations-between-geometric-objects.html|offset|length|296730|但是在这个阶段我不能评论成本或性能|296731|entityMap|0|LINK|mutability|MUTABLE|url^0|0|0|31|0|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|P|8|@]|9|@$D|Q|E|R|1|S]]|A|$]]|$1|F|3|G|5|6|7|T|8|@]|9|@]|A|$]]|$1|H|3|-4|5|6|7|U|8|@]|9|@]|A|$]]]|I|$J|$5|K|L|M|A|$N|C]]]]

Just an note that MySQL has finally added in proper GIS logic.

<a href="http://dev.mysql.com/doc/refman/5.6/en/functions-for-testing-spatial-relations-between-geometric-objects.html" rel="nofollow">http://dev.mysql.com/doc/refman/5.6/en/functions-for-testing-spatial-relations-between-geometric-objects.html</a>

But I can't comment on cost or performance at this stage

blocks|key|299339|text|PostGIS是最好的，因为它正在成为当今地理信息系统应用程序中的标准，而且PostGIS是免费的。它在性能上远远优于MySQL|type|unstyled|depth|inlineStyleRanges|entityRanges|data|299340|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

PostGIS is best because it is becoming a standard in GIS applications these days and PostGIS is free. It is far superior to MySQL in performance

EDIT: I have been using Postgres with PostGIS for a few months now, and I am satisfied.

I need to analyze a few million geocoded records, each of which will have latitude and longitude. These records include data of at least three different types, and I will be trying to see if each set influences the other.

What database is best for the underlying data store for all this data? Here's my desires:

<ul>
<li>I'm familiar with the DBMS. I'm weakest with PostgreSQL, but I am willing to learn if everything else checks out.</li>
<li>It does well with GIS queries. Google searches suggest that PostgreSQL + PostGIS may be the strongest? At least a lot of products seem to use it. MySql's Spatial Extensions seem comparatively minimal?</li>
<li>Low cost. Despite the 10GB DB limit in SQL Server Express 2008 R2, I'm not sure I want to live with this and other limitations of the free version.</li>
<li>Not antagonistic with Microsoft .NET Framework. Thanks to Connector/Net 6.3.4, MySql works well C# and .NET Framework 4 programs. It fully supports .NET 4's Entity Framework. I cannot find any noncommercial PostgreSQL equivalent, although I'm not opposed to paying $180 for Devart's dotConnect for PostgreSQL Professional Edition.</li>
<li>Compatible with R. It appears all 3 of these can talk with R using ODBC, so may not be an issue.</li>
</ul>

I've already done some development using MySql, but I can change if necessary.

GIS: PostGIS/PostgreSQL vs. MySql vs. SQL Server?

数据库管理系统

数据库管理

数据存储

SQL Server

PostgreSQL

数据库

服务器

MySQL

编辑:我已经在PostGIS上使用Postgres几个月了，我很满意。我需要分析几百万个地理编码记录，每个记录都有纬度和经度。这些记录包括至少三种不同类型的数据，我将尝试查看每组数据是否会相互影响。哪个数据库最适合所有这些数据的底层数据存储？这是我的愿望：I'm熟悉数据库管理系统。out.It我对的了解最弱，但我愿意学...

问GIS: PostGIS/PostgreSQL vs. MySql vs. SQL Server？
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问GIS: PostGIS/PostgreSQL vs. MySql vs. SQL Server？EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问GIS: PostGIS/PostgreSQL vs. MySql vs. SQL Server？
EN