Difference between Derby and MySQL

1. Derby :
Apache Derby is a full-featured, open-source relational database management system (RDBMS) implemented in Java and as the name suggests it is developed by Apache Software Foundations. It is based on Java, JDBC and SQL standards. Derby is easy to install, deploy, and use. It is either embedded into a Java application or used as a database server.

2. MySQL :
MYSQL is a widely-used open-source relational database management system (RDBMS) developed by Oracle Corporation. MYSQL is developed in C and C++ programming languages. The database models supported by MySQL are RDBMS and Document Store.

Difference between Derby and MySQL :

S.No. Derby MYSQL
1. Derby was developed by Apache Software Foundation. MYSQL was developed by Oracle Corporation.
2. Derby is implemented in Java programming language. MYSQL is implemented in C/C++ programming Languages.
3. The language supported by derby is Java. The languages supported by MYSQL are C, C#, C++, Python, Ruby, Java, PHP, Javascript and others.
4. Derby was launched in August 2004. MySQL was launched on 23 May 1995.
5. The Replication method used here is Master-Slave Replication. The Replication methods used here are Master-Master Replication and Master-Slave Replication.
6. Derby suits well when there is need of small RDBMS in an application. MYSQL suits well for both small and large organizational data storage for an application.
7. Derby is not well established in the market as compared to MYSQL. MYSQL is well established in the market and is used by organizations ranging from small to large.
8. The speed provided by derby is fast. Derby is fast but C/C++ is faster as compared to Java, thus making MYSQL faster.
9. The operating systems supported by Derby are Windows, macOs, Linux, Unix, BSD and z/OS. The operating systems supported by MySQL are Windows, macOs, Linux, Unix, AmigaOS, BSD, z/OS and Android.
10. Derby does not support any partitioning methods. MySQL supports partitioning methods like hash, list, range and composite partitioning.
11. Derby supports ACID properties. MySQL also supports ACID properties.
12. No secondary database model is used. The secondary database model supported is Document Store.
13. APIs and other access methods used by Derby is JDBC. APIs and other access methods used by MySQL are ADO.NET, JDBC and ODBC.

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.

My Personal Notes arrow_drop_up

Check out this Author's contributed articles.

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.

Article Tags :
Practice Tags :


Please write to us at contribute@geeksforgeeks.org to report any issue with the above content.