#Online transaction processing system pdf update#

Whereas OLTP systems process all kinds of queries (read, insert, update and delete), OLAP is generally optimized for read only and might not even support other kinds of queries. OLTP is typically contrasted to OLAP (online analytical processing), which is generally characterized by much more complex queries, in a smaller volume, for the purpose of business intelligence or reporting rather than to process transactions. However, like many modern online information technology solutions, some systems require offline maintenance, which further affects the cost-benefit analysis of an online transaction processing system. Reduced paper trails and the faster, more accurate forecast for revenues and expenses are both examples of how OLTP makes things simpler for businesses. The key goals of OLTP applications are availability, speed, concurrency and recoverability. These applications are used concurrently by hundreds of users. Online transaction processing applications have high throughput and are insert- or update-intensive in database management.

An automated teller machine (ATM) for a bank is an example of a commercial transaction processing application. OLTP has also been used to refer to processing in which the system responds immediately to user requests. ) : 50 OLTP may use transactions of the first type to record transactions of the second.

The term 'transaction' can have two different meanings, both of which might apply: in the realm of computers or database transactions it denotes an atomic change of state, whereas in the realm of business or finance, the term typically denotes an exchange of economic entities (as used by, e.g., Transaction Processing Performance Council or commercial transactions. In online transaction processing ( OLTP), information systems typically facilitate and manage transaction-oriented applications.