1. NoSQL The term NoSQL classifies databases as descriptive, like "No-SQL". NoSQL is a comprehensive category of databases designed to overcome the problems posed by SQL databases. They are called schemeless documents and they store data in document, graph, key-value and non-ordered fashion.
Advantages of NoSQL:
- They scale better than traditional systems when dynamic behaviour is required.
- These systems are better optimized for non-relational data.
- Allows schema-on-write operations.
Disadvantages of NoSQL:
- Systems built with NoSQL are fundamentally non-transactional.
- The amount of data created is enormous and does not provide any traditional database functionality.
- It does not follow consistency when multiple transactions are executed concurrently.
2. NewSQL
The term NewSQL classifies databases that are a combination of the relational model with advances in scalability, flexibility of data types. These databases focus on features that do not exist in NoSQL, which provides strong consistency guarantees. This covers two layers of data, a layer of relational data and a key-value store.
Advantages of NewSQL:
- It introduces a new implementation for traditional relational databases.
- It brings together the strengths of SQL and NoSQL.
- Migrating between user types and needs is easy.
Disadvantages of NewSQL:
- They provide partial access to rich legacy systems.
- It can cause problems with in-memory architectures to exceed the amount of data.
- The core foundation of such databases is a relational system, which makes understanding tricky.
The difference between NoSQL and NewSQL:
| S.No | NoSQL | NewSQL |
|---|---|---|
| 1 | NoSQL is a schemeless database | NewSQL is schema-fixed and a schema-less database |
| 2 | NoSQL scales horizontally | NewSQL is horizontally scalable |
| 3 | NoSQL has automatic high availability | NewSQL has built-in high availability |
| 4 | NoSQL supports cloud | disk and cache storage. NewSQL fully supports cloud, disk and cache storage |
| 5 | NoSQL promotes the CAP feature | NewSQL promotes acid properties. |
| 6 | NoSQL does not support online transaction processing | NewSQL fully supports online transaction processing |
| 7 | NoSQL has low security issues | NewSQL has modest security concerns |
| 8 | NoSQL Use Cases, Social Networking Applications, and Internet of Things. | Use Cases: E-Commerce, Telecom Industry and Gaming |
| 9 | NoSQL examples: DynamoDB, MongoDB, RaveenDB, etc | For example: VoltDB, Cockroach DB, NuoDB, etc. |
