Method and apparatus for accessing of large object data segments from a remote database
US5920860A · kind A · utility
Assignee
Inventors
Key dates
| Filing date | Sep 15, 1997 |
| Grant date | Jul 6, 1999 |
| Priority date | — |
| Expiry date | Sep 15, 2017 |
Classification
- Technology area (CPC Y)Emerging Cross-Sectional Technologies
- CPC primaryY10S707/99935
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
A method enables a computer to manipulate data from a table in a remote database in accord with a query from a query requestor, wherein at least some data in the table includes large data objects (LOBs). The method includes the steps of: responding to the query by configuring a database query and determining (i) if a response to the database query requires transfer of LOB data from the table and if yes, and (ii) the LOB data can be transferred in response to the database query without a data manipulation which uses the LOB data or (iii) a data manipulation required in response to the database query which uses the LOB data can be performed at the remote database, then designating the LOB data for "streaming"; dispatching the database query to the remote database and receiving a result set from the table from the remote database in response to the query; and storing the result set and causing any LOB data which has been marked for streaming to be then dispatched to the query requestor without being written to disk.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.