What’s the difference between OLTP and OLAP?

OLTP and OLAP look similar but refer to different kinds of database systems. Both of them are online processing systems. When we talk about databases, most people think of OLTP. We can suppose that OLTP systems provide source data to the OLAP systems that help us to analyze the data.

What’s OLTP?

OLTP stands for Online Transactional Processing and the main focus of OLTP is to excel in looking up filtered information and manage current Update, Insertion, and Deletion while a transaction.OLTP workloads consist of short transaction that runs in a small period concurrently. So OLTP database effectiveness can be measured by the number of transactions per second.

Common tasks for OLTP:

• What is the userID of the current user?
• What is the current location of the user?
• Delete billing information of a specific user or group.
• Update user information.

Common OLTP systems :

• Mysql
• Oracle Database
• Postgresql
• Microsoft SQL
• IBM DB2

What’s OLAP?