PARAMETERIZED CONTINUOUS QUERY TEMPLATES

• US 20140095543A1
• Filed: 03/14/2013
• Published: 04/03/2014
• 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, Zhang, Jianrong, Zhou, Xiaochao
• Granted Patent: US 10,042,890 B2
• Time in Patent Office: Days
• US Class Current: 707/779
• 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 selection of one or more business logic templates;

receive, via the selected template, business event parameters associated with a user; and

generate, based at least in part on the selections of the one or more business logic templates and the business event parameters associated with the user, a continuous query for retrieving business event data of 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 execute the generated continuous query to retrieve the business event data of the user.

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

4. The system of claim 1, wherein the selected one or more business logic templates indicate at least a type of template for generating a corresponding type of continuous query for the user.

5. The system of claim 4, wherein the type of template comprises at least one of an alert template type, 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.

6. The system of claim 5, wherein the alert template includes at least a key performance indicator alert template.

7. 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.

8. The system of claim 1, wherein the continuous query is configured to process streaming data or relation data.

9. The system of claim 8, wherein the relation data includes at least an unordered, time-varying set of tuples associated with the business event data of the user.

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

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

12. A 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 selection of one of a plurality of continuous query types;

instructions that cause the one or more processors to at least provide, based at least in part on the received selection, a continuous query template corresponding to the selected continuous query type; and

instructions that cause the one or more processors to at least receive, via the provided continuous query template, business event parameters; and

instructions that cause the one or more processors to at least generate a continuous query based at least in part on the business event parameters and the continuous query template.

13. The computer-readable memory of claim 12, 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.

14. The computer-implemented method of claim 13, 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.

15. The computer-implemented method of claim 12, wherein the continuous query is configured to enable retrieval of data from a stream or a relation.

16. A computer-implemented method, comprising:

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

receiving selection of one of the plurality of business event query template types;

providing, based at least in part on the received selection, a query template corresponding to the selected business event query template type;

receiving, via the provided query template, business event parameters associated with user data;

generating a continuous query based at least in part on the received business event parameters and the query template; and

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

19. The computer-implemented method of claim 16, 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.

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

17. The computer-implemented method of 16, further comprising providing the processed user data in a user interface configured for active display.

18. The computer-implemented method of 16, wherein processing the user data includes at least receiving the user data from a stream or based at least in part on a relation.