UNDERSTANDING THE TECHNOLOGICAL TRENDS AND QUANTITATIVE ANALYSIS OF NEWSQL DATABASES

Abstract

Modern database systems have come a long way from the first IBM system R, which is considered the first relational database management system, to modern days cloud databases. A recent survey pointed out that around 90% of the data we have was generated in the last 2 years alone. And with the growing reach of Internet and Internet applications the generated data became so large that it was eventually referred as Big Data. To store this rapidly expanding data efficiently, NoSQL databases were developed that have a high horizontal scaling and can be run on cheap commodity hardware. But, NoSQL lacks a key property of traditional RDBMS. It lacks ACID transactional properties and provides availability over consistency. Many enterprise solutions(Ex. Financial systems) need to scale but cannot give up transactional and consistency requirements. So a new type of system, named NewSQL are being developed which aims to provide the best of both worlds (RDBMS and NoSQL)transactional properties of RDBMS and scalability of NoSQL. In this theses, we study the technological trends in databases and also bench-mark and compare the upcoming NewSQL databases. We will also try to understand if these NewSQL systems are here to stay or they are just a stepping stone in the world of ever evolving technologies.