Open In App

On Line Transaction Processing (OLTP) System in DBMS

Last Updated : 19 Aug, 2019
Like Article

On-Line Transaction Processing (OLTP) System refers to the system that manage transaction oriented applications. These systems are designed to support on-line transaction and process query quickly on the Internet.
For example: POS (point of sale) system of any supermarket is a OLTP System.

Every industry in today’s world use OLTP system to record their transactional data. The main concern of OLTP systems is to enter, store and retrieve the data. They covers all day to day operations such as purchasing, manufacturing, payroll, accounting, etc.of an organization. Such systems have large numbers of user which conduct short transaction. It supports simple database query so the response time of any user action is very fast.

The data acquired through an OLTP system is stored in commercial RDBMS, which can be used by an OLAP System for data analytics and other business intelligence operations.

Some other examples of OLTP systems include order entry, retail sales, and financial transaction systems.

Advantages of an OLTP System:

  • OLTP Systems are user friendly and can be used by anyone having basic understanding
  • It allows its user to perform operations like read, write and delete data quickly.
  • It responds to its user actions immediately as it can process query very quickly.
  • This systems are original source of the data.
  • It helps to administrate and run fundamental business tasks
  • It helps in widening customer base of an organization by simplifying individual processes

Challenges of an OLTP system:

  • It allows multiple users to access and change the same data at the same time. So it requires concurrency control and recovery mechanism to avoid any unprecedented situations
  • The data acquired through OLTP systems are not suitable for decision making. OLAP systems are used for the decision making or “what if” analysis.

Type of queries that an OLTP system can Process:
An OLTP system is an online database modifying system. So it supports database query like INSERT, UPDATE and DELETE information from the database. Consider a POS system of a supermarket, Below are the sample queries that it can process –

  • Retrieve the complete description of a particular product
  • Filter all products related to any particular supplier
  • Search for the record of any particular customer.
  • List all products having price less than Rs 1000.

Type of queries that an OLTP system can not Process:
An OLTP system supports simple database query like INSERT, UPDATE and DELETE only. It does not support complex query. Reconsider the POS system of the supermarket, Below are the sample queries that it can not process –

  • How much discount should they offer on a particular product?
  • Which product should be introduced to its customer ?

To read difference between an OLTP system and an OLAP system, Please refer the following article-

Similar Reads

Online Transaction Processing (OLTP) and Online Analytic Processing (OLAP)
Online Transaction Processing (OLTP): OLTP databases are meant to be used to do many small transactions, and usually serve as a "single source of storage". An example of OLTP system is online movie ticket booking website. Suppose two persons at the same time wants to book the same seat for the same movie for same movie timing then in this case whoe
5 min read
Difference between Data Warehousing and Online transaction processing (OLTP)
1. Data Warehousing : Data Warehousing is a technique that gathers or collects data from different sources into a central repository, or, in other words, a single, complete, and consistent store of data that is obtained from different sources. It is a powerful database model that enhances the user ability to analyze huge, multidimensional datasets;
2 min read
Difference between OLAP and OLTP in DBMS
Pre-Requisite: OLAP, OLTP OLAP stands for Online Analytical Processing. OLAP systems have the capability to analyze database information of multiple systems at the current time. The primary goal of OLAP Service is data analysis and not data processing. OLTP stands for Online Transaction Processing. OLTP has the work to administer day-to-day transac
5 min read
Introduction to Transaction Processing
Single user system : In this at-most, only one user at a time can use the system. Multi-user system : In the same, many users can access the system concurrently. Concurrency can be provided through : Interleaved Processing - In this, the concurrent execution of processes is interleaved in a single CPU. The transactions are interleaved, meaning the
2 min read
Transaction Isolation Levels in DBMS
Prerequisite - Concurrency control in DBMS, ACID Properties in DBMS As we know, in order to maintain consistency in a database, it follows ACID properties. Among these four properties (Atomicity, Consistency, Isolation, and Durability) Isolation determines how transaction integrity is visible to other users and systems. It means that a transaction
5 min read
Transaction States in DBMS
States through which a transaction goes during its lifetime. These are the states which tell about the current state of the Transaction and also tell how we will further do the processing in the transactions. These states govern the rules which decide the fate of the transaction whether it will commit or abort. They also use Transaction log. Transa
2 min read
Transaction Control in DBMS
The transaction is a single logical unit that accesses and modifies the contents of the database. Transactions access data using read and write operations. Transaction is a single operation of processing that can have many operations. Transaction is needed when more than one user wants to access same database. Transaction has ACID properties. [capt
5 min read
Transaction in DBMS
When the data of users is stored in a database, that data needs to be accessed and modified from time to time. This task should be performed with a specified set of rules and in a systematic way to maintain the consistency and integrity of the data present in a database. In DBMS, this task is called a transaction. It is similar to a bank transactio
10 min read
Query Processing in Distributed DBMS
Query processing in a distributed database management system requires the transmission of data between the computers in a network. A distribution strategy for a query is the ordering of data transmissions and local data processing in a database system. Generally, a query in Distributed DBMS requires data from multiple sites, and this need for data
5 min read
Pipeline in Query Processing in DBMS
Database system processing in a satisfactory manner encompasses providing fast responses to data retrieval and manipulation tasks, with two of the keywords being performance and responsiveness. A concept that acts as the foundational element in improving batch processing performance is called "pipeline." In this article, the network of rungs or pip
5 min read
Article Tags :