US5978787A
Expired / Lapsed
US
⏱️ 0.0 years remaining
Report server caching
Assignee: Oracle International Corp
•
Filing: 1997-02-28
•
Granted: 1999-11-02
•
Expires: 2017-02-28
Abstract
Abstract A method and apparatus for processing reports is disclosed. After receiving a current report request, a duplicate job detection (DJD) key is generated based upon the current report request. The DJD key is then compared to DJD keys associated with previous report requests to determine whether the currently requested report has been previously requested. If the currently requested report has been previously requested, then a saved report generated in response to the previous report request is retrieved. Otherwise, a new report is generated based upon the current report request and then stored.
Inventors
- 👤 Simon Wong
- 👤 Stewart Wilson
- 👤 Marco Tilli
Bibliographic Details
Application Number
—
Jurisdiction
US
Data Source
google_patents
Last Synchronized
2026-10-28 21:32
CPC Classifications
G; G06; G06F; G06F16/00; G06F16/20; G06F16/25; G06F16/252; Y; Y10; Y10S; Y10S707/00; Y10S707/99931; Y10S707/99932
Claims Analysis
Total Claims: 25
Claim 1
Independent Claim
149 words
A method for processing report requests, the method comprising the computer-implemented steps of: a) receiving a new report request; b) determining whether a new report specified by the new report request was requested by a previous report request within a specified time prior to receiving the new report request; c) if the new report satisfies a set of conditions which includes that the new report was requested by a previous report request within a specified time prior to receiving the new report request, then providing a prior report specified by the previous report request; and d) if the new report does not satisfy a set of conditions which includes that the new report was requested by a previous report request within a specified time prior to receiving the new report request, then performing the steps of i) generating and providing the new report, and ii) saving the new report.
Claim 2
Independent Claim
149 words
A method for processing report requests, the method comprising the computer-implemented steps of: a) receiving a new report request; b) determining whether a new report specified by the new report request was requested by a previous report request within a specified time prior to receiving the new report request; c) if the new report satisfies a set of conditions which includes that the new report was requested by a previous report request within a specified time prior to receiving the new report request, then providing a prior report specified by the previous report request; and d) if the new report does not satisfy a set of conditions which includes that the new report was requested by a previous report request within a specified time prior to receiving the new report request, then performing the steps of i) generating and providing the new report, and ii) saving the new report.
Claim 3
Dependent Claim
56 words
The method of claim 1, wherein the step of determining whether a new report specified by the current report request was requested by a previous report request prior to receiving the new report request includes the step of comparing the new report request to a previous report request received prior to receiving the new report request.
Claim 4
Dependent Claim
51 words
The method of claim 2, wherein the step of comparing the new report request to a previous report request received prior to receiving the new report request includes the step of comparing a report parameter associated with the new report request to a report parameter associated with the previous report request.
Claim 5
Dependent Claim
20 words
The method of claim 1, further comprising the step of saving a report parameter associated with the new report request.
Claim 6
Independent Claim
152 words
A method for processing report requests, the method comprising the computer-implemented steps of: a) receiving a new report request; b) determining whether a new report specified by the new report request was requested by a previous report request prior to receiving the new report request; c) if the new report satisfies a set of conditions which includes that the new report was requested by a previous report request prior to receiving the new report request, then providing a prior report specified by the previous report request: d) if the new report does not satisfy a set of conditions which includes that the new report was requested by a previous report request prior to receiving the new report request, then performing the steps of i) generating and providing the new report, and ii) saving the new report; and e) deleting a saved report that has been saved for more than a specified time.
Claim 7
Independent Claim
152 words
A method for processing report requests, the method comprising the computer-implemented steps of: a) receiving a new report request; b) determining whether a new report specified by the new report request was requested by a previous report request prior to receiving the new report request; c) if the new report satisfies a set of conditions which includes that the new report was requested by a previous report request prior to receiving the new report request, then providing a prior report specified by the previous report request: d) if the new report does not satisfy a set of conditions which includes that the new report was requested by a previous report request prior to receiving the new report request, then performing the steps of i) generating and providing the new report, and ii) saving the new report; and e) deleting a saved report that has been saved for more than a specified time.
Claim 8
Dependent Claim
184 words
A computer-readable medium carrying one or more sequences of one or more instructions for processing report requests, the one or more sequences of one or more instructions including instructions which, when executed by one or more processors, cause the one or more processors to perform the steps of: a) receiving a new report request; b) determining whether a new report specified by the new report request was requested by a previous report request within a specified time prior to receiving the new report request; c) if the new report satisfies a set of conditions which includes that the new report was requested by a previous report request within a specified time prior to receiving the new report request, then providing a prior report specified by the previous report request; and d) if the new report does not satisfy a set of conditions which includes that the new report was requested by a previous report request within a specified time prior to receiving the new report request, then performing the steps of i) generating and providing the new report, and ii) saving the new report.
Claim 9
Dependent Claim
184 words
A computer-readable medium carrying one or more sequences of one or more instructions for processing report requests, the one or more sequences of one or more instructions including instructions which, when executed by one or more processors, cause the one or more processors to perform the steps of: a) receiving a new report request; b) determining whether a new report specified by the new report request was requested by a previous report request within a specified time prior to receiving the new report request; c) if the new report satisfies a set of conditions which includes that the new report was requested by a previous report request within a specified time prior to receiving the new report request, then providing a prior report specified by the previous report request; and d) if the new report does not satisfy a set of conditions which includes that the new report was requested by a previous report request within a specified time prior to receiving the new report request, then performing the steps of i) generating and providing the new report, and ii) saving the new report.
Claim 10
Dependent Claim
56 words
The computer-readable medium of claim 6, wherein the instructions for determining whether the new report specified by the new report request was requested by a previous report request prior to receiving the new report request include instructions for comparing the new report request to a previous report request received prior to receiving the new report request.
Claim 11
Dependent Claim
51 words
The computer-readable medium of claim 7, wherein the instructions for comparing the new report request to a previous report request received prior to receiving the new report request include instructions for comparing a report parameter associated with the new report request to a report parameter associated with the previous report request.
Claim 12
Dependent Claim
20 words
The computer-readable medium of claim 6, further including instructions for saving a report parameter associated with the new report request.
Claim 13
Dependent Claim
187 words
A computer-readable medium carrying one or more sequences of one or more instructions for processing report requests, the one or more sequences of one or more instructions including instructions which, when executed by one or more processors, cause the one or more processors to perform the steps of: a) receiving a new report request; b) determining whether a new report specified by the new report request was requested by a previous report request prior to receiving the new report request; c) if the new report satisfies a set of conditions which includes that the new report was requested by a previous report request prior to receiving the new report request, then providing a prior report specified by the previous report request: d) if the new report does not satisfy a set of conditions which includes that the new report was requested by a previous report request prior to receiving the new report request, then performing the steps of i) generating and providing the new report, and ii) saving the new report; and e) deleting a saved report that has been saved for more than a specified time.
Claim 14
Dependent Claim
187 words
A computer-readable medium carrying one or more sequences of one or more instructions for processing report requests, the one or more sequences of one or more instructions including instructions which, when executed by one or more processors, cause the one or more processors to perform the steps of: a) receiving a new report request; b) determining whether a new report specified by the new report request was requested by a previous report request prior to receiving the new report request; c) if the new report satisfies a set of conditions which includes that the new report was requested by a previous report request prior to receiving the new report request, then providing a prior report specified by the previous report request: d) if the new report does not satisfy a set of conditions which includes that the new report was requested by a previous report request prior to receiving the new report request, then performing the steps of i) generating and providing the new report, and ii) saving the new report; and e) deleting a saved report that has been saved for more than a specified time.
Claim 15
Independent Claim
167 words
A method for processing database report requests, the method comprising the steps of a) receiving a new report request; b) comparing a report parameter specified by the new report request to a report parameter specified by a previous report request received prior to receiving the new report request to determine whether a new report specified by the new report request is the same as a prior report specified by the previous report request; c) if the new report is the same as the prior report and the previous report request was received within a specified time prior to the new report request, then providing the prior report; and d) if either the new report is not the same as the prior report or the previous report request was not received within a specified time prior to the new report request, then performing the steps of i) generating the new report, ii) saving the new report, and iii) saving a report parameter specified by the new report request.
Claim 16
Independent Claim
167 words
A method for processing database report requests, the method comprising the steps of a) receiving a new report request; b) comparing a report parameter specified by the new report request to a report parameter specified by a previous report request received prior to receiving the new report request to determine whether a new report specified by the new report request is the same as a prior report specified by the previous report request; c) if the new report is the same as the prior report and the previous report request was received within a specified time prior to the new report request, then providing the prior report; and d) if either the new report is not the same as the prior report or the previous report request was not received within a specified time prior to the new report request, then performing the steps of i) generating the new report, ii) saving the new report, and iii) saving a report parameter specified by the new report request.
Claim 17
Dependent Claim
65 words
The method of claim 11, wherein the step of comparing a report parameter specified by the new report request to a report parameter specified by a previous report request includes the step of comparing a first ordered ASCII string reflecting a parameter value associated with the new report request to a second ordered ASCII string reflecting a parameter value associated with the previous report request.
Claim 18
Dependent Claim
18 words
The method of claim 12, further comprising the step of checking a report status of the prior report.
Claim 19
Independent Claim
195 words
A system for processing report requests, the system comprising: one or more processors; memory coupled to said one or more processors; and instructions for one or more processes stored in said memory; said one or more processes, when executed by said one or more processors, being configured to receive a new report request, and determine whether a new report specified by the new report request was requested by a previous report request within a specified time prior to receiving the new report request; said one or more processes being further configured to retrieve a prior report that was generated in response to the previous report request if the new report satisfies a set of conditions which includes that the new report was requested by a previous report request within a specified time prior to receiving the new report request; and said one or more processes being further configured to (A) generate the new report and (B) save the new report, if the new report does not satisfy the set of conditions which includes that the new report was requested by a previous report request within a specified time prior to receiving the new report request.
Claim 20
Independent Claim
195 words
A system for processing report requests, the system comprising: one or more processors; memory coupled to said one or more processors; and instructions for one or more processes stored in said memory; said one or more processes, when executed by said one or more processors, being configured to receive a new report request, and determine whether a new report specified by the new report request was requested by a previous report request within a specified time prior to receiving the new report request; said one or more processes being further configured to retrieve a prior report that was generated in response to the previous report request if the new report satisfies a set of conditions which includes that the new report was requested by a previous report request within a specified time prior to receiving the new report request; and said one or more processes being further configured to (A) generate the new report and (B) save the new report, if the new report does not satisfy the set of conditions which includes that the new report was requested by a previous report request within a specified time prior to receiving the new report request.
Claim 21
Dependent Claim
47 words
The system of claim 14, wherein the one or more processes are further configured determine whether the new report was requested prior to receiving the new report request by comparing the new report request to a previous report request received prior to receiving the new report request.
Claim 22
Dependent Claim
52 words
The system of claim 15, wherein the one or more processes compare the new report request to a previous report request received prior to receiving the new report request by comparing a first report parameter associated with the new report request to a second report parameter associated with the previous report request.
Claim 23
Dependent Claim
25 words
The system of claim 14, wherein the one or more processes are further configured to save a report parameter associated with the new report request.
Claim 24
Independent Claim
206 words
A system for processing report requests the system comprising: one or more processors; memory coupled to said one or more processors; and instructions for one or more processes stored in said memory; said one or more processes, when executed by said one or more processors, being configured to receive a new report request, and determine whether a new report specified by the new report request was requested by a previous report request prior to receiving the new report request; said one or more processes being further configured to retrieve a prior report that was generated in response to the previous report request if the new report satisfies a set of conditions which includes that the new report was requested by a previous report request prior to receiving the new report request; said one or more processes being further configured to (A) generate the new report and (B) save the new report, if the new report does not satisfy the set of conditions which includes that the new report was requested by a previous report request prior to receiving the new report request; and said one or more processes being further configured to delete a saved report that has been saved for more than a specified time.
Claim 25
Independent Claim
206 words
A system for processing report requests the system comprising: one or more processors; memory coupled to said one or more processors; and instructions for one or more processes stored in said memory; said one or more processes, when executed by said one or more processors, being configured to receive a new report request, and determine whether a new report specified by the new report request was requested by a previous report request prior to receiving the new report request; said one or more processes being further configured to retrieve a prior report that was generated in response to the previous report request if the new report satisfies a set of conditions which includes that the new report was requested by a previous report request prior to receiving the new report request; said one or more processes being further configured to (A) generate the new report and (B) save the new report, if the new report does not satisfy the set of conditions which includes that the new report was requested by a previous report request prior to receiving the new report request; and said one or more processes being further configured to delete a saved report that has been saved for more than a specified time.
References Cited (Backward Citations)
US5008853A
Cited
US5625818A
Cited
US5799322A
Cited
US5694608A
Cited
US5826253A
Cited
US5727220A
Cited
USPTO Annuity & Maintenance Windows
| Annuity Stage | Window Opens | Payment Deadline | Surcharge Period Until | Estimated Fee | Status |
|---|---|---|---|---|---|
| 3.5 Years (Year 4) | 2002-11-01 | 2003-05-03 | 2003-11-02 | $2000.00 | Window Closed / Lapsed |
| 7.5 Years (Year 8) | 2006-11-01 | 2007-05-03 | 2007-11-02 | $3760.00 | Window Closed / Lapsed |
| 11.5 Years (Year 12) | 2010-11-01 | 2011-05-03 | 2011-11-02 | $7700.00 | Window Closed / Lapsed |