introduce

OLTP (Online Transaction Processing) is a category of data processing that handles a large number of transactions performed by many users.

An oltp database system is an online database system that handles daily queries, usually involving inserting, updating, and deleting data.

In this article, you will learn what OLTP is, its features, advantages, disadvantages, and how it differs from OLAP.
OLTP databases store and manage data related to the day-to-day operations of a system or company. However, OLTP focuses on transaction-oriented tasks.

OLTP typically handles query processing (inserting, updating, deleting data in a database) and maintaining data integrity and validity while processing a large number of transactions simultaneously.

OLTP and OLAP
OLTP and OLAP are two complementary systems. OLTP handles the day-to-day transactions while OLAP helps in analyzing the processed data.
Features of OLTP
Some basic characteristics of OLTP are:

Handles transactions involving small amounts of data.
Has indexed access to data (faster access).
Support a large number of users.
Handles frequent queries and updates.
Response time is measured in milliseconds.
OLTP architecture
OLTP systems are based on a 3-tier architecture. A three-tier architecture organizes applications into three logical and physical computing tiers:

Presentation layer (UI).
Application layer (data processing).
Data layer (data storage and management).
Each of the three tiers is independent, has its own infrastructure, development, and update intervals, and does not affect the other tiers.

Business strategy. The top management of a company usually sets the business strategy. Business strategy deals with issues that affect the entire company.
Business Process. A set of activities and tasks that, upon completion, achieve company goals.
Customers, Transactions, etc. A database that stores information about products, transactions, customers, suppliers, etc.