Apparatus and method for transferring information in blocks from a database to a memory
US5446858A · kind A · utility
Assignee
Inventors
Key dates
| Filing date | Aug 3, 1992 |
| Grant date | Aug 29, 1995 |
| Priority date | — |
| Expiry date | Aug 3, 2012 |
Classification
- Technology area (CPC Y)Emerging Cross-Sectional Technologies
- CPC primaryY10S707/99938
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
A method, system and process for providing an improved database blocking technique for updatable and scrollable cursors is disclosed. The invention is facilitated by the operation of a process in the memory of a processor. The processor, under the control of the process, builds a reserved area in the memory of the computer. The reserved area in the memory contains an image of a portion of the information residing on disk in the database. When an application opens a cursor to a database, the type of blocking is specified for that cursor. The application issues a fetch request, and if the row is not in the block in the reserved area in the memory, then a remote procedure call is performed to get the required next block of rows and return the block containing the rows back to the application. Various lock data structures are employed to manage and control the processing.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.