What is OLTP?

Asked 06-Dec-2019
Viewed 423 times

1 Answer


In a three-tier design, OLTP is an operating system that supports transaction-oriented applications. It is in charge of an organization's day-to-day operations. OLTP is primarily concerned with query processing, data integrity in multi-access scenarios, and effectiveness, which is assessed in terms of total transactions per second. OLTP stands for Online Transaction Processing in its full form.

An online database changing system is known as an OLTP system. As a result, it allows database queries including inserting, updating, and deleting data from the database.

The following are some of the most important properties of OLTP:

  • In OLTP, transactions containing little amounts of data are employed.
  • The database's indexed data is easily accessible.
  • There are a lot of people who use OLTP.
  • Its response times are quick.
  • End-users have direct access to databases.
  • OLTP uses a fully normalized structure to ensure database consistency.
  • The OLTP system is quick to respond.
  • It strictly performs the predefined operations on a small number of records.
  • The records from the previous several days or a week are stored in OLTP.
  • It is capable of handling complex data models and tables.

The ATM center is an example of an OLTP system. Assume that a couple has a joint bank account. One day, they both arrive at different ATM terminals at the same time and want to withdraw the entire balance in their bank accounts.

The individual who completes the authentication process first, on the other hand, will be allowed to receive money. In this situation, the OLTP system ensures that the amount withdrawn is never greater than the amount in the bank. The important thing to keep in mind is that OLTP systems are designed for transactional supremacy rather than data analysis.