Patent US5920860A successfully refreshed from Google Patents.
US5920860A
Expired / Lapsed
US
⏱️ 0.0 years remaining
Method and apparatus for accessing of large object data segments from a remote database
Assignee: International Business Machines Corp
•
Filing: 1997-09-15
•
Granted: 1999-07-06
•
Expires: 2017-09-15
Abstract
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.
Inventors
- 👤 Hemant Maheshwari
- 👤 Tina Louise Mukai
- 👤 Steven John Watts
Bibliographic Details
Application Number
—
Jurisdiction
US
Data Source
google_patents
Last Synchronized
2026-11-09 00:14
CPC Classifications
G; G06; G06F; G06F16/00; G06F16/20; G06F16/24; G06F16/245; Y; Y10; Y10S; Y10S707/00; Y10S707/99931; Y10S707/99932; Y10S707/99933; Y10S707/99935
Claims Analysis
Total Claims: 10
Claim 1
Independent Claim
167 words
A method for enabling a computer to manipulate data from a table in a remote database in accord with a request from a query requestor, wherein at least some data in said table includes large data objects (LOBs), said method comprising the steps of: a) responding to said query request by configuring a database query and (i) if a response to said database query requires transfer of LOB data from said table and if yes, and (ii) the LOB data can be transferred in response to the database query without a data manipulation which uses said LOB data, then designating the LOB data for "streaming"; b) dispatching said database query to said remote database and receiving a result set from said table from said remote database in response to said query; and c) storing said result set and causing any LOB data which has been marked for streaming to be then dispatched to said query requestor of said query request without being written to a non-volatile memory.
Claim 2
Independent Claim
167 words
A method for enabling a computer to manipulate data from a table in a remote database in accord with a request from a query requestor, wherein at least some data in said table includes large data objects (LOBs), said method comprising the steps of: a) responding to said query request by configuring a database query and (i) if a response to said database query requires transfer of LOB data from said table and if yes, and (ii) the LOB data can be transferred in response to the database query without a data manipulation which uses said LOB data, then designating the LOB data for "streaming"; b) dispatching said database query to said remote database and receiving a result set from said table from said remote database in response to said query; and c) storing said result set and causing any LOB data which has been marked for streaming to be then dispatched to said query requestor of said query request without being written to a non-volatile memory.
Claim 3
Dependent Claim
45 words
The method as recited in claim 1, wherein step a) further designates the LOB data for "streaming" if a data manipulation which is required to respond to said database query uses said LOB data, but said data manipulation can be performed at said remote database.
Claim 4
Dependent Claim
25 words
The method as recited in claim 2, wherein said LOB data is dispatched to said source of said query request, as portions thereof are received.
Claim 5
Dependent Claim
82 words
The method as recited in claim 2, wherein if step a) determines (i) that the LOB data cannot be transferred in response to the database query without a data manipulation which uses said LOB data or (ii) that a data manipulation required in response to said database query which uses said LOB data cannot be performed at said remote database, then said LOB data is written to non-volatile memory in association with said computer when received as part of a result set.
Claim 6
Dependent Claim
181 words
A memory media for controlling a computer to manipulate data from a table in a remote database in accord with a request from a query requestor, wherein at least some data in said table includes large data objects (LOBs), said memory media comprising: a) means for controlling said computer to respond to said request by configuring a database query and (i) if a response to said database query requires transfer of LOB data from said table and if yes, and (ii) the LOB data can be transferred in response to the database query without a data manipulation which uses said LOB data, then designating the LOB data for "streaming"; b) means for controlling said computer to dispatch said database query to said remote database and to receive a result set from said table from said remote database in response to said database query; and c) means for controlling said computer to store said result set and to cause any LOB data which has been marked for streaming to be dispatched to said query requestor without being written to a non-volatile memory.
Claim 7
Dependent Claim
181 words
A memory media for controlling a computer to manipulate data from a table in a remote database in accord with a request from a query requestor, wherein at least some data in said table includes large data objects (LOBs), said memory media comprising: a) means for controlling said computer to respond to said request by configuring a database query and (i) if a response to said database query requires transfer of LOB data from said table and if yes, and (ii) the LOB data can be transferred in response to the database query without a data manipulation which uses said LOB data, then designating the LOB data for "streaming"; b) means for controlling said computer to dispatch said database query to said remote database and to receive a result set from said table from said remote database in response to said database query; and c) means for controlling said computer to store said result set and to cause any LOB data which has been marked for streaming to be dispatched to said query requestor without being written to a non-volatile memory.
Claim 8
Dependent Claim
51 words
The memory media as recited in claim 5, wherein means step a) further controls said computer to designate the LOB data for "streaming" if a data manipulation which is required to respond to said database query uses said LOB data, but said data manipulation can be performed at said remote database.
Claim 9
Dependent Claim
23 words
The memory media as recited in claim 6, wherein said LOB data is dispatched to said query requestor as portions thereof are received.
Claim 10
Dependent Claim
85 words
The memory media as recited in claim 6, wherein if means a) controls said computer to determine (i) that the LOB data cannot be transferred in response to the database query without a data manipulation which uses said LOB data or (ii) that a data manipulation required in response to said database query which uses said LOB data cannot be performed at said remote database, then said computer is caused to write said LOB data non-volatile memory when received as part of a result set.
References Cited (Backward Citations)
US5517605A
Cited
US5600831A
Cited
US5623652A
Cited
US5625818A
Cited
US5566329A
Cited
US5708825A
Cited
US5748954A
Cited
US5701451A
Cited
US5712979A
Cited
US5675721A
Cited
USPTO Annuity & Maintenance Windows
| Annuity Stage | Window Opens | Payment Deadline | Surcharge Period Until | Estimated Fee | Status |
|---|---|---|---|---|---|
| 3.5 Years (Year 4) | 2002-07-05 | 2003-01-04 | 2003-07-06 | $2000.00 | Window Closed / Lapsed |
| 7.5 Years (Year 8) | 2006-07-05 | 2007-01-04 | 2007-07-06 | $3760.00 | Window Closed / Lapsed |
| 11.5 Years (Year 12) | 2010-07-05 | 2011-01-04 | 2011-07-06 | $7700.00 | Window Closed / Lapsed |