⚡ SnapGyan by Tejav

💻 IT & Coding concepts,
clear in 60 seconds.

I'm preparing for

Topic · IT & Coding

system design

116 shorts across 1 course, in learning order

🎛️ Narrow down IT & Coding1▾

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.

Medium5m5 MCQs

⚡ One HLD concept. 60 seconds. Interview ready

Elasticsearch Filters vs Queries: MUST vs FILTER Explained

Filters check conditions without affecting relevance, while queries do.

Medium5m5 MCQs

⚡ 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.

Medium5m5 MCQs

⚡ 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.

Medium5m5 MCQs

⚡ 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.

Medium5m5 MCQs

⚡ One HLD concept. 60 seconds. Interview ready

B-Tree Index: Efficient Database Navigation

B-Trees help databases find data quickly without scanning every row.

Medium5m5 MCQs

⚡ 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.

Medium5m5 MCQs

⚡ 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.

Medium5m5 MCQs

⚡ 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.

Medium5m5 MCQs

⚡ One HLD concept. 60 seconds. Interview ready

Understanding Cache Breakdown and Request Coalescing

Cache breakdowns can overwhelm databases, but request coalescing solves this issue.

Medium5m5 MCQs

⚡ 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.

Medium5m5 MCQs

⚡ 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.

Medium5m5 MCQs

⚡ 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.

Medium5m5 MCQs

⚡ 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.

Medium5m5 MCQs

⚡ 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.

Medium5m5 MCQs

🧠Related by meaning

Not tagged “system design”, but closely connected