Finding Patterns In Data

Continuous Computational Language (CCL) queries can use a special pattern matching syntax that enables a query to detect the occurrence of certain patterns of events.

When a MATCHING clause is added to a query, the query detects a match on the pattern by looking at two or more data sources within a specified interval. Rows are published from the query for each successfully detected match.

• Finding a Sequence of Events
  Run a pattern-matching query to isolate a sequence of events in your data.
• Detecting Non-Events
  An important pattern-matching operator is the "!" or "Not" operator.
• Other Pattern-Matching Operators
  There are a number of pattern-matching operators that you can use inside a MATCHING clause.
• Matching Associated Events
  Use the stream alias and self-join techniques to join rows from two different events with an associated key value.

---

Created March 8, 2010. Send feedback on this help topic to Sybase Technical Publications: pubs@sybase.com