Invention Grant
US07958149B2 Computer program and product for append mode insertion of rows into tables in database management systems 有权
用于在数据库管理系统中将行插入表的附加模式的计算机程序和产品

Computer program and product for append mode insertion of rows into tables in database management systems
Abstract:
Implementation of append mode concurrent insert operations in tables in a page-based concurrent relational database management system is carried out by defining a set of last pages as a current cache into which rows may be inserted by appenders. Append mode insert operations for each page in the current cache are serialized. Appenders seek to access the pages in the current cache using a two-pass process in which latches are sought to be acquired conditionally in the first pass and unconditionally in the second pass. A shared data structure is provided to define a current cache and a next cache for a table supporting append mode inserts in the relational database. The shared data structure includes information reflecting the unused space for each page in the current cache.
Information query
Patent Agency Ranking
0/0