Optimizing command execution in database systems that provide support for updatable scrollable cursors
US7010552B2 · kind B2 · utility
0Cited by
13References
22Claims
0Family size
Assignee
Inventors
Key dates
| Filing date | May 31, 2001 |
| Grant date | Mar 7, 2006 |
| Priority date | — |
| Expiry date | Feb 9, 2023 |
Classification
- Technology area (CPC Y)Emerging Cross-Sectional Technologies
- CPC primaryY10S707/99954
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
A procedure optimizes command execution in a database system. According to one embodiment, the database system stores data records on data pages, and provides an identifier for each data page. The identifier indicates when any of the data records contained in the data page were last modified. A data record is selected from a data page and copied to a second storage area. Verification that the selected data record has not been modified since the time that is was copied to the second storage area is based upon the identifier, and then the command is executed.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.