USE OF ANALYTICS TO SCHEDULE, SUBMIT OR MONITOR PROCESSES OR REPORTS

• US 20100162246A1
• Filed: 12/19/2008
• Published: 06/24/2010
• Est. Priority Date: 12/19/2008
• Status: Active Grant

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle International Corporation (Oracle Corporation)
• Inventors: Manyam, Balamurali, Kawanishi, Ashton, Tollefson, Lynda, Hunur, Nagaraj M., Bodla, Prasad
• Granted Patent: US 9,563,668 B2
• Time in Patent Office: Days
• US Class Current: 718/101
• CPC Class Codes: G06F 16/2465 Query processing support for facilitating data mining operations in structured databases
• CPC Class Codes: G06F 16/248 Presentation of query results

Abstract

Embodiments of the invention provide for executing a batch process on a repository of information. According to one embodiment, executing a batch process can comprise presenting one or more aspects of records of the repository and receiving a selection of a criteria for at least one aspect of the records. Records matching the selected criteria can be identified and a summary of the information can be presented. The batch process can comprise one of a plurality of batch processes. In such a case, a selection of the batch process can be received and parameters of the batch process can be populated with the selected criteria. The batch process can then be executed with the parameters. For example, executing the batch process can comprise generating a report based on the parameters and the records of the repository.

Claims

1. A method of executing a batch process on a plurality of records in a corpus of information, the method comprising:

presenting one or more aspects of the plurality of records, each aspect comprising one or more criteria;

receiving a selection of a criteria for at least one aspect of the plurality of records;

identifying one or more records of the plurality of records matching each of the selected criteria; and

presenting a summary of the corpus of information based on the identified one or more records.

2. The method of claim 1, wherein the batch process comprises one of a plurality of batch processes.

3. The method of claim 2, further comprising:

receiving a selection of the batch process; and

in response to the selection, populating one or more parameters of the batch process with the selected criteria.

4. The method of claim 3, further comprising executing the batch process with the one or more parameters.

5. The method of claim 4, wherein executing the batch process comprises generating a report based on the one or more parameters and the plurality of records.

6. The method of claim 1, wherein presenting the summary of the corpus of information based on the selected criteria comprises displaying a graph, the graph enumerating records matching the selected criteria.

7. The method of claim 1, wherein each of the one or more aspects comprises a general category for representing records of the plurality of records.

8. The method of claim 7, wherein each of the one or more criteria comprises a specific sub-category for representing records in each category.

9. The method of claim 3, wherein the batch process comprises a script including one or more variables and wherein values for the one or more variables are passed to the script via the one or more parameters.

10. The method of claim 9, wherein the script comprises a Structured Query language (SQL) script.

11. A system comprising:

a database containing a corpus of information, the corpus of information including a plurality of records;

a processor communicatively coupled with the repository; and

a memory communicatively coupled with and readable by the processor, the memory having stored therein a series of instructions which, when executed by the processor, cause the processor to present one or more aspects of the plurality of records, receive a selection of a criteria for at least one aspect of the plurality of records, identify one or more records of the plurality of records matching each of the selected criteria, and present a summary of the corpus of information based on the identified one or more records.

12. The system of claim 11, wherein the batch process comprises one of a plurality of batch processes.

13. The system of claim 12, wherein the instructions further cause the processor to receive a selection of the batch process, and in response to the selection, populate one or more parameters of the batch process with the selected criteria.

14. The system of claim 13, further comprising a database management system adapted to execute the batch process with the one or more parameters.

15. The system of claim 14, wherein executing the batch process comprises generating a report based on the one or more parameters and the plurality of records.

16. The system of claim 11, wherein presenting the summary of the corpus of information based on the selected criteria comprises displaying a graph, the graph enumerating records matching the selected criteria.

17. The system of claim 11, wherein each of the one or more aspects comprises a general category for representing records of the plurality of records.

18. The system of claim 17, wherein each of the one or more criteria comprises a specific sub-category for representing records in each category.

19. The system of claim 13, wherein the batch process comprises a script including one or more variables and wherein values for the one or more variables are passed to the script via the one or more parameters.

20. The system of claim 19, wherein the script comprises a Structured Query language (SQL) script.

21. A machine-readable medium having stored thereon a series of instructions which, when executed by a processor, cause the processor to execute a batch process on a plurality of records in a corpus of information by:

presenting one or more aspects of the plurality of records, each aspect comprising one or more criteria;

receiving a selection of a criteria for at least one aspect of the plurality of records;

identifying one or more records of the plurality of records matching each of the selected criteria; and

presenting a summary of the corpus of information based on the identified one or more records.

22. The machine-readable medium of claim 21, wherein the batch process comprises one of a plurality of batch processes.

23. The machine-readable medium of claim 22, further comprising:

receiving a selection of the batch process; and

in response to the selection, populating one or more parameters of the batch process with the selected criteria.

24. The machine-readable medium of claim 23, further comprising executing the batch process with the one or more parameters.

25. The machine-readable medium of claim 24, wherein executing the batch process comprises generating a report based on the one or more parameters and the plurality of records.

26. The machine-readable medium of claim 21, wherein presenting the summary of the corpus of information based on the selected criteria comprises displaying a graph, the graph enumerating records matching the selected criteria.

27. The machine-readable medium of claim 21, wherein each of the one or more aspects comprises a general category for representing records of the plurality of records.

28. The machine-readable medium of claim 27, wherein each of the one or more criteria comprises a specific sub-category for representing records in each category.

29. The machine-readable medium of claim 23, wherein the batch process comprises a script including one or more variables and wherein values for the one or more variables are passed to the script via the one or more parameters.

30. The machine-readable medium of claim 29, wherein the script comprises a Structured Query language (SQL) script.