Relational Database Comparision - Part I

The internet is filled with an overwhelming amount of information on databases that one could easily get lost and no surprise there because there are a plethora of relational databases available in the RDBMS space. Just like us humans, the thing about databases is that there is no one database better than the other, each has something to offer and it all depends on what we're looking for. Some are good for the available cost, some for their enterprise features, and some for their support.

In the table below which is Part I of a Three-Part Series of the relational database comparison, you will find

1. A comparison of the widely know relational databases
2. An outline of the essential topics
3. More information about databases in bite-sized and easy to digest chunks

SQL Server	Oracle	MySQL	PostgreSQL
Price
Standard: $3,500 per 2 CPU cores Enterprise: $14,700 per 2 CPU cores	Standard: $18,700 per CPU Enterprise: $48,000 per CPU	Community Edition: Open Source	Core: Open Source
OS Support
Windows Server (Linux coming soon)	Windows Server Linux	Windows Server Linux	Windows Server Linux
Connection Pooling
Connection Pooling not available by default	Connection Pooling not available by default	Connection Pooling available via third-party tools	Can be accomplished by a middleware like pgpool II
Replication
Master/Standby	Golden Gate Master/Standby Active Standby	Master/Standby	Among many options available, some are: Streming replication Pgpool II Slony-I (trigger based)
Partioning
Vertical partitioning available only in Enterprise version	No Vertical partitioning available	No Vertical partitioning available	Vertical partitioning available as child/parent tables
In-Memory Analytics
Available in SQL Server 2012 and above	Available in Oracle Database 12.1.0.2	Not Available	Not Available

In the following article Gartner 'positions' Microsoft as number 1 in 2016

http://www.vir.com.vn/gartner-positions-microsoft-as-number-1-in-2016-magic-quadrant.html

I hope you learned something new today! In Part II, I will be discussing topics like programming, documentation, support among many others. Stay tuned.

I'd like to hear from you! Please leave in the comment section below what topics you'd like me to cover in the future.