Selection of rows and values from indexes with updates

Details Selection of rows and values from indexes with updates Selection of rows and values from indexes with updates

2007-10-04

2010-11-16

Wong, Don (Department: 2163)

Data processing: database and file management or data structures

Database and file access

Reexamination Certificate

active

07836037

ABSTRACT:
Methods and apparatus, including computer program products, for selection of rows and values from indexes with updates. In general, rows of an index may be associated with validity flags that indicate whether a row has been updated with an update inserted in a delta index; one scheme for value identifiers may be used for an index and another scheme for one or more delta indexes where all of the indexes are, to at least some extent, compressed according to dictionary-based compression; and multiple delta indexes may be used in alternation such that one delta index may accept updates while another is being updated. The delta indexes may also have validity flags and all updates, such as modifications of values, deletion of records, and inserting of new records may be handled as updates accepted by one or more delta indexes.

REFERENCES:
patent: 5539899 (1996-07-01), Huynh et al.
patent: 5838950 (1998-11-01), Young et al.
patent: 5953723 (1999-09-01), Linoff et al.
patent: 6439783 (2002-08-01), Antoshenkov
patent: 2004/0243560 (2004-12-01), Broder et al.
patent: 2005/0192998 (2005-09-01), Dittrich et al.
patent: 2008/0294863 (2008-11-01), Faerber et al.

Affiliated with

Also associated with

Rating

Selection of rows and values from indexes with updates does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Selection of rows and values from indexes with updates, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Selection of rows and values from indexes with updates will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-4252179