DB2 vs PostgreSQL vs SQL Server [英] DB2 vs PostgreSQL vs SQL Server
问题描述
我在一个使用DB2主要在Linux（Red Hat）上的大型组织中工作。我们有一些大型数据库，并调查了迁移到其他RDBMS解决方案，如Oracle和SQL Server。我在SQL服务器端做了很多工作。
我们发现，SQL服务器的性能要好得多，而且要比DB2更少调优，特别是当表大于1M条记录。 HADR也是困难和庞大的，至少要说。
我们发现DB2和SQL Server之间有很多差异，而且在这里列出的数量太多。我负责在一个平台之间进行大量的代码转换工程，不能说我在DB2中发现任何东西都优于SQL服务器，但是确实发现了很多我喜欢SQL服务器的东西。以下是我头上的一些：
- 在SQL Server中更好的选择数据类型，如MONEY和SMALL MONEY。 >
- SQL Server中混合字符编码。一些列可以是ANSI和其他的UNICODE（分别为char和nchar）。
- SQL Server中更好的工具，主要用于ETL的SSIS（与价格非常低廉的IBM Data Stage相比）。
- SQL服务器有更宽容的语法。例如，您不需要在任何地方使用分号。也许只是一个个人喜好，但我发现在T-SQL中编写代码更容易。
- SQL服务器中的许多高级功能似乎更好。例如，SQL Server允许您进行页面级压缩，其中DB2受限于行级压缩。
- 使用SQL Server IDE调整SQL Server查询变得更加容易>
还有更多，但老实说，我建议任何正在考虑一个人的人都应该同时使用这两个系统。现在看来，SQL服务器似乎是一个更好的整体解决方案，但是DB2可能有一天会取胜。
最后，在处理数据仓库时，SQL，SSIS和SSAS比InfoSphere，DataStage和DB2提供了更好的解决方案。我可以写一个白皮书，但我的建议是自己设置，花一个礼拜，或者使用每个解决方案。微软在这方面的解决方案比IBM更快更便宜。我不知道做出决定的任何其他依据。
平台不应该是一个问题，因为数据库通常在自己的机器上运行，但是总是那些没有微软！和没有linux！周围的商店。真的很可惜我建议使用SQL Server。
Has anyone used all three of these databases? What are your experiences with them? PostgreSQL looks pretty tempting for a project but I'm curious to learn more about it (We're a .NET Shop). I've also heard of quite a lot of people being satisfied with DB2.
I work in a very large organization that uses DB2 primarily on Linux (Red Hat). We have a number of large databases and have investigated moving to other RDBMS solutions, such as Oracle and SQL Server. I did a lot of work on the SQL server end of that.
We found that SQL server performs much better and requires less tuning than DB2, especially when tables frow larger than 1M records. HADR is also difficult and bulky, to say the least.
We found many differences between DB2 and SQL Server, and too many to list here. I was responsible for doing a lot of the engineering behind code conversion from one platform to another, and can't say I found anything in DB2 to be superior to SQL server, but did find many things I liked better about SQL server. Here are some off the top of my head:
- Better selection data types in SQL Server, such as MONEY and SMALL MONEY.
- Mixed character encoding in SQL Server. Some columns can be ANSI and others UNICODE (char and nchar, respectively). Setting this up in DB2 is neither straightforward nor easy.
- Better tools in SQL server, mainly SSIS for ETL (As opposed to the insanely priced IBM Data Stage).
- SQL server has more forgiving syntax. For example, you don't need semi-colons everywhere. Maybe just a personal preference but I found it much easier to code in T-SQL.
- Many advanced features seem to work better in SQL server. For example, SQL server lets you do page-level compression, where DB2 is limited to row-level compression.
- It was easier to tune SQL Server queries with the SQL Server IDE
There are more, but honestly I suggest that anyone who is considering one over the other should set both up and spend some time working with both systems. Right now it seems like SQL server is a better overall solution, but DB2 may one day take the crown.
Lastly, when dealing with data warehousing, SQL, SSIS, and SSAS made a much better solution than InfoSphere, DataStage, and DB2. I could write a whitepaper on it, but my suggestion here is to set it up on your own and spend a week or to playing with each solution. Microsoft's solution here was faster and cheaper than IBM's. I don't know of any other basis upon which to make a decision.
Platform shouldn't be an issue since databases generally run on their own machines, but there are always those "no microsoft!" and "no linux!" shops around. It's a shame, really. I'd recommend SQL server.
这篇关于DB2 vs PostgreSQL vs SQL Server的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
