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
