MySQL，SQL Server和Oracle [英] MySQL vs. SQL Server vs. Oracle

问题描述

我一直只使用MySQL而没有其他数据库系统.

I have always only used MySQL and no other database system.

今天在公司会议上提出了一个问题，但我不知所措，我不知道: 对于开发人员而言，MS或Oracle提供了MySQL所缺乏的，令人震惊的功能，并且MS和Oracle可以为其系统付费吗?

A question came up at a company meeting today and I was embarrassed I did not know: To a developer, what earth-shaking functionality do MS or Oracle offer that MySQL lacks and which allows MS and Oracle to charge for their systems?

推荐答案

我认为其他评论员也可以正确使用与商业解决方案捆绑在一起的所有其他非核心RDBMS功能.

I think other commentators are quite right to highligh all of the extra non-core RDBMS abilities that are bundled with the commercial solutions.

这里是Oracle版本和功能的矩阵，值得您浏览以了解额外"功能，特别是在开发和支持您自己的版本时(如果是这样，则是这样)甚至可能)在类似MySQL的产品上: http://www. oracle.com/us/products/database/product-editions-066501.html

Here is a matrix of Oracle editions and features that would be worth browsing just for an understanding of the "extra" features, particularly in the context of what it would cost to develop and support your own version of them (if that is even possible) on a product like MySQL: http://www.oracle.com/us/products/database/product-editions-066501.html

例如，如果您有一个要求说:用户应能够在提交更改后的一周内恢复他们删除/更新的任何以前版本的数据"，那么这意味着一定的开发开销在没有像oracle的Flashback Query这样的内置功能的系统上，我认为这会更高.

For example, if you had a requirement that said: "Users shall be able to recover any previous versions of data that they have deleted/updated up to one week after the changes has been committed" then that implies a certain development overhead that I think would be much higher on a system that did not have a built-in feature like oracle's Flashback Query.

这篇关于MySQL，SQL Server和Oracle的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！