Data summarization integration

• US 8,600,961 B2
• Filed: 02/16/2012
• Issued: 12/03/2013
• Est. Priority Date: 02/16/2012
• Status: Active Grant

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle International Corporation (Oracle Corporation)
• Inventors: Vermette, Shane Robert, Manguluru, Vijay
• Primary Examiner(s): LE, HUNG D
• Application Number:
  US13/398,301
• Publication Number:
  US 20130218856A1
• Time in Patent Office: 656 Days
• Field of Search: None
• US Class Current: 707/703
• CPC Class Codes: G06Q 10/06 Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling

Abstract

Embodiments of the invention provide systems and methods for providing summarizations of data and transactions based on the status of the summarization and the data and transactions being summarized. According to one embodiment, a method for providing summarizations of data and transactions related to one or more applications can comprise initiating a first summarization of the data and transactions related to the one or more applications. The first summarization can be paused in response to a request to evaluate the data and transactions being summarized. Data and transactions available for summarization can be evaluated in response to and based on the request. The first summarization can be resumed upon a completion or a timeout of the evaluating of the data and transactions being summarized.

Claims

1. A method for providing summarizations of data and transactions related to one or more applications, the method comprising:

initiating, by a computer system, a first summarization of the data and transactions related to the one or more applications;

pausing, by the computer system, the first summarization in response to a request to evaluate the data and transactions being summarized;

evaluating, by the computer system, data and transactions available for summarization in response to and based on the request; and

resuming, by the computer system, the first summarization upon a completion or a timeout of the evaluating of the data and transactions being summarized, wherein resuming the first summarization upon a timeout of the evaluating of the data and transactions being summarized comprises determining, by the computer system, whether the first summarization is currently paused, in response to determining that the first summarization is currently paused, further determining, by the computer system, whether pausing the first summarization has timed out according to a predetermined timeout limit, and in response to determining that pausing the first summarization has timed out, recording, by the computer system, an indication that pausing the first summarization has timed out.

2. The method of claim 1, wherein pausing the summarization comprises:

acquiring a pause identifier for a pause instance of the first summarization;

translating parameters passed to the pause instance to a scope of the pause instance;

obtaining an exclusive lock on the scope of the pause instance;

determining whether one or more second summarizations overlap with the pause instance;

in response to determining that one or more other summarizations overlap with the pause instance, setting a pause indicator for the one or more second summarizations; and

releasing the exclusive lock on the scope of the pause instance.

3. The method of claim 2, wherein evaluating the data and transactions being summarized comprises:

receiving the request to evaluate the data and transactions being summarized, the request including a pause identifier;

determining whether the pause identifier from the request is a valid pause identifier for the pause instance of the first summarization; and

in response to determining the pause identifier from the request is a valid pause identifier for the pause instance of the first summarization, executing an evaluation identified in the request.

4. The method of claim 2, wherein resuming the first summarization comprises:

receiving a request to resume the first summarization, and any other summarizations affected by the pause, the request including a pause identifier;

determining whether the pause identifier from the request is a valid pause identifier for the pause instance of the first summarization; and

in response to determining the pause identifier from the request is a valid pause identifier for the pause instance of the first summarization, deleting any pause indicators for pause instances with the same pause identifier and releasing the exclusive lock on the scope of the pause instance.

5. The method of claim 1, wherein executing the first summarization further comprises:

populating in a queue the first summarization instance with data to be exposed in the first summarization, the queue comprising data to be exposed in one or more summarizations;

creating an event for exposing the data in the first summarization; and

upon a failure of the first summarization or a timeout of the event for exposing the data in the first summarization, copying the data to be exposed in the first summarization from the queue to a quarantine.

6. The method of claim 5, further comprising:

processing, by the computer system, the queue of data to be exposed;

upon completion of processing the queue of data to exposed, processing, by the computer system, data from the quarantine in a same scope as the first summarization; and

upon completion of processing data from the quarantine in the same scope as the first summarization, loading, by the computer system, all data from the quarantine into the queue and purging the loaded data from the quarantine.

7. A method for providing summarizations of data and transactions related to one or more applications, the method comprising:

issuing a pause, by a computer system, in response to a request to evaluate the data and transactions being summarized;

initiating, by the computer system, a first summarization of the data and transactions related to the one or more applications;

enforcing, by the computer system, the pause on the first summarization;

evaluating, by the computer system, data and transactions available for summarization in response to and based on the request; and

releasing the pause, by the computer system, wherein releasing the pause includes resuming the first summarization upon a completion or a timeout of the evaluating of the data and transactions being summarized, wherein releasing the pause upon a timeout of the evaluating of the data and transactions being summarized comprises determining, by the computer system, whether the pause has timed out according to a predetermined timeout limit and in response to determining that the pause has timed out, recording, by the computer system, an indication that the pause has timed out.

8. The method of claim 7, wherein issuing a pause comprises:

acquiring a pause identifier for a pause instance;

obtaining an exclusive lock on a scope of the pause instance;

determining whether one or more summarizations overlap with the scope of the pause instance;

in response to determining that one or more summarizations overlap with the pause instance, setting a pause indicator for the one or more summarizations; and

releasing the exclusive lock on the scope of the pause instance.

9. The method of claim 8, wherein evaluating the data and transactions being summarized comprises:

receiving the request to evaluate the data and transactions being summarized, the request including a pause identifier;

determining whether the pause identifier from the request is a valid pause identifier for the pause instance; and

in response to determining the pause identifier from the request is a valid pause identifier for the pause instance, executing an evaluation identified in the request.

10. The method of claim 8, wherein resuming the first summarization comprises:

receiving a request to resume the pause instance, the request including a pause identifier;

determining whether the pause identifier from the request is a valid pause identifier for the pause instance; and

in response to determining the pause identifier from the request is a valid pause identifier for the pause instance, deleting any pause indicators for pause instances with the same pause identifier and releasing the exclusive lock on the scope of the pause instance.

11. A system comprising:

a processor; and

a memory communicatively coupled with and readable by the processor and having stored therein a sequence of instructions which, when executed by the processor, cause the processor to provide summarizations of data and transactions related to one or more applications by initiating a first summarization of the data and transactions related to the one or more applications, pausing the first summarization in response to a request to evaluate the data and transactions being summarized, evaluating data and transactions available for summarization in response to and based on the request, and resuming the first summarization upon a completion or a timeout of the evaluating of the data and transactions being summarized, wherein resuming the first summarization upon a timeout of the evaluating of the data and transactions being summarized comprises determining whether the first summarization is currently paused, in response to determining that the first summarization is currently paused, further determining whether pausing the first summarization has timed out according to a predetermined timeout limit, and in response to determining that pausing the first summarization has timed out, recording an indication that pausing the first summarization has timed out.

12. The system of claim 11, wherein pausing the summarization comprises:

acquiring a pause identifier for a pause instance of the first summarization;

translating parameters passed to the pause instance to a scope of the pause instance;

obtaining an exclusive lock on the scope of the pause instance;

determining whether one or more second summarizations overlap with the pause instance;

in response to determining that one or more other summarizations overlap with the pause instance, setting a pause indicator for the one or more second summarizations; and

releasing the exclusive lock on the scope of the pause instance.

13. The system of claim 12, wherein evaluating the data and transactions being summarized comprises:

receiving the request to evaluate the data and transactions being summarized, the request including a pause identifier;

determining whether the pause identifier from the request is a valid pause identifier for the pause instance of the first summarization; and

in response to determining the pause identifier from the request is a valid pause identifier for the pause instance of the first summarization, executing an evaluation identified in the request.

14. The system of claim 12, wherein resuming the first summarization comprises:

receiving a request to resume the first summarization, and any other summarizations affected by the pause, the request including a pause identifier;

determining whether the pause identifier from the request is a valid pause identifier for the pause instance of the first summarization; and

in response to determining the pause identifier from the request is a valid pause identifier for the pause instance of the first summarization, deleting any pause indicators for pause instances with the same pause identifier and releasing the exclusive lock on the scope of the pause instance.

15. The system of claim 11, wherein executing the first summarization further comprises:

populating in a queue the first summarization instance with data to be exposed in the first summarization, the queue comprising data to be exposed in one or more summarizations;

creating an event for exposing the data in the first summarization; and

upon a failure of the first summarization or a timeout of the event for exposing the data in the first summarization, copying the data to be exposed in the first summarization from the queue to a quarantine.

16. The system of claim 15, wherein providing summarizations of data and transactions related to one or more applications further comprises:

processing the queue of data to be exposed;

upon completion of processing the queue of data to exposed, processing data from the quarantine in a same scope as the first summarization; and

upon completion of processing data from the quarantine in the same scope as the first summarization, processing all the data from the quarantine.