NoSQL Chapter Flashcards
Name the four broad classification types of data?
structured data, unstructured data, dynamic data, static data
Name the data classification type:
____________ data has a predefined model, which organizes data into a form that is relatively easy to store, process, retrieve and manage.
e.g. relational data.
Structured
Name the data classification type:
__________ data is the ooposite of structured data.
unstructured
Name the data classification type:
Flat binary files containing text, video or audio are examples of _________ data.
unstructured.
T/F: data is not completely devoid of a structure.
True, (e.g., an
audio file may still have an encoding structure and some
metadata associated with it)
Name the data classification type:
____________ Data is data that changes relatively frequently.
Dynamic
__________ data is the opposite of dynamic data.
▪ E.g., Medical imaging data from MRI or CT scans.
Static
Name the data classification type:
Office documents and transactional entries in a financial database are examples of __________ Data.
dynamic
File systems or NoSQL databases can be used for _______, ___________ data
static, unstructured
T/F: Relational databases are usually used for structured data.
True
A ___________ provides a mechanism for storage and retrieval of data that is modeled by means other than the tabular relations used in relational databases.
NoSQL database
NoSQL databases mainly follow the _______ properties (out of scope).
BASE
Amazon’s Dynamo and Google’s Bigtable are examples of ____________.
NoSQL Databases
T/F: No strict schema requirements are one of the main characteristics of NoSQL databases.
True
T/F: No strict adherence to BASE properties (out of scope) is one of the characteristics of NoSQL databases.
False, ACID not BASE properties.
T/F: Consistency is traded in favor of availability (out of scope) is one of the characteristics of NoSQL databases.
true.
Name the four different types of NoSQL databases.
Document Stores, Graph Databases, Key-Value Stores, Columnar Databases.
Semi-structured data happened as a result of __________ and ___________.
Big Data, Web 2.0 & 3.0
Name the NoSQL database:
Documents are stored in some standard format or
encoding (e.g., XML, JSON, PDF or Office Documents).
E.g., MongoDB and CouchDB
Document Stores
____________ are typically referred to as Binary Large Objects (BLOBs)
Document Stores
Name the NoSQL database:
Data are represented as vertices and edges.
E.g., Neo4j and VertexDB
Graph Databases
T/F: Graph databases are powerful for graph-like queries.
True.
Name the NoSQL database:
Keys are mapped to (possibly) more complex value (e.g., lists)
E.g., Amazon DynamoDB and Apache Cassandra
Key-Value Stores
Name the NoSQL database:
Has a simple put/get interface.
typically supports regular CRUD (create, read, update, and delete) operations but no joins and aggregate functions.
Key-Value Stores
T/F: In a Key-Value Stores, Keys can be stored in a hash table and can be distributed easily.
True.
Name the NoSQL database:
___________ databases are a hybrid of RDBMSs and Key-Value stores.
E.g., HBase and Vertica
Columnar
T/F: column stores are suitable for write-mostly, write-intensive, large data repositories.
False, read-mostly, read-intensive, large data repositories.
T/F: In Columnar Databases, Values are stored in groups of zero or more columns, but in Column-Order (as opposed to Row-Order).
True.
T/F: In Columnar databases, Values are queried by matching keys.
True.
