Angelo Santagata's Blog

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..