Time in Data Streams

Time is an essential aspect of Sybase CEP. Data rows arrive continuously, and the CCL queries associated with a data stream execute every time a new row arrives. For queries to run smoothly, Sybase CEP must keep track of the sequence in which rows arrive. Sequencing is done by timestamps that are associated with each row.

• Row Timestamps
  Every row in Sybase CEP has an associated row timestamp. When a stream or window is viewed in a Sybase CEP Studio viewer, this timestamp value appears as the left-most column of each data row.
• Setting Row Timestamp Values
  A description of how to set row timestamp values with Sybase CEP Engine and adapters.
• Timestamp Values
  All timestamp values in Sybase CEP, including row timestamps, are measured and stored internally in absolute microseconds.
• Rows With Duplicate Timestamp Values
  Sybase CEP uniquely distinguishes every row, even where multiple rows have the same row timestamp value.

---

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