Online Transaction Processing

Teach Me

Online Transaction Processing (OLTP) is an implementation of a transaction processing system — a cross-functional information system that processes data resulting from a business transaction. It plays a key role in e-commerce, where businesses use the Internet and smaller networks to connect with their customers and other businesses electronically. Online Transaction Processing operates in real-time; it captures and processes information immediately.

The transaction processing cycle:

• Batch Processing: collecting data over time and processing it periodically.
• Real-time Processing: processing data immediately following a transaction, as in an online purchase.

1. Data Entry: capture of business data (e.g., a customer selects items and enters quantities, enters shipping and billing information).
2. Database Maintenance: updating the company's database to reflect day-to-day business transactions.
3. Document and Report Generation: the production of summaries of transactions (e.g., purchase orders, sales invoices, error reports).
4. Inquiry Processing: checking on the status of a transaction in progress (e.g., order status, package tracking).

	An understanding of the technology behind the process will help ensure an enjoyable e-commerce experience. For example, clicking the "submit" button usually submits data to a database in realtime. A shopper who knows this would avoid the common mistake of double-clicking the button and consequently submitting the order more than once.
	Many OLTP systems use fault-tolerant computer systems to prevent data loss. A fault-tolerant computer system implements things such as redundant processors and software as a failsafe in case of a system failure. This prevents loss or corruption of data that would occur in the event of a malfunction in the system.

Show Me

The steps of an online purchase:

1. Data Entry:

• Customer chooses which products or services to purchase.
• The order is finalized and a subtotal is shown.
• Customer information (shipping and billing information, email address) is collected.
• The order is submitted.

2. Database Maintenance:

• The customer information and the data resulting from the order is added the company's database.

3. Document and Report Generation:

• A receipt or sales invoice is generated.

4. Inquiry Processing:

• An order/transaction number is given to the customer.