OLTP

OLTP or On-Line Transaction Processing applications are multi-user on-line systems where multiple users access the similar data concurrently and modify the information, that are sensitive in nature. On-Line Transaction Processing systems should ensure consistent view of data for modification in which multi-user environment and make sure that the transactions are serialized. In OLTP applications, conclusion can wait but data accuracy can’t be compromised. Instance of OLTP environment are reservation systems, stock exchange counters, betting system in racecourses, bank teller counters, and many more.

In OLTP systems the data is selected for updating critical information. So, by you get a feeling which you get concurrent data access, in fact the user operations are serialized.  i.e., they are carried out through the system one after another.

Although there is indeed a great deal of complexity in building online transaction processing systems, they can commonly be broken down into fairly standard finite steps. For instance, to update a customer’s address record and a developer would have to code the following steps:

- To update database verify user authorization
- Ask for the customer number
- Verify it is valid
- Populate the screen and Retrieve the record
- Position the cursor on the address
- Accept user input
- Verify input against any rules
- Ask for user feedback on correctness
- Rewrite the record

To the developer and user, it should be as simple as update a customer’s address record.  A system that should be concerned with the numerous steps it takes to finish the task. The Smart OLTP interfaces will take care of the detailed transaction management steps. In client or server architectures a smart OLTP interfaces hold distributed transaction management service-request management and session management.

Presently, the only client or server development tool available with a smart OLTP interface is Ellipse from cooperative solutions.