04-10-2010, 12:03 PM
[attachment=4924]
Introduction to Transaction Processing Concepts and Theory
Chapter Outline
1. Introduction to Transaction Processing
2 .Transaction and System Concepts
3 .Desirable Properties of Transactions
4. Characterizing Schedules based on Recoverability
5. Characterizing Schedules based on Serializability
6 .Transaction Support in SQL
Introduction to Transaction Processing
Single-User System:
At most one user at a time can use the database management system.
Eg. Personal computer system
Multiuser System:
Many users can access the DBMS concurrently.
Eg. Air line reservation, Bank and the like system are operated by many users who submit transaction concurrently to the system
This is achieved by multiprogramming , which allows the computer to execute multiple programs /processes at the same time.