What Are OLAP and OLTP?
There are two data processing methods: online analytical processing (OLAP) and online transaction processing (OLTP).
- OLAP is an approach to answer multi-dimensional analytical (MDA) queries swiftly in computing. The source data of OLAP is usually stored in the data warehouse (DWH) of a relational database. OLAP is a main application in DWH systems. It supports complex analysis, focuses on decision support, and provides query results that are easy to understand.
- OLTP is a transaction-oriented processing system, which immediately sends original user data to the computing center for processing and provides the processing result within a short period of time. OLTP is a main application of traditional relational databases. It processes basic and routine transactions, such as banking transactions.
Parent topic: Basic Concepts
Did this article solve your problem?
Thank you for your score！Your feedback would help us improve the website.