Parameterized continuous query templates

Patent metadata

Field	Value
Publication number	US-10042890-B2
Application number	US-201313827631-A
Country	US
Kind code	B2
Filing date	Mar 14, 2013
Priority date	Sep 28, 2012
Publication date	Aug 7, 2018
Grant date	Aug 7, 2018

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.

First claim

What is claimed is:

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.

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 rece

Assignees

• Oracle Int Corp

Inventors

• Hsiao Eric
• Zhou Xiaochao
• Zhang Jianrong

Classifications

• G06F16/24539

  using cached or materialised query results · CPC title

• G06F16/2456

  Join operations · CPC title

• G06F16/2455

  Query execution · CPC title

• G06F16/24568 Primary

  Data stream processing; Continuous queries · CPC title

• G06F16/248

  Presentation of query results · CPC title