US6421715B1
Expired / Lapsed
US
⏱️ 0.0 years remaining
System and method for generating and transmitting a command in response to a request for additional data and data described in the request
Assignee: Oracle International Corp
•
Filing: 1997-06-11
•
Granted: 2002-07-16
•
Expires: 2017-06-11
Abstract
Abstract A method and apparatus allows a client or other device separate from a server to retrieve from the server more data than is requested by an application program on the client. The additional data is maintained by the client or other device and provided to the application program in response to a subsequent request, reducing the number of times data is requested from the server, and also the processing and overhead required by the server to supply the data. If the server releases memory pointing to the data on the server at the time or after all data specified by the application program has been retrieved, because the data is potentially retrieved from the server in amounts larger than requested by the application program, the server may release memory pointing to the data on the server sooner than it would by processing requests for the data from the application program alone.
Inventors
- 👤 Debashish Chatterjee
- 👤 Lakshminarayanan “Luxi” Chidambaran
- 👤 Mohammad S Lari
Bibliographic Details
Application Number
—
Jurisdiction
US
Data Source
google_patents
Last Synchronized
2026-11-06 17:33
CPC Classifications
H; H04; H04L; H04L69/00; H04L69/30; H04L69/32; H04L69/322; H04L69/329; G; G06; G06F; G06F16/00; G06F16/20; G06F16/24; G06F16/242; G06F16/2433; G06F16/2438; G06F16/245; G06F16/2455; H04L67/00; H04L67/50; H04L67/56; H04L67/568; H04L67/5681; H04L67/01; H04L67/02
Claims Analysis
Total Claims: 30
Claim 1
Independent Claim
95 words
An apparatus for providing data from a server, comprising: a request manager module remote from the server and coupled to the server for receiving a request describing data and preparing and transmitting to the server a command, different from the request, requesting an amount of data different from the data described in the request; a local storage remote from the server and coupled to the server for receiving data from the server; and wherein the command prepared and transmitted by the request manager module is for the data described in the request and additional data.
Claim 2
Independent Claim
95 words
An apparatus for providing data from a server, comprising: a request manager module remote from the server and coupled to the server for receiving a request describing data and preparing and transmitting to the server a command, different from the request, requesting an amount of data different from the data described in the request; a local storage remote from the server and coupled to the server for receiving data from the server; and wherein the command prepared and transmitted by the request manager module is for the data described in the request and additional data.
Claim 3
Dependent Claim
19 words
The apparatus of claim 1 wherein the data described in the request and the additional data comprise a table.
Claim 4
Dependent Claim
11 words
The apparatus of claim 1 wherein the command comprises a size.
Claim 5
Dependent Claim
50 words
The apparatus of claim 3 wherein the size comprises a number formed by adding numbers selected from a number of rows of the local storage, a number of rows in the request and a constant number, and subtracting a number of rows of the requested data in the local storage.
Claim 6
Dependent Claim
22 words
The apparatus of claim 3 wherein the size comprises a number of bytes corresponding to a number of bytes in the request.
Claim 7
Dependent Claim
24 words
The apparatus of claim 1 wherein the command comprises a command selected from at least one of a fetch command and an execute command.
Claim 8
Dependent Claim
78 words
The apparatus of claim 1 additionally comprising: a storage manager module coupled to the local storage and the request manager module for signaling whether at least a portion of the data described in the request is stored in the local storage; and wherein the request manager module is coupled to the storage manager module and is additionally for providing from the local storage at least a portion of the data requested responsive to the storage manager module signal.
Claim 9
Dependent Claim
33 words
The apparatus of claim 7 additionally comprising a placeholder coupled to the storage manager module for identifying a first set of the data described in the request and stored in the local storage.
Claim 10
Dependent Claim
18 words
The apparatus of claim 1 wherein the request describing data comprises an explicit, numerical quantity of the data.
Claim 11
Independent Claim
136 words
A method of providing data from a server, comprising: receiving a command to provide data from a table comprising rows, the command comprising at least one size different from a first number of rows; calculating a whole number of the rows of the table corresponding to at least one of the at least one size different from the number of rows of the command received wherein a size of the whole number of rows is different from the at least one size different from the first number of rows and wherein the command specifies a second number of rows greater than the whole number of rows; and transmitting the data to a device external to the server the data having a third number of rows equal to the whole number of rows of the data calculated.
Claim 12
Independent Claim
136 words
A method of providing data from a server, comprising: receiving a command to provide data from a table comprising rows, the command comprising at least one size different from a first number of rows; calculating a whole number of the rows of the table corresponding to at least one of the at least one size different from the number of rows of the command received wherein a size of the whole number of rows is different from the at least one size different from the first number of rows and wherein the command specifies a second number of rows greater than the whole number of rows; and transmitting the data to a device external to the server the data having a third number of rows equal to the whole number of rows of the data calculated.
Claim 13
Dependent Claim
34 words
The method of claim 10 , comprising the additional steps of: receiving a query command; reading a storage to identify data corresponding to the command received; and building the table from the data identified.
Claim 14
Independent Claim
74 words
A method of providing a set of data, comprising: receiving a request for at least a portion of data in the set, the request specifying an amount of the data; responsive to the request received, transmitting a command, different from the request, to a remote server for an amount of data different from the amount specified by the request; and wherein the command is for the data described in the request and additional data.
Claim 15
Independent Claim
74 words
A method of providing a set of data, comprising: receiving a request for at least a portion of data in the set, the request specifying an amount of the data; responsive to the request received, transmitting a command, different from the request, to a remote server for an amount of data different from the amount specified by the request; and wherein the command is for the data described in the request and additional data.
Claim 16
Dependent Claim
86 words
The method of claim 12 , additionally comprising the steps of: identifying the existence in a local data storage of at least a portion of the data in the set; responsive to at least a portion of the data in the set in the local data storage, providing at least a portion of the data in the set from the local storage; and wherein the transmitting step is responsive to at least a portion of the data in the set not in the local data storage.
Claim 17
Dependent Claim
32 words
The method of claim 13 wherein the request is received from an application software remote from the server; and the application software and local data storage are located in the same device.
Claim 18
Dependent Claim
24 words
The method of claim 13 , comprising the additional step of receiving data corresponding to the data in the command transmitted to the server.
Claim 19
Dependent Claim
23 words
The method of claim 13 wherein the command transmitted is selected from at least one of an execute command and a fetch command.
Claim 20
Dependent Claim
16 words
The method of claim 12 wherein the request comprises an explicit numerical quantity of the data.
Claim 21
Dependent Claim
186 words
A computer program product comprising a computer useable medium having computer readable program code embodied therein for providing data from a server, the computer program product comprising: computer readable program code devices configured to cause a computer to receive a command to provide data from a table comprising rows, the command comprising at least one size different from a first number of rows; computer readable program code devices configured to cause a computer to calculate a whole number of the rows of the table corresponding to at least one of the at least one size different from the number of rows of the command wherein a size of the whole number of rows is different from the at least one size different from the first number of rows and wherein the command specifies a second number of rows greater than the whole number of rows; and computer readable program code devices configured to cause a computer to transmit the data to a device external to the server the data having a third number of rows equal to the whole number of rows of the data calculated.
Claim 22
Dependent Claim
186 words
A computer program product comprising a computer useable medium having computer readable program code embodied therein for providing data from a server, the computer program product comprising: computer readable program code devices configured to cause a computer to receive a command to provide data from a table comprising rows, the command comprising at least one size different from a first number of rows; computer readable program code devices configured to cause a computer to calculate a whole number of the rows of the table corresponding to at least one of the at least one size different from the number of rows of the command wherein a size of the whole number of rows is different from the at least one size different from the first number of rows and wherein the command specifies a second number of rows greater than the whole number of rows; and computer readable program code devices configured to cause a computer to transmit the data to a device external to the server the data having a third number of rows equal to the whole number of rows of the data calculated.
Claim 23
Dependent Claim
65 words
The computer program product of claim 18 additionally comprising: computer readable program code devices configured to cause a computer to receive a query command; computer readable program code devices configured to cause a computer to read a storage to identify data corresponding to the command received; and computer readable program code devices configured to cause a computer to build the table from the data identified.
Claim 24
Independent Claim
74 words
A method of providing a set of data, comprising: receiving a request for at least a portion of data in the set, the request specifying an amount of the data; responsive to the request received, transmitting a command, different from the request to a remote server for an amount of data different from the amount specified by the request; and wherein the command is for the data described in the request and additional data.
Claim 25
Independent Claim
74 words
A method of providing a set of data, comprising: receiving a request for at least a portion of data in the set, the request specifying an amount of the data; responsive to the request received, transmitting a command, different from the request to a remote server for an amount of data different from the amount specified by the request; and wherein the command is for the data described in the request and additional data.
Claim 26
Dependent Claim
114 words
The computer program product of claim 20 additionally comprising: computer readable program code devices configured to cause a computer to identify the existence in a local data storage of at least a portion of the data in the set; computer readable program code devices configured to cause a computer to provide at least a portion of the data in the set from local storage responsive to at least a portion of the data in the set in the local storage; and wherein the computer readable program code devices configured to cause a computer to transmit are responsive to at least a portion of the data in the set not in the local data storage.
Claim 27
Dependent Claim
34 words
The computer program product of claim 21 wherein the request is received from an application software remote from the server; and the application software and local data storage are located in the same device.
Claim 28
Dependent Claim
34 words
The computer program product of claim 22 , additionally comprising computer readable program code devices configured to cause a computer to receive data corresponding to the data in the command transmitted to the server.
Claim 29
Dependent Claim
25 words
The computer program product of claim 21 wherein the command transmitted is selected from at least one of an execute command and a fetch command.
Claim 30
Dependent Claim
18 words
The computer program product of claim 20 wherein the request comprises an explicit numerical quantity of the data.
References Cited (Backward Citations)
US5822749A
Cited
US5797001A
Cited
US5819268A
Cited
US5832231A
Cited
US5632015A
Cited
US5835904A
Cited
US5754771A
Cited
US5812527A
Cited
US5802569A
Cited
US5787461A
Cited
USPTO Annuity & Maintenance Windows
| Annuity Stage | Window Opens | Payment Deadline | Surcharge Period Until | Estimated Fee | Status |
|---|---|---|---|---|---|
| 3.5 Years (Year 4) | 2005-07-15 | 2006-01-14 | 2006-07-16 | $2000.00 | Window Closed / Lapsed |
| 7.5 Years (Year 8) | 2009-07-15 | 2010-01-14 | 2010-07-16 | $3760.00 | Window Closed / Lapsed |
| 11.5 Years (Year 12) | 2013-07-15 | 2014-01-14 | 2014-07-16 | $7700.00 | Window Closed / Lapsed |