Saturday, May 2, 2009

Saturday 18, Sunday 19 Apr '09 meetings


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
Presentation on Saturday 02 May:
PDF 2 slides Color

No comments:

Post a Comment