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
- A comparison of the widely know relational databases
- An outline of the essential topics
- 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.