OLAP vs OLTP Databases

Problem

You need to choose a database for a high-frequency banking API (handling millions of rapid inserts) and another for business analytics (handling aggregations). Write a query that outputs comparison with the value: "OLTP databases are optimized for rapid, row-based transactional writes, whereas OLAP databases are optimized for columnar, read-heavy analytical aggregations."

Database Schema

This problem acts as a scratchpad. You will write your own DDL/DML or conceptual queries, so there is no predefined schema.

Try It

Hint

Solution