Cited By
View all- Mohan C(1978)An overview of recent data base researchACM SIGMIS Database: the DATABASE for Advances in Information Systems10.1145/2579474.257947610:2(3-24)Online publication date: 1-Sep-1978
A study of the effects of locking granularity in a data base management system
Page 121
Abstract
Many data base systems guarantee some form of integrity control upon multiple concurrent updates by some form of locking. Some "granule" of the data base is chosen as the unit which is individually locked, and a lock management algorithm is used to ensure integrity. By a simulation model this paper explores the desired size of a "granule". Under a wide variety of seemingly realistic conditions, surprisingly coarse granularity is called for. The paper concludes with some implications of these results concerning the viability of so called "predicate locking".Research sponsored by the Naval Electronic Systems Command Contract N00039-76-c-0022, the National Science Foundation Grant DCR75-03839 and the Army Research Office Grant DAAG29-76-6-0245.
- A study of the effects of locking granularity in a data base management system
Recommendations
Effects of locking granularity in a database management system
Many database systems guarantee some form of integrity control upon multiple concurrent updates by some form of locking. Some “granule” of the database is chosen as the unit which is individually locked, and a lock management algorithm is used to ensure ...
Locking granularity revisited
Locking granularity refers to the size and hence the number of locks used to ensure the consistency of a database during multiple concurrent updates. In an earlier simulation study we concluded that coarse granularity, such as area or file locking, is ...
Pre-analysis locking: a safe and deadlock free locking policy
VLDB '85: Proceedings of the 11th international conference on Very Large Data Bases - Volume 11A safe and deadlock free lock policy is introduced, called pre-analysis locking. Pre-analysis locking is based on an efficient geometric algorithm which inserts lock and unlock operations into the transactions. Pre-analysis locking is the first safe and ...
Comments
Information & Contributors
Information
Published In
August 1977
181 pages
ISBN:9781450373432
DOI:10.1145/509404
- Conference Chair:
- J. B. Fry,
- General Chair:
- W. Frank King,
- Program Chair:
- Diane C. P. Smith
Copyright © 1977 ACM.
Permission to make digital or hard copies of all or part of this work for personal or classroom use is granted without fee provided that copies are not made or distributed for profit or commercial advantage and that copies bear this notice and the full citation on the first page. Copyrights for components of this work owned by others than ACM must be honored. Abstracting with credit is permitted. To copy otherwise, or republish, to post on servers or to redistribute to lists, requires prior specific permission and/or a fee. Request permissions from [email protected]
Sponsors
Publisher
Association for Computing Machinery
New York, NY, United States
Publication History
Published: 03 August 1977
Check for updates
Qualifiers
- Article
Acceptance Rates
Overall Acceptance Rate 785 of 4,003 submissions, 20%
Contributors
Other Metrics
Bibliometrics & Citations
Bibliometrics
Article Metrics
- View Citations1Total Citations
- 169Total Downloads
- Downloads (Last 12 months)15
- Downloads (Last 6 weeks)4
Reflects downloads up to 30 Aug 2024
Other Metrics
Citations
Cited By
View all- Mohan C(1978)An overview of recent data base researchACM SIGMIS Database: the DATABASE for Advances in Information Systems10.1145/2579474.257947610:2(3-24)Online publication date: 1-Sep-1978
View Options
Get Access
Login options
Check if you have access through your login credentials or your institution to get full access on this article.
Sign in