or
Bookmark and Share
Method for concurrency control for a secondary index
   
Document Number
US Patent 7181453
Issued Date
February 20, 2007
Link
Inventors
Map
Abstract
The present invention relates to a method and a computer program for concurrency control for a secondary index (13) wherein many deadlocks are avoided by means of a selective locking strategy and by means of allowing index records (14) of the secondary index to contain some keys to many but never too few. When keys are read from the secondary index (13) it is thus possible to read some keys that may be irrelevant. However, such irrelevant keys are sorted out by means of checking against the corresponding records (12) in the table (11) to which the secondary index (13) is associated. The selective locking strategy allows for increased concurrency.
Tags:
Description:
Amusing 0%
Clever 0%
Complex 0%
Efficient 0%
Historic 0%
Important 0%
Innovative 0%
Interesting 0%
Practical 0%
Simple 0%
Number of Claims:
22
Comments:
no comments yet
Owner
MySQL AB (Uppsala,SE)
Published
February 20, 2007
Application Number
10/481,301
Filed
June 28, 2001
US Classification
707/8   707/2 707/E17.007
Int'l Classification
G06F   17/30   (20060101)  
Examiner
Assistant Examiner
USPTO Field of Search
707/1   707/2   707/3   707/4   707/5   707/100   707/8  
Related Patents
Claims
Description
About| FAQs| Terms & Disclaimer| Link to Us| Contact Us