Data Analytics Overview(OLTP vs OLAP)
You’ve likely heard about the lucrative careers of high-level Data Analysts, but have you ever wondered how they actually handle "Big Data"? Of course, they aren’t just using Microsoft Excel. To understand the technology behind it, we must first distinguish between the two primary ways we process information: OLTP and OLAP . 1. OLTP OLTP (Online Transactional Processing) is the DB used for company’s daily operations. Whenever you post on Reddit or place an order on Amazon, you are interacting with an OLTP database. It is triggered by the business's customer and handled by the backend server so that it can provide the business. Fast: It handles millions of requests with millisecond response times. Small&Frequent: It focuses on small, frequent transactions—usually just a few rows at a time. Write-intensive: Its primary job is to record or update new data as it happens. 2. OLAP OLAP (Online Analytical Processing) is the very technology we...