The transaction processing facilities are useful in many applications, such as on-line transaction processing systems, database management systems, file systems and mailing systems. In this thesis, an architecture for transaction processing system which has concurrency control facilities was designed. For concurrency controls, a strict two-phase locking scheme with multiple granularity was adopted in order to guarantee the high degree of resource utilization and flexibility. A wait-for-graph used for detecting the possible deadlock.
The prototype of our transaction processing system was implemented on a UNIX operating system. To build the prototype, we rewrote most of Wisconsin Storage System (WiSS) and added some new modules. The performance testing reported that our prototype was about twice faster than C-ISAM in sequential accesses.
