Database Engine Internals and Implementation
Data Systems
Implementation-focused deep dive into the single-node database engine substrate: workload shape, page and record layout, buffer pools, B-tree and LSM access paths, WAL, checkpoints, crash recovery, and the transaction boundary that builds on durable storage.
Data Architecture and Platforms
Data Systems
Architecture-level design of data platforms: source-of-truth boundaries, derived-data contracts, regional placement, serving planes, reliability controls, governance handoffs, and platform operating models.
Search Indexing and Retrieval
Search Ranking And Recommendation
Index construction, lexical retrieval models, postings mechanics, ranking baselines, and the retrieval-system boundary before serving, vector search, and evaluation tracks.
Ranking, Evaluation, and Search Quality
Search Ranking And Recommendation
Learning to rank, experimentation, evaluation pipelines, and search quality governance.
Web Crawling and Corpus Acquisition
Search Ranking And Recommendation
Crawler frontiers, politeness, canonicalization, parsing, duplicate control, freshness, corpus governance, and the handoff from web acquisition into search indexing.
Analytical Query Engines and Warehouses
Data Systems
Columnar storage, execution engines, warehouse architecture, vectorization, and the internals of large-scale analytical query systems.
Data Integration, CDC, and Pipelines
Data Systems
Change capture, ingestion contracts, backfills, schema drift, and the operational trade-offs of moving data through modern pipelines.
Data Systems Foundations
Data Systems
Data models, storage trade-offs, batch versus streaming, analytical versus transactional systems, and the basic mental models for modern data stacks.
Data Lakehouse and Storage Formats
Data Systems
Draft track for columnar formats, table metadata layers, schema evolution, compaction, and lakehouse architecture.
Metadata, Lineage, and Catalog Systems
Data Systems
Schemas, ownership, lineage graphs, discovery surfaces, and the metadata infrastructure that makes data platforms governable.
Streaming Data Infrastructure
Data Systems
Streaming ingestion, stateful processors, watermarks, checkpoints, exactly-once claims, backpressure, replay, and the platform patterns behind low-latency data movement.
Knowledge Graphs and Entity Resolution
Search Ranking And Recommendation
Entity linking, graph modeling, canonicalization, and the data structures used to connect knowledge across noisy sources.
Large-Scale Data Mining
Search Ranking And Recommendation
Approximation, sketching, distributed analytics, graph mining, clustering, and operational judgment for massive datasets without mixing in personalization product loops.
Ads, Auctions, and Marketplace Ranking
Search Ranking And Recommendation
Auction design, bidding signals, marketplace objectives, and the ranking trade-offs unique to monetized retrieval systems.
Query Understanding and Semantic Retrieval
Search Ranking And Recommendation
Intent parsing, reformulation, semantic matching, and the retrieval improvements that start from better representations of user needs.
Experimentation and Online Learning for Ranking
Search Ranking And Recommendation
Interleaving, A/B testing, bandits, feedback loops, and the online methods used to improve ranking systems safely.
Recommendation and Personalization Systems
Search Ranking And Recommendation
Candidate generation, multi-stage ranking, feedback loops, experimentation, fairness, and serving architecture for personalization systems.
Retrieval and Ranking Foundations
Search Ranking And Recommendation
Indexing basics, ranking intuition, query-document matching, and the introductory mental models behind search and recommendation quality.
Vector Search and Embedding Systems
Search Ranking And Recommendation
Draft track for embeddings, ANN indexes, hybrid retrieval, vector databases, and retrieval serving trade-offs.
In-Memory Data Systems and Redis
Data Systems
In-memory system design through Redis as the concrete case study: event loops, data structures, persistence, replication, clustering, caching, queues, locks, and operations.
NoSQL and Distributed Data Stores
Data Systems
Key-value, document, wide-column, graph, and search-oriented data stores with partitioning, replication, consistency, compaction, indexing, and operations.
Search Engine Serving and Operations
Search Ranking And Recommendation
Production search serving: schemas, analyzers, shards, query execution, aggregations, relevance tuning, hybrid search, indexing pipelines, cluster operations, and incidents.
Backend Database Operations and Query Performance
Data Systems
Operational database depth for backend engineers: connection pools, isolation, query planning, index health, sharding, replicas, failover, and split-brain prevention.
PostgreSQL Internals and Operations
Data Systems
PostgreSQL-specific depth for production systems: MVCC, WAL, locks, planner evidence, indexes, vacuum, replication, pooling, migrations, security, and operational debugging.
Transaction Manager Implementation
Data Systems
Single-node transaction-manager implementation: transaction state, isolation anomalies, lock managers, MVCC, optimistic validation, serializable snapshot isolation, undo, WAL integration, recovery, index consistency, testing, and observability.