ABSTRACT
NewSQL systems are special types of big data systems which promote horizontal scalability while ensuring ACID (Atomicity, Consistency, Isolation, and Durability) transactions guarantee. In order to provide ACID properties, a NewSQL system can incorporate several features such as storing data in main memory, partitioning the data across different systems, implementing concurrency control mechanisms, implementing secondary indexes, replicating data, and incorporating crash recovery mechanisms. VoltDB-a NewSQL database-incorporates partitioning for scalability. NuoDB- another NewSQL system-provides ACID guarantees by separating transaction processing and storage processing. Spanner - a NewSQL system developed by Google, distributes data in zones. It achieves massive scalability through efficient management of data, external consistency, and time stamping. NewSQL systems have enormous potential to provide ACID guarantees while maintaining scalability.
