Build a high-throughput Search Pipeline

Last updated: May 8, 2026

Quick Overview

Design a high-throughput search system that handles millions of requests. Discuss trade-offs in consistency, availability, and performance.

Oracle
System Design
Machine Learning Engineer
Oracle
May 8, 2026
Machine Learning Engineer
Onsite
System Design
Easy

1

14

1,292 solved


Design a high-throughput search system that handles millions of requests. Discuss trade-offs in consistency, availability, and performance.

System design interviews at Oracle typically last 45-60 minutes. You are expected to drive the conversation, starting from requirements gathering through to a detailed architecture. The interviewer will evaluate your ability to handle ambiguity and make practical engineering decisions.

What the Interviewer Expects
  • Clearly define functional and non-functional requirements
  • Propose a reasonable high-level architecture with core components
  • Choose appropriate data storage solutions with basic justification
  • Discuss basic scaling strategies (horizontal scaling, caching)
  • Identify potential bottlenecks and suggest simple solutions
Key Topics to Cover
Consistency models and replication
Database selection and data modeling
Monitoring, logging, and alerting
Requirements gathering and capacity estimation
How to Approach This
  1. Start by clarifying functional and non-functional requirements with the interviewer.
  2. Estimate the scale: QPS, storage, bandwidth. This drives your design decisions.
  3. Draw a high-level architecture first, then deep dive into 1-2 critical components.
  4. Discuss trade-offs explicitly (e.g., consistency vs availability, SQL vs NoSQL).
  5. Address failure scenarios, monitoring, and how the system handles 10x traffic spikes.
Possible Follow-up Questions
  • What monitoring and alerting would you set up on day one?
  • How do you ensure data consistency across multiple services?
  • How would you migrate from a monolithic to a microservices architecture?
  • What would the deployment pipeline look like for this system?
Practice a Similar Problem on Codemia

Solve a related problem with our interactive workspace, get AI feedback, and view detailed solutions.

Solve on Codemia
Sample Answer
Requirements Clarification

Before diving into the architecture, clarify the scope with the interviewer. For high-throughput Search Pipeline, key functional requirements include:...

Capacity Estimation

Estimate the scale to drive design decisions. Assume 100M DAU with an average of 10 actions per user per day = 1B requests/day ~ 12K QPS average, ~36K...


Submit Your Answer
Markdown supported

Related Questions