Posts tagged cql
Oracle 8i (8.1.6 if I remember correctly) started with the introduction of a that wonderful new phenomenon in SQL: Analytical Functions. Functions that basically allow the result for one row in the result set to be calculated using the values in other rows. This allowed to look forward (lag) and back (lead) in result sets as well as calculate aggregates across partitions in every direction. Analytical Functions have helped to produce quite advanced analyses of data using very elegant, compact and surprisingly well performing queries.
With Oracle Database 12c, our SQL just got a little better equipped to perform analysis. The MATCH_RECOGNIZE operator has been introduced – one you may know if you have ever dabbled in CQL, the Continuous Query Language that is at the heart of several complex event processors. This operator goes beyond Analytical Functions in its capabilities to analyze a data set. The comparisons MATCH_RECOGNIZE allows us to make between rows in order to decide whether or not to produce a result are more advanced (and sometimes more fuzzy) than the straightforward comparison operators available with analytical functions. That sounds a little cryptic. Let’s look at More >
JavaOne 2010 presentation: Why and how to engage a Complex Event Processor from a Java Web Application0
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).
Temperatuur Simulator en Temperatuur Sensor Processor: TemperatuurSensorenSimulatorEnProcessor
WebApplicatie Analyzer: WebWinkelAnalyse.zipReferences & 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/
Setting up your development More >
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 More >