What is a data warehouse vs. a transactional database?
Tests your grasp of systems optimized for different access patterns (writes vs. reads). Define OLTP for transactions and OLAP for analytics. Contrast their schema (normalized vs. denormalized), data, and workload. A red flag is calling it a 'big database'.
This tests your understanding of systems optimized for different access patterns: high-throughput writes (OLTP) vs. complex analytical queries (OLAP). A great answer defines OLTP for running the business and data warehouses for analyzing it. Then, contrast their schema (normalized vs. denormalized star schema), data scope (current vs. historical), and workload (many small writes vs. few large reads).
Read the original → Wikipedia: Data warehouse
- #data modeling
- #databases
- #system design
- #analytics
Get five bites like this every day.
Tezvyn delivers a daily feed of 60-second tech bites with quizzes to lock in what you learn.