Stream and Window Examples

Event Stream Processor includes several stream and window examples that demonstrate a range of functionality, including how to use delta streams, make joins and unions, and split streams.

• Streams
  Create input and local streams.
• Local Windows and Output Windows
  Compare streams with windows and observe the differences between local and output windows.
• Delta Stream
  A delta stream incorporates the getrowid and now functions.
• Join Windows
  Use the FROM clause with ANSI JOIN syntax to join two windows.
• Join Streams
  Join two windows into a stream.
• Outer Join
  Create left, right, and full joins between input windows.
• Union Streams
  Create a simple union between two windows.
• Jumping Windows
  Jumping Windows retain data for a specified interval of time or for a specified number of rows and delete all retained rows when the specified interval of time expires, or the specified number of rows is exceeded.
• Splitter
  Use the splitter feature to route data from one stream to multiple streams.