Vector reads for array updates

Details Vector reads for array updates Vector reads for array updates

2004-05-18

2010-06-08

Jalil, Neveen Abel (Department: 2165)

Data processing: database and file management or data structures

File or database maintenance

Synchronization

Reexamination Certificate

active

07734581

ABSTRACT:
An array update operation which specifies number of (row-identifier, value) pairs for updating rows in a table of a database is implemented as follows. A block-identifier of a block (on disk) that holds a row identified by a row-identifier in a specified pair is looked up using a database index, and the block-identifier thus found is stored in a structure. Use of a row-identifier to look up the corresponding block-identifier, and the storage of the block-identifier in the structure are repeatedly performed, for each of several specified pairs. Next, a vector read is performed, to read and store in a cache, each block identified by a block-identifier in the structure, and all the blocks that have been read are stored in the cache during a single function call. Thereafter, rows identified in specified pairs are modified, in blocks currently in the cache, using the values in the specified pairs.

REFERENCES:
patent: 4785400 (1988-11-01), Kojima et al.
patent: 5517631 (1996-05-01), Machado et al.
patent: 5619690 (1997-04-01), Matsumani et al.
patent: 5918225 (1999-06-01), White et al.
patent: 5948062 (1999-09-01), Tzelnic et al.
patent: 6032219 (2000-02-01), Robinson et al.
patent: 6070164 (2000-05-01), Vagnozzi
patent: 6321234 (2001-11-01), Debrunner
patent: 6385626 (2002-05-01), Tamer et al.
patent: 6466942 (2002-10-01), Tolkin
patent: 6772155 (2004-08-01), Stegelmann
patent: 7080081 (2006-07-01), Agarwal et al.
patent: 2002/0103815 (2002-08-01), Duvillier et al.
patent: 2002/0116573 (2002-08-01), Gold
J. Holt, “Predicting Multi-Block Read Call Sizes”, hotsos journal, Jan. 3, 2000, pp. 1-2.
Oracle Articles: Difference between DBFile Sequential and Scattered Reads, “keeptool Tools for Oracle Databases”, Apr. 23, 2003, pp. 1.

Affiliated with

Also associated with

Rating

Vector reads for array 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 Vector reads for array updates, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Vector reads for array updates will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-4153637