Patent ID: 7958149

Claim:
A computer program product for implementing append mode insert operations in a concurrent relational database management system in which table data for each table among a plurality of tables is stored in pages and in which appenders are able to concurrently access pages in each of the plurality of tables, the computer program product comprising a computer usable medium having computer readable program code means embodied in said medium, and comprising: computer readable program code means for defining a set of pages in a table selected among the plurality of tables to be a current cache for the selected table, and computer readable program code means for implementing append mode insert operations for the selected table by permitting appenders to concurrently insert one or more rows into a plurality of pages in the current cache, wherein an appender performs an append mode insert operation and inserts one or more rows into a plurality of pages in the current cache utilizing a two-pass mechanism, whereby said appender cycles through the set of pages in the current cache, in a first pass, to conditionally obtain exclusive access to a page among the plurality of pages in the current cache and if not permitted exclusive access to a page in the first pass, said appender cycles through the set of pages in the current cache, in a second pass, to unconditionally obtain exclusive access to a page among the plurality of pages in the current cache.