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. |
Attention reader! Don’t stop learning now. Get hold of all the important CS Theory concepts for SDE interviews with the CS Theory Course at a student-friendly price and become industry ready.
Recommended Posts:
- Difference between Oracle NoSQL and Oracle
- Difference between Oracle and MongoDB
- Difference between Impala and Oracle
- Difference between Hive and Oracle
- Difference between Oracle and PostgreSQL
- Difference between Oracle and Cassandra
- Difference between Oracle and Couchbase
- Difference between Oracle and CouchDB
- Difference between Oracle and MariaDB
- Difference between Oracle and Firebase
- Difference between Oracle and Derby
- Difference between Oracle and dBASE
- Difference between Oracle and PouchDB
- Difference between MySQL and MS SQL Server
- Difference between MySQL and PostgreSQL
- Difference between MySQL and SQLite
- Difference Between MySQL and MariaDB
- Difference between Cassandra and MySQL
- Difference between Alibaba Cloud AnalyticDB for MySQL and Amazon Neptune
- Difference between MySQL and dBASE
If you like GeeksforGeeks and would like to contribute, you can also write an article using contribute.geeksforgeeks.org or mail your article to contribute@geeksforgeeks.org. See your article appearing on the GeeksforGeeks main page and help other Geeks.
Please Improve this article if you find anything incorrect by clicking on the "Improve Article" button below.
