nosql, graph db, mongo db

Polyglot Persistence

a term that refers to using multiple data storage technologies within a single system, in order to meet varying data storage needs. Such a system may consist of multiple applications, or it may be a single application with smaller components.

NoSQL include data storage and retrieval

not based on the relational model

NoSQL systems enable automated ______ to allow distribution of the data among multiple nodes to allow servers to operate independently on the data located on it

sharding

Wide Column Stores

- Rows and columns. - Distribution of data based on both key values (records) and columns, using "column groups/families"

Data in MongoDB is represented in

BSON

noSQL practice questions

noSQL practice questions

Key Value Stores

- A simple pair of a key and an associated collection of values - Key is usually a string - Database has no knowledge of the structure or meaning of the values.

Document Stores

- Like a key-value store, but "document" goes further than "value" - Document is STRUCTURED so specific elements can be manipulated separately

NoSQL Comparison Rankings 1. Performance 2. Scalability 3. Flexibility 4. Complexity 5. Functionality

1. Performance: Key Value, Document Store, Column > Graph 2. Scalability: Key-Value, Column > Document, Graph 3. Flexibility: Key Value, Document, Graph > Column 4. Complexity: Graph > Document, Column > Key-Value 5. Functionality: Key Value - variable Document - variable (low) Column - minimal Graph - graph theory

NOSQL Examples 1. Key Value 2. Document 3. Wide Column 4. Graph

1. Redis 2. MongoDB 3. Apache Cassandra 4. Neo4j

NoSQL

- stands for Not Only SQL - not based on relational model - scales OUT (horizontally) rather than scale UP - supports schema on READ (the schema is created only when the data is read and not before data ingestion) - largely OPEN SOURCE - most nosql DBS are NOT ACID compliant - use BASE properties basically available, soft state, eventually consistent

T or F NoSQL focuses on avoidance of replication and minimizing storage space

False

T or F Neo4j is a wide column NoSQL database management system developed by Oracle

False

Apache Cassandra is a leading producer of ____ NoSQL database management system

wide-column

T or F Apache Cassandra is a wide column NoSQL database management system

True

T or F Big data databases tend to sacrifice consistency for availability

True

T or F JSON is commonly uses in conjunction with the 'document store' NoSQL database model

True

T or F Graph-oriented databases are designed to maintain information regarding the relationships between data items

True

T or F NoSQL databases DO NOT support ACID

True

Which data model is commonly used in document-oriented NoSQL databases like MongoDB? A) Key-value B) Relational C) Document-based D) Columnar

C) Document-based

NoSQL stands for

Not Only SQL

An organization that decides to adopt the most popular NoSQL database management system would select:

MongoDB

Which of the following is NOT a characteristic of NoSQL databases? A) Support for flexible schema B) ACID transactions C) Horizontal scalability D) High availability

B) ACID transactions NoSQL follows BASE properties Basically Available Soft State Eventually Consistent

Graph Oriented Databases

Maintain information regarding the relationships between data items - Node with properties - Connections between nodes can also have properties

An organization requires a graph database that is highly scalable would select the ___ database management system.

Neo4j

An organization that requires a sole focus on performance with the ability for keys to include strings, hashes, lists, and sorted lists would select ___ database management system.

Redis

____ is the most popular key-value store NoSQL database management system

Redis

MongoDB databases are composed of

collections

NoSQL focuses on

flexibility

The NoSQL model that is specifically designed to maintain information regarding the relationships (often real-world instances of entities) between data items is called a

graph oriented database

The NoSQL model that includes a simple pair of a key and an associated collection of value is called a

key-value store

NoSQL systems allow ____ by incorporating commodity servers that can be easily added to the architectural solution

scaling out

When reporting and analysis organization of the data is determined when the data is used is called a(n)

schema on read

The NoSQL model that incorporates 'column families' is called a

wide-column store