TomoLink
CompaniesMicrosoftSystem DesignHow to Choose the Right Database
System Design
Mediumdatabase-and-storage

How to Choose the Right Database

30 minsdatabase selectiondata storage
30 mins
1 sections
database selection, data storage

Overview

  • OLTP: For transactional systems requiring strong consistency
  • OLAP: Optimized for complex queries and data analysis
  • Full-Text Search: Fast, flexible text search capabilities
  • Document Stores: JSON-like document storage and querying
  • Key-Value Stores: High-speed, simple data models
  • Graph Databases: Managing highly connected data
  • Embeddings: Efficient storage and retrieval of vector representations
  • Geospatial: Specialized for location-based data and queries
How to Choose the Right Database [Medium] | Microsoft System_design | TomoLink