Autonomic lock escalation in an SQL environment

Details Autonomic lock escalation in an SQL environment Autonomic lock escalation in an SQL environment

2006-06-22

2009-06-23

LeRoux, Etienne P (Department: 2169)

Data processing: database and file management or data structures

Database design

Data structure types

C707S793000, C707S793000, C710S200000

Reexamination Certificate

active

07552121

ABSTRACT:
Embodiments of the invention provide a method, article of manufacture, and an apparatus used to optimize the execution of a database query. One embodiment includes a computer-implemented method that includes the steps of receiving a query of a database, prior to executing the query, analyzing the query to select a locking strategy to use in executing the query, and executing the query using the selected locking strategy. Depending on the content of a particular query, or the status of a database, a query optimizer may determine whether to escalate from a row level locking strategy to a page level locking strategy when executing the data query.

REFERENCES:
patent: 5737611 (1998-04-01), Vicik
patent: 6418438 (2002-07-01), Campbell
patent: 2004/0199512 (2004-10-01), Cornwell et al.
patent: 2005/0234842 (2005-10-01), Lau et al.
patent: 2005/0289188 (2005-12-01), Nettleton et al.

Affiliated with

Also associated with

Rating

Autonomic lock escalation in an SQL environment does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Autonomic lock escalation in an SQL environment, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Autonomic lock escalation in an SQL environment will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-4115590