EDUCBA

EDUCBA

MENUMENU
  • Free Tutorials
  • Free Courses
  • Certification Courses
  • 360+ Courses All in One Bundle
  • Login

What is OLTP?

By Savi JaggaSavi Jagga

Home » Data Science » Data Science Tutorials » Data Warehouse Tutorial » What is OLTP?

What is OLTP

Overview of OLTP

OLTP or Online Transaction Processing is a type of data processing approach, where the transactions play the major role for data manipulation in the database. This provides facts and statistics for the Business Intelligence required for business decision-making process. OLTP is usually applied on applications related to e-commerce, online banking, online shopping, sales and service platforms, etc. This type of data processing is known for its high performance, faster accessibility and reliable & consistent data.

Understanding OLTP

OLTP supports only those operations that are already defined. For example, In the case of online airline booking, we need to book an airline which is related to insertion in the database. OLTP ensures the availability in the cart and concurrency in case a large number of users are accessing the same website at the same time. This is done using the following characteristics of OLTP:-

Start Your Free Data Science Course

Hadoop, Data Science, Statistics & others

Understanding OLTP

  1. 3NF databases – It uses fully normalized databases to ensure the consistency and optimization of all the transactional tasks.
  2. Predefined operations – It strictly performs only the predefined operations only on the small number of records.
  3. Updation of databases is directly accessible to end users.
  4. A small number of records – It processes only a handful of records only. For example – ‘Retrieving the money from ATM.’
  5. Maintaining historical data- It stores the records of the last few days or a week to successfully perform the transactions.

How does OLTP make working so easy?

  • Online transaction process concerns about concurrency and atomicity.

When two users trying to access the same data in a particular database system, none of them will able to change the data until and unless one user has finished processing. In general, one user will process and one will wait while making any amendments. This is coined as Concurrency controls.

Atomicity controls guarantee that in a transaction all steps are completed successfully as a group. That is, if any steps between the transaction fail, all other steps must fail also

  • OLTP works only on normalized databases with a small number of records at a time in a decentralized system that optimizes all the transactional tasks being predefined to the system. OLTP stores less historical data which make it efficient.
  • As it only performs the task related to insertion/deletion, it maintains the consistency and concurrency of the data in the databases which always ensures the availability of the databases

What can you do with OLTP?

  • Its goal is to availability, speed, concurrency, and recoverability.
  • A large number of users can conduct short transactions using OLTP systems.
  • We can design such systems that help in performing operations whose database queries are usually simple, require less than second response times and return comparatively fewer records.

Working with OLTP

  • Online transaction processing (OLTP) involves gathering information as input, processing the data according to needs and updating data to reflect the processing information. It is used in a client-server system.
  • For various decentralized database systems, OLTP brokering programs distribute transactions processes among multiple computers on a network.
  • OLTP is also carried into the service-oriented architecture (SOA) and Web services.

Some crucial segments that affect the performance of OLTP are

  • Rollback segments: Rollback segments are the parts of the database that record the transactions that are rolled back. This ensures consistency in the database among several users. It also records the transactions rolled back and helps in the recovery of databases to avoid the loss.
  • Clusters: It is a schema that has records of the columns that are common among different tables which will further help in clustering. This clustering operations help in optimizing join operations.
  • Discrete transactions: The transactions that revert all the changes made into the database until the last commit refers to discrete transactions. These are crucial in case of short and non-distributed transactions.
  • Blocksize: The size of the block should be multiple of the Operating system size to avoid non-required I/O operations.
  • Buffer cache size: It is used to avoid unnecessary resource utilization by SQL statements.
  • Dynamic allocation: It refers to the space allocated to tables and rollback segments
  • Transaction processing: It is used to coordinate different transactions overs multiple computing devices. It is similar to an operating system to maintain multithreaded operations.
  • Partition (database): It is used to increase performance for parts that have transactions on a regular basis and still maintains availability and security.
  • Database tuning: An OLTP system can maximize its performance as efficiently and rapidly as possible using database tuning.

Advantages

1. Concurrency: OLTP ensures transactions made into the database should not deplete the concurrency between different users. Otherwise, the users will not be able to change or he has to wait for other users to complete so that there is not a deadlock situation.

2. Acid Compliance: ACID means a database that holds properties such as atomicity, consistent, isolated and durable. This property is an essential part of the database that records the transactions made on money. One failure could lead to many big loss. Thus OLTP ensures there is no loss of transactions and maintains the ACID property to its databases.

Popular Course in this category
All in One Software Development Bundle (600+ Courses, 50+ projects)600+ Online Courses | 3000+ Hours | Verifiable Certificates | Lifetime Access
4.6 (3,144 ratings)
Course Price

View Course

Related Courses
Business Intelligence Training (12 Courses, 6+ Projects)All in One Data Science Bundle (360+ Courses, 50+ projects)Data Visualization Training (15 Courses, 5+ Projects)

