Title :
Locking granularity in multiprocessor database systems
Author :
Dandamudi, S. ; Au, Siu-Lun
Author_Institution :
Sch. of Comput. Sci., Carleton Univ., Ottawa, Ont., Canada
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;
Conference_Titel :
Data Engineering, 1991. Proceedings. Seventh International Conference on
Conference_Location :
Kobe
Print_ISBN :
0-8186-2138-9
DOI :
10.1109/ICDE.1991.131474
