Online transaction processing

Online transaction processing

Online transaction processing, or OLTP, refers to a class of systems that facilitate and manage transaction-oriented applications, typically for data entry and retrieval transaction processing. The term is somewhat ambiguous; some understand a "transaction" in the context of computer or database transactions, while others (such as the Transaction Processing Performance Council) define it in terms of business or commercial transactions.[1] OLTP has also been used to refer to processing in which the system responds immediately to user requests. An automatic teller machine (ATM) for a bank is an example of a commercial transaction processing application.



OLAP (Online Analytical Processing) is a methodology to provide end users with access to large amounts of data in an intuitive and rapid manner to assist with deductions based on investigative reasoning.

Online Analytical Processing Online transaction processing increasingly requires support for transactions that span a network and may include more than one company. For this reason, new online transaction processing software uses client or server processing and brokering software that allows transactions to run on different computer platforms in a network.

In large applications, efficient OLTP may depend on sophisticated transaction management software (such as CICS) and/or database optimization tactics to facilitate the processing of large numbers of concurrent updates to an OLTP-oriented database.

For even more demanding Decentralized database systems, OLTP brokering programs can distribute transaction processing among multiple computers on a network. OLTP is often integrated into service-oriented architecture (SOA) and Web services.


Online Transaction Processing has two key benefits: simplicity and efficiency. Reduced paper trails and the faster, more accurate forecasts for revenues and expenses are both examples of how OLTP makes things simpler for businesses.


As with any information processing system, security and reliability are considerations. Online transaction systems are generally more susceptible to direct attack and abuse than their offline counterparts.[citation needed] When organizations choose to rely on OLTP, operations can be severely impacted if the transaction system or database is unavailable due to data corruption, systems failure, or network availability issues. Additionally, like many modern online information technology solutions, some systems require offline maintenance which further affects the cost-benefit analysis.

See Also

Contrasted To


  1. ^ Transaction Processing Performance Council website

External links

Wikimedia Foundation. 2010.

Нужен реферат?

Look at other dictionaries:

  • Online Transaction Processing — (OLTP), Onlinetransaktionsverarbeitung, bezeichnet ein Benutzungsparadigma von Datenbanksystemen und Geschäftsanwendungen, bei dem die Verarbeitung von Transaktionen im Vordergrund steht. Während früher Batch Verarbeitung gebräuchlich war, und… …   Deutsch Wikipedia

  • Online Transaction Processing — Online Transaction Processing,   OLTP …   Universal-Lexikon

  • online transaction processing —    Abbreviated OLTP. A business system that operates in real time, collecting and posting transaction related data and making changes to shared databases.    A transaction is a single, discrete unit of work, which is normally part of a business… …   Dictionary of networking

  • Online Transaction Processing (OLTP) — im ⇡ Dialogbetrieb ablaufende Massendatenverarbeitung in operativen DV Systemen, bei der betriebswirtschaftliche ⇡ Transaktionen erfasst und verarbeitet werden. Gegensatz: ⇡ Online Analytical Processing …   Lexikon der Economics

  • online transaction processing — category of software designed to manage data entry and retrieval tasks; method of real time processing in which a computer immediately responds to the user s commands and actions, OLTP …   English contemporary dictionary

  • Online complex processing — (OLCP) is a class of realtime data processing involving complex queries, lengthy queries and/or simultaneous reads and writes to the same records. Sources term/0,2542,t=online+complex+processing i=48345,00.asp… …   Wikipedia

  • Online Analytical Processing — (OLAP) wird neben dem Data Mining zu den Methoden der analytischen Informationssysteme gezählt. OLAP wird weiterhin den hypothesengestützten Analysemethoden zugeordnet. Der Analyst muss vor der eigentlichen Untersuchung wissen, welche Anfragen er …   Deutsch Wikipedia

  • Online analytical processing — In computing, online analytical processing, or OLAP (  /ˈoʊlæ …   Wikipedia

  • Online Analytical Processing — En informatique, et plus particulièrement dans le domaine des bases de données, le traitement analytique en ligne (anglais online analytical processing abr. OLAP) est un type d application informatique orienté vers l analyse sur le champ d… …   Wikipédia en Français

  • Transaction processing system — A Transaction Processing System To be considered a transaction processing system the computer must pass the ACID test.From a technical perspective, a Transaction Processing System (or Transaction Processing Monitor) monitors transaction programs …   Wikipedia

Share the article and excerpts

Direct link
Do a right-click on the link above
and select “Copy Link”