RDBMS vs. NoSQL vs. NewSQL; which one to choose?

The market is flooded with many types of database and this creates dilemma for architects to choose one that suits the project’s requirement. ‘One size fits all’ approach is not longer applicable. Enterprises need to judge the relevance and applicability before adopting any of the databases. The different databases are scrutinised below to understand when to implement them.