Transaction Management Using Serial Validation Approach for Relational Database

Abstract

Nowadays, accessing the same database from the different applications is natural when one company wants to sell their products not only by itself but also by other partner companies or agencies. The accesses to the database can be transactions from many client applications. It needs to monitor, examine, and control the concurrent accesses so that the overall correctness of the database is maintained. In our case study, we implements data accessed components which uses the serial validation with optimistic concurrency scheme to ensure the serial equivalence of the overlapping client transactions. The use of a multi-tiered architecture to develop the overall system architecture will meet the best architecture design decision to distributed deployment of these components as a separate tire on the web. These components can be connected via their interfaces from any application client and concurrency control is achieved through them.