Data processing: database and file management or data structures – Database design – Data structure types
Reexamination Certificate
2004-04-06
2008-08-12
Lee, Wilson (Department: 2163)
Data processing: database and file management or data structures
Database design
Data structure types
C707S793000, C707S793000, C707S793000, C707S793000, C707S793000
Reexamination Certificate
active
07412465
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.
REFERENCES:
patent: 5666532 (1997-09-01), Saks et al.
patent: 5717919 (1998-02-01), Kodavalla et al.
patent: 5787433 (1998-07-01), Plotkin et al.
patent: 5940828 (1999-08-01), Anaya et al.
patent: 6131094 (2000-10-01), Gord
patent: 6223176 (2001-04-01), Ricard et al.
patent: 6334134 (2001-12-01), Haderle et al.
patent: 6360220 (2002-03-01), Forin
patent: 6363387 (2002-03-01), Ponnekanti et al.
patent: 6411964 (2002-06-01), Iyer et al.
patent: 6430260 (2002-08-01), Snyder
patent: 6470360 (2002-10-01), Vaitheeswaran
patent: 6480862 (2002-11-01), Gall
patent: 6487567 (2002-11-01), Michelman et al.
patent: 6578131 (2003-06-01), Larson et al.
patent: 2002/0040376 (2002-04-01), Yamanaka et al.
patent: 2006/0230013 (2006-10-01), Hrle et al.
Hing Nelson Hop
Spilchen Matthew J.
Winer Michael J.
Filipczyk Marc R
International Business Machines - Corporation
Lee Wilson
Sughrue & Mion, PLLC
LandOfFree
Method for append mode insertion of rows into tables in... does not yet have a rating. At this time, there are no reviews or comments for this patent.
If you have personal experience with Method for append mode insertion of rows into tables in..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Method for append mode insertion of rows into tables in... will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-4012848