Method and system for automated web reports

• US 6,898,599 B2
• Filed: 10/26/2001
• Issued: 05/24/2005
• Est. Priority Date: 10/26/2001
• Status: Active Grant

• Current Assignee: Oracle America, Inc. (Oracle Corporation)
• Original Assignee: Sun Microsystems Incorporated (Oracle Corporation)
• Inventors: Platt, Janice L., Young, William J.
• Primary Examiner(s): Mizrahi, Diane D.
• Application Number:
  US10/039,362
• Publication Number:
  US 20030084062A1
• Time in Patent Office: 1,306 Days
• Field of Search: 707 1- 10, 707/102, 707/101, 709/200, 709/202, 709/203, 709/221, 705/32, 714/1
• US Class Current: 1/1
• CPC Class Codes: G06F 16/9577 Optimising the visualization of content, e.g. distillation of HTML documents

Abstract

The present invention provides a method and system for viewing reports on a network. One embodiment of the present invention employs a temporary database for holding data to be used in the reports, where the data extracted from a source database. A format module formats the reports using the data in the temporary database, and an access module allows users to access the reports created by the format module.

Claims

1. In an electronic device coupled to a network, a method, comprising the steps of:

creating a temporary database for holding information from a source database;

loading the temporary database with data originating from the source database;

determining that a current usage of an electronic device holding the source database does not exceed a parameter;

using the temporary database to generate a report regarding the source database;

providing the report for access over the network.

2. The method of claim 1, wherein the network is the Internet.

3. The method of claim 1, wherein the report is one of an HTML document and XML document.

4. The method of claim 1 further comprising the steps of:

removing data from the temporary database after the report is generated; and

updating the temporary database with data from the source database prior to generating a new report.

5. The method of claim 1 further comprising the step of:

removing the temporary database from the electronic device after the report is generated.

6. The method of claim 1 further comprising the step of:

generating additional reports regarding the source database by using the temporary database.

7. The method of claim 1 further comprising the step of:

identifying a non-peak load time on an electronic device holding the source database.

8. The method of claim 7, wherein the non-peak load time is provided by a system administrator.

9. The method of claim 7, wherein an identification of the non-peak load time is retrieved from a pre-determined location.

10. The method of claim 7, wherein the generation of reports regarding the source database takes place during the identified non-peak load time.

11. A medium for use in an electronic device coupled to a network, said medium holding instructions for performing a method, comprising the steps of:

creating a temporary database for holding information from a source database;

loading the temporary database with data originating from the source database;

determining that a current usage of an electronic device holding the source database does not exceed a parameter;

using the temporary database to generate a report regarding the source database;

providing the report for access over the network.

12. The medium of claim 11, wherein the method further comprises the steps of:

removing data from the temporary database after the report is generated; and

updating the temporary database with data from the source database prior to generating a new report.

13. The medium of claim 11, wherein the method further comprises the step of removing the temporary database from the electronic device after the report is generated.

14. The medium of claim 11, wherein the method further comprises the step of generating additional reports regarding the source database by using the temporary database.

15. The medium of claim 11 further comprising the step of:

identifying a non-peak load time on an electronic device holding the source database.

16. The medium of claim 15, wherein the non-peak load time is provided by a system administrator.

17. The medium of claim 15, wherein an identification of the non-peak time is retrieved from a pre-determined location.

18. The medium of claim 15, wherein the generation of reports regarding the source database takes place during the identified non-peak load time.

19. A system for viewing reports in a network, said system comprising;

a temporary database holding data to be used in the reports, said data being extracted from a source database;

a format module for formatting the reports using the data in the temporary database; and

an access module for allowing access to users in the network the reports created by the format module;

said access module allowing generation of said reports following a determination that a current usage of an electronic device holding the source database does not exceed a parameter.

20. The system of claim 19, wherein the access module provides the reports in a format that is viewable by a client using a web browser.

21. The system of claim 19 further comprising:

an interface for interfacing the system with the network.

22. The system of claim 21, wherein the network is the Internet.

23. The said system of claim 19, wherein the determination of a current usage occurs at an identified non-peak load time on an electronic device holding the source database.

24. The system of claim 23, wherein the access module receives the identified non-peak load time via one of a system administrator and a value retrieved from a pre-determined location.

25. A method for viewing reports in a network, said method comprising:

creating a temporary database for holding information from a source database;

loading the temporary database with data originating from the source database;

defining tables and views to be used in the reports;

updating the temporary database with data received from a different source database in the network;

using the temporary database to generate a report regarding at least one of the source databases;

allowing access to users in the network to the generated reports created by a format module; and

removing old reports after a specified amount of time from the temporary database.

26. The method as recited in claim 25, wherein the reports are web accessible reports.

27. The method of claim 25, wherein the network is the Internet.

28. The method of claim 25 further comprising the step of:

identifying a non-peak load time on an electronic device interfaced with said temporary database.

29. The method of claim 28, wherein the non-peak load time is provided by a system administrator.

30. The method of claim 28, wherein the non-peak load time is identified by retrieving a value from a pre-determined location.

31. The method of claim 25 further comprising the step of:

determining current usage of an electronic device holding said source database does not exceed a pre-determined parameter.