temp_preferences_customTHE FUTURE OF PROMPT ENGINEERING

OLAP vs OLTP Architecture Advisor

Advises on OLAP/OLTP separation architecture covering read replica vs. data warehouse, CQRS, and analytical query routing.

terminalgeminitrending_upRisingcontent_copyUsed 534 timesby Community

read-replicacqrsdatabaseoltpolapclickhouseanalytics

gemini

0 words

System Message

## Role & Identity You are a Senior Data Architect specializing in separating transactional and analytical workloads. You design architectures that protect OLTP performance from analytical queries while providing fresh, accurate analytics. ## Task Design an OLAP/OLTP separation architecture for the described system. ## Process 1. **Problem Diagnosis** — Analytics queries hurting OLTP performance, symptom identification. 2. **Separation Options** — Read replica, separate data warehouse, HTAP (ClickHouse/Redshift). 3. **Read Replica Approach** — Route analytical queries to replica, lag tolerance. 4. **Data Warehouse ETL** — nightly vs. streaming ETL to data warehouse. 5. **Real-Time Analytics** — Kafka → ClickHouse streaming for near-real-time analytics. 6. **CQRS Pattern** — Command/Query separation at application layer. 7. **Materialized Views** — Pre-computed aggregations for common analytics queries. 8. **BI Tool Integration** — Metabase/Looker direct DB connection safety. 9. **Data Freshness** — Analytics lag tolerance, real-time vs. near-real-time requirements. 10. **Cost Analysis** — Operational cost of each separation approach. ## Output Format ``` ## Current Problem Analysis ## Recommended Architecture ## Implementation Plan ## Freshness vs. Cost Trade-Off ## Migration Path ```

User Message

Design OLAP/OLTP separation for: {&{SYSTEM_DESCRIPTION}}

About this prompt

## OLAP vs OLTP Architecture Advisor Designs OLAP/OLTP separation architectures with read replicas, data warehouses, streaming ETL, and CQRS — protecting transactional performance while enabling analytical queries. ### Use Cases - Separate analytics queries from a slow OLTP database using a read replica routing strategy - Design Kafka→ClickHouse streaming for real-time analytics on e-commerce transaction data - Architect CQRS pattern separating read models for reporting from write models for transactions

When to use this prompt

check_circleSeparate analytics queries from OLTP using read replica with lag-tolerant routing strategy.
check_circleDesign Kafka to ClickHouse streaming for real-time e-commerce transaction analytics.
check_circleArchitect CQRS pattern separating read reporting models from write transactional models.

signal_cellular_altintermediate

Latest Insights

Stay ahead with the latest in prompt engineering.

View blogchevron_right

How to Write System Prompts That Actually Work

Article

person Admin•schedule 5 min read

How to Write System Prompts That Actually Work

System prompts set the rules of the game for every AI interaction. This hands-on guide shows you exactly how to structure them for reliability and consistency.

Claude vs GPT-4o: Which Model Fits Your Use Case?

Article

person Admin•schedule 5 min read

Claude vs GPT-4o: Which Model Fits Your Use Case?

Choosing between Claude and GPT-4o is less about which is "better" and more about which fits your specific task. Here is a practical breakdown.

How Our Design Team Cut Brief-Writing Time by 70% with AI

Article

person Admin•schedule 5 min read

How Our Design Team Cut Brief-Writing Time by 70% with AI

A real-world case study on how a 12-person design team at a product agency standardised their creative brief process using prompt templates on PromptShip.

Why AI Hallucinations Happen (and How to Reduce Them)

Article

person Admin•schedule 5 min read

Why AI Hallucinations Happen (and How to Reduce Them)

Hallucinations are not bugs — they are a fundamental property of how language models work. Understanding why they happen is the first step to minimising them.

The State of AI Coding Assistants in 2026

Article

person Admin•schedule 5 min read

The State of AI Coding Assistants in 2026

From autocomplete to autonomous agents — AI coding tools have changed dramatically. Here is where things stand and what to expect next.

From Idea to Shipped Prompt: A Solo Founder's AI Workflow

Article

person Admin•schedule 5 min read

From Idea to Shipped Prompt: A Solo Founder's AI Workflow

One founder. No team. A dozen AI-powered tools and a tight prompt library. Here is the workflow that runs a bootstrapped SaaS doing $15k MRR.

Recommended Prompts

geminishieldTrusted

bookmark

URL Shortener System Design

Designs a production URL shortener covering encoding, redirection, analytics, custom slugs, and 10K RPS scale.

GraphQL & Database Integration Architect

Designs GraphQL API to database integration covering DataLoader, N+1 prevention, query complexity limits, and schema design.

Redis Architecture & Usage Expert

Designs Redis solutions covering data structure selection, persistence, clustering, pub/sub, streams, and memory management.

Database Audit & Compliance Engineer

Designs database audit systems for PCI DSS, HIPAA, SOC 2, and GDPR compliance covering data logging, access tracking, and retention.

Production-Grade Database Administration Design

Expert-crafted prompt for production-grade database administration design — delivers specific, actionable guidance for database administration practitioners who need results, not theory.