Practice Flashcards
Flip to reveal answersName five database types.
Track your progress — Sign up free to save your progress and get smart review reminders based on spaced repetition.
All 5 Flashcards — Types of database
Sign up free to track progress and get spaced-repetition review schedules.
Question
Name five database types.
Answer
**Relational** (tables), **document** (varying fields), **key-value** (fetch by key), **graph** (nodes and edges), **column-family** (columns grouped).
Question
When does a graph database beat relational?
Answer
When the **relationships are the question** — "friends of friends" is one traversal against a self-join per level in SQL.
Question
What can a key-value store not do?
Answer
**Query the value.** You fetch by key or not at all, which is why it suits caches and sessions.
Question
What does a document store give up for its flexibility?
Answer
**Joins** and enforced schema — so data is duplicated, and update anomalies return.
Question
Is NoSQL an upgrade on relational?
Answer
**No, a trade.** Relational remains right for most business data because it enforces structure and transactions.
Read the notes
Full study notes for Types of database
Topic 3.4 hub
Alternative databases
More from Topic 3.4
All flashcards in this topic
Computer Science exam skills
Paper structures & tips
Track your progress with spaced repetition
Sign up free — Aimnova tells you exactly which cards to review and when, so you remember everything before your IB exam.
Start Free