What is the difference between OLTP and OLAP?
Model answer
OLTP systems handle many small transactions (orders, logins) with normalised tables and fast writes. OLAP systems run large analytical queries over lots of historical data, often in a data warehouse with denormalised schemas such as star schemas. They are tuned differently.
Learn this topic
What Is SQL and What Is a Database? in the course SQL for Beginners: Learn Databases Step by Step.
Sign in to add your own answer.