CONCURRENCY CONTROL ON TRANSACTIONAL REPLICATION

Abstract

Nowadays, commerce is larger and larger and it affects to open new branch offices in different locations. Therefore, it is important to handle the transaction (Write/Update) of each branch by the head office. There are two databases: original database and replica /(Key/value store) database. When the original database handles read/write transactional application workloads while the copy information base handles read-just responsibilities from similar applications over the information recreated from the first data set. The principal necessity is guaranteeing the utilization of the reports on the copy data set in precisely the same request they were executed in the first data set, which is called execution-defined request. The essential server executes the activities and sends duplicates of the refreshed information to the copies. This framework presents a novel concurrency control algorithm to solve the concurrency problem in the hotel reservation system. This system is implemented using C# programming language with Microsoft SQL server database engine.