Abstract:
Distributed Database Management System (DDBMS) is becoming interested due to the declining cost of computer hardware and geographically dispersed organizations where data processing is increased. A distributed database is a collection of multiple interconnected databases, which are spread physically across different locations that communicate via a computer network. One of the main problems in DDBMS is concurrency control problem. The main objective of concurrency control is to ensure that there is no interference when two or more users access a shared database simultaneously. In this system, the problems of concurrent access are studied on Online Shopping System. The system firstly implements distributed online shopping databases across 3 different sites and the data are allocated by using primary horizontal fragmentation. In Distributed Database Management System, concurrency control problem is solved with 2 phase locking method with lock manager. The original 2 phase locking has cascading rollback and deadlock. Therefore, this proposed system uses rigorous 2 phase locking with distributed lock manager to solve cascading rollback and wound-wait deadlock avoidance scheme is used to solve deadlock. Microsoft SQL Server 2016, and Java Platform, Enterprise Edition (J2EE) programming language are used to implement this system.
Description:
Firstly, I would like to express her special thanks to Dr.Aung Win, Rector, University of Technology (Yatanapon Cyber City) for initaiting the Master programming. I would like to appreciate Dr.Soe Soe Khaing, Pro-Rector, University of
Technology (Yatanapon Cyber City), for her vision and guidance for preparation of this article. I would like to express to my teacher Dr.Hninn Aye Thant, Professor, Department of Information Science, for her advices and kindly support the essential things. I am also grateful to Dr.Nyo Nyo Yee, Lecturer, for giving me valuable advices and guidance. Lastly, I would like to thank to all persons who directly and indirectly contributed towards the success of this paper.
