METHOD AND SYSTEM FOR CONTROLLING CONCURRENT ACCESS TO DATA IN A DATABASE SYSTEM

A method and system for controlling concurrency of access to data in a database system is provided. The method includes receiving a lock request for access to data in the database system, in which the lock request is a request for a page lock or a row lock for a corresponding row or page in the data...

Full description

Saved in:
Bibliographic Details
Main Authors TENG JAMES Z, LYLE ROBERT W, CORNWELL KARELLE L, COUCH TANYA, WATTS JULIE A
Format Patent
LanguageEnglish
Published 10.01.2008
Subjects
CALCULATING
COMPUTING
COUNTING
ELECTRIC DIGITAL DATA PROCESSING
PHYSICS
Online AccessGet full text

Cover

More Information
Summary:A method and system for controlling concurrency of access to data in a database system is provided. The method includes receiving a lock request for access to data in the database system, in which the lock request is a request for a page lock or a row lock for a corresponding row or page in the database system containing the data. The method further includes identifying a partition in the database system that contains the row or the page in the database system containing the data; associating the lock request with a partition lock on the partition that contains the row or the page in the database system containing the data; and accessing the data using the partition lock.
Bibliography:Application Number: US20070777921