Weblog for the AMIS Technology corner
Posts tagged cql
JavaOne 2010 presentation: Why and how to engage a Complex Event Processor from a Java Web Application
Sep 22nd
Complex Event Processors are capable of handling large volumes of events – by filtering, aggregating or detecting patterns. Java Applications use a CEP to pre-process incoming signals. These applications can also generate the events – for example the user click and navigation behavior in the web application – and report them to the CEP. The web application can subsequently utilize the outcomes from the CEP to for example intelligently guide the user or present relevant details. This session shows various ways in which a CQL based CEP can be integrated into a Java application to enhance the web application’s behavior.
The intended audience for this presentation consists of experience Web Java and Enterprise Java developers.
- introduction to Complex Event Processing
- demonstration of CQL event processing on events arriving on JMS
- discussion of how the web application can absorb the CEP results
- demonstration of a simple Web Shop application that published events to the CEP and utilizes the CEP results
- discussion on when and how CEP can add value to Java applications
Complex Event Processing – Java Magazine – Sources & References
Feb 25th
This article contains the resources for an article on Complex Event Processing (using Oracle CEP) that is published in the March 2010 issue of the Dutch Java Magazine. This article describes the interaction between CEP and Java Applications, using examples of temperature sensors that are monitored (aggregating their readings and looking out for any broken sensors) and web shops that try to determine the most popular and the most efficient search terms as well as the search terms that are quite useless (as they never result in a transaction).
The article is in Dutch – it will be made available for download later on. Note that it is based on Chapter 19 in the upcoming Oracle SOA Suite 11g Handbook (Oracle Press, due Summer 2010).
Sources
Temperatuur Simulator en Temperatuur Sensor Processor: TemperatuurSensorenSimulatorEnProcessor
WebApplicatie Analyzer: WebWinkelAnalyse.zip
References & Resources
Download Oracle CEP en CEP Plugin for Eclipse:
Oracle CEP Server: http://www.oracle.com/technology/software/products/cep/index.html
Oracle CEP Plugin voor Eclipse: http://download.oracle.com/technology/software/cep-ide/11/
Installatie instructies:
Setting up your development environment:http://download.oracle.com/docs/cd/E15523_01/doc.1111/e14476/examples.htm#i1013710
Configuring Eclipse:http://download.oracle.com/docs/cd/E15523_01/doc.1111/e14301/ide_intro.htm#CHDDAADG
Creating CEP Servers in Eclipse:http://download.oracle.com/docs/cd/E15523_01/doc.1111/e14301/ide_serv.htm#CHDEJEHC
Documentatie voor CEP ontwikkelaars:
CEP Getting Started:http://download.oracle.com/docs/cd/E15523_01/doc.1111/e14476/toc.htm
Administrator’s Guide:http://download.oracle.com/docs/cd/E15523_01/doc.1111/e14300/toc.htm
IDE Developer’s Guide (Eclipse):http://download.oracle.com/docs/cd/E15523_01/doc.1111/e14301/toc.htm
CQL Language Reference:http://download.oracle.com/docs/cd/E15523_01/doc.1111/e12048/toc.htm
CEP Java API Reference:http://download.oracle.com/docs/cd/E15523_01/doc.1111/e14303/toc.htm
Simple Event Processing – Using SQL with Analytical Functions to detect traffic patterns
Oct 6th
One of the intriguing subjects at last weeks Oracle Open World conference for me was Complex Event Processing. The ability to process streams of real time events, and up to 1000s per second of them, opens up many new avenues of interesting opportunities. Detecting patterns and anomalies, aggregating and comparing – reporting only the noteworthy events or findings, thereby making sense (information) of enormous volumes of data is both great fun and tremendously useful in specific situations. The SQL like CQL language – Continuous Query Language – provides us with a syntax to analyze data streams in various ways – detecting trends and patterns, variations and aberrations. There are several key characteristics in the CEP architecture: handling large volumes of events, applying this special language for event analysis and executing the queries continuously. That last bit means that the query is registered with a stream of events, not executed at a single moment in time against the data as it is at that moment but looking for query results continously as the events keep streaming in. Query results can be reported for as long as the query registration remains active and the events keep streaming in.
Normal SQL is definitely not capable of being executed continuously nor is it particularly suited for dealing with large volumes of real time events that we typically do not want to store in a database table. The special pattern analyzing functionaliy of CQL also is not available in SQL. However – SQL can do more in this area than you may suspect. In this article I will give a small and hardly useful demonstration of those capabilities. We will investigate a stream of Car Sighting events. A Car Sighting event consists of a timestamp and the color of the car.
The analysis of the Car Sighting data stream we will do should answer the question: report all car sightings that are followed within five cars by a car of the same color. 
Read the rest of this entry »
