System and method for executing a large object fetch query against a database
US7039651B2 · kind B2 · utility
1Cited by
6References
24Claims
0Family size
Assignee
Inventors
Key dates
| Filing date | Apr 29, 2003 |
| Grant date | May 2, 2006 |
| Priority date | — |
| Expiry date | Sep 9, 2024 |
Classification
- Technology area (CPC Y)Emerging Cross-Sectional Technologies
- CPC primaryY10S707/99946
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
A database server helps to streamline the retrieval of LOB values by deciding to send a locator in replacement of the LOB value, or the LOB value itself, depending upon the specific LOB value being retrieved. A threshold value is determined in a fetch query, and the LOB sizes below that threshold are sent as values in a corresponding fetch response, and the lengths above are sent as locators in the fetch response. Indicators are inserted in a fetch parameter of the response to inform the receiving client the form of retrieval that was used for each requested LOB value being returned.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.