EDUCBA

EDUCBA

MENUMENU
  • Free Tutorials
  • Free Courses
  • Certification Courses
  • 360+ Courses All in One Bundle
  • Login
Home Data Science Data Science Tutorials Data Warehouse Tutorial What is OLTP?
Secondary 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 Features
    • Data Warehouse Modeling
    • Data Warehouse Software
    • Data Warehousing
    • 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
    • Data Warehouse Components
    • Snowflake Schema
    • Snowflake Architecture
    • 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
    • ETL architecture
    • 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

What is OLTP?

By Savi JaggaSavi Jagga

What is OLTP

Overview of OLTP

OLTP or Online Transaction Processing is a type of data processing approach where the transactions play a major role in data manipulation in the database. This provides facts and statistics for the Business Intelligence required for the 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 that 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:-

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 a 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 concurrency and atomicity.

When two users trying to access the same data in a particular database system, none of them will be 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.

Start Your Free Data Science Course

Hadoop, Data Science, Statistics & others

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 makes 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 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 loss.
  • Clusters: It is a schema that has records of the columns that are common among different tables, which will further help in clustering. These 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 the 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 over 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, consistency, isolated and durable. This property is an essential part of the database that records the transactions made on money. One failure could lead to much big loss. Thus OLTP ensures there is no loss of transactions and maintains the ACID property to its databases.

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 the 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 to the insertion, update 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 systems, which provides greater availability and consistency. This also ensures maintaining concurrency among the database. OLTP often works differently in the 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, Definitions, and Advantages of OLTP. You can also go through our other suggested articles to learn more –

All in One Data Science Bundle(360+ Courses, 50+ projects)
Python TutorialMachine LearningAWSArtificial Intelligence
TableauR ProgrammingPowerBIDeep Learning
Price
View Courses
360+ Online Courses | 50+ projects | 1500+ Hours | Verifiable Certificates | Lifetime Access
4.7 (86,650 ratings)
  1. What is Mainframe?
  2. Career in Data Warehousing
  3. What is Data Analytics
  4. What is Neural Networks?
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
Price

View Course

Related Courses

Business Intelligence Training (12 Courses, 6+ Projects)4.9
All in One Data Science Bundle (360+ Courses, 50+ projects)4.8
Data Visualization Training (15 Courses, 5+ Projects)4.7
1 Shares
Share
Tweet
Share
Primary Sidebar
Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • Live Classes
  • 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

ISO 10004:2018 & ISO 9001:2015 Certified

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

EDUCBA
Free Data Science Course

SPSS, Data visualization with Python, Matplotlib Library, Seaborn Package

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

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA Login

Forgot Password?

By signing up, you agree to our Terms of Use and Privacy Policy.

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

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

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

By signing up, you agree to our Terms of Use and Privacy Policy.

Let’s Get Started

By signing up, you agree to our Terms of Use and Privacy Policy.

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

Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more