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.