Relational Database Management System (RDBMS)
Organize data as a series of two-dimensional tables with rows and columns.
RDBMS solutions include
- Azure SQL
- DB2
- MariaDB
- MS SQL Server
- MySQL
- Oracle
- PostgreSQL
- Teradata (Server)
Key-Value Database (NoSQL)
Stores each data value with a unique key.
- Amazon DynamoDB (Snapchat)
- Azure Cache
- Azure Table
- Cosmos DB
- Redis
Document Database (NoSQL)
A document that can be into an code object. JSON or XML for example.
- Amazon Document DB
- Cosmos DB
- Google Firestore
- MongoDB
Graph Database
Highly-connected datasets. Uses graph structures for semantic queries with nodes, edges, and properties to represent and store data.
- Amazon Neptune
- Cosmos DB for Apache Gremlin
- MS SQL Server
- Neo4j
- Oracle
Object Storage
Storing and retrieving binary files (images, videos, audio, PDFs, documents)
- Amazon Simple Storage Service
- Azure Blob Storage
- Azure Data Lake Storage
Data Files
Simple flat data files used to store and retrieve data.
- Apache Parquet
- Delimited Text Files: Comma Separated Values (CSV), Tab Delimited
- JSON
- XML
Data Analytics
Provide parallel solutions for ingesting, storing, and analyzing data.
- Amazon Athena
- Apache Hadoop
- Apache Spark
- Azure Synapse Analytics
- Azure Data Lake
- Azure Databricks (Spark)
- MS SQL Analysis Services