{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2023,10,24]],"date-time":"2023-10-24T06:10:29Z","timestamp":1698127829350},"reference-count":12,"publisher":"Wiley","issue":"6","license":[{"start":{"date-parts":[[2007,3,21]],"date-time":"2007-03-21T00:00:00Z","timestamp":1174435200000},"content-version":"vor","delay-in-days":5558,"URL":"http:\/\/onlinelibrary.wiley.com\/termsAndConditions#vor"}],"content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":["Systems &amp;amp; Computers in Japan"],"published-print":{"date-parts":[[1992,1]]},"abstract":"<jats:title>Abstract<\/jats:title><jats:p>With the advanced use of databases, on\u2010line and batch transactions are executed concurrently. Then a demand arose for the concurrency control method which can realize the excellent on\u2010line transaction processing independently of the batch transactions. The multiversion concurrency control is suitable for such a requirement.<\/jats:p><jats:p>This paper proposes a new multiversion concurrency control algorithm which has a high concurrency between the partial update transactions, which is a typical on\u2010line transaction, and the bulk retrieval transactions, which is a typical batch transaction. The algorithm is based on a mixture of an improved two\u2010version, two\u2010phase locking and the multiversion time stamp ordering. It is shown as simulation results that the proposed algorithm is better than the traditional ones in terms of the completion ratio of the partial update and the completion ratio of the bulk retrieval, independently of the number of partial updates executed concurrently. It is shown also that the algorithm is better than the traditional ones in such an environment since the data contention between partial update transactions is high.<\/jats:p>","DOI":"10.1002\/scj.4690230602","type":"journal-article","created":{"date-parts":[[2007,7,7]],"date-time":"2007-07-07T23:45:49Z","timestamp":1183851949000},"page":"14-25","source":"Crossref","is-referenced-by-count":0,"title":["A new multiversion concurrency control algorithm for partial update transactions and bulk retrieval transactions"],"prefix":"10.1002","volume":"23","author":[{"given":"Ryoji","family":"Kataoka","sequence":"first","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Tetsuji","family":"Satoh","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Ushio","family":"Inoue","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]}],"member":"311","published-online":{"date-parts":[[2007,3,21]]},"reference":[{"key":"e_1_2_1_2_2","first-page":"476","volume-title":"Concurrency Control of Bulk Access Transactions on Shared Nothing Parallel Database Machines","author":"Ohmori T.","year":"1990"},{"key":"e_1_2_1_3_2","doi-asserted-by":"publisher","DOI":"10.1145\/348.318588"},{"key":"e_1_2_1_4_2","first-page":"96","volume-title":"Algorithmic Aspects of Multiversion Concurrency Control","author":"Hadzilacos T.","year":"1985"},{"key":"e_1_2_1_5_2","doi-asserted-by":"publisher","DOI":"10.1145\/320141.320146"},{"key":"e_1_2_1_6_2","first-page":"275","volume-title":"Distributed Concurrency Control in Database Systems","author":"Bayer R.","year":"1980"},{"key":"e_1_2_1_7_2","first-page":"74","volume-title":"Distributed Database Concurrency Controls Using Before\u2010values","author":"Stearns R. E.","year":"1981"},{"key":"e_1_2_1_8_2","doi-asserted-by":"publisher","DOI":"10.1145\/319996.319998"},{"key":"e_1_2_1_9_2","volume-title":"Concurrency Control and Recovery in Database Systems","author":"Bernstein P. A.","year":"1987"},{"key":"e_1_2_1_10_2","volume-title":"The Design of an Ada Compatible Local Database Manager (LDM). Technical Report CCA\u201081\u201009","author":"Chan A.","year":"1981"},{"key":"e_1_2_1_11_2","doi-asserted-by":"publisher","DOI":"10.1109\/TSE.1985.232196"},{"key":"e_1_2_1_12_2","doi-asserted-by":"publisher","DOI":"10.1109\/TSE.1987.232835"},{"key":"e_1_2_1_13_2","first-page":"408","volume-title":"Modular Synchronization in Multiversion Databases: Version Control and Concurrency Control","author":"Agrawal D.","year":"1989"}],"container-title":["Systems and Computers in Japan"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/api.wiley.com\/onlinelibrary\/tdm\/v1\/articles\/10.1002%2Fscj.4690230602","content-type":"unspecified","content-version":"vor","intended-application":"text-mining"},{"URL":"https:\/\/onlinelibrary.wiley.com\/doi\/pdf\/10.1002\/scj.4690230602","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2023,10,23]],"date-time":"2023-10-23T12:59:37Z","timestamp":1698065977000},"score":1,"resource":{"primary":{"URL":"https:\/\/onlinelibrary.wiley.com\/doi\/10.1002\/scj.4690230602"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[1992,1]]},"references-count":12,"journal-issue":{"issue":"6","published-print":{"date-parts":[[1992,1]]}},"alternative-id":["10.1002\/scj.4690230602"],"URL":"https:\/\/doi.org\/10.1002\/scj.4690230602","archive":["Portico"],"relation":{},"ISSN":["0882-1666","1520-684X"],"issn-type":[{"value":"0882-1666","type":"print"},{"value":"1520-684X","type":"electronic"}],"subject":[],"published":{"date-parts":[[1992,1]]}}}