Online Transaction Processing
Online transaction processing (OLTP) applications are high throughput, insert/update-intensive systems. These systems are characterized by growing volumes of data that several hundred users access concurrently. Typical OLTP applications are airline reservation systems, large order-entry applications, and banking applications. The key goals of OLTP systems are availability (sometimes 7 day/24 hour availability); speed (throughput); concurrency; and recoverability.
The following elements are crucial for tuning OLTP systems:
- Rollback segments
- Indexes, clusters, and hashing
- Discrete transactions
- Data block size
- Dynamic allocation of space to tables and rollback segments
- Transaction processing monitors and the multi-threaded server
- The shared pool
- Well-tuned SQL statements
- Integrity constraints
- Client/server architecture
- Dynamically changeable initialization parameters
- Procedures, packages, and functions
PDF 2 slides Color
No comments:
Post a Comment