Relational Database Comparision - Part IsteemCreated with Sketch.

in #technology7 years ago (edited)

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.

Sort:  

Congratulations @humblebeginnings! You received a personal award!

Happy Birthday! - You are on the Steem blockchain for 2 years!

You can view your badges on your Steem Board and compare to others on the Steem Ranking

Vote for @Steemitboard as a witness to get one more award and increased upvotes!