eli5: What is the difference between OLAP and OLTP
In: 2
*The main difference between OLAP and OLTP: Processing type The main distinction between the two systems is in their names: analytical vs. transactional. Each system is optimized for that type of processing.*
*OLAP is optimized for conducting complex data analysis for smarter decision-making. OLAP systems are designed for use by data scientists, business analysts and knowledge workers, and they support business intelligence (BI), data mining and other decision support applications.*
*OLTP, on the other hand, is optimized for processing a massive number of transactions. OLTP systems are designed for use by frontline workers (e.g., cashiers, bank tellers, hotel desk clerks) or for customer self-service applications (e.g., online banking, e-commerce, travel reservations).*
Edit: Not my write up, pulled it from here. Short answer, one is looking at more abstract data concepts and the other more transactional.
[https://www.ibm.com/cloud/blog/olap-vs-oltp](https://www.ibm.com/cloud/blog/olap-vs-oltp)
Latest Answers