![]() |
![]() |
![]() |
@inproceedings{DBLP:conf/vldb/GoldSH85,
author = {Israel Gold and
Oded Shmueli and
Micha Hofri},
editor = {Alain Pirotte and
Yannis Vassiliou},
title = {The Private Workspace Model Feasibility and Applications to 2PL
Performance Improvements},
booktitle = {VLDB'85, Proceedings of 11th International Conference on Very
Large Data Bases, August 21-23, 1985, Stockholm, Sweden},
publisher = {Morgan Kaufmann},
year = {1985},
pages = {192-208},
ee = {db/conf/vldb/GoldSH85.html},
crossref = {DBLP:conf/vldb/85},
bibsource = {DBLP, http://dblp.uni-trier.de}
}
In the private workspace model of concurrency con- trol the transaction manager, TM, maintains a private workspace for each transaction.Data items accessed by a transaction, regardless of access mode, are cached in this workspace.At transaction commit time updates are made permanent in the database.
This paper addresses two basic issues.First, the feasibility of the model is exhibited by introducing a relatively straightforward and efficient parallel commit phase algorithm in which no I/O operations are associ- ated with a critical section of the TM.Second, by simula- tion experiments, a concurrency control method in which readers use certification whereas writers use 2PL and do not wait for readers is shown to usually outper- form the "standard" 2PL method within the private workspace context. The detailed physical model used in the simulation captures the basic properties of the private workspace idea.
Copyright © 1985 by the VLDB Endowment. Permission to copy without fee all or part of this material is granted provided that the copies are not made or distributed for direct commercial advantage, the VLDB copyright notice and the title of the publication and its date appear, and notice is given that copying is by the permission of the Very Large Data Base Endowment. To copy otherwise, or to republish, requires a fee and/or special permission from the Endowment.