1. MySQL :
MySQL is an open-source relational database management system (RDBMS) based on Structured Query Language (SQL). It is developed and managed by Oracle Corporation and initially released on 23 May 1995. It is widely being used in many small and large scale industrial applications and capable of handling a large volume of data.
2. dBASE :
dBase is a microcomputer database management system (DBMS) that runs on a Windows platform. It is one of the first database systems that run on a microcomputer. It is designed to manipulate relational databases. Nowadays, dBASE PLUS 11 version is used, which was released in 2016. DBASE uses procedural functions and commands similar to the BASIC language. It uses simple commands for data manipulation like USE, GO TOP, and more.
Difference between MySQL and dBASE :
|1.||It was developed by Oracle and initially released in May 1995.||It was developed by Asthon Tate and initially released in 1979.|
|2.||MySQL is an open-source software, commerical software are also available with extended facilities.||dBASE is commercial software only|
|3.||Server operating systems for MySQL are FreeBSD, Linux, OS X, Solaris and Windows.||Server operating systems for dBASE are DOS (dBASE Classic) and Windows (dBASE Pro).|
|4.||Replication method used by MySQL are Master-Slave Replication and Master-Master Replication.||It does not have any replication method.|
|5.||MySQL support SQL (Standard Query Language).||dBASE does not support SQL.|
|6.||ACID transaction properties (Atomicity, Consistency, Isolation, and Durability) is supported by MySQL.||dBASE does not support ACID properties.|
|7.||It supports server side script procedures.||It does not support server side script procedures.|
|8.||JDBC, ODBC are used as APIs and other access method.||It does not support any APIs and access methods.|
|9.||It supports Horizontal partitoning method and triggers.||It neither supports any paritioning methods nor triggers.|
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.