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:
Feb. 06, 2007
Filed:
Jan. 23, 2003
Gang Luo, Madison, WI (US);
Michael W. Watzke, Madison, WI (US);
Curt J. Ellmann, Madison, WI (US);
Jeffrey F. Naughton, Madison, WI (US);
Gang Luo, Madison, WI (US);
Michael W. Watzke, Madison, WI (US);
Curt J. Ellmann, Madison, WI (US);
Jeffrey F. Naughton, Madison, WI (US);
NCR Corp., Dayton, OH (US);
Abstract
A database system includes a locking mechanism for a view defined on one or more base relations. A B-tree index is defined on the view. In response to updates of a base relation, predefined locks are placed on the view. With locking mechanisms according to some embodiments of the invention, concurrency of transactions that access the view and B-tree index is enhanced by enabling concurrent updates of the materialized view by plural transactions in certain cases, while avoiding read-write and write-read conflicts.