Patent ID: 7412465
Filing Date: 2008-08-12
Classification: G06F,Y10S

Abstract:
1. A computer-implemented method for implementing append mode insert operations in a concurrent relational database management system in which table data of 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 method comprising: defining a set of pages in a table selected among the plurality of table to be a current cache for the selected table, and 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 to insert 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 said 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 said a page among the plurality of pages in the current cache.