database DB2 和 Oracle 之间的差异
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/2863865/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
Differences between DB2 and Oracle
提问by Ondrej Slinták
We had a talk with colleagues about databases yesterday as we will have a DB2 education in few weeks. I'm wondering, what are the differences between DB2 and Oracle as two major enterprise solutions? Are there any limitations in comparison to each other? Are there any tasks more suitable for DB2 or Oracle?
昨天我们与同事讨论了数据库，因为我们将在几周内接受 DB2 教育。我想知道，作为两个主要的企业解决方案，DB2 和 Oracle 之间有什么区别？相互比较有什么限制吗？有没有更适合 DB2 或 Oracle 的任务？
(I found thisarticle, but I somehow doubt it covers everything)
（我找到了这篇文章，但我怀疑它是否涵盖了所有内容）
回答by paxdiablo
The major difference in my eyes is that DB2 can tell the difference between a NULL and an empty string :-)
在我看来，主要区别在于 DB2 可以区分 NULL 和空字符串 :-)
回答by Erwin Smout
IMMSMW, an extremely important difference between the two is the way they achieve transaction isolation. Oracle uses MVCC, DB2 uses traditional two-phase locking.
IMMSMW，两者之间一个极其重要的区别是它们实现事务隔离的方式。Oracle 使用 MVCC，DB2 使用传统的两阶段锁定。
But that might have changed in recent DB2 releases, of course.
但是，当然，这在最近的 DB2 版本中可能已经改变了。
回答by ciaran
With the release of db2 9.7 last year there are fewer differences that there every were DB2 has licensed Postgress plus and this is in DB2 9.7. This is being used essentially a set of Oracle compatibility features. One of those features is Concurrency control. The other main ones are SQL dialect, PL/SQL, PL/SQL packages Built-in packages, JDBC client with extensions, OCI client applications, SQL*Plus scripts. More details here http://www.ibm.com/developerworks/data/library/techarticle/dm-0907oracleappsondb2/
随着去年 db2 9.7 的发布，与 DB2 已获得 Postgress plus 许可的差异越来越小，而 DB2 9.7 就是如此。这主要是使用一组 Oracle 兼容性特性。其中一项功能是并发控制。其他主要的有 SQL 方言、PL/SQL、PL/SQL 包、内置包、带有扩展的 JDBC 客户端、OCI 客户端应用程序、SQL*Plus 脚本。此处有更多详细信息http://www.ibm.com/developerworks/data/library/techarticle/dm-0907oracleappsondb2/
I should disclose that I work for IBM now a migration specialist.
我应该透露，我现在为 IBM 工作，是一名迁移专家。
回答by Goibniu
Oracle table, schema and column names are still limited to 30 characters, which can get annoying.
Oracle 表、模式和列名仍然限制为 30 个字符，这可能会很烦人。
回答by Ingo
From which point of view?
从哪个角度看？
For developers that stick to some standard, the differences should not be notable. For admins, yes, that's another story.
对于坚持某些标准的开发人员来说，差异不应该很明显。对于管理员来说，是的，这是另一回事。
