Complex Event Processing FAQ


Development & Design-Time

Customer Use Cases


Q: What major runtime features are available in Oracle CEP 11gR1?
In this fast moving world of events, it is crucial to ensure, that when needed, all events are always available and that they can be shared across the potentially large numbers of Event sinks, or destination applications. In 11gR1, the transparently integrated coherence in-memory grid technology provides an potentially unmatched level of Enterprise-grade High availability and infrastructure reliability. These two “powerhouse” products together with the worlds fastest JVM, JRockit.
Q: The Continuous Query Language is now available in Oracle CEP 11gR1 what is it, and is the previous Event processing Language (EPL) still supported?
Oracle Continuous Query Language (Oracle CQL) is a Standards focused query language based on SQL with added constructs that support streaming data. Using Oracle CQL, you can express queries on data streams to perform complex event processing (CEP) using Oracle CEP. Due to the flexible loosely coupled architecture provided by EDA, Oracle CEP provides the capability to support various different processors in an EPN (Event Processing network), and therefore an EPL processor is still supported. However, it is recommended that all new OCEP applications are based on CQL.

Development & Design-time

Q: Is there any assistance in Oracle CEP 11gR1 to build Continuous Query Language (CQL) queries?
In this release, we have a compelling collection of Visual CQL construction and editing tools available. Business users and developers alike, can quickly create very complex event queries by dragging and dropping, the context aware statement identifiers from a palette onto the CEP Visualizer canvas. Using the mouse, a user can simply connect the statements together and then not only, validate the correct query structure, but immediately inject the query into an executing EDA application, without the need to restart that application.

What new features in 11gR1 do we offer Java developers?

The ability to build complete EDA/CEP Java application solutions fast and effectively has always been the goal for Oracle, on our integrated OSGi based platform. In 11gR1, we have extended our Visual Eclipse IDE capabilities by introducing the ability, to not only view the EDA event processing network application, but to now also dynamically construct an application directly on the IDE workspace canvas. The developer can then use the mouse to “wire” together the EPN nodes, such as adapters, processors and the integrated in-memory grid, caching nodes. With all of the resultant optimized Java code built on the fly for the developer.


Q: Is there EDA/CEP Industry Standards and is this addressed in Oracle CEP 11gR1?
Over this past year, EDA and CEP technologies have evolved from the early adoption phase to more mainstream acceptance. I often hear customers asking for new industry standards, particularly in regard to a single industry event processing language, abstracted from the Java code, and which is easy to understand and implement, but at the same time provides easy portability. We address this issue directly in Oracle CEP 11gR1, by including the Continuous Query Language (CQL) processor support. A significant subset of CQL has already been submitted to the ANSI SQL standards board with other vendors, and is based on the powerful, well-known and easily understood SQL, with statement extensions to address all of the additional temporal and event sequencing needs of our Complex Event Stream processing customers.
Q: What is CEP and why is it so important
One can think of complex event processing (CEP) as analogous to the database management of structured data—but reversed. Rather than the information stored statically with queries being executed dynamically across the data, in an event-driven application, it is the queries that remain static with the data continuously changing. The EDA application includes powerful CEP processors that continuously filter, correlate, manages causality and aggregation in the streaming event data, with all this evaluated in real time. This has proven to be a very challenging task in the past, where developers would have generally written huge amounts of code, forced to perhaps use the C, C++ or Assembler languages, to achieve what is now possible in a single CQL statement and which is much easier to maintain and change.
Q: How is Oracle solving Customers needs for Event-driven Architecture, event-driven SOA (EDSOA) and Complex Event processing?

EDA, EDSOA and CEP technologies at Oracle focus on the ability to effectively address the requirements for the real time processing of streaming event data, in which complex event patterns are instantly identified and analyzed. Depending on the specific use case, the Oracle CEP platform is capable of providing the resultant response, in seconds, milliseconds, or even microseconds, on the Java platform, on standard commodity hardware. All businesses are event-driven—just like life itself! And event-driven SOA addresses all the capabilities organizations need to respond to these real-time business dynamics. Event-driven SOA combines service oriented architecture’s  send/reply and event-driven architecture’s sense/respond usage paradigms. Together these design principles result in extreme agility, enabling the enterprise to conduct business at lighting speed, in ways never before possible.


Customer Use Cases

Q: What are some of the various Industry Use Cases for Oracle CEP 11gR1?

Real Time Systems management & fault mitigation

Customers who need their entire system infrastructure online and running at optimum performance (such as some major online retail Customers) see a need for Oracle CEP to collect and analyze events occurring from all event enabled system artifacts, such as SNMP traps indicating hardware status, Operating system warning and error events (log “tailing”), middleware infrastructure events, such as those from EDN, ESB and even events triggered directly from the executing critical Applications. These can all be filtered, aggregated, correlated and causality determined by OCEP to proactively ensure system viability, provide alerts on infrastructure latencies, and if HardWar is issuing known errors, which generally proceed a typical major shutdown scenario, then application load can be redirected to other stable systems.

Border Security , Transportation Logistics

