Report server caching

• US 5,978,787 A
• Filed: 02/28/1997
• Issued: 11/02/1999
• Est. Priority Date: 02/28/1997
• Status: Expired due to Term

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle Corporation
• Inventors: Wilson, Stewart, Wong, Simon, Tilli, Marco
• Primary Examiner(s): AMSBURY, WAYNE P
• Application Number:
  US08/808,102
• Time in Patent Office: 977 Days
• Field of Search: 707/2
• US Class Current: 1/1
• CPC Class Codes: G06F 16/252 between a Database Management System and a front-end application
• CPC Class Codes: Y10S 707/99932 Access augmentation or optimizing

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.

Claims

1. 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.

2. 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.

3. 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.

4. The method of claim 1, further comprising the step of saving a report parameter associated with the new report request.

5. 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.

6. 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.

7. 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.

8. 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.

9. The computer-readable medium of claim 6, further including instructions for saving a report parameter associated with the new report request.

10. 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.

11. 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.

12. 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.

13. The method of claim 12, further comprising the step of checking a report status of the prior report.

14. 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.

15. 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.

16. 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.

17. 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.

18. 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.