NoSQL & NewSQL Flashcards
NoSQL Database
When people use the term “NoSQL database,” they typically use it to refer to any non-relational database. Some say the term “NoSQL” stands for “non SQL” while others say it stands for “not only SQL.” Either way, most agree that NoSQL databases are databases that store data in a format other than relational tables.
NoSQL DB Features
o NoSQL databases are horizontally scalable
o NoSQL databases are document, key-value, graph
o It avoids joins and it is easy to scale.
o It’s used for Big Data and real-time web apps.
Structural Variety in Big Data
- Sets
- Hierarchies
- Graphs
- Arrays
NewSQL Database
NewSQL is a new approach to relational databases that wants to combine transactional ACID (atomicity, consistency, isolation, durability) guarantees of good ol’ RDBMSs and the horizontal scalability of NoSQL.