02 - NoSQL: Not Only SQL Flashcards
T/F
NoSQL is BASE compliant
T
T/F
NoSQL databases are usually normalized.
F
non-normalized
Explain
CAP Theorem
For any distributed system, you can only have two of the three properties simultaneously.
In its DEFAULT mode of operations, which properties does MongoDB implement?
Partition Tolerance
Consistency
The BASE property that states the system may change over time even without input
Soft-State
List
CAP Theorem
Consistency
Availability
Partition Tolerance
Define
Consistency
Ensuring that every request receives the most recent write
Define
Availability
Ensuring that all systems produce a non-error response
Define
Partition Tolerance
Ensuring that the system can survive the loss of a partition
List
ACID Compliance
Atomic
Consistent
Isolated
Durable
Define
Atomic - ACID Compliance
Complete success or failure
Define
Consistent - ACID
Data always follows schema and always returns the correct result
Define
Isolated
One transaction cannot interfere with another
Define
Durable
Ensure that changes are permanent
List
BASE
Basic Availability
Soft-state
Eventual consistency
Define
Basic Availability - BASE
Highly available
Define
Soft-state - BASE
System may change over time even without input
Define
Eventual consistency - BASE
System will be consistent over time as long as there is no more additional input
Differentiate: SQL vs NoSQL
Representation
SQL: Multiple tables, each containing columns and rows
NoSQL: Collection of documents; single table with keys and values
SQL vs NoSQL
Primary Informer
SQL: Entities
NoSQL: Access patterns
SQL vs NoSQL
Data Design
SQL: Normalized relational or dimensional data warehouse
NoSQL: Denormalized document, wide column or key value
SQL vs NoSQL
Query Style
SQL: Language: SQL
NoSQL: Language: multiple depending on database service
SQL vs NoSQL
Scaling
SQL: Vertical scaling
NoSQL: Horizontal scaling