Online Transaction Processing (OLTP) Definition
Databases must often allow the real-time processing of SQL transactions to support e-commerce and other time-critical applications. This type of processing is known as online transaction processing (OLTP).
online transaction processing Used in a system where clients store and interrogate data which is important to an organization's business. Typical applications include stock control, airline seat reservation, and share dealing. Such applications require secure data and guaranteed response times for TRANSACTIONS. They were once only found on MAINFRAME COMPUTER systems but they are increasingly being found on CLIENT SERVER COMPUTING systems. Online transaction processing systems which are DISTRIBUTED SYSTEMS provide major technical challenges in terms of response time, security and reliability.
Want to get AdventureWorks OLTP Database Diagram?