I’ve just been browsing through some Oracle Openworld presentations on SOA and BPEL, and found some interesting info in a presentation about Oracle’s SOA Suite 11G. One of the big improvements in 11g will be on monitoring, aka Business Activity Monitoring (BAM). BAM will enable you to monitor events on all your business processes.
This means that the system has to be able to handle and query data from a large number of events. You’ll have a continuous stream of event data. This is where Continuous Query Language comes in. CQL is like a SQL query with additional expressions describing how to filter the data before it’s stored.
Here’s an example:
select w.location
, avg(w.water_level)
from water_level_stream w
[range by '10 minutes' slide by '10 minutes']
where w.state = 'zeeland'
group by w.location
From a continuous stream of water level data this query would calculate a water level average for every 10 minutes.
November 23rd, 2006 at 02:12:38
[...] Original post by Andrej Koelewijn and software by Elliott Back [...]
July 10th, 2009 at 01:18:59
[...] an example from a post by Andreq Koelewijn at [...]