We see many use cases with vendors who produce drone tracking sensors, facial and resource imaging technologies who want to leverage Oracle CEP to take the feeds from these devices and from many other event sources (such as GPS from surveillance vehicles, weather and terrain conditions, persisted alien historical movement tends) analyze in real time, and initiate immediate response systems. Government entities, such as Immigration agencies around the world are seeking to improve their real time insight and automated visibility with such solutions. Transportation companies can also leverage similar solutions with GPS and satellite feeds to monitor truck and car movements, improving "in auto response systems" types of solutions with far more personalized capabilities. Location of cargo ships (using GPS) with real time monitoring of the condition of each individual container and the goods within (temperature and humidity sensors etc). In the airline industry, real time passenger flow through the airport is another use case, where Oracle CEP can directly interact with the movement flow of passengers, such as slowing down or speeding up the “travelators”, controling movements around the immigration areas or increasing revenue by retaining customers for a certain amount of time in the duty free areas. “NOT” event tracking for lost bags is an Oracle CEP solution, where using potentially, RFID tagging, bags can be monitored from the check-in counters right up to the containers on the plane and when one goes missing (i.e an event does not happen within a specific time period) then Oracle CEP can be used to trigger downstream BPM/BAM systems.

Dynamic Aircraft Maintenance.

Oracle CEP can be used for analyzing event data directly from any types of aircraft, such as fighter jets, as soon as they land, and together with historical trending event data, the flight readiness can be instantly determines for the next flight or mission.

RealTime Slot machine usage “persuasion”

Gaming machine manufacturers have use cases to ‘encourage” gamblers to stay playing at slot machines with real timedetermined available concessional offers. Oracle CEP can be used to monitor the play of a user, determine loss/gain levels and monitor immediately available facilities to offer, for example, a discounted meal in the nearby restaurant in 20 minutes or a free room if play continues for 1 more hour etc.

Online Fraud

Many use cases for banks/credit card companies to augment existing solutions with analysis of real time fraudulent activities, anticipating trends prior to successive attempts. These types of use cases span the entire financial services industry and could redically reduce the incidents of identify frauds by monitoring for non-typical personal usage profiles and issues immediate alerts

Utilities - Smart Meters, Oil Rig Mananagement

Utility companies around the world have now identified Oracle CEP as the technology to effectively manage the new world of Smart Meters and the associate smart power grids. In houses, these smart meters are “event” devices and can provide a wealth of consumption data which can be used together with other power event data (such as sub-station utilizations). As load on sub-stations increases, the technology is now available to “influence” individual meters to reduce home consumption levels. Customers can agree to this capability with reduced power cost incentives. The ability to effectively monitor oil pressure levels in real time on, for example, oil rigs, while at the same time monitor weather conditions which will impact the situation and dynamically monitor the various resources nearest to the oil pipe in question, with the correct skills to correct the problems.

Roadways Toll management Systems

Roadway toll companies can use Oracle CEP to effectively manage and charge for car/truck usage, dynamically, for only the amount of road used. A use case can be where exit points on a particular toll road do not have toll charging gates, so toll management could use the “NOT” event features or Oracle CEP to identify that a tracked car has passed one location, but did not pass a subsequent location within a specific time period (the assumption is the car departed the toll road or had a breakdown (which could trigger another action by the toll management company))

Intelligent cable box Management

Several companies supporting cable companies, have use cases where their cable boxes for each household provided event data. This data indicates not only, "BOX ON", "BOX OFF", but also the viewing trends which would be analyzed by Oracle CEP in real time to offer addition services and preempt tampering scenarios.

Algorithmic Trading, Smart Order Routing

Almost unlimited use cases coming from the financial services world. Real Time stock trading is an obvious one, where we are told that milliseconds matter! One trading company said “if I can save 1 millisecond a year it is worth $100M to us!” Smart Order routing uses Oracle CEP to determine the best worldwide financial market to trade from a specific customers order book. It uses a complex collection of “strategies” which not only indicates “SELL/BUY/Price levels/market SLA’s” but is also impacted by the actual real time latencies from the markets.

Emergency Services Real Time Location Proximity Tracking

When a fire emergency happens it is mission critical that many complex event scenarios happen instantly and at the same time. The Oracle Complex Event Processing solution can be used to isolate fire locations and immediately create boundary areas around the incident, based on several complex criteria’s, such as the geography of the area (whether next to a river or on a hillside etc) and the density of the population. In parallel, the solution identifies the fire resources, via GPS (Global Positioning Systems) that are in the vicinity and are best equipped to deal with the particular type of emergency (is the fire causing poisonous gases so HAZMAT resources will be needed, or is the fire in a steep location requiring tall ladders etc). Oracle CEP can invoke the require processes with its tight integration with the Oracle SOA Products, to expedite those resources movements. While Oracle Complex Event Processing is executing these tasks in the background, it can also communicates instantly with a lightweight Monitoring Dashboard, which is constantly updated, driven by the generated resource events showing the actual location of each resources and whether it is transgressing the boundary areas, indicated by the status of, IN, NEAR or IN VOID (very close to the incident), triggering further synthetic events.