Parameterized continuous query templates

• US 10,042,890 B2
• Filed: 03/14/2013
• Issued: 08/07/2018
• Est. Priority Date: 09/28/2012
• Status: Active Grant

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle International Corporation (Oracle Corporation)
• Inventors: Hsiao, Eric, Zhou, Xiaochao, Zhang, Jianrong
• Primary Examiner(s): Kim, Paul
• Application Number:
  US13/827,631
• Publication Number:
  US 20140095543A1
• Time in Patent Office: 1,972 Days
• CPC Class Codes: B29D 2030/0682 Inner liners tubeless tyres with impervious liner or coating on the tyre B60C5/14
• CPC Class Codes: B29D 30/0681 Parts of pneumatic tyres; accessories, auxiliary operations
• CPC Class Codes: B32B 27/08 of synthetic resin
• CPC Class Codes: B32B 27/34 comprising polyamides
• CPC Class Codes: B60C 1/0008 Compositions of the inner liner
• CPC Class Codes: B60C 5/14 with impervious liner or coating on the inner wall of the tyre
• CPC Class Codes: G06F 16/242 Query formulation
• CPC Class Codes: G06F 16/245 Query processing
• CPC Class Codes: G06F 16/2453 Query optimisation
• CPC Class Codes: G06F 16/24535 of sub-queries or views
• CPC Class Codes: G06F 16/24539 using cached or materialised query results
• CPC Class Codes: G06F 16/2455 Query execution
• CPC Class Codes: G06F 16/24553 of query operations
• CPC Class Codes: G06F 16/2456 Join operations
• CPC Class Codes: G06F 16/24568 Data stream processing; Continuous queries
• CPC Class Codes: G06F 16/2474 Sequence data queries, e.g. querying versioned data
• CPC Class Codes: G06F 16/2477 Temporal data queries
• CPC Class Codes: G06F 16/248 Presentation of query results
• CPC Class Codes: G06F 16/25 Integrating or interfacing systems involving database management systems
• CPC Class Codes: G06F 16/313 Selection or weighting of terms for indexing
• CPC Class Codes: G06F 16/9024 : Graphs; Linked lists G06F16/9027 takes precedence
• CPC Class Codes: G06F 16/951 : Indexing; Web crawling techniques

Abstract

Techniques for managing parameterized continuous query templates are provided. In some examples, a continuous query may be generated based at least in part on one or more selections of one or more business logic templates and business event parameters associated with a user. The continuous query may also be configured to retrieve business event data of the user. In some examples, a service provider may receive selection of one or more business logic templates. The service provider may also receive the business event parameters associated with the user. The business event parameters may be received via the selected template. The continuous query may then be generated using the information received via the template.

Claims

1. A system comprising:

a memory storing a plurality of instructions; and

one or more processors configured to access the memory, wherein the one or more processors are further configured to execute the plurality of instructions to at least;

receive, via a first user interface, a selection of a business logic template from a plurality of business logic templates from a user, the selected business logic template indicating at least a type of template for generating a corresponding type of continuous query for the user, the selected business logic template comprising a Key Performance Indicator (KPI) alert template;

generate the selected business logic template by;

identifying one or more query parameters related to the selected business logic template, the set of one or more query parameters comprising at least one KPI measure that identifies a critical metric of an organization, and the at least one KPI measure specifying an aggregation on a column of a data object in the KPI alert template;

determining a set of one or more threshold parameters specifying one or more threshold conditions for the set of one or more query parameters; and

defining an alert event to be transmitted to the user when a value associated with a query parameter exceeds a threshold condition specified by the set of one or more threshold parameters associated with the at least one query parameter;

upon the generation of the selected business logic template, determine, from a set of input data source types, one or more compatible input data source types usable with the selected business logic template based at least in part on actions associated with the selected business logic template, the set of input data source types including a stream type data and a relation type data;

provide, via a second user interface, the set of one or more query parameters associated with the selected business logic template;

receive via the second user interface, a value associated with the at least one KPI measure from the set of one or more query parameters from the user;

receive via the second user interface, a user-selected input data source type of the one or more compatible input data source types;

provide, via a third user interface, the set of one or more threshold parameters for the at least one KPI measure, the set of one or more threshold parameters specifying the one or more threshold conditions for the at least one KPI measure;

receive, via the third user interface, one or more values associated with the set of one or more threshold parameters for the at least one KPI measure from the user;

generate a continuous query for retrieving business event data of the user based at least in part on the selected business logic template, the set of one or more query parameters associated with the selected business logic template, and the set of one or more threshold parameters, the continuous query configured to provide the alert event when the value associated with the at least one KPI measure exceeds the threshold condition specified by the set of one or more threshold parameters associated with the at least one KPI measure;

receive a request to save the generated continuous query;

generate an extensible markup language (XML) file configured to enable subsequent generation of the generated continuous query;

store the extensible markup language file; and

execute the continuous query on an input data source of the user-selected input data source type to retrieve the business event data associated with the user.

2. The system of claim 1, wherein the one or more processors are further configured to execute the plurality of instructions to at least provide, via a fourth user interface, display of the retrieved business event data of the user.

3. The system of claim 1, wherein the type of template comprises at least one of a duplicate detection template type, an event count monitoring template type, a missing event detection template type, a trending detection template type, a top N item detection template type, or a moving aggregation template type.

4. The system of claim 1, wherein the one or more processors are further configured to execute the plurality of instructions to at least:

receive a request to open an active dashboard for presenting the business event data of the user; and

enable a report cache to retrieve the extensible markup language file from a metadata service configured to store the extensible markup language file.

5. The system of claim 1, wherein the one or more processors are further configured to execute the plurality of instructions to at least provide a user interface for selecting from among the one or more business logic templates prior to receiving the selection of the one or more business logic templates or the business event parameters.

6. The system of claim 1, wherein the input data source is an archived relation data object containing an unordered, time-varying set of tuples associated with the business event data of the user.

7. The system of claim 1, wherein the continuous query is configured as a flat query or a group query.

8. The system of claim 1, wherein selection of the one or more business logic templates includes at least receiving a user-defined template.

18. The system of claim 1, wherein the KPI alert template enables the user to generate a continuous query configured to provide the alert event when the value associated with the at least one KPI measure exceeds the threshold condition specified by the set of one or more threshold parameters associated with the at least one KPI measure.

19. The system of claim 1, wherein the KPI measure comprises at least one of a financial performance measure, a notification event, or a call processing time associated with an organization.

9. A non-transitory computer-readable memory storing a plurality of instructions executable by one or more processors, the plurality of instructions comprising:

instructions that cause the one or more processors to at least receive, via a first user interface, a selection of a continuous query type from a plurality of continuous query types from a user;

instructions that cause the one or more processors to generate, based at least in part on the received selection, a continuous query template corresponding to the selected continuous query type, the continuous query template comprising a Key Performance Indicator (KPI) alert template, the instructions to generate the continuous query template further comprising;

instructions that cause the one or more processors to identify a set of one or more query parameters related to the selected continuous query type, the set of one or more query parameters comprising at least one KPI measure that identifies a critical metric of an organization, and the at least one KPI measure specifying an aggregation on a column of a data object in the KPI alert template;

instructions that cause the one or more processors to determine a set of one or more threshold parameters specifying one or more threshold conditions for the set of one or more query parameters; and

instructions that cause the one or more processors to define an alert event to be transmitted to the user when a value associated with a query parameter exceeds a threshold condition specified by the set of one or more threshold parameters associated with the at least one query parameter;

instructions that cause the one or more processors to determine, upon the generation of the continuous query template, one or more compatible input data source types, from a set of input data source types, usable with the continuous query template based at least in part on actions associated with the continuous query template, the set of input data source types including a stream type data and a relation type data;

instructions that cause the one or more processors to provide, via a second user interface, the set of one or more query parameters associated with the continuous query template;

instructions that cause the one or more processors to at least receive, via the second user interface, a value associated with the at least one KPI measure from the set of one or more query parameters from the user;

instructions that cause the one or more processors to at least receive, via the second user interface, a user-selected input data source type of the one or more compatible input data source types;

instructions that cause the one or more processors to provide, via a third interface, the set of one or more threshold parameters for the at least one KPI measure, the set of one or more threshold parameters specifying the one or more threshold conditions for the at least one KPI measure;

instructions that cause the one or more processors to receive, via the third user interface, one or more values associated with the set of one or more threshold parameters for the at least one KPI measure from the user;

instructions that cause the one or more processors to at least generate a continuous query based at least in part on the set of one or more query parameters, the set of one or more threshold parameters, and the continuous query template, the continuous query configured to provide the alert event when the value associated with the at least one KPI measure exceeds the threshold condition specified by the set of one or more threshold parameters associated with the at least one KPI measure;

instructions that cause the one or more processors to at least receive a request to save the generated continuous query;

instructions that cause the one or more processors to at least generate an extensible markup language (XML) file configured to enable subsequent generation of the generated continuous query;

instructions that cause the one or more processors to at least store the extensible markup language file; and

instructions that cause the one or more processors to execute the continuous query on an input data source of the user-selected input data source type to retrieve the business event data associated with the user.

10. The non-transitory computer-readable memory of claim 9, wherein the plurality of instructions further comprise instructions that cause the one or more processors to at least provide a different respective interface for at least a subset of the plurality of continuous query types.

11. The non-transitory computer-readable memory of claim 10, wherein the continuous query template includes at least one of an alert template, a duplicate detection template, an event count monitoring template, a missing event detection template, a trending detection template, a top N item detection template, or a moving aggregation template.

12. The non-transitory computer-readable memory of claim 9, wherein the input data source is an archived relation data object containing an unordered, time-varying set of tuples associated with the business event data of the user.

13. A computer-implemented method, comprising:

providing a first user interface configured to enable selection from a plurality of business event query template types from a user;

receiving selection of a business event query template type from the plurality of business event query template types, the selected business event query template type comprising a Key Performance Indicator (KPI) alert template;

generating the selected business event query template type by;

identifying a set of one or more query parameters related to the selected business event query template type, the set of one or more query parameters comprising at least one KPI measure that identifies a critical metric of an organization, and the at least one KPI measure specifying an aggregation on a column of a data object in the KPI alert template;

determining a set of one or more threshold parameters specifying one or more threshold conditions for the set of one or more query parameters; and

defining an alert event to be transmitted to the user when a value associated with a query parameter exceeds a threshold condition specified by the set of one or more threshold parameters associated with the at least one query parameter;

upon the generation of the selected business event query template type, determine, from a set of input data source types, one or more compatible input data source types usable with the selected business event query template type based at least in part on actions associated with the selected business event query template type, the set of input data source types including a stream type data and a relation type data;

providing, via the first user interface, based at least in part on the received selection, the KPI alert template;

providing, via a second user interface, the set of one or more query parameters associated with the selected business event query template;

receiving, via the second user interface, a value associated with the at least one KPI measure from the set of one or more query parameters from the user;

receiving, via the second user interface, a user-selected input data source type of the one or more compatible input data source types;

providing, via a third interface, the set of one or more threshold parameters for the at least one KPI measure, the set of one or more threshold parameters specifying the one or more threshold conditions for the at least one KPI measure;

receiving, via the third user interface, one or more values associated with the set of one or more threshold parameters for the at least one KPI measure from the user;

generating a continuous query based at least in part on the set of one or more query parameters, the set of one or more threshold parameters, and the business event query template, the continuous query configured to provide the alert event when the value associated with the at least one KPI measure exceeds the threshold condition specified by the set of one or more threshold parameters associated with the at least one KPI measure;

receiving a request to save the generated continuous query;

generating an extensible markup language (XML) file configured to enable subsequent generation of the continuous query;

storing the extensible markup language file; and

execute the continuous query on an input data source of the user-selected input data source type to retrieve the business event data associated with the user.

14. The computer-implemented method of claim 13, further comprising:

processing user data based at least in part on the generated continuous query; and

providing the processed user data in a user interface configured for active display.

15. The computer-implemented method of claim 13, further comprising processing the user data based at least in part on the generated continuous query, wherein processing the user data includes at least receiving the user data from a stream or based at least in part on a relation.

16. The computer-implemented method of claim 13, further comprising dynamically loading a workflow at least in response to the received selection, and wherein generating the continuous query includes at least implementing the workflow based at least in part on the business event parameters.

17. The computer-implemented method of claim 13, further comprising providing a natural language statement for identifying functionality of the continuous query.