-
公开(公告)号：CA2322603C
公开(公告)日：2005-04-12
申请号：CA2322603
申请日：2000-10-06
Applicant: IBM CANADA
Inventor： HURAS MATTHEW A , WINER MICHAEL J , GORALWALLA IQBAL A , SHARPE DAVID C
Abstract: 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, th e temporary copy is associated with a timestamp included on each page storing the data records o f 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 wit h 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 databa se table record and there is no need to carry out a comparison of the attribute values of the temporar y record with the record in the database table.
-
公开(公告)号：CA2322603A1
公开(公告)日：2002-04-06
申请号：CA2322603
申请日：2000-10-06
Applicant: IBM CANADA
Inventor： GORALWALLA IQBAL A , WINER MICHAEL J , SHARPE DAVID C , HURAS MATTHEW A
Abstract: 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, th e temporary copy is associated with a timestamp included on each page storing the data records o f 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 wit h 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 databa se table record and there is no need to carry out a comparison of the attribute values of the temporar y record with the record in the database table.
-
Search Results
2
records
(took 0.017 seconds)
