MySQL和ORACLE之间的区别

深藏阁楼爱情的钟 2022-12-07 13:16 299阅读 0赞

Here you will get to know about difference between mysql and oracle database.

在这里，您将了解mysql和oracle数据库之间的区别。

Both MySQL and Oracle are popular relational database management software developed by Oracle Corporation.

MySQL和Oracle都是Oracle公司开发的流行的关系数据库管理软件。

**MySQL:** Its name is combination of words “My” and “SQL”, where “My” is name of daughter of co-founder Michael Widenius. And SQL full form is **Structured Query Language.** It is most popular free and Open Source database management system Developed and maintained by Oracle Corporation.

**MySQL：**它的名称是单词“ My”和“ SQL”的组合，其中“ My”是联合创始人Michael Widenius的女儿的名字。 SQL的完整形式是**结构化查询语言。** 它是由Oracle Corporation开发和维护的最受欢迎的免费开放源数据库管理系统。

**ORACLE:** It commonly known as Oracle RDBMS, is a multi-model database management system produced and marketed by Oracle Corporation. Oracle database commonly used for running Data ware housing (DW), online transaction processing (OLTP) and mixing of these two (DW & OLTP)

**ORACLE：**它通常称为Oracle RDBMS，是由Oracle Corporation生产和销售的多模型数据库管理系统。 Oracle数据库通常用于运行数据仓库(DW)，在线事务处理(OLTP)以及两者的混合(DW和OLTP)

## MySQL和Oracle之间的区别 **(**Difference between MySQL and Oracle**)** ##

<table> 
 <tbody> 
  <tr> 
   <td><strong>MySQL</strong></td> 
   <td><strong>Oracle</strong></td> 
  </tr> 
  <tr> 
   <td>MySQL is free open source Database.</td> 
   <td>Oracle is a commercial database.</td> 
  </tr> 
  <tr> 
   <td>It is light, simple RDBMS, very well for web.</td> 
   <td>Oracle is very powerful than MySQL, allows to write any complex system like in Banking, ERP, Insurance, finance companies.</td> 
  </tr> 
  <tr> 
   <td>MySQL doesn’t support distributed databases.</td> 
   <td>Oracle supports distributed databases.</td> 
  </tr> 
  <tr> 
   <td>Mysqlhotcopy and mysqldump are backup utilities for MySQL.</td> 
   <td>Oracle has different type of backups like cloud backup, hot backup, export, import data dump. It offers most popular backup utility called Recovery Manager (RMAN)</td> 
  </tr> 
  <tr> 
   <td>Temporary tables will be displayed only to particular session. Those tables will be dropped automatically as soon as session ends.</td> 
   <td>But in oracle, tables should be dropped explicitly. Those are visible to all sessions.</td> 
  </tr> 
  <tr> 
   <td>MySQL doesn’t support any extra features.</td> 
   <td>Oracle supports several extensions and programs on its database server for instance, Active Data Guard, Audit vault, Partitioning, and Data Mining etc.</td> 
  </tr> 
  <tr> 
   <td>MySQL doesn’t have Tablespace, Role management, sanapshots and automatic storage management.</td> 
   <td>On other hand Oracle has all of these features.</td> 
  </tr> 
  <tr> 
   <td>MySQL written in C and C++</td> 
   <td>Oracle written in Assembly Language, C and C++</td> 
  </tr> 
  <tr> 
   <td>Some most popular companies which use MySQL database are: YouTube, PayPal, Google, Facebook, Twitter, GitHub, eBay, LinkedIn etc.</td> 
   <td>Some most popular companies which use Oracle databases are: CAIRN India, TVS Motor Company, Vilene, National foods Australia, ENEL etc.</td> 
  </tr> 
  <tr> 
   <td>Official website: <a href="https://www.mysql.com" rel="nofollow">www.mysql.com</a></td> 
   <td>Official website: <a href="https://www.oracle.com/database/" rel="nofollow">www.oracle.com/database</a></td> 
  </tr> 
 </tbody> 
</table>

<table> 
 <tbody> 
  <tr> 
   <td> <strong>MySQL</strong> </td> 
   <td> <strong>Oracle</strong> </td> 
  </tr> 
  <tr> 
   <td> MySQL是免费的开源数据库。 </td> 
   <td> Oracle是商业数据库。 </td> 
  </tr> 
  <tr> 
   <td> 它轻巧，简单的RDBMS，非常适合Web。 </td> 
   <td> Oracle比MySQL非常强大，允许编写任何复杂的系统，例如银行，ERP，保险，金融公司。 </td> 
  </tr> 
  <tr> 
   <td> MySQL不支持分布式数据库。 </td> 
   <td> Oracle支持分布式数据库。 </td> 
  </tr> 
  <tr> 
   <td> Mysqlhotcopy和mysqldump是MySQL的备份实用程序。 </td> 
   <td> Oracle具有不同类型的备份，例如云备份，热备份，导出，导入数据转储。 它提供了最受欢迎的备份实用程序，称为恢复管理器(RMAN) </td> 
  </tr> 
  <tr> 
   <td> 临时表将仅显示给特定会话。 会话结束后，这些表将被自动删除。 </td> 
   <td> 但是在oracle中，应该显式删除表。 这些对所有会话都可见。 </td> 
  </tr> 
  <tr> 
   <td> MySQL不支持任何其他功能。 </td> 
   <td> Oracle在其数据库服务器上支持多种扩展和程序，例如Active Data Guard，Audit Vault，分区和Data Mining等。 </td> 
  </tr> 
  <tr> 
   <td> MySQL没有表空间，角色管理，快照和自动存储管理。 </td> 
   <td> 另一方面，Oracle具有所有这些功能。 </td> 
  </tr> 
  <tr> 
   <td> 用C和C ++编写MySQL </td> 
   <td> 用汇编语言，C和C ++编写的Oracle </td> 
  </tr> 
  <tr> 
   <td> 一些使用MySQL数据库的最受欢迎的公司是：YouTube，PayPal，Google，Facebook，Twitter，GitHub，eBay，LinkedIn等。 </td> 
   <td> 一些使用Oracle数据库的最受欢迎的公司是：印度凯恩(CAIRN)，TVS汽车公司，Vilene，澳大利亚国家食品，ENEL等。 </td> 
  </tr> 
  <tr> 
   <td> 官方网站： <a href="https://www.mysql.com" rel="nofollow">www.mysql.com</a> </td> 
   <td> 官方网站： <a href="https://www.oracle.com/database/" rel="nofollow">www.oracle.com/database</a> </td> 
  </tr> 
 </tbody> 
</table>

> 翻译自: [https://www.thecrazyprogrammer.com/2019/01/difference-between-mysql-and-oracle.html][https_www.thecrazyprogrammer.com_2019_01_difference-between-mysql-and-oracle.html]

[https_www.thecrazyprogrammer.com_2019_01_difference-between-mysql-and-oracle.html]: https://www.thecrazyprogrammer.com/2019/01/difference-between-mysql-and-oracle.html