Core differences between relational and NoSQL databases including document, key value, and column family stores.
28 cards · basic cards · AI-written, checked twice. Edit anything.
- What does SQL stand for?
- Structured Query Language
- What is a primary key in a relational database?
- A unique identifier that distinguishes each row from all others
- What is normalization in database design?
- The process of organizing data to reduce redundancy and improve integrity
- Name three common SQL commands
- SELECT, INSERT, UPDATE (also acceptable: DELETE, CREATE, DROP)
- What is a foreign key?
- A column that references the primary key of another table
- What does ACID stand for?
- Atomicity, Consistency, Isolation, Durability
- What does a JOIN clause do in SQL?
- Combines rows from two or more tables based on a related column
- What does NoSQL mean?
- Not Only SQL, a database approach that does not rely on relational tables
- Name three main types of NoSQL databases
- Document stores, key-value stores, column family stores
- What is schema-less storage?
- A database design where the structure of data does not need to be defined upfront
- What is a document store database?
- A NoSQL database that stores data as documents, typically in JSON or BSON format
- What is JSON in the context of document databases?
- JavaScript Object Notation, a text format for storing structured data with key-value pairs
- Name a popular document database
- MongoDB
- What is a collection in MongoDB?
- A group of documents, similar to a table in a relational database
- How are nested data structures handled in document stores?
- Documents can contain nested objects and arrays directly, with no need to join separate tables