Which Type of NoSQL Is for You?

By Adam Fowler

The first question is what does your data look like? Unlike relational databases, where it’s a given that the data model includes tables, rows, columns, and relationships, NoSQL databases can contain a wide variety of data types.

The table matches data types with the NoSQL database you may want to consider.

NoSQL Data Management Use Cases
Data to Manage NoSQL Database
Trade documents (FpML), Retail insurance policies (ACORD),
healthcare messages, e-form data
Document database with XML support
Monthly data dumps in text delimited (CSV, TSV) files, or
system/web log files
Bigtable clone for simple structures
Document database for very complex structures
Office documents, emails, PowerPoint Document database with binary document text and metadata
extraction support
Web application persistent data (JavaScript Object Notation
— JSON)
Document database with JSON support and a RESTful API
Metadata catalog of multiple other systems (for example,
library systems)
Bigtable for simple list of related fields and values
Document database for complex data structures or full text
information
Uploaded images and documents for later retrieval by unique
ID
Key-value store for simple store/retrieval
Document store with binary text extraction and search for more
complex requirements
RDF, N-Triples, N3, or other linked (open) data Triple store to store and query facts (assertions) about
subjects
Graph store to query and analyze relationships between these
subjects
Mix of data types in this table Hybrid NoSQL database