IP Library › Granted Patent US 9,292,574
Granted Patent B2
US 9,292,574 · App. 13/827,987 · Granted Mar 22, 2016

Tactical query to continuous query conversion

Inventors: Eric Hsiao (San Mateo, CA); Vishal Sharma (Bangalore, IN); Adriano Covello Santos (Redwood City, CA); Rahul Gupta (Bangalore, IN)
Assignee: Oracle International Corporation
G06F17/30483G06F17/30389G06F17/30451G06F17/30457G06F17/30516G06F17/30548G06F17/30551G06F17/30864
View Patent ↗
Loading inventors, assignments & file history…
Monitor This Case
Get email alerts when status or documents change.
Order Certified Copies
Most orders are placed with the USPTO same day — all within 24 business hours.
Order via The Patent Place →
Pre-filled with this patent's details
Quick Facts
Patent No.
US 9,292,574
App. No.
13/827,987
Granted
Mar 22, 2016
Kind
B2
Abstract

Techniques for managing tactical query to continuous query conversion are provided. In some examples, a tactical query configured to enable the pulling of business event data from a database to a query engine may be determined. For example, a query engine may be configured with the tactical query. The configuration may be based at least in part on an indication of the business event data to be displayed. Further, in some examples, a conversion of the tactical query to a continuous query may be enabled. The conversion or enablement of the conversion may be based at least in part on a request.

Claims (39)

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:

configure, based at least in part on an indication of business event data to be displayed, a query engine with a tactical query, the tactical query configured to enable pulling the business event data from a database to the query engine;

receive, from a user, a first request to generate an active visualization of the business event data only for the user, the first request to activate the visualization comprising at least a request to collapse the business event data into one or more objects and to update the one or more objects based at least in part on a user-specified time interval;

enable, based at least in part on the first request, conversion, at runtime, of the tactical query to a continuous query configured to enable a stream of the business event data to be pushed to the query engine and to generate one or more hybrid queries for executing with a combination of the continuous query and a scheduled database query;

register a listening service to receive data pushed from the stream of the business event data;

execute the continuous query against the stream of business event data;

receive, during execution of the continuous query, a second request to change a dimension of the continuous query;

change the dimension of the continuous query via a dashboard at runtime based at least in part on the second request; and

provide a user interface configured to display the active visualization of the business event data pushed from the stream to the query engine based at least in part on the execution of the continuous query against the stream of business event data.

2. The system of claim 1 , wherein the continuous query is configured to receive data that is pushed from the stream to the listening service associated with the query engine.

3. The system of claim 1 , wherein the tactical query is configured to pull data on behalf of the query engine.

4. The system of claim 1 , wherein the user is associated with the data to be displayed.

5. The system of claim 4 , wherein the first request is received via a user interface configured to display the data to be displayed to the user.

6. The system of claim 4 , wherein the first request includes at least one of a data window, a data range, a filter value, or a dimension change associated with the user.

7. 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 determine a tactical query for querying business event data of a user from a database, the tactical query configured to enable pulling the business event data from the database to a query engine;

instructions that cause the one or more processors to configure the query engine with the tactical query;

receive, from the user, a first request to generate an active visualization of the business event data only for the user, the first request to activate the visualization comprising at least a request to collapse the business event data into one or more objects and to update the one or more objects based at least in part on a user-specified time interval;

instructions that cause the one or more processors to convert, at runtime, the tactical query to a continuous query configured to enable pushing of streaming business event data of the user to the query engine and to enable generation of one or more hybrid queries for executing with a combination of the continuous query and a scheduled database query;

instructions that cause the one or more processors to register a listening service to receive data pushed from the stream of the business event data;

instructions that cause the one or more processors to execute the continuous query against the streaming business event data;

instructions that cause the one or more processors to receive, during execution of the continuous query, a second request to change a dimension of the continuous query;

instructions that cause the one or more processors to change the dimension of the continuous query via a dashboard at runtime based at least in part on the second request; and

instructions that cause the one or more processors to provide a user interface configured to display the active visualization based at least in part on data pushed to the query engine based at least in part on the execution of the continuous query against the streaming business event data.

8. The computer-readable memory of claim 7 , wherein the tactical query is converted to the continuous query based at least in part on the first request to generate the active visualization of the business event data.

9. A computer-implemented method, comprising:

determining, by a computing system, a tactical query configured to enable pulling business event data from a database to a query engine;

configuring, based at least in part on an indication of the business event data to be displayed, the query engine with the tactical query;

receiving a first request, from a user associated with the business event data, associated with generating an active visualization of the business event data only for the user, the first request to activate the visualization comprising at least a request to collapse the business event data into one or more objects and to update the one or more objects based at least in part on a user-specified time interval;

converting at runtime, by the computing system at runtime, the tactical query to a continuous query configured to enable a stream of the business event data of the user to be pushed to the query engine and to enable generation of one or more hybrid queries for executing with a combination of the continuous query and a scheduled database query;

registering a listening service to receive data pushed from the stream of the business event data;

executing the continuous query against the stream of business event data;

receiving, during execution of the continuous query, a second request to change a dimension of the continuous query;

changing the dimension of the continuous query via a dashboard at runtime based at least in part on the second request; and

providing a user interface configured to display the active visualization based at least in part on the streaming business event data pushed to the query engine.

10. The computer-implemented method of claim 9 , further comprising receiving a third request to apply a filter to the continuous query or to change a dimension of the continuous query.

11. The computer-implemented method of claim 9 , wherein the first request associated with generating the active visualization of the business event data comprises a sliding window configuration specified by the user.

Assignments (1)
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Mar 15, 2013
From: HSIAO, ERIC; SHARMA, VISHAL; SANTOS, ADRIANO COVELLO; GUPTA, RAHUL
To: ORACLE INTERNATIONAL CORPORATION
Reel/Frame 030013/0509 →
Continuity (2)
Provisional Application 61707641 · Sep 28, 2012
Related Publication 20140095525A1 · Apr 3, 2014