database 为什么要使用 Oracle 数据库？

Why would you use Oracle database?

提问by BuddyJoe

I'm curious for technical reasons why you choose Oracle database versus the latest flavors of:
1) Microsoft SQL Server
2) MySQL
3) PostgreSQL

我很好奇你为什么选择 Oracle 数据库而不是最新版本的技术原因：
1) Microsoft SQL Server
2) MySQL
3) PostgreSQL

What features or functionality justify the extra cost. I'm interested in technical arguments, not a religious war. A friend asked me this and I've always used one of the 3 I listed. I didn't know enough about Oracle Databases to offer an opinion.

哪些特性或功能可以证明额外的成本是合理的。我对技术争论感兴趣，而不是宗教War。一个朋友问我这个问题，我一直使用我列出的三个中的一个。我对 Oracle 数据库的了解不够，无法发表意见。

Thanks.

谢谢。

回答by user1016765

Noone seems to talk about the cost of developers time working with Oracle. Most developers who know any other db hate Oracle, those that don't assume that all DB code and/or ORM tools are difficult to use.

似乎没有人谈论开发人员与 Oracle 合作的时间成本。大多数了解任何其他数据库的开发人员都讨厌 Oracle，那些不认为所有数据库代码和/或 ORM 工具都难以使用的开发人员。

If I started a business that I believed was going to scale to Amazon proportions I might consider NoSQL solutions, otherwise I'd choose PostgreSQL, SQL Server (or indeed even Sybase now) over Oracle every time. I say this having worked (as a dev) with Oracle for 2 years - its terrible to work with!

如果我创办了一家我认为会扩展到亚马逊规模的业务，我可能会考虑使用 NoSQL 解决方案，否则我每次都会选择 PostgreSQL、SQL Server（甚至现在甚至是 Sybase）而不是 Oracle。我说这已经（作为开发人员）与 Oracle 合作了 2 年 - 与它合作太糟糕了！

回答by Robert Gould

Only Oracle and Microsoft's SQLServer are closed source, and when something goes wrong and you have a problem the answer is just a phone call away (and cash if course). Anyways MySQL and PostGre have several enterprise consulting services but in the end these consultants aren't really resposible for the product, because the product belongs to everyone. Which is great because you can go in and fix the code if you are good with C and relatively lowlevel programming, but if you aren't finding the solution might become a wild goose chase.

只有 Oracle 和 Microsoft 的 SQLServer 是封闭源代码，当出现问题并且您遇到问题时，只需一个电话即可获得答案（当然还有现金）。无论如何 MySQL 和 PostGre 有几个企业咨询服务，但最终这些顾问并不真正为产品负责，因为产品属于每个人。这很好，因为如果您擅长 C 和相对低级的编程，您可以进入并修复代码，但如果您没有找到解决方案，则可能会成为一场疯狂的追逐。

Now since not everyone is skilled enough, and those enterprises with money prefer the security (in the business sense) of the closed source databases, is the reason why these solutions haven't gone out of business, besides the fact that their implementations are solid and worth the money if you have it.

现在由于不是每个人都足够熟练，而那些有钱的企业更喜欢闭源数据库的安全性（在商业意义上），这就是这些解决方案没有倒闭的原因，除了它们的实现是可靠的如果你有的话，物有所值。

Ok now finally the most important difference is between SQLServer and Oracle and that difference is the OS, most people using Windows will stick with, you guessed it, SQLServer, but if you run on flavors of Unix Oracle is your closed source solution. Anyways I use Oracle on Solaris, but if our target were Windows I would probably use SQLServer because both products are rock solid, but I trust Microsoft has some special tricks under the hood to get the best performance on windows.

好吧，现在最重要的区别是 SQLServer 和 Oracle 之间的区别，区别在于操作系统，大多数使用 Windows 的人都会坚持使用，你猜对了，SQLServer，但如果你在 Unix 上运行 Oracle 是你的闭源解决方案。无论如何，我在 Solaris 上使用 Oracle，但如果我们的目标是 Windows，我可能会使用 SQLServer，因为这两种产品都非常可靠，但我相信 Microsoft 有一些特殊的技巧可以在 Windows 上获得最佳性能。

