Maintaining State

Sybase CEP Engine will retain rows in order to perform calculations or comparisons across these rows.

• Getting Started: Maintaining State
  Maintaining state enables you to perform aggergate calculations. There are four ways to maintain the state in the Sybase CEP Engine.
• Maintaining State
  Perform calculations or comparisons across rows. Replace the CCL statements that filter rows with statements that create a window.
• Maintaining State per Column Value
  Modify the count-based window to maintain the rows within the window.
• Aggregating Values
  Perform a common action on multiple rows within a window.
• Consolidating the Code
  Create window statement and a single query statement.
• Exploring Window Types
  Use different window types when maintaining a specific number of rows situations.
• Maintaining Rows Based on Rank
  Windows are also defined based on the rank of a value of a column.
• Wrap-up
  Summary of maintaining rows in a memory contianing data.
• Solutions
  Solutions to maintaining state exercise.