Hi there, A company contacted me to solve a query puzzle that they have. They are reading incoming tuples and want to select all tuples that are between two...
Hi Pedro, In Esper its a pattern with followed-by and unbound repeat, such as: begin=Event(param1=2, param2=2) -> Event until Event(param1 = begin.param1) Doc...
The Situation language used by IBM Active Middleware Technology has lifespan as a building block which describes temporal context for detecting patterns of...
There's also an easy way to do this in the Aleri Streaming Platform with an "event cache". It's a data structure that resembles a window of events, but one...
Shailendra, Thanks for the answer. Please clarify in which product and version do we run this? Oracle 11g? Oracle CEP/BEA Web Logic? Thanks! pedro On Tue, Dec...
Hi Pedro: do you want just 1 pattern (ie from the 1st instance of an ON) or all such patterns? And why do you have the constraint of using a "query" when there...
Hi Your goal can be achieved with the 6 lines of CCL code shown below. Basically, we define a 1 column/1 row window containing a boolean. This acts as a "gate"...
There are a few ways to do this in SQLstream. First, the Oracle solution you describe should work practically unchanged, because SQLstream supports SQL:2003...
A colleague just pointed out a fourth way to do this in SQLstream. It is simpler than the other queries I posted and works even if there are multiple ...
Dear Colleagues, Will the Semantic Web ever hit the market? What is missing to make it a reality? Tell us what you think in our current survey, the Web...
The Semantic Web has already hit the market and failed to make a very significant impact. It won't make an impact so long as 1) it continues to lower...
I really do suggest you guys put this out on the Forum. It should get exposure to general discussion. - David ... continues to ... price, ... the ... mark-up. ...
[ our apologies should you receive this message more than one time ] Call for Papers I-Semantics 2009: International Conference on Semantic Systems Graz,...
Leading companies through calm waters is currently the ultimate challenge for management. Which strategies do IT managers have in their back pockets? In an...
We are looking for a doctoral candidate in Computer Science with a focus on Corporate Semantic Web. The Corporate Semantic Web Group (AG CSW) at the Free...
Dear Colleagues, Rule markup languages will be the vehicle for using rules on the Web and in other distributed systems. They allow deploying, executing, ...
Hi, I have the good old StockTrades stream with two fields: symbol and price. I'm trying to answer the following question "Were Company X stock actions priced...
In Oracle model, this is one of the reasons why we don't mix application time & wall clock time. The model is based on application time (unless explicitly...
Correct me if I'm wrong here, but I believe the issue to be that 1ms prior to when the second trade was made the price was in fact $71 post trade it was $69...
Hi Luis. The main issue with your example is that you are asking a temporal query not on the events but on the state created by the events (where event is a ...
Yes, that is the issue. Luís Pureza ... prior to when the second trade was made the price was in fact $71 post trade it was $69 event though the last every...
Well, I guess I could find out how many events happened during the last 5 minutes and then create a fixed window of size N + 1 (to contain the newest event...
(sorry for the spam!) Opher, Interesting post. However those examples seem to be quite challenging, while my problem is very simple :-) Luís Pureza ... event...
Hi Luis. Your problem seems simple, but it is not really that simple, the query: Were Company X stock actions priced above $70 during any moment of the last...
Since the question is posed at 11:00am and the question result is expected to be aware of the events that arrived before 11:00am, the solution seems to require...