1. Introduction
Outline
1.1 The Basics - What’s a Transaction?
The “ities” are What Makes Transaction Processing (TP) Hard
What Makes TP Important?
TP System Infrastructure
TP System Infrastructure … Defines System and Application Structure
System Characteristics
Application Servers
Application Servers (cont’d)
PPT Slide
Automated Teller Machine (ATM) Application Example
Internet Retailer
System Software Vendor’s View
1.2 The ACID Properties
Atomicity
Example - ATM Dispenses Money (a non-undoable operation)
Reading Uncommitted Output Isn’t Undoable
Compensating Transactions
Consistency
Some Notation
Consistency Preservation Example
Isolation
A Serializability Example
Serializability Examples (cont’d)
Non-Serializable Examples
Durability
1.3 Atomicity and Two-Phase Commit
Two-Phase Commit
Two-Phase Commit System Architecture
1.4 Availability
1.5 Performance Requirements
TPC-A/B — Bank Tellers
The TPC-C Order-Entry Benchmark
TPC-C Transactions
Comments on TPC-C
Typical TPC-C Numbers
TPC/W – Web Retailer
1.6 TP is System Engineering
TP vs. Batch Processing (BP)
TP vs. Timesharing (TS)
TP vs. Real Time (RT)
TP and Client/Server (C/S)
TP and Decision Support Systems (DSSs)
What’s Next?
Email: philbe@microsoft.com
Home Page: http://www.cs.washington.edu/education/courses/593
Download presentation source