Value-added locking: concurrently supporting transactions and queries in DBMS

Author

Cova, Luis L. ; Sun, Wei

Author_Institution

Sch. of Comput. Sci., Florida Int. Univ., Miami, FL, USA

fYear

1992

fDate

2-3 Feb 1992

Firstpage

20

Lastpage

25

Abstract

This paper presents an approach value-added locking (VAL), that allows effective transaction processing and the execution of complex, read-only, and long-lived queries simultaneously on the same database. VAL integrates the concepts of altruistic locking and quasi-copies to provide a mechanism that allows users, application designers to database administrators to fine-tune the system performance in terms of transaction throughput and queries´ average response times. By deploying VAL, a significant gain in system performance may be expected. It also shows that a conventional concurrency control mechanisms such as 2-phase locking becomes a special case of the approach

Keywords

concurrency control; database management systems; query processing; transaction processing; 2-phase locking; VAL; altruistic locking; concurrency control; quasi-copies; query processing; system performance; transaction processing; value-added locking; Centralized control; Computer science; Concurrency control; Database systems; Delay; Performance gain; Sun; System performance; Throughput; Transaction databases;

fLanguage

English

Publisher

ieee

Conference_Titel

Research Issues on Data Engineering, 1992: Transaction and Query Processing, Second International Workshop on

Conference_Location

Tempe, AZ

Print_ISBN

0-8186-2660-7

Type

conf

DOI

10.1109/RIDE.1992.227428

Filename

227428