The patent badge is an abbreviated version of the USPTO patent document. The patent badge does contain a link to the full patent document.
The patent badge is an abbreviated version of the USPTO patent document. The patent badge covers the following: Patent number, Date patent was issued, Date patent was filed, Title of the patent, Applicant, Inventor, Assignee, Attorney firm, Primary examiner, Assistant examiner, CPCs, and Abstract. The patent badge does contain a link to the full patent document (in Adobe Acrobat format, aka pdf). To download or print any patent click here.
Patent No.:
Date of Patent:
Jul. 18, 2006
Filed:
Nov. 05, 2001
Namik Hrle, Boeblingen, DE;
Andreas R. Maier, Stuttgart, DE;
James Zu-chia Teng, San Jose, CA (US);
Julie A. Watts, Morgan Hill, CA (US);
Namik Hrle, Boeblingen, DE;
Andreas R. Maier, Stuttgart, DE;
James Zu-Chia Teng, San Jose, CA (US);
Julie A. Watts, Morgan Hill, CA (US);
International Business Machines Corporation, Armonk, NY (US);
Abstract
According to the method, apparatus, and computer readable medium of the present invention, a scan is performed by accessing all rows of a table in a relational database, evaluating each row to determine whether the row satifies a set of predicates of a database query, and returning the row if it satisfies the set of predicates. According to a preferred embodiment of the present invention, all rows are evaluated regardless of current locks. The scan is continued if the row does not satisfy the set of predicates regardless of the current lock on the row. The locking semantics according to the invention has the advantage that it completely removes the problem of lock contention on the rows that do not satisfy statement predicates.