丁久

Posted on May 16 • Originally published at dingjiu1989-hue.github.io

Database Types Overview: Relational, Document, Key-Value, Graph, Time-Series, Vector

#database #backend #data

This article was originally published on AI Study Room. For the full version with working code examples and related articles, visit the original post.

Database Types Overview: Relational, Document, Key-Value, Graph, Time-Series, Vector

Choosing the right database type is one of the most consequential architectural decisions. Each type optimizes for different access patterns, consistency guarantees, and scalability requirements. This article surveys the major database types and their ideal use cases.

Relational Databases (PostgreSQL, MySQL, SQL Server)

Relational databases organize data into tables with predefined schemas, linked by foreign keys. They provide ACID transactions and powerful querying via SQL.

Strengths :

ACID transactions with strong consistency guarantees.
Complex joins and aggregations across multiple tables.
Rich constraint system (foreign keys, unique, check).
Mature ecosystem and tooling.

Weaknesses :

Schema changes require migrations.
Horizontal scaling is complex (sharding).
Rigid for highly varied, sparse data.

\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\-- Typical relational model

CREATE TABLE users (

id BIGSERIAL PRIMARY KEY,

email TEXT UNIQUE NOT NULL,

created_at TIMESTAMPTZ DEFAULT NOW()

);

CREATE TABLE orders (

id BIGSERIAL PRIMARY KEY,

user_id BIGINT REFERENCES users(id),

total NUMERIC(10,2),

created_at TIMESTAMPTZ DEFAULT NOW()

);

SELECT u.email, COUNT(o.id) AS order_count

FROM users u

LEFT JOIN orders o ON o.user_id = u.id

GROUP BY u.email;

Best for : Financial systems, ERP, CRM, any application where data integrity is paramount.

Document Databases (MongoDB, Couchbase)

Document databases store semi-structured data in JSON-like documents. Schemas are flexible, and documents can have varying structures.

Strengths :

Schema flexibility: documents in the same collection can have different fields.
Native JSON support with rich query operations.
Horizontal scaling with native sharding.
Developer productivity for rapidly evolving models.

Weaknesses :

Limited join capabilities ($lookup is less performant than SQL JOINs).
Multi-document transactions are newer and slower than ACID RDBMS.
No enforced schema means application-level validation is essential.

// MongoDB document model

db.users.insertOne({

_id: ObjectId(),

email: "alice@example.com",

profile: { name: "Alice", avatar: "avatar.jpg" },

orders: [

{ order_id: 1, total: 99.99, items: ["Widget"] }

]

});

Best for : Content management, catalogs, rapid prototyping, applications with evolving schemas.

Key-Value Stores (Redis, DynamoDB, Riak)

Key-value stores are the simplest database type. They store values accessed by a unique key, optimized for high-throughput, low-latency lookups.

Strengths :

Extremely fast reads and writes (sub-millisecond).
Simple data model with no schema.
Easy to scale horizontally.
Ideal for caching and session storage.

Weaknesses :

No query capabilities beyond key lookups (in pure KV stores).
Limited to simple data structures (without secondary indexes).
Application must manage data relationships.

SET user:42 '{"email": "alice@example.com", "name": "Alice"}'

GET user:42

LPUSH recent_views:42 "product:100"

ZADD leaderboard 1000 "player_alice"

Best for : Caching, session management, real-time counters, pub/sub, rate limiting.

Graph Databases (Neo4j, Amazon Neptune)

Graph databases model data as nodes and edges, optimized for traversing relationships.

Strengths :

Relationship traversal is extremely fast, independent of graph size.
Natural modeling of highly connected data.
Patter

Read the full article on AI Study Room for complete code examples, comparison tables, and related resources.

Found this useful? Check out more developer guides and tool comparisons on AI Study Room.

DEV Community

Database Types Overview: Relational, Document, Key-Value, Graph, Time-Series, Vector

Database Types Overview: Relational, Document, Key-Value, Graph, Time-Series, Vector