A New Query Language to learn….
Working with some collegues of mine at a large SI, they asked me whats comming up in Fusion Middleware 11g, lots was my immediate answer…
So then we went, and trawled through presentations at OOW, and a good one is
“Whats new in Oracle SOA Suite”
If you have a peek at this you’ll see that App. Server 11g has a lot of really good improvements but one which I looked at and thought, eh?? whats that? is a BAM feature called “CQL” or Continuous Query Language.
I’ll be honest here I haven’t tinkered much with AS11g, but this feature did catch my eye… In short your able to create a query which is constantly run and provides agregated data over a period of time. As its a query you can filter it before pumping it into BAM.
Here’s an example from a post by Andreq Koelewijn at IT-Eye
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 which can then be graphed by Oracle BAM..
cool.. Look forward to tinkering with this.
Tags: Amp, Ant, Avg, Bam, Blog, Blogs, Bpel, Collegues, Continuous Stream, Cool Look, Ddl, Ef, Fusion, Fusion Middleware, Hp, Improvements, Logs, Lot, Lt, Middleware, Nbsp, Oel, Oow, Oracle, ORACLE BLOGS, Peek, Period Of Time, Presentation, Query Language, Rac, Sit, Soa, Technology, Ui, Water Level Data, Weblog, Whats New, Zeeland