Difference between Oracle and MySQL
1. Oracle :
Oracle is a relational database management system (RDBMS). It was developed by Oracle Corporation in 1980. It is the first database designed for grid computing that provides the most flexible and cost-effective way to manage information and application. It runs on major platforms like Windows, Unix, Linux, and macOS. It is a relational database in which data is accessed by user through application or query language called SQL.
2. MySQL :
MySQL is an open source Relational Database Management System (RDBMS) based on Structured Query Language (SQL). It runs on platforms like Linux, UNIX and Windows.
Difference between Oracle and MySQL :
| S.NO. | Oracle | MySQL |
|---|---|---|
| 1. | It is developed By Oracle in 1980. | It is developed By Oracle in 1995. |
| 2. | It is commercial. | It is Open Source. |
| 3. | Server operating systems for Oracle is AIX, HP-UX, Linux, OS X, Solaris, Windows, z/OS. | Server operating systems for MySQL is FreeBSD, Linux, OS X, Solaris, Windows. |
| 4. | Its Primary database model is a Relational DBMS. | Its primary database model is also Relational DBMS. |
| 5. | It has predefined data type such as date or float. | It also has predefined data type such as date or float. |
| 6. | It supports SQL. | It also supports SQL. |
| 7. | APIs and other access methods for Oracle is JDBC, ODBC, ODP.NET, Oracle Call Interface (OCI). | APIs and other access methods for MySQL is ADO.NET, JDBC, ODBC, Proprietary native API. |
| 8. | Programming languages supported by Oracle are C, C#, C++, Clojure, Cobol, Delphi, Eiffel, Erlang, Fortran, Groovy, Haskell, Java, JavaScript, Lisp, Objective C, OCaml, Perl, PHP, Python, R, Ruby, Scala, Tcl, Visual Basic. | Programming languages supported by MySQL are Ada, C, C#, C++, D, Delphi, Eiffel, Erlang, Haskell, Java, JavaScript (Node.js), Objective-C, OCaml, Perl, PHP, Python, Ruby, Scheme, Tcl. |
| 9. | It supports Server-side scripting using user PL/SQL. | It also supports Server-side scripting. | 10. | It supports Partitioning methods using horizontal partitioning. | It supports Partitioning methods using horizontal partitioning, sharding with MySQL Cluster or MySQL Fabric. |
.png)