Database Types reference data
Different database systems and their characteristics.
Datasets in Database Types
-
ACID vs BASE Properties
Comparison of ACID (traditional RDBMS) and BASE (NoSQL) consistency models.
-
CAP Theorem
The CAP theorem: a distributed data store can provide only two of three guarantees simultaneously.
-
Database Systems Comparison
Comparison of database types: Relational, Document, Key-Value, Column-Family, Graph, and Vector databases with examples and best-fit use cases.
-
Graph Databases Comparison
Property graphs (Neo4j, Amazon Neptune) vs RDF triplestores (Apache Jena). Query languages (Cypher, Gremlin, SPARQL). Use cases: social networks, recommendation engines, knowledge graphs.
-
NewSQL & Distributed SQL Databases
Modern distributed SQL databases combining ACID with horizontal scaling: CockroachDB, TiDB, YugabyteDB, Google Spanner, Amazon Aurora, Vitess.
-
NoSQL Databases Overview
Document (MongoDB, Couchbase), Key-Value (Redis, DynamoDB), Column-Family (Cassandra, HBase), Graph (Neo4j, JanusGraph). CAP theorem, scaling, use cases.
-
SQL Join Types
Reference for all SQL JOIN types and their use cases.
-
SQL Query Types Reference
Categories of SQL statements for data definition, manipulation, and control.
-
Time-Series Databases Comparison
Comparison of time-series databases: InfluxDB, TimescaleDB, Prometheus, VictoriaMetrics, QuestDB, and ClickHouse. Storage engines, query languages, compression, and use cases.
Fetch this category
One request returns the category with all of its dataset summaries. Append
?format=yaml or ?format=toon for the other encodings.
GET https://yjtoon.com/api/category/database-types?format=json