US6105017A
Expired / Lapsed
US
⏱️ 0.0 years remaining
Method and apparatus for deferring large object retrievals from a remote database in a heterogeneous database system
Assignee: International Business Machines Corp
•
Filing: 1997-09-15
•
Granted: 2000-08-15
•
Expires: 2017-09-15
Abstract
Abstract A database management method enables an improved efficiency processing action in a computer wherein manipulation of data from a table is required in accord with a query request, wherein the table is stored remotely from said computer and at least some data in the table includes large data objects (LOBs). The method includes the steps of: responding to the request by transmitting a query to the table; configuring a result set from the table in response to the query, wherein the result set includes one or more unique identifiers of any LOB data associated with the result set; receiving the result set and performing a data manipulation action on data contained in the result set to form a response; transferring the response to the query requester; and accessing LOB data from the table that is referenced by the one or more unique identifiers in the result set and causing transfer of the LOB data to the query requester.
Inventors
- 👤 James Charles Kleewein
- 👤 Eileen Tien Lin
- 👤 Hemant Maheshwari
- 👤 Tina Louise Mukai
- 👤 Steven John Watts
Bibliographic Details
Application Number
—
Jurisdiction
US
Data Source
google_patents
Last Synchronized
2026-11-03 20:44
CPC Classifications
G; G06; G06F; G06F16/00; G06F16/20; G06F16/24; G06F16/245; Y; Y10; Y10S; Y10S707/00; Y10S707/99931; Y10S707/99932
Claims Analysis
Total Claims: 15
Claim 1
Independent Claim
183 words
A method for enabling a processing action in a computer which requires a manipulation of large object data (LOB) from a table in accord with a query request, wherein said table is stored remotely, said method comprising the steps of: a) determining if a data manipulation of said LOB data is required to respond to said query request and, if not, responding to said query request by transmitting a database query to a database management system (DBMS) which controls the table; b) enabling said DBMS to configure a result set from said table in response to said database query, which result set includes one or more unique identifiers for said LOB data associated with said result set; c) receiving said result set and performing a data manipulation action on data contained in said result set to form a query response; d) transferring said query response to said query requestor; and e) accessing said LOB data from said table that is referenced by said one or more unique identifiers in said query response and causing transfer of said LOB data to said query requester.
Claim 2
Independent Claim
183 words
A method for enabling a processing action in a computer which requires a manipulation of large object data (LOB) from a table in accord with a query request, wherein said table is stored remotely, said method comprising the steps of: a) determining if a data manipulation of said LOB data is required to respond to said query request and, if not, responding to said query request by transmitting a database query to a database management system (DBMS) which controls the table; b) enabling said DBMS to configure a result set from said table in response to said database query, which result set includes one or more unique identifiers for said LOB data associated with said result set; c) receiving said result set and performing a data manipulation action on data contained in said result set to form a query response; d) transferring said query response to said query requestor; and e) accessing said LOB data from said table that is referenced by said one or more unique identifiers in said query response and causing transfer of said LOB data to said query requester.
Claim 3
Dependent Claim
38 words
The method as recited in claim 1, wherein said method is implemented by a processor which incorporates a DBMS and steps a)-e) are performed only if said LOB data is able to be identified by a unique identifier.
Claim 4
Dependent Claim
25 words
The method as recited in claim 1, wherein step e) causes a transfer of said LOB data directly to memory utilized by said query requester.
Claim 5
Dependent Claim
40 words
The method as recited in claim 1, wherein prior to step a), said computer performs the follow initial step: determining if said query response will comprise only a subset of the result set, and only if yes, performing steps a)-e).
Claim 6
Independent Claim
214 words
A method for enabling a processing action which requires a join of data from a first table and data from a second table, wherein said second table is stored remotely from said first table, and wherein data from at least one said table includes large object (LOB) data, said method comprising the steps of: a) determining if a data manipulation of said LOB data is required to perform said join and, if not, responding to a query from a query requester by obtaining a value from the first table and transmitting a query to a database management system (DBMS) controlling the second table to enable the DBMS to access matching data for said value, said matching data associated with said LOB data; b) configuring a result set corresponding to said matching data from said second table, which result set includes one or more unique identifiers for any said LOB data associated with said result set; c) receiving said result set and performing a join procedure to form a query response; d) transferring said query response to said query requester; and e) accessing said LOB data from said second table that is referenced by said one or more unique identifiers in said query response and causing transfer of said LOB data to said query requester.
Claim 7
Independent Claim
214 words
A method for enabling a processing action which requires a join of data from a first table and data from a second table, wherein said second table is stored remotely from said first table, and wherein data from at least one said table includes large object (LOB) data, said method comprising the steps of: a) determining if a data manipulation of said LOB data is required to perform said join and, if not, responding to a query from a query requester by obtaining a value from the first table and transmitting a query to a database management system (DBMS) controlling the second table to enable the DBMS to access matching data for said value, said matching data associated with said LOB data; b) configuring a result set corresponding to said matching data from said second table, which result set includes one or more unique identifiers for any said LOB data associated with said result set; c) receiving said result set and performing a join procedure to form a query response; d) transferring said query response to said query requester; and e) accessing said LOB data from said second table that is referenced by said one or more unique identifiers in said query response and causing transfer of said LOB data to said query requester.
Claim 8
Dependent Claim
38 words
The method as recited in claim 5, wherein said method is implemented by a processor which incorporates a DBMS and steps a)-e) are performed only if said LOB data is able to be identified by a unique identifier.
Claim 9
Dependent Claim
25 words
The method as recited in claim 5, wherein step e) causes a transfer of said LOB data directly to memory utilized by said query requester.
Claim 10
Dependent Claim
40 words
The method as recited in claim 5, wherein prior to step a), said method includes the following initial step: determining if said query response will comprise only a subset of the result set, and only if yes, performing steps a)-e).
Claim 11
Dependent Claim
217 words
A memory media for controlling a processing action in a computer which requires a manipulation of large object (LOB) data from a table in accord with a query request, wherein said table is stored remotely, said memory media comprising: a) means for controlling said processing action to determine if a data manipulation of said LOB data is required to respond to said query request and, if not, to respond to said query request by transmitting a database query to a database management system (DBMS) which controls the table, so as to enable said DBMS to configure a result set from said table in response to said database query, which result set includes one or more unique identifiers for said LOB data associated with said result set; b) means for controlling said processing action to receive said result set and to perform a data manipulation action on data contained in said result set so as to form a query response; c) means for controlling said processing action to transfer said query response to said query requester; and d) means for controlling said processing action to access said LOB data from said table that is referenced by said one or more unique identifiers in said query response and to cause transfer of said LOB data to said query requestor.
Claim 12
Dependent Claim
217 words
A memory media for controlling a processing action in a computer which requires a manipulation of large object (LOB) data from a table in accord with a query request, wherein said table is stored remotely, said memory media comprising: a) means for controlling said processing action to determine if a data manipulation of said LOB data is required to respond to said query request and, if not, to respond to said query request by transmitting a database query to a database management system (DBMS) which controls the table, so as to enable said DBMS to configure a result set from said table in response to said database query, which result set includes one or more unique identifiers for said LOB data associated with said result set; b) means for controlling said processing action to receive said result set and to perform a data manipulation action on data contained in said result set so as to form a query response; c) means for controlling said processing action to transfer said query response to said query requester; and d) means for controlling said processing action to access said LOB data from said table that is referenced by said one or more unique identifiers in said query response and to cause transfer of said LOB data to said query requestor.
Claim 13
Dependent Claim
27 words
The method as recited in claim 9, wherein said means a)-d) are operative only if said LOB data is able to be identified by a unique identifier.
Claim 14
Dependent Claim
26 words
The memory media as recited in claim 9, wherein means d) causes a transfer of said LOB data directly to memory utilized by said query requester.
Claim 15
Dependent Claim
44 words
The memory media as recited in claim 9, wherein prior to operation of means a)-d), said processing action is controlled to determine if said query response will comprise only a subset of the result set, and only if yes, enabling operation of means a)-d).
References Cited (Backward Citations)
US5794250A
Cited
US5864843A
Cited
USPTO Annuity & Maintenance Windows
| Annuity Stage | Window Opens | Payment Deadline | Surcharge Period Until | Estimated Fee | Status |
|---|---|---|---|---|---|
| 3.5 Years (Year 4) | 2003-08-15 | 2004-02-14 | 2004-08-15 | $2000.00 | Window Closed / Lapsed |
| 7.5 Years (Year 8) | 2007-08-15 | 2008-02-14 | 2008-08-15 | $3760.00 | Window Closed / Lapsed |
| 11.5 Years (Year 12) | 2011-08-15 | 2012-02-14 | 2012-08-15 | $7700.00 | Window Closed / Lapsed |