Parameterized continuous query templates
First Claim
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.
1 Assignment
0 Petitions
Accused Products
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.
556 Citations
19 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. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 18, 19)
-
-
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. - View Dependent Claims (10, 11, 12)
-
-
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. - View Dependent Claims (14, 15, 16, 17)
-
Specification