Executing a batch process on a repository of information based on an analysis of the information in the repository

• US 9,563,668 B2
• Filed: 12/19/2008
• Issued: 02/07/2017
• Est. Priority Date: 12/19/2008
• Status: Active Grant

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle International Corporation (Oracle Corporation)
• Inventors: Tollefson, Lynda, Hunur, Nagaraj M., Manyam, Balamurali, Bodla, Prasad, Kawanishi, Ashton
• Primary Examiner(s): VICARY, KEITH E
• Application Number:
  US12/339,673
• Publication Number:
  US 20100162246A1
• Time in Patent Office: 2,972 Days
• US Class Current: 1/1
• 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 database, the method comprising:

presenting, by a computer system, a plurality of aspects of the plurality of records, each aspect defining a general category of information in the plurality of records and comprising one or more criteria, each of the one or more criteria defining a specific sub-category of information in the plurality of records;

receiving, by the computer system, a selection of a criterion of the one or more criteria for at least one aspect of the plurality of records;

analyzing, by the computer system, the plurality of records to identify one or more records that match the selected criterion for each of at least one aspect of the plurality of records based on the selected criterion for each of at least one aspect of the plurality of records and aspects of the plurality of records before executing one or more of a plurality of batch processes, wherein the selected criterion for each of at least one aspect of the plurality of records and aspects of the plurality of records relate to one or more parameters of the one or more of the plurality of batch processes, and wherein analyzing the one or more records comprises executing one or more queries on one or more periodically updated summary tables of the database;

presenting, by the computer system, a summary of the database based on the analysis of the plurality of records, wherein presenting the summary of the database based on the analysis of the plurality of records comprises providing a graph and a table, the graph providing a summary of information in the database based on the selected criterion for each of at least one aspect of the plurality of records and the table comprising a list of reports and a corresponding number of records in the database related to each report and wherein each entry in the list of reports comprises a link to a batch process associated with the report;

receiving, by the computer system, a selection of a batch process from the plurality of batch processes;

populating, by the computer system, the one or more parameters of the selected batch process with the selected criterion for each of at least one aspect of the plurality of records; and

executing, by the computer system, the selected batch process with the populated one or more parameters.

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

3. The method of claim 1, 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 of the selected batch process.

4. The method of claim 3, wherein the script comprises a Structured Query Language (SQL) script.

5. A system comprising:

a database including a plurality of records;

a processor communicatively coupled with the database; 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, causes the processor to;

present a plurality of aspects of the plurality of records, each aspect defining a general category of information in the plurality of records and comprising one or more criteria, each of the one or more criteria defining a specific sub-category of information in the plurality of records;

receive a selection of a criterion of the one or more criteria for at least one aspect of the plurality of records;

analyze the plurality of records to identify one or more records that match the selected criterion for each of at least one aspect of the plurality of records based on the selected criterion for each of at least one aspect of the plurality of records and aspects of the plurality of records before executing one or more of a plurality of batch processes, wherein the selected criterion for each of at least one aspect of the plurality of records and aspects of the plurality of records relate to one or more parameters of the one or more of the plurality of batch processes, and wherein analyzing the one or more records comprises executing one or more queries on one or more periodically updated summary tables of the database;

present a summary of the database based on the analysis of the plurality of records, wherein presenting the summary of the database based on the analysis of the plurality of records comprises providing a graph and a table, the graph providing a summary of information in the database based on the selected criterion for each of at least one aspect of the plurality of records and the table comprising a list of reports and a corresponding number of records in the database related to each report and wherein each entry in the list of reports comprises a link to a batch process associated with the report;

receive a selection of a batch process from the plurality of batch processes;

populate the one or more parameters of the selected batch process with the selected criterion for each of at least one aspect of the plurality of records; and

execute the selected batch process with the populated one or more parameters.

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

7. The system of claim 5, 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 of the selected batch process.

8. The system of claim 7, wherein the script comprises a Structured Query Language (SQL) script.

9. A non-transitory machine-readable medium having stored thereon a series of instructions which, when executed by a processor, causes the processor to execute a batch process on a plurality of records in a database by:

presenting a plurality of aspects of the plurality of records, each aspect defining a general category of information in the plurality of records and comprising one or more criteria, each of the one or more criteria defining a specific sub-category of information in the plurality of records;

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

analyzing the plurality of records to identify one or more records that match the selected criterion for each of at least one aspect of the plurality of records based on the selected criterion for each of at least one aspect of the plurality of records and aspects of the plurality of records before executing one or more of a plurality of batch processes, wherein the selected criterion for each of at least one aspect of the plurality of records and aspects of the plurality of records relate to one or more parameters of the one or more of the plurality of batch processes, and wherein analyzing the one or more records comprises executing one or more queries on one or more periodically updated summary tables of the database, and wherein executing the one or more queries comprises providing summations of the database based on the selected criterion for each of at least one aspect of the plurality of records and aspects of the plurality of records;

presenting a summary of the database based on the analysis of the plurality of records, wherein presenting the summary of the database based on the analysis of the plurality of records comprises providing a graph and a table, the graph providing a summary of information in the database based on the selected criterion for each of at least one aspect of the plurality of records and the table comprising a list of reports and a corresponding number of records in the database related to each report and wherein each entry in the list of reports comprises a link to a batch process associated with the report;

receiving a selection of a batch process from the plurality of batch processes;

populating the one or more parameters of the selected batch process with the selected criterion for each of at least one aspect of the plurality of records; and

executing the selected batch process with the populated one or more parameters.

10. The non-transitory machine-readable medium of claim 9, wherein executing the selected batch process comprises generating a report based on the one or more parameters of the selected batch process and the plurality of records.

11. The non-transitory machine-readable medium of claim 9, 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 of the selected batch process.

12. The non-transitory machine-readable medium of claim 11, wherein the script comprises a Structured Query Language (SQL) script.