In this article, we will look at the basics of NewSQL. NewSQL was first conceived in 2011 by Matthew Aslett in a research paper.
What is NewSQL?
NewSQL is a database language based on concepts of RDBMS & NoSQL. It combines the performance of NoSQL (horizontal scaling) and reliability (ACID properties – Atomicity, Consistency, Isolation and Durability) of RDBMS. It’s designed for the cloud era with the distributed computing in mind.
Many organisations that handle transaction processing systems are too large for conventional systems which will have the eventual consistency & high-performance requirement. RDBMS & NoSQL doesn’t provide solution to both of these requirements. NewSQL is developed to resolve this.
Features:
- In memory storage & data processing
- High availability & fault tolerant for faster recovery
- ACID support which ensures data integrity
- Partitioning scales the database
- Secondary indexing for faster query processing
Top 10 Popular NewSQL databases available in the market
- ClusterixDB (Autoscaling, High Availability)
- NuoDB (Consistency, Availability)
- CockroachDB (Scalable, High Consistency, Strong disaster recovery)
- Pivotal GemFire XD (InMemory, High Performance supporting real time application)
- Altibase (InMemory, Large storage capacity)
- MemSQL (InMemory, High Performance Database)
- VoltDB (InMemory, Operational database)
- c-treeACE (fully ACID advanced key-value store, High performance database)
- Percona TokuDB (High performance, Fully ACID complaint)
- Apache Trafodion (SQL on H-Base Solution)