IP Library › Granted Patent US 12,670,167
Granted Patent B2
US 12,670,167 · App. 17/864,211 · Granted Jun 30, 2026

Real-time business event analysis and monitoring

Inventors: Hoyong Park (San Jose, CA); Anand Srinivasan (Bangalore, IN); Roger Bolsius (Round Rock, TX); Eric Hsiao (San Mateo, CA); Jeffrey Toillion (Half Moon Bay, CA); Vikram Shukla (Fremont, CA)
Assignee: Oracle International Corporation
G06F16/24568G06F16/242G06F16/245G06F16/2453G06F16/24535G06F16/24539G06F16/2455G06F16/24553G06F16/2456G06F16/2474G06F16/2477G06F16/248G06F16/25G06F16/313G06F16/9024G06F16/951
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 12,670,167
App. No.
17/864,211
Filed
Jul 13, 2022
Granted
Jun 30, 2026
Kind
B2
Art Unit
2153
USPC
707/770
Abstract

Techniques for managing real-time business event analysis and monitoring are provided. In some examples, a logical request may be received at a business intelligence server configured with a continuous query service. Additionally, the continuous query service may be configured to translate the logical request into a physical request. Further, business intelligence information may be provided based at least in part on querying against an event data stream with a continuous query configured based at least in part on the physical request translated by the continuous query service.

Claims (41)

1 . A system, comprising:

a memory storing a plurality of instructions; and

one or more processors configured to access the memory and further configured to execute the plurality of instructions to at least:

implement, by a server device, a continuous query service;

receive, at the continuous query service via an application programming interface (API), a request from a user, the request being at least in part in a logical form configured to identify one or more events;

automatically generate, by the continuous query service, a tactical query based at least in part on the logical form of the request from the user;

translate, by the continuous query service, the tactical query into a continuous query by generating the continuous query, the continuous query configured to query against a stream of event data associated with the user based at least in part on the translation;

convert, by an adapter of the continuous query service, the event data into a normalized format;

process, by a continuous query engine, the converted event data by utilizing the continuous query; and

provide information associated with an event pattern associated with the processed event data to a client device for presentation as part of an alert in a user interface comprising at least one visualization of a plurality of watch list user interfaces.

2 . The system of claim 1 , wherein the plurality of watch list user interfaces comprises key performance indicator watch list user interfaces.

3 . The system of claim 2 , wherein the one or more processors are further configured to execute the plurality of instructions to at least enable output events of the continuous query to be stored in a plurality of output tables.

4 . The system of claim 3 , wherein each output table of the plurality of output tables corresponds to a respective key performance indicator watch list user interface of the plurality of key performance indicator watch list user interfaces.

5 . The system of claim 4 , wherein each respective key performance indicator watch list user interface is configured to display real-time data of each respective key performance indicator.

6 . The system of claim 5 , wherein the one or more processors are further configured to execute the plurality of instructions to at least generate the alert, for a particular key performance indicator watch list user interface, according to the updated entry in the corresponding output table being over a threshold corresponding to the affected key performance indicators.

7 . The system of claim 1 , wherein the tactical query is received from a logical business model of the server device.

8 . A non-transitory computer-readable memory storing a plurality of instructions that, when executed by one or more processors, cause the one or more processors to perform operations comprising:

receiving, at the continuous query service via an application programming interface (API), a request from a user, the request comprising a logical statement requesting identification of one or more events;

automatically generate, by the continuous query service, a tactical query based at least in part on the logical statement of the request from the user;

translating, by the continuous query service, the tactical query into a continuous query by generating the continuous query, the continuous query configured to query against a stream of event data associated with the user based at least in part on the translation;

converting, by an adapter of the continuous query service, the event data into a normalized format;

processing, by a continuous query engine, the converted event data by utilizing the continuous query; and

providing information associated with an event pattern associated with the processed event data to a client device for presentation as part of an alert in a user interface comprising at least one visualization of a plurality of watch list user interfaces.

9 . The non-transitory computer-readable memory of claim 8 , wherein the plurality of watch list user interfaces comprises key performance indicator watch list user interfaces.

10 . The non-transitory computer-readable memory of claim 9 , wherein the operations further comprise enabling output events of the continuous query to be stored in a plurality of output tables.

11 . The non-transitory computer-implemented method of claim 10 , wherein each output table of the plurality of output tables corresponds to a respective key performance indicator watch list user interface of the plurality of key performance indicator watch list user interfaces.

12 . The non-transitory computer-implemented method of claim 11 , wherein each respective key performance indicator watch list user interface is configured to display real-time data of each respective key performance indicator.

13 . The non-transitory computer-implemented method of claim 12 , wherein the operations further comprise generating the alert, for a particular key performance indicator watch list user interface, according to the updated entry in the corresponding output table being over a threshold corresponding to the affected key performance indicators.

14 . A computer-implemented method, comprising:

receiving, at a continuous query service via an application programming interface (API), a request from a user, the request comprising a logical form configured to identify one or more events;

automatically generating, by the continuous query service, a tactical query based at least in part on the logical form of the request from the user;

translating, by the continuous query service, the tactical query into a continuous query by generating the continuous query, the continuous query configured to query against a stream of event data associated with the user based at least in part on the translation;