回答by Anonymous

Just to name a few:

仅举几个：

• Oracle Real Application Cluster - provides advanced clustering features
• Oracle Data Guard- in short provides physical and logical stand-by features.
• Oracle Exadata - implements the database aware storage (that can do predicate filtering, column projection filtering, join processing, hastens tablespace creation). The solution comes with HP servers, full 24/7 warranty, and other nice things. It's quite nice for applications with highly intensive data loading (for example thanks to the independent tablespace creation).
• Oracle Virtualization

• Oracle Real Application Cluster - 提供高级集群特性
• Oracle Data Guard- 简而言之，提供物理和逻辑备用特性。
• Oracle Exadata - 实现数据库感知存储（可以执行谓词过滤、列投影过滤、连接处理、加速表空间创建）。该解决方案随附 HP 服务器、24/7 全面保修以及其他好处。对于具有高度密集数据加载的应用程序来说非常好（例如由于独立的表空间创建）。
• 甲骨文虚拟化

And of course the magic of the brand ;)

当然还有品牌的魔力;)

And when it comes to choosing the RDBMS? Usually the choice is pretty obvious - Oracle or the rest of the world. After that you can narrow the choice down by:

当谈到选择 RDBMS 时？通常选择是很明显的——甲骨文或世界其他地方。之后，您可以通过以下方式缩小选择范围：

• platform (windows-only or not)
• weight (sqlite, MySQL, PostgreSQL, ...)
• budget (initial license cost, maintenance + support cost)
• evolution perspectives, for example:
  • Oracle Express -> Oracle
  • SQL Server Express -> MSSQL
• business perspectives - "secure, well known product" or open-source product (bear in mind the quotation around the first phrase). Other post tends to look deeper into this aspect.

• 平台（仅限 Windows）
• 重量 (sqlite, MySQL, PostgreSQL, ...)
• 预算（初始许可成本、维护 + 支持成本）
• 进化观点，例如：
  • Oracle Express -> Oracle
  • SQL Server Express -> MSSQL
• 商业观点——“安全、知名的产品”或开源产品（记住第一句话周围的引语）。其他帖子倾向于更深入地研究这方面。

回答by iChaib

I think it's because Oraclewas the first RDMS that supported "sharding"

我认为是因为Oracle是第一个支持“分片”的RDMS

回答by TomHastjarjanto

The real question is, what kind of application is going to be used to make use of a RDMS. You certainly don't need oracle for your wordpress blog or twitter clone. But if you want to do some heavy business intelligence, then Oracle might have some features which can help doing that more efficiently than the others.

真正的问题是，将使用什么样的应用程序来使用 RDMS。您的 wordpress 博客或 twitter 克隆当然不需要 oracle。但是，如果您想做一些繁重的商业智能，那么 Oracle 可能有一些功能可以帮助您比其他功能更有效地完成这项工作。

Ms sql server is very good aswell, it has tons of features. If you are struck on linux and you need a database with features as offered by ms sql, then oracle would be a good pick.

Ms sql server 也非常好，它有很多功能。如果您对 linux 感兴趣并且需要一个具有 ms sql 提供的功能的数据库，那么 oracle 将是一个不错的选择。

回答by David Aldridge

The costs of SQL Server and Oracle are not that far apart, you know.

您知道，SQL Server 和 Oracle 的成本相差不远。

In fact for small systems the cost of Oracle vs Your Favourite Free Database is between zero (Oracle Express Edition) and not-very-big ($5,800 processor perpetual for Standard Edition One).

事实上，对于小型系统，Oracle 与您最喜欢的免费数据库的成本介于零（Oracle 快捷版）和不是很大（标准版一的处理器永久费用为 5,800 美元）之间。

Here's a link to the capabilities of the various editions in 11g: http://www.oracle.com/database/product_editions.html.

以下是 11g 中各种版本功能的链接：http: //www.oracle.com/database/product_editions.html。

List prices are available for all territories at http://store.oracle.com-- typically large companies do not pay retail, of course ;)

在http://store.oracle.com上提供适用于所有地区的标价——当然，大公司通常不支付零售费用；)