DocumentCode
3199767
Title
Locking granularity in multiprocessor database systems
Author
Dandamudi, S. ; Au, Siu-Lun
Author_Institution
Sch. of Comput. Sci., Carleton Univ., Ottawa, Ont., Canada
fYear
1991
fDate
8-12 Apr 1991
Firstpage
268
Lastpage
277
Abstract
The effects of locking granularity in a shared-nothing multiprocessor database system are analyzed. The analysis shows that when the system is lightly loaded fine granularity (one lock per database entity) is needed when transactions access the database randomly. However, when transactions access the database sequentially, coarse granularity is desired. When the system is heavily loaded, coarse granularity is desirable. The results also indicate that horizontal partitioning results in better performance than random partitioning
Keywords
distributed databases; coarse granularity; horizontal partitioning; locking granularity; multiprocessor database systems; shared-nothing; Computer science; Concurrency control; Concurrent computing; Costs; Database machines; Database systems; Gold; System performance; Transaction databases;
fLanguage
English
Publisher
ieee
Conference_Titel
Data Engineering, 1991. Proceedings. Seventh International Conference on
Conference_Location
Kobe
Print_ISBN
0-8186-2138-9
Type
conf
DOI
10.1109/ICDE.1991.131474
Filename
131474
Link To Document