Database Engineering & Data Systems Topics
Database design patterns, optimization, scaling strategies, storage technologies, data warehousing, and operational database management. Covers database selection criteria, query optimization, replication strategies, distributed databases, backup and recovery, and performance tuning at database layer. Distinct from Systems Architecture (which addresses service-level distribution) and Data Science (which addresses analytical approaches).
Caching and Connection Management
The layer between application and database: cache strategies (cache-aside, write-through, invalidation) for query results, connection pooling and lifecycle, and efficient application-to-database interaction. Covers reducing database load, avoiding pool exhaustion, and the consistency trade-offs caching introduces. Bridges application performance and database health.
Client-Side and Mobile Data Persistence
Storing data on devices and clients: embedded and mobile databases (SQLite and similar), local caching, offline-first persistence and sync, and durable save/state systems for applications and games. Covers constrained-storage design, conflict resolution on sync, and persisting state reliably outside a central server. Serves mobile and game development interviews.