I'm preparing for
Topic · IT & Coding
system design
116 shorts across 1 course, in learning order
🎛️ Narrow down IT & Codingsubject · level · topic1▾
Results · 15 for “Advanced Query Techniques”
← Front page✨ Smart search: matched by meaning, not just words

⚡ One HLD concept. 60 seconds. Interview ready
Elasticsearch Pagination: From & Size vs Search After
Elasticsearch offers two pagination methods: from & size for shallow pages and search_after for deep pages.

⚡ One HLD concept. 60 seconds. Interview ready
Elasticsearch Filters vs Queries: MUST vs FILTER Explained
Filters check conditions without affecting relevance, while queries do.

⚡ One HLD concept. 60 seconds. Interview ready
HLD: Search Engine Architecture and Its Components
Search engines collect, index, retrieve, and rank documents to provide relevant results.

⚡ One HLD concept. 60 seconds. Interview ready
HLD: Full-Text Search vs Database Search with Elasticsearch
Choose Elasticsearch for complex text searches, but use databases for structured queries.

⚡ One HLD concept. 60 seconds. Interview ready
Identifying and Optimizing Database Bottlenecks
Database bottlenecks slow down performance, but identifying them helps optimize and scale effectively.

⚡ One HLD concept. 60 seconds. Interview ready
B-Tree Index: Efficient Database Navigation
B-Trees help databases find data quickly without scanning every row.

⚡ One HLD concept. 60 seconds. Interview ready
Inverted Index: How Search Engines Find Pages Efficiently
An inverted index helps search engines quickly find documents containing specific terms.

⚡ One HLD concept. 60 seconds. Interview ready
Elasticsearch Query Execution: How Searches Work Across Shards
Elasticsearch distributes search queries across shards to find and retrieve results quickly.

⚡ One HLD concept. 60 seconds. Interview ready
Understanding the Cache-Aside Pattern in System Design
The Cache-Aside Pattern speeds up data retrieval by using a cache to store frequently accessed data.

⚡ One HLD concept. 60 seconds. Interview ready
Understanding Cache Breakdown and Request Coalescing
Cache breakdowns can overwhelm databases, but request coalescing solves this issue.

⚡ One HLD concept. 60 seconds. Interview ready
SQL vs NoSQL: Choosing the Right Database for Your Needs
The choice between SQL and NoSQL databases depends on your application's specific needs.

⚡ One HLD concept. 60 seconds. Interview ready
Understanding Cache Penetration in System Design
Cache penetration occurs when requests for non-existent data overload the database.

⚡ One HLD concept. 60 seconds. Interview ready
Elasticsearch Zero-Downtime Reindexing: The Alias Switch Trick
You can update Elasticsearch indices without downtime using alias switching.

⚡ One HLD concept. 60 seconds. Interview ready
Elasticsearch Fuzzy Search: Handling Typos in Queries
Elasticsearch fuzzy search allows finding results even with typos in queries.

⚡ One HLD concept. 60 seconds. Interview ready
Elasticsearch Aliases and Rollover: Zero-Downtime Index Switching
Elasticsearch aliases allow zero-downtime switching between indices for applications.
🧠Related by meaning
Not tagged “system design”, but closely connected

