Method for append mode insertion of rows into tables in database management systems

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.