Saturday 16, Sunday 23 May '09 meetings

Business System Planning

Business System Planning is a method for analyzing, defining and designing an information architecture of organizations. It was first issued by IBM in 1981, though the initial work on BSP began in the early 1970s.[1] At first, it was for IBM internal use only. Later it was made available to customers[1] and this method became an important tool for many organizations. It is a very complex method dealing with data, processes, strategies, aims and organizational departments which are interconnected.

Link to Presentation on Saturday 16 May:
PDF color. Read more!

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
Read more!