Solutions

Detecting a sequence of events: Solution

• The not operator (!) specifies the absence of an event. In this case, the pattern matches only if no row arrives on Cust within 10 seconds of the row arriving on Phone. In other words, the broker doesn't place the order for the customer within the 10-second limit.

Subdividing a Sequence: Solution

• The following MATCHING clause accomplishes the specified task:

  MATCHING [10 SECONDS: Phone || Web, [2 SECONDS: Broker && Cust]]
  

  The row containing order ID 1314 matches the new pattern, but not previous patterns.