Data processing: database and file management or data structures – Database design – Data structure types
Reexamination Certificate
1999-05-17
2001-03-06
Amsbury, Wayne (Department: 2771)
Data processing: database and file management or data structures
Database design
Data structure types
Reexamination Certificate
active
06199058
ABSTRACT:
FIELD OF THE INVENTION
The present invention relates to database systems, and more specifically, to a method and apparatus for processing reports using report caching.
BACKGROUND OF THE INVENTION
With conventional client-server database report processing a client application spawns a report process which executes on the client system. The report process processes a report by requesting data from a database server process executing on a database management system which in turn retrieves data from a database. Although relatively simplistic in implementation, this approach requires that a new report process be spawned for each requested report, which can strain the resources of the client system, particularly when many reports are requested simultaneously.
To reduce the processing burden on client systems, some contemporary database report processing systems have implemented a “multi-client report server” approach, which involves transferring report processing from the client system to a different processor, such as the database system processor itself. According to the multi-client report server approach, client applications submit report requests to a report server process, executing on the database system processor, which manages the processing of reports. This approach can significantly reduce the processing burden on client systems which is attributable to report processing. However, even with the multi-client report server approach, the same report is sometimes requested by several different clients. Regenerating the same report for each client wastes system resources and can strain system resources when the same report is requested simultaneously by different clients. For example, identical financial market reports are often requested by several different clients simultaneously.
One approach for avoiding having to regenerate the same report for different clients is the “pre-generation approach” which involves generating and storing all possible reports based upon all combinations of report parameters and then periodically regenerating and restoring the reports to keep them current. When a report request is received, a stored report matching the requested parameters is retrieved instead of regenerating the report. This approach reduces the impact on system resources because each report only has to be generated once per refresh period, regardless of how many times the report is requested.
Despite the benefits of the pre-generation approach, it is not without its disadvantages. Specifically, all possible report combinations must be generated and stored, irrespective of how frequently the reports are actually requested. As the number of report parameters increases, the number of possible reports can become exceedingly large, requiring more system resources to generate and store the reports. Moreover, some reports may never be requested which wastes system resources to generate and store the reports. Consequently, the pre-generation approach is best suited for use with a small number of report parameters.
In view of the system resources required to process database reports in multiclient report server environments and the limitations inherent in the pre-generation approach, a method of processing database reports in a multi-client report server system which reduces the burden on system resources attributable to database report processing is highly desirable.
SUMMARY OF THE INVENTION
According to one aspect of the present invention, a method is provided for processing reports. After receiving a current report request, a determination is made as to whether a report specified by the current report request has been requested prior to receiving the current report request. If the report was requested by a previous report request prior to receiving the current report request, then the report that was generated in response to the previous report request is retrieved. If, on the other hand, the report was not requested by a previous report request prior to receiving the current report request, then a report specified by the current report request is generated and stored.
According to another aspect of the present invention, a method is provided for processing reports. After receiving a current report request, a report parameter associated with the current report request is compared to a report parameter associated with a previous report request which was received prior to receiving the current report request to determine whether a report specified by the current report request is the same as a report specified by the previous report request. If the report parameter associated with the current report request is the same as the report parameter associated with the prior report request, then a report that was generated in response to the prior report request is retrieved. If, on the other hand, the report parameter associated with the report request is not the same as the report parameter associated with the prior report request, then a report specified by the report request is generated and saved.
According to another aspect of the present invention, a computer system having a storage medium with a report table stored thereon is provided. The report table includes a set of report parameters specifying the contents of a report associated with the report table and a set of status data specifying the status of the report associated with the report table.
REFERENCES:
patent: 5008853 (1991-04-01), Bly et al.
patent: 5168444 (1992-12-01), Cukor et al.
patent: 5625818 (1997-04-01), Zarmer et al.
patent: 5694608 (1997-12-01), Shostak
patent: 5727220 (1998-03-01), Hohensee et al.
patent: 5799322 (1998-08-01), Mosher, Jr.
patent: 5826253 (1998-10-01), Bredenberg
patent: 5873097 (1999-02-01), Harris et al.
patent: 5895455 (1999-04-01), Bellinger et al.
Tilli Marco
Wilson Stewart
Wong Simon
Amsbury Wayne
Becker Edward A.
Hickman Palermo & Truong & Becker LLP
Oracle Corporation
LandOfFree
Report server caching does not yet have a rating. At this time, there are no reviews or comments for this patent.
If you have personal experience with Report server caching, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Report server caching will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-2444040