Online Transaction Processing System

4954 Words20 Pages
What is an OLTP System? Online Transaction Processing (OLTP) systems are one of the most common data processing systems in today's enterprises. Classical examples of OLTP systems are order entry, retail sales, and financial transaction systems. OLTP systems are primarily characterized through a specific data usage that is different from data warehousing environments, yet some of the characteristics, such as having large volumes of data and lifecycle-related data usage and importance, are identical. The main characteristics of an OLTP environment are: * Short response time The nature of OLTP environments is predominantly any kind of interactive ad hoc usage, such as telemarketeers entering telephone survey results. OLTP systems require…show more content…
A partition management operation generates less redo than the equivalent DML operations. * Potential higher concurrency through elimination of hot spots A common scenario for OLTP environments is to have monotonically increasing index values that are used to enforce primary key constraints, thus creating areas of high concurrency and potential contention: every new insert tries to update the same set of index blocks. Partitioned indexes, in particular hash-partitioned indexes, can help to alleviate this situation. Online transaction processing has become the order of the day. Online transaction processing undergoes constant improvisation and change to stay in tune with the market demands. Online transaction processing is said to be the key factor in deciding a company's stake in the market for the competitors may otherwise have an edge because online transaction processing services cater to a global audience. The trends in online transaction processing are improving day after day. Online transaction processing enables internet based applications to function in an efficient manner. When applications are dealing with online details transaction processing helps in providing the required information in the form of input and deriving the results by carrying out the operations in the form of output. They are used in most of the business in the
Open Document