DEE Document List

• 0.DEE Overview
• 5.Glossary
• 10.ACID Properties
• 11.CAP Theorem
• 12.Relational vs Non-Relational
• 100.Normalization
• 101.Primary Keys and Surrogate Keys
• 102.Foreign Keys and Referential Integrity
• 103.Relationships
• 150.Indexing and Storage Overview
• 151.B-Tree Indexes
• 152.Hash Indexes
• 153.Composite Indexes
• 154.Partial and Conditional Indexes
• 155.Full-Text Search Indexes
• 200.Query and Performance Overview
• 201.Reading Execution Plans
• 202.The N+1 Query Problem
• 203.JOIN Strategies
• 204.Subqueries vs JOINs
• 205.Query Optimization Patterns
• 300.Schema Evolution Overview
• 301.Migration Fundamentals
• 302.Backward-Compatible Schema Changes
• 303.Zero-Downtime Migrations
• 304.Data Backfilling Strategies
• 305.Schema Versioning
• 400.NoSQL Patterns Overview
• 401.Document Store Modeling
• 402.Key-Value Store Patterns
• 403.Column-Family Modeling
• 404.Graph Database Modeling
• 405.Choosing the Right NoSQL Type
• 450.Caching and Search Overview
• 451.Cache-Aside Pattern
• 452.Read-Through and Write-Through Caching
• 453.Cache Invalidation Strategies
• 454.Redis Data Structures for Caching
• 455.Redis Persistence (RDB vs AOF)
• 456.Distributed Locking with Redis
• 457.Redis Pub/Sub and Streams
• 458.Full-Text Search with Elasticsearch
• 500.Application Patterns Overview
• 501.Connection Pool Configuration
• 502.ORM Pitfalls and Best Practices
• 503.Repository Pattern
• 504.Multi-Tenancy Data Isolation
• 505.Soft Delete vs Hard Delete
• 600.Operations Overview
• 601.Backup and Restore Strategies
• 602.Replication Topologies
• 603.Sharding Strategies
• 604.Database Monitoring and Alerting
• 605.Disaster Recovery