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:
Mar. 01, 2016
Filed:
Dec. 30, 2013
Mark Delafranier, Waterloo, CA;
David Wein, Saint Paul, MN (US);
Rolando Blanco, Waterloo, CA;
Anil Kumar Goel, Waterloo, CA;
Mihnea Andrei, Issy les Moulineaux, FR;
Mark DeLaFranier, Waterloo, CA;
David Wein, Saint Paul, MN (US);
Rolando Blanco, Waterloo, CA;
Anil Kumar Goel, Waterloo, CA;
Mihnea Andrei, Issy les Moulineaux, FR;
Sybase, Inc., Dublin, CA (US);
Abstract
A set-oriented locking based on in-memory bitmap for a column store database is described. An example method includes establishing a column-based in-memory database including a main store and a delta store, where the delta store has a plurality of row-visibility lock bitmaps visible to transactions at various points in time. The lock bitmaps represent a bit encoding to indicate whether there are granted row locks tables in the database. A delete or an update statement is executed with a transaction on a table. A set of row locks on rows of the table manipulated by the delete or the update statement are requested to preclude other transactions from currently deleting or updating the same rows. Accordingly, set operations are performed on the lock bitmap to manage the set of row locks associated with the transaction.