Glossary term
What is OLAP (Online Analytical Processing)?
OLAP stands for Online Analytical Processing.
Big queries over lots of data. Example: "Revenue by city for last year.".
Learn it properly · System DesignLesson 5: SQL Basics Every System Designer NeedsBefore sharding, replicas or NoSQL, learn to use one relational database well. Tables and keys, the queries you will write every day, indexes and EXPLAIN, the N+1 trap, transactions, and the connection limit that takes databases down.