Relational and Non-Relational Databases

Relational Databases

  • store a large amount of data and various kinds of data
  • high availability-RDs can be a single point of failure as they are not distributed. Thye can be scaled vertically
  • fast reads-in RDS, the queries take time to retrieve data

NoSQL databases

  • If you need a consistent database with ACID transactions, you cannot use NoSQL databases. (Although NoSQL is consistent, they are cannot support ACID transactions)
  • Need to do joins, aggregations and analytics (you have do join tables across thousands of servers because of the distributed nature)
  • Small data sets and changing business requirements

--

--

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store