In our previous articles, we provide detailed descriptions along with the pros and cons of some of the most popular and widely used database management systems. We discussed, MYSQL, MS SQL Server, MongoDB, and Postgres DB.
In this article, we are going to present a comparison of these four famous database systems in tabular. Readers can view the comparison matrix and decide what type of Database Management System suffices their database application development needs.
|Postgres||MySQL||MongoDB||MS SQL SERVER|
|Database Type||Object-Relational Database Model||RDBS, widely used in LAMP suit.||JSON Type Database schema instead of traditional SQL based queries.||Microsoft’s proprietary DBMS|
|Developed By||Postgre SQL Global Development Group||Oracle||MongoDB Inc||Microsoft|
|Programmed in||C||C and C++||C++||C++|
|Database Model||Relational||Relational||Document Store||Relational|
|Query Mechanism||SQL Based||JSON Type Query Mechanism (NoSQL)||SQL Based||SQL Based|
|Concurrent Processing||Allows Concurrent Processing||Allows Concurrent Processing||Allows Concurrent Processing||Allows Concurrent Processing|
|Replication Topologies||Master-Slave Topology||Master-Master,
MySQL Cluster Topology
|Master-Slave Topology||Dependent on database edition|
|Language Support||Perl, Python, Tcl, .Net, C, C++||Ada, C, C#, C++, D, Java
OCaml, Perl, Eiffel, Erlang, Haskell
|Portioning Mechanism||Not Supported but Table Inheritance can be used to achieve the purpose.||MySQL Cluster based horizontal partitioning||Sharding Partitioning||Horizontal Partitioning with a table spanning several files but no sharding|
Further information on the best database management systems. Some of the most popular DBMS systems are as follows:
We will now be giving a DBMS comparison between the four while paralleling the characteristics of them all.
Since most of these DBMS servers are relational database management systems, let us start with understanding what a Relational Database is.
A category of databases that is responsible for storing and allowing access to multiple, interlinked data points is a relational database. Based on the Relational Model, first introduced by Edgar F. Codd in 1969, they function on a straightforward and intuitive technique of tabular data representation.
Each row and column has a unique ID identification in a relational database. This unique ID is called a ‘key.’ These columns are carriers of data and its various attributes. This system of recording makes it very easy to create links and relations amongst the various data points.
The Oracle DBMS is a revolutionary database that is self-equipped to eliminate errors done through manual management of data. It was developed by the Oracle Corporation multi-tier database system mostly used for facilitating online transactions and ‘data warehousing.’
Released by IBM, originally in 1983, IBM Db2 is the company’s pioneer DBMS system used for mostly hybrid management products that aid the user in managing unstructured and structured data alike, on private and communal cloud milieus.
Earlier, during the making of the IBM Db2, the DBMS software bolstered the relational model of functionality, but in due course of time, they extended their range to and non-relational systems like XML and JSON.
At this date and time, IBM Db2 systems support Windows, Unix and Linux Operating System and houses premium features like the in-memory technology frequent optimization of storage, compressed action and constant round the clock data availability.
|Oracle DBMS||IBM Db2||Microsoft SQL Server|
|1 variant for all software and systems||Different variants for Windows, Unix, and Linux||1 variant for Linux and Windows|
|Relational Database||Relational Database||MS Relational DBMS|
|Access rights to SQL standards||Access rights to SQL standards||Access rights to SQL standards|
|In-memory function||No in-memory attribute||In-memory function|
An open-source relational DBMS. It has aided its users in facilitating high-performance technologies that are important for heavy and demanding usage. Altibase is known as the pioneer of the hybrid database since the company developed the very first commercialized one, way back in 2005.
A DBMS server developed by Microsoft in 1989, Microsoft SQL Server is a relational database with the principal function of data storage and retrieval from and by other software. This server can either be run on an entire network of devices or individually on a single system. It houses a data integration system so that everything can be done in one place itself.
|Model Variant||Relational DBMS||Relational DBMS||Relational DBMS|
|Built||Client to Server||Client to Server||Client to Server|
|Type||Hybrid (on-disk and in-memory)||Only on-disk||Only on-disk|
All four major databases have been compared on the basis of several attributes in the comparison matrix. It is now up to the programmer to choose the database system that suits the application being developed.