converting, by an adapter of the continuous query service, the event data into a normalized format;

processing, by a continuous query engine, the converted event data by utilizing the continuous query; and

providing information associated with an event pattern associated with the processed event data to a client device for presentation as part of an alert in a user interface comprising at least one visualization of a plurality of watch list user interfaces.

15 . The computer-implemented method of claim 14 , wherein the plurality of watch list user interfaces comprises key performance indicator watch list user interfaces.

16 . The computer-implemented method of claim 15 , wherein the one or more processors are further configured to execute the plurality of instructions to at least enable output events of the continuous query to be stored in a plurality of output tables.

17 . The computer-implemented method of claim 16 , wherein each output table of the plurality of output tables corresponds to a respective key performance indicator watch list user interface of the plurality of key performance indicator watch list user interfaces.

18 . The computer-implemented method of claim 17 , wherein each respective key performance indicator watch list user interface is configured to display real-time data of each respective key performance indicator.

19 . The computer-implemented method of claim 18 , wherein the one or more processors are further configured to execute the plurality of instructions to at least generate the alert, for a particular key performance indicator watch list user interface, according to the updated entry in the corresponding output table being over a threshold corresponding to the affected key performance indicators.

20 . The system of claim 1 , wherein the continuous query engine is instantiated by an event application, the event application instantiated within the continuous query service.

Assignments (1)
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Jul 15, 2022
From: PARK, HOYONG; SRINIVASAN, ANAND; BOLSIUS, ROGER; HSIAO, ERIC; TOILLION, JEFFREY; SHUKLA, VIKRA
To: ORACLE INTERNATIONAL CORPORATION
Reel/Frame 060526/0074 →
Continuity (4)
Continuation 17353581 · Jun 21, 2021
Continuation 13830378 · Mar 14, 2013
Provisional Application 61707641 · Sep 28, 2012
Related Publication 20220350808A1 · Nov 3, 2022
References Cited (44)
US 8396886B1 · Tsimelzon · 2013 [cited by examiner]
US 9047259B1 · Ho · 2015 [cited by examiner]
US 9305057B2 · de Castro Alves · 2016 [cited by examiner]
US 9305238B2 · Srinivasan · 2016 [cited by examiner]
US 9852186B2 · Herwadkar et al. · 2017 [cited by applicant]
US 11093505B2 · Park et al. · 2021 [cited by applicant]
US 20020038217A1 · Young · 2002 [cited by applicant]
US 20040030421A1 · Haley · 2004 [cited by applicant]
US 20050071217A1 · Hoogs et al. · 2005 [cited by applicant]
US 20060100957A1 · Buttler et al. · 2006 [cited by applicant]
US 20060167704A1 · Nicholls · 2006 [cited by examiner]
US 20070156787A1 · MacGregor · 2007 [cited by applicant]
US 20070299834A1 · Liu et al. · 2007 [cited by applicant]
US 20080028095A1 · Lang et al. · 2008 [cited by applicant]
US 20080115103A1 · Datars et al. · 2008 [cited by applicant]
US 20080162583A1 · Brown et al. · 2008 [cited by applicant]
US 20080275891A1 · Park · 2008 [cited by examiner]
US 20080301086A1 · Gupta · 2008 [cited by applicant]
US 20090037370A1 · Mishra · 2009 [cited by examiner]
US 20090327257A1 · Abouzeid · 2009 [cited by examiner]
US 20100017380A1 · Naibo · 2010 [cited by examiner]
US 20100138405A1 · Mihaila · 2010 [cited by examiner]
US 20100229081A1 · Rothbucher · 2010 [cited by examiner]
US 20100250572A1 · Chen · 2010 [cited by examiner]
US 20100287293A1 · Wright · 2010 [cited by examiner]
US 20110004603A1 · Osborne · 2011 [cited by examiner]
US 20110016123A1 · Pandey et al. · 2011 [cited by applicant]
US 20110016160A1 · Zhang et al. · 2011 [cited by applicant]
US 20110035253A1 · Mason · 2011 [cited by examiner]
US 20110314019A1 · Jimenez Peris · 2011 [cited by examiner]
US 20120016866A1 · Dunagan et al. · 2012 [cited by applicant]
US 20120072455A1 · Jain · 2012 [cited by examiner]
US 20120078868A1 · Chen · 2012 [cited by examiner]
US 20120116982A1 · Yoshida et al. · 2012 [cited by applicant]
US 20120158360A1 · Cammert · 2012 [cited by examiner]
US 20120166421A1 · Cammert et al. · 2012 [cited by applicant]
US 20130046725A1 · Cammert et al. · 2013 [cited by applicant]
US 20130091123A1 · Chen · 2013 [cited by examiner]
US 20130132108A1 · Solilov et al. · 2013 [cited by applicant]
US 20130262399A1 · Eker et al. · 2013 [cited by applicant]
US 20140019194A1 · Anne · 2014 [cited by applicant]
US 20140095540A1 · Hsiao · 2014 [cited by examiner]
U.S. Appl. No. 17/353,581, Notice of Allowance, mailed on May 18, 2022, 10 pages. [cited by applicant]
U.S. Appl. No. 17/518,447, “Final Office Action”, mailed Nov. 8, 2024, 38 pages. [cited by applicant]