OLTP
- tags
- similar: OLAP
Acronym and Database #
OLTP or Online Transaction Processing is a type of data processing that consists of executing a number of transactions occurring concurrently— *online banking, shopping, order entry, or sending text messages, for example. These transactions traditionally are referred to as economic or financial transactions, recorded and secured so that an enterprise can access the information anytime for accounting or reporting purposes.
Online transaction processing provides transaction-oriented applications in a 3-tier architecture. OLTP administers the day-to-day transactions of an organization.
OLTP Examples #
An example considered for OLTP System is ATM Center a person who authenticates first will receive the amount first and the condition is that the amount to be withdrawn must be present in the ATM. The uses of the OLTP System are described below.
ATM center is an OLTP application.
OLTP handles the ACID properties during data transactions via the application.
It’s also used for Online banking, Online airline ticket booking, sending a text message, add a book to the shopping cart.
Benefits of OLTP Services #
OLTP services allow users to read, write and delete data operations quickly. OLTP services help in increasing users and transactions which helps in real-time access to data. OLTP services help to provide better security by applying multiple security features. OLTP services help in making better decision making by providing accurate data or current data. OLTP Services provide Data Integrity, Consistency, and High Availability to the data.
Drawbacks of OLTP Services #
OLTP has limited analysis capability as they are not capable of intending complex analysis or reporting. OLTP has high maintenance costs because of frequent maintenance, backups, and recovery. OLTP Services get hampered in the case whenever there is a hardware failure which leads to the failure of online transactions. OLTP Services many times experience issues such as duplicate or inconsistent data.