Optimizing updatable scrollable cursors in database systems

Details Optimizing updatable scrollable cursors in database systems Optimizing updatable scrollable cursors in database systems

G - Physics

06

F

G06F 17/30 (2006.01) G06F 9/312 (2006.01) G06F 12/02 (2006.01)

Patent

CA 2322603

An optimization for updatable scrollable cursors in database systems. To ensure that a temporary copy of a data record matches the data record maintained in the database, the temporary copy is associated with a timestamp included on each page storing the data records of the database. The timestamp on a page in the database is updated whenever any record stored on the page is updated. The optimization compares the timestamp stored with the temporary record with the current timestamp associated with the page on which the data record is stored in the database. If the two timestamps are matching then the temporary record is identical to the database table record and there is no need to carry out a comparison of the attribute values of the temporary record with the record in the database table.

Affiliated with

Also associated with

Rating

Optimizing updatable scrollable cursors in database systems does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Optimizing updatable scrollable cursors in database systems, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Optimizing updatable scrollable cursors in database systems will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFCA-PAI-O-1744670