NoSQL, NewSQL and the future of Database Management Systems, Part 1
NoSQL – The NoSQL database offers a system for storing and retrieving data that has been modeled in non-tabular relations. The motivations behind this approach in database management system include basic design, detailed control over availability and horizontal scaling.
It has a different data structure compared to the RDBMS, which makes certain operations faster. However, there are even more differences between the two systems and the application of a particular NoSQL database will depend on the problem at hand.
NoSQL database systems are increasingly used in industries for real-time web applications and big data applications. These systems are also called “Not only SQL” to indicate that they could enable the use of query languages similar to SQL. When it comes to the CAP theorem, this system can sometimes give more preference to partition tolerance and availability compared to consistency.
The limitations that keep NoSQL database systems from getting widely adopted include the absence of support for full ACID transaction, the vast investments that enterprises have already made in SQL, and the absence of regular interfaces.
NewSQL – This is a relatively newer database management system that is considered to be better than SQL. There are many factors in the NewSQL database that make it different from and probably superior to SQL. According to many DB professionals SQL is quite complex and outmoded.
It is claimed that NewSQL systems have similar performance as the NoSQL systems. The system provides DBAs with ACID performance, Consistency, Atomicity, Durability, or Isolation.
The name NewSQL was created by a member of the 451 Group, Matthew Aslett. The name describes all the products that rely on relational data model and have a main SQL interface. It is perfect for any enterprise that wants to migrate their current applications to Big Data systems, or want to develop new applications on vast online transaction processing mechanisms, or want to use the current knowledge of online truncation processing.