-
RootNode
Item
{"_buckets": {"deposit": "37c6c0b5-0e58-4e31-834e-752813ec481d"}, "_deposit": {"id": "4732", "owners": [], "pid": {"revision_id": 0, "type": "recid", "value": "4732"}, "status": "published"}, "_oai": {"id": "oai:meral.edu.mm:recid/4732", "sets": ["1597824273898", "user-ucsy"]}, "communities": ["ucsy"], "item_1583103067471": {"attribute_name": "Title", "attribute_value_mlt": [{"subitem_1551255647225": "Concurrency Control in Distributed Database Management System (Case Study in Online Shopping System)", "subitem_1551255648112": "en"}]}, "item_1583103085720": {"attribute_name": "Description", "attribute_value_mlt": [{"interim": "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."}]}, "item_1583103108160": {"attribute_name": "Keywords", "attribute_value_mlt": [{"interim": "Distributed Database Management System"}, {"interim": "Concurrency control"}, {"interim": "Rigorous 2 phase locking"}]}, "item_1583103120197": {"attribute_name": "Files", "attribute_type": "file", "attribute_value": []}, "item_1583103131163": {"attribute_name": "Journal articles", "attribute_value_mlt": [{"subitem_issue": "", "subitem_journal_title": "Sixteenth International Conferences on Computer Applications(ICCA 2018)", "subitem_pages": "", "subitem_volume": ""}]}, "item_1583103147082": {"attribute_name": "Conference papers", "attribute_value_mlt": [{"subitem_acronym": "", "subitem_c_date": "", "subitem_conference_title": "", "subitem_part": "", "subitem_place": "", "subitem_session": "", "subitem_website": ""}]}, "item_1583103211336": {"attribute_name": "Books/reports/chapters", "attribute_value_mlt": [{"subitem_book_title": "", "subitem_isbn": "", "subitem_pages": "", "subitem_place": "", "subitem_publisher": ""}]}, "item_1583103233624": {"attribute_name": "Thesis/dissertations", "attribute_value_mlt": [{"subitem_awarding_university": "", "subitem_supervisor(s)": [{"subitem_supervisor": ""}]}]}, "item_1583105942107": {"attribute_name": "Authors", "attribute_value_mlt": [{"subitem_authors": [{"subitem_authors_fullname": "Htet, Soe Yadanar Ko"}, {"subitem_authors_fullname": "Yee, Nyo Nyo"}]}]}, "item_1583108359239": {"attribute_name": "Upload type", "attribute_value_mlt": [{"interim": "Publication"}]}, "item_1583108428133": {"attribute_name": "Publication type", "attribute_value_mlt": [{"interim": "Article"}]}, "item_1583159729339": {"attribute_name": "Publication date", "attribute_value": "2018-02-22"}, "item_1583159847033": {"attribute_name": "Identifier", "attribute_value": "http://onlineresource.ucsy.edu.mm/handle/123456789/446"}, "item_title": "Concurrency Control in Distributed Database Management System (Case Study in Online Shopping System)", "item_type_id": "21", "owner": "1", "path": ["1597824273898"], "permalink_uri": "http://hdl.handle.net/20.500.12678/0000004732", "pubdate": {"attribute_name": "Deposited date", "attribute_value": "2019-07-04"}, "publish_date": "2019-07-04", "publish_status": "0", "recid": "4732", "relation": {}, "relation_version_is_last": true, "title": ["Concurrency Control in Distributed Database Management System (Case Study in Online Shopping System)"], "weko_shared_id": -1}
Concurrency Control in Distributed Database Management System (Case Study in Online Shopping System)
http://hdl.handle.net/20.500.12678/0000004732
http://hdl.handle.net/20.500.12678/00000047321df4a8f7-490c-467f-9929-168b2b3436db
37c6c0b5-0e58-4e31-834e-752813ec481d
Publication type | ||||||
---|---|---|---|---|---|---|
Article | ||||||
Upload type | ||||||
Publication | ||||||
Title | ||||||
Title | Concurrency Control in Distributed Database Management System (Case Study in Online Shopping System) | |||||
Language | en | |||||
Publication date | 2018-02-22 | |||||
Authors | ||||||
Htet, Soe Yadanar Ko | ||||||
Yee, Nyo Nyo | ||||||
Description | ||||||
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. | ||||||
Keywords | ||||||
Distributed Database Management System, Concurrency control, Rigorous 2 phase locking | ||||||
Identifier | http://onlineresource.ucsy.edu.mm/handle/123456789/446 | |||||
Journal articles | ||||||
Sixteenth International Conferences on Computer Applications(ICCA 2018) | ||||||
Conference papers | ||||||
Books/reports/chapters | ||||||
Thesis/dissertations |