3. Availability: The latest data is available to all the users as concurrency is properly maintained.

4. Integrity: As the normalized database is maintained, integrity holds at every step in case of OLTP transactions.

Disadvantages

For such concurrency, availability and faster transactions OLTP often requires support for transactions that include many company’s networks. Thus in today’s era, we require a more decentralized system.

Examples

Some examples of OLTP systems include

  1. Order entry
  2. Retail sales
  3. Financial transaction systems
  4. CICS – Sometimes OLTP depends on transaction management software and database optimization tactics to process a greater number of simultaneous OLTP-oriented databases.

Why should we use OLTP?

1. To use less paper and make a faster, more accurate prediction of revenues and expenses.
2. The system that requires offline maintenance makes a good requirement for online transaction processing.
3. Availability, concurrency, and atomicity of data are much more important.

Why do we need OLTP?

We need OLTP to perform the tasks which are often performed by the system and require only a smaller number of records. The tasks are related insertion, updation or deletion of data in databases. Consistency and concurrency are required to perform such tasks which ensures its greater availability. OLTP maintains normalized databases and decentralized system which provides greater availability and consistency. This also ensures to maintain concurrency among the database. OLTP often works differently in case of batch processing and grid computing. On the contrary, OLAP(Online Analytic Processing) works on a greater number of tasks related to complex on databases used in main business intelligence tasks.

Conclusion

OLTP is a type of data processing where a large number of users make transactions i.e. updation, insertion or deletion that deals with a smaller number of records. It always ensures concurrency, atomicity, availability of data using normalized databases, decentralized systems, and less historical data.

Recommended Articles

This has been a guide to What is OLTP. Here we discussed the Basic concepts, Definition, and Advantages of OLTP. You can also go through our other suggested articles to learn more –

  1. What is Mainframe?
  2. Career in Data Warehousing
  3. What is Data Analytics
  4. What is Neural Networks?

All in One Software Development Bundle (600+ Courses, 50+ projects)

600+ Online Courses

3000+ Hours

Verifiable Certificates

Lifetime Access

Learn More

1 Shares
Share
Tweet
Share
Primary Sidebar
Data Warehouse Tutorial
  • Basic
    • What is Data Warehouse
    • Data Warehouse tools
    • Career in Data Warehousing
    • Benefits of Data Warehouse
    • Data Warehouse Architecture
    • Data Warehouse Design
    • Data Warehouse Implementation
    • Data Warehouse Modeling
    • Data Warehouse Software
    • Types of Data Warehouse
    • 10 Popular Data Warehouse Tools
    • Data Lake Architecture
    • Three Tier Data Warehouse Architecture
    • Data Warehouse Process
    • Database Parallelism
    • What is OLTP
    • What is OLAP
    • OLAP Tools
    • Types of OLAP
    • Operations in OLAP
    • MOLAP
    • HOLAP
    • Data Warehouse Schema
    • Snowflake Schema
    • What is Star Schema
    • Galaxy Schema
    • What is Fact Table
    • Kimball Methodology
    • Data Warehouse Testing
    • Operational Data Stores
  • ETL
    • What is Data Mart
    • What is Data Cube
    • What is a Data Lake
    • What is Data Integration
    • What is ETL
    • What is ETL Testing
    • ETL Testing Tools
    • Dimension Table
    • Multidimensional Data Model
    • Fact Constellation Schema
    • ETL Process
  • Interview Questions
    • Data Warehouse Interview Questions
    • ETL Interview Questions
    • ETL Testing Interview Questions
    • Data Warehousing Interview Questions

Related Courses

Business Intelligence Course

All in One Data Science Course

Data Visualization Certification Courses

Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • Corporate Training
  • Certificate from Top Institutions
  • Contact Us
  • Verifiable Certificate
  • Reviews
  • Terms and Conditions
  • Privacy Policy
  •  
Apps
  • iPhone & iPad
  • Android
Resources
  • Free Courses
  • Database Management
  • Machine Learning
  • All Tutorials
Certification Courses
  • All Courses
  • Data Science Course - All in One Bundle
  • Machine Learning Course
  • Hadoop Certification Training
  • Cloud Computing Training Course
  • R Programming Course
  • AWS Training Course
  • SAS Training Course

© 2020 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA Login

Forgot Password?

EDUCBA
Free Data Science Course

Hadoop, Data Science, Statistics & others

*Please provide your correct email id. Login details for this Free course will be emailed to you
Book Your One Instructor : One Learner Free Class

Let’s Get Started

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA
Free Data Science Course

Hadoop, Data Science, Statistics & others

*Please provide your correct email id. Login details for this Free course will be emailed to you

Special Offer - All in One Software Development Bundle (600+ Courses, 50+ projects) Learn More