The StockTrades Data Stream

The StockTrades data stream is used in many of the examples provided by Sybase CEP. The information here is provided for your reference in order to give you a more complete understanding of the examples.

• The Problem Domain describes the sector within which this data stream is designed to operate.

• Data Stream and Schema describes the principal external data stream used by the application and the stream's schema.

• The Problem Domain
  The StockTrades data stream provides only a small number of data columns. However, you can use it to provide answers for many queries with Sybase CEP, including to output the average trading price for each stock during a specific period for each new trade, to raise an alert whenever shares of a certain stock rise above a particular price, and to indicate whenever the number of shares traded for a stock exceeds the average volume of that stock over a specific period.
• Data Stream and Schema
  The StockTrades data stream is used to simulate how Sybase CEP Engine receives messages from an external data source, such as a stock exchange ticker.
• Other Data Streams
  Data streams can provide additional input to the Sybase CEP application and output streams which connect to external adapters.

---

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