SQL and NoSQL With Complete Solutions Latest Update
No SQL Agreement - ANSWER Not Relational
Highly distributable and scalable
High availability, fault tolerant
Supports sparse, and large amounts of data
Trades performance for transaction consistency
NoSQL - ANSWER Not Only Structured Query Language
Common Data Models - ANSWER Wide column stores-store columns of data together,
instead of rows
Document stores- can contain many different key-value pairs, key-array pairs or nested
documents.
Key-Value stores
Graph stores- for social networks
NoSQL Benefits (over Relational Model) - ANSWER Supports large volumes of
semi-structured data without pre-defined schema
• better handling of large volumes of rapidly changing structured, semistructured and
unstructured data
• dynamic schemas which allow agile development
• use of object-oriented programming paradigm
• Horizontal scaling - increase capacity by adding more servers rather than increasing
the size of a single server
• Servers can be geographically distributed, i.e., in the cloud.
• Databases can automatically replicate to maintain availability in the occurrence of
No SQL Agreement - ANSWER Not Relational
Highly distributable and scalable
High availability, fault tolerant
Supports sparse, and large amounts of data
Trades performance for transaction consistency
NoSQL - ANSWER Not Only Structured Query Language
Common Data Models - ANSWER Wide column stores-store columns of data together,
instead of rows
Document stores- can contain many different key-value pairs, key-array pairs or nested
documents.
Key-Value stores
Graph stores- for social networks
NoSQL Benefits (over Relational Model) - ANSWER Supports large volumes of
semi-structured data without pre-defined schema
• better handling of large volumes of rapidly changing structured, semistructured and
unstructured data
• dynamic schemas which allow agile development
• use of object-oriented programming paradigm
• Horizontal scaling - increase capacity by adding more servers rather than increasing
the size of a single server
• Servers can be geographically distributed, i.e., in the cloud.
• Databases can automatically replicate to maintain availability in the occurrence of
