What is the definition of OLTP or On Line Transactional Processing. OLTP refers to all databases designed to manage the processing of data in a transactional and reliable manner, for management purposes in general. Examples include accounting data and supermarket sales data.
OLTP or On Line Transactional Processing and Transactional Database definition
The notion of a single and indivisible transaction is fundamental in OLTP. For example, a system validates or cancels a sale in its entirety. We update data transaction by transaction, in a “transactional” way, unlike batch processing or multidimensional databases.
What is online transaction processing or OLTP?
Online transaction processing, or OLTP, refers to a class of systems that facilitate and manage transactional applications, typically for the capture and processing of retrieval transactions. The term is somewhat ambiguous, with some seeing it as a “transaction” in the context of computer or database operations, while others (such as the Transaction Processing Performance Council) define it as economic or business transactions.
OLTP is used and known as a process in which the system responds immediately to user requests. An example of a business transaction processing application is an automated teller machine for a bank.
OLTP and Datawarehouse, how do they work together?
I recently came across an announcement that questioned some of the messaging associated with the recent launch of the Sun Oracle Database Machine. It questioned the fact that a device designed to support data warehousing could not support OLTP operations. Also a device designed to support OLTP operations could not be expected to support data warehousing.
OLTP vs OLAP
Are these two types of operations mutually exclusive? Is it possible to deliver a device that truly offers the best of both worlds? More importantly, why would you need one? I would say that we quickly reached a point where there is very little difference between the types of functions and operations required to support OLTP operations versus the data warehouse.
Some specific data warehouses today are using data from an OLTP application. We refer to it as an active data warehouse. This data warehouse type is completely different from the traditional data warehouse. It aims to provide near real-time operational decision support system.