OLTP vs OLAP: what’s the difference between them?

OLTP is an online transaction system; OLAP is an online retrieval and analysis system

What is OLTP?

What is OLAP?

Putting it all together

  • OLTP is used to store and manage data for day-to-day operations;
  • OLAP is used to analyse that data.
OLTP and OLAP working together

--

--

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Imaginary Cloud

Imaginary Cloud

Applying our own Product Design Process to bring great digital products to life | www.imaginarycloud.com