Oracle 11g 的开源或免费替代品
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/5265213/
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
Open source or free alternative to Oracle 11g
提问by fredericoagent
I work in IT for a large multinational that spends millions of dollars on Oracle solutions.
我在一家大型跨国公司的 IT 部门工作，该公司在 Oracle 解决方案上花费了数百万美元。
That got me wondering whether there was is a viable alternative to Oracle for enterprises. Can anyone suggest a free or opensource alternative to something like Oracle 11g
这让我想知道是否有适用于企业的 Oracle 的可行替代方案。任何人都可以建议像 Oracle 11g 这样的免费或开源替代品
回答by Darius Kucinskas
Postgresql http://www.postgresql.org/
Postgresql http://www.postgresql.org/
回答by Gary Myers
There's a bunch of things to consider.
有很多事情要考虑。
Firstly, downgrade from Enterprise Edition to Standard Edition (which is a lot cheaper). If you are using features that require EE (such as encryption, compression) then you aren't going to get much joy from open source. I'm not saying it can't be done, but you'd definitely be looking at paid support, more specialized (and rarer) skillsets and expensive rework to existing applications.
首先，从企业版降级到标准版（便宜很多）。如果您正在使用需要 EE 的功能（例如加密、压缩），那么您将不会从开源中获得太多乐趣。我并不是说它不能完成，但您肯定会关注付费支持、更专业（和更少）的技能组合以及对现有应用程序的昂贵返工。
Secondly, server consolidation. Can you take databases sitting on three servers and put them all onto one server ? Maybe make use of virtualization and resource management ?
其次，服务器整合。您可以将位于三台服务器上的数据库放在一台服务器上吗？也许利用虚拟化和资源管理？
Thirdly, mix and match. You don't need Oracle to host a content management system. You can have a few simple MySQL databases in some places instead.
第三，混合搭配。您不需要 Oracle 来托管内容管理系统。您可以在某些地方使用一些简单的 MySQL 数据库。
Also, remember you have already paid for your current licenses. You are still paying for maintenance/support. You could take the risk and choose NOT to pay for those. That means no patches or upgrade path, but it is worth considering.
另外，请记住您已经为当前的许可证付费。您仍在支付维护/支持费用。您可以冒险并选择不支付这些费用。这意味着没有补丁或升级路径，但值得考虑。
回答by gsiems
Short answer: Postgresql.
简短的回答：Postgresql。
Long answer: It depends on the Oracle feature set that you are using.
长答案：这取决于您使用的 Oracle 功能集。
My guess is that you are talking lots of databases. Do all the databases have to use the same engine? For the databases that are using all the Oracle bells and whistles then leave them there. For the databases that are more vanilla then look at Postgresql.
我的猜测是你在谈论很多数据库。所有数据库都必须使用相同的引擎吗？对于使用所有 Oracle 花里胡哨的数据库，然后将它们留在那里。对于更普通的数据库，请查看 Postgresql。
If you are looking for a migration strategy then look at EnterpriseDB.com-- their flagship product is Postgresql with an Oracle compatibility layer. You can conceivably slide your Oracle database straight over with no to minimal changes. Once in EnterpriseDB then you can start re-writing the Oracle pieces to Postgresql. Works slick.
如果您正在寻找迁移策略，那么请查看 EnterpriseDB.com——他们的旗舰产品是具有 Oracle 兼容层的 Postgresql。可以想象，您可以直接滑动您的 Oracle 数据库，而无需更改或进行最少更改。一旦进入 EnterpriseDB，您就可以开始将 Oracle 部分重写为 Postgresql。做工圆滑。
回答by Neil Mulkern
You probably dont want to go from one extreme to the other, most expensive to free. What you should be looking at is something with the same sort of pedigree and big vendor support as Oracle that can be deployed alot cheaper. Take a look at IBM. There two very good alternatives, if its an "all rounder" you need then DB2 is a very credible alternative ( it even understands PLSQL) or if you are really looking at extreme OLTP then the legendary Informix database can often out perform Oracle on much lighter tin and near zero DBA time - Regarded by tekkies as the best, if not the most well publicised, database on the market ( the Informix replication options make RAC look like an also ran). If you are moving off Oracle, IBM will give you a " competitive swop out" price to sweeten the deal :-)
您可能不想从一个极端到另一个极端，从最昂贵的到免费。您应该关注的是具有与 Oracle 相同类型的血统和大型供应商支持的东西，并且可以更便宜地部署。看看IBM。有两个非常好的替代方案，如果它是您需要的“多面手”，那么 DB2 是一个非常可靠的替代方案（它甚至可以理解 PLSQL），或者如果您真的在考虑极端的 OLTP，那么传奇的 Informix 数据库通常可以在轻得多的情况下执行 Oracle tin 和接近零的 DBA 时间 - 被 tekkies 认为是市场上最好的，如果不是最广为人知的数据库（Informix 复制选项使 RAC 看起来像也跑了）。如果您要离开甲骨文，IBM 会给您一个“有竞争力的置换”价格以增加交易的乐趣:-)
回答by mic.sca
Have you ever thought there might be good reasons (features, quality, performances) behind the price of a product...free doesn't always mean better (Ok, nor does expensive).
你有没有想过产品价格背后可能有很好的理由（功能、质量、性能）......免费并不总是意味着更好（好吧，也不是昂贵）。
Large companies anyway often need large reliable dbs, widely used and heavily documented, always improved, etc... more than saving some money.
无论如何，大公司通常需要大型可靠的数据库，广泛使用和大量记录，总是改进等等......不仅仅是节省一些钱。
