Skip to content

Concept List: The Right Database

Total Concepts: 220 Generated: 2026-05-14

ATAM Methodology

  1. Architecture Tradeoff Analysis
  2. Quality Attribute Workshop
  3. Utility Tree
  4. Quality Attribute Scenario
  5. Architectural Driver
  6. Sensitivity Point
  7. Tradeoff Point
  8. Architectural Risk
  9. Non-Risk
  10. Risk Theme
  11. Utility Tree Prioritization
  12. ATAM Stakeholder Roles
  13. Business Driver
  14. Architectural Approach
  15. ATAM Evaluation Team
  16. ATAM Nine-Step Process
  17. Architectural Decision Record
  18. Quality Attribute Refinement
  19. Scenario Stimulus
  20. Scenario Response Measure
  21. ATAM Output Artifacts
  22. Software Architecture View

Foundation Concepts

  1. Database Management System
  2. Data Model
  3. Schema
  4. Query Language
  5. Database Index
  6. Query Optimizer
  7. Storage Engine
  8. Data Serialization
  9. Workload Characterization
  10. Read/Write Ratio
  11. Latency vs Throughput
  12. OLTP Workload
  13. OLAP Workload
  14. HTAP Workload
  15. Data Volume Scaling
  16. Impedance Mismatch
  17. Query Expressiveness
  18. Operational Complexity

Relational Databases

  1. Relational Data Model
  2. SQL
  3. Primary Key
  4. Foreign Key
  5. Normalization
  6. First Normal Form
  7. Third Normal Form
  8. Join Operation
  9. B-Tree Index
  10. Query Execution Plan
  11. Stored Procedure
  12. Database View
  13. Transaction Log
  14. Write-Ahead Log
  15. Multi-Version Concurrency
  16. Lock-Based Concurrency
  17. Deadlock Detection
  18. Connection Pooling
  19. PostgreSQL
  20. MySQL

Analytical Databases

  1. Columnar Storage
  2. Massively Parallel Processing
  3. Data Warehouse
  4. Star Schema
  5. Snowflake Schema
  6. OLAP Cube
  7. ETL Pipeline
  8. Inmon Architecture
  9. Kimball Architecture
  10. Bitmap Index
  11. Materialized View
  12. Query Pushdown
  13. Snowflake Database
  14. BigQuery
  15. Apache Parquet Format

Key-Value Stores

  1. Key-Value Data Model
  2. Hash Table Storage
  3. Time-to-Live
  4. Cache Eviction Policy
  5. Redis
  6. DynamoDB
  7. Read-Through Cache
  8. Write-Through Cache
  9. Write-Behind Cache
  10. Cache Stampede
  11. Hot Key Problem
  12. Key Expiration

Column-Family Databases

  1. Column-Family Data Model
  2. Wide Row
  3. LSM Tree
  4. Compaction Strategy
  5. Bloom Filter
  6. Apache Cassandra
  7. Apache HBase
  8. Partition Key
  9. Clustering Column
  10. Write-Optimized Storage
  11. Read Amplification
  12. Write Amplification

Graph Databases

  1. Property Graph Model
  2. RDF Graph Model
  3. SPARQL
  4. Cypher Query Language
  5. Graph Traversal Algorithm
  6. Depth-First Search
  7. Breadth-First Search
  8. Shortest Path Algorithm
  9. Neo4j
  10. TigerGraph
  11. Amazon Neptune
  12. Distributed Graph Database
  13. Graph Partitioning
  14. GSQL
  15. Knowledge Graph

Document Databases

  1. Document Data Model
  2. JSON Document Storage
  3. BSON Format
  4. Embedded Document
  5. Document Reference
  6. Aggregation Pipeline
  7. Schema Flexibility
  8. MongoDB
  9. Couchbase
  10. Compound Index
  11. Full-Text Search Index
  12. Change Stream

CAP Theorem and Consistency Models

  1. CAP Theorem
  2. Consistency (CAP)
  3. Availability (CAP)
  4. Partition Tolerance
  5. CP Database System
  6. AP Database System
  7. PACELC Model
  8. Latency-Consistency Tradeoff
  9. Eventual Consistency
  10. Strong Consistency
  11. Read-Your-Writes Consistency
  12. Monotonic Read Consistency
  13. Causal Consistency
  14. Session Consistency
  15. Linearizability
  16. Serializability
  17. BASE Semantics
  18. Conflict Resolution
  19. Vector Clock
  20. Gossip Protocol

ACID and Transactions

  1. Atomicity
  2. Consistency (ACID)
  3. Isolation
  4. Durability
  5. Transaction Isolation Level
  6. Read Uncommitted
  7. Read Committed
  8. Repeatable Read
  9. Serializable Isolation
  10. Dirty Read
  11. Phantom Read
  12. Non-Repeatable Read
  13. Two-Phase Locking
  14. Optimistic Concurrency Control
  15. Savepoint
  16. Rollback
  17. Commit Protocol
  18. Distributed Saga

Distributed ACID and NewSQL

  1. Two-Phase Commit
  2. Three-Phase Commit
  3. Distributed Transaction Coordinator
  4. Saga Orchestration
  5. Saga Choreography
  6. Compensating Transaction
  7. NewSQL Database
  8. Google Spanner
  9. CockroachDB
  10. YugabyteDB
  11. TrueTime API
  12. Global Transaction ID
  13. Cross-Shard Transaction
  14. Paxos Protocol
  15. Raft Consensus Protocol
  16. ZAB Protocol

Distributed Systems and Scaling

  1. Horizontal Scaling
  2. Vertical Scaling
  3. Data Sharding
  4. Range-Based Sharding
  5. Hash-Based Sharding
  6. Directory-Based Sharding
  7. Geographic Sharding
  8. Database Replication
  9. Single-Leader Replication
  10. Multi-Leader Replication
  11. Leaderless Replication
  12. Quorum Read/Write
  13. Read Replica
  14. Replication Lag
  15. Split-Brain Problem
  16. Leader Election
  17. ZooKeeper Coordination
  18. etcd

High Availability

  1. High Availability
  2. Five-Nines Availability
  3. SLA Decomposition
  4. Failure Domain
  5. Single Point of Failure
  6. Active-Active Clustering
  7. Active-Passive Clustering
  8. Failover
  9. Heartbeat Monitoring
  10. Chaos Engineering
  11. Mean Time Between Failures
  12. Mean Time to Recovery
  13. Geographic Redundancy
  14. Multi-Region Deployment
  15. Circuit Breaker Pattern

Vector Search and Embeddings

  1. Vector Embedding
  2. Embedding Dimensionality
  3. Cosine Similarity
  4. Dot Product Similarity
  5. Euclidean Distance
  6. Approximate Nearest Neighbor
  7. HNSW Index
  8. IVF Index
  9. Flat Vector Index
  10. pgvector Extension
  11. Semantic Search
  12. Hybrid Search
  13. Native Vector Search Feature
  14. ANN Recall vs Speed

LLM Embeddings

  1. Large Language Model
  2. Transformer Architecture
  3. Tokenization
  4. Attention Mechanism
  5. CLS Token Pooling
  6. Mean Pooling
  7. Embedding Model Selection
  8. OpenAI Embeddings API
  9. Sentence Transformers
  10. Self-Hosted Embedding Model
  11. Embedding Cost at Scale
  12. Re-Embedding Migration
  13. Multimodal Embedding
  14. Embedding Pipeline Architecture
  15. Embedding Model Versioning

Database Selection and Polyglot Persistence

  1. Polyglot Persistence
  2. Database Selection Framework
  3. Scoring Matrix
  4. Total Cost of Ownership
  5. Vendor Lock-In Risk
  6. Database Migration Plan
  7. Schema Migration
  8. Multi-Model Database
  9. Operational Runbook
  10. Team Expertise Factor
  11. Database Deprecation Risk
  12. Data Access Pattern Analysis