Filtering Data

Filtering data enables you to filter incoming data to a specific location such as a stock symbol or an IP address.

Sybase® CEP Engine is an information processing system designed to run continuous queries. This means that instead of having to submit your query each time you want it to produce results, you submit your query to Sybase CEP Server, which runs the query continuously until you tell it to stop. This gives you the power to examine and analyze large volumes of incoming data virtually instantaneously, even if the data is arriving at very high speeds, without having to store the information in a database first.

This tutorial walks you through the process of using Sybase CEP Studio to build a simple Sybase CEP application that filters incoming stock trade data for events related to a specific stock symbol. While the example used in this tutorial is based on stock trading, filtering is a fundamental activity that you will undoubtedly incorporate into your application regardless of business segment. For example, you can filter sensor readings for values that fall outside a particular range, or filter clickstream data for user connections from a particular IP address.

If you would like a conceptual introduction to Sybase CEP Engine before you begin, see Sybase CEP Engine Data Flow. This information is also presented as a recap at the end of the tutorial.

After completing this tutorial, you will be able to:

Before you begin the activities in this tutorial, be sure you have access to the following:
  • An instance of Sybase CEP Server running on your computer. If you don't have such an instance, follow the directions in "Installing Sybase CEP Engine" in the Sybase CEP Installation Guide . Note that attempting to complete the tutorial while connected to a remote instance of Sybase CEP Server will not work because of the data files used in the tutorial.

  • Sybase CEP Studio installed on your computer. If you have not installed Sybase CEP Studio, follow the directions in "Installing Sybase CEP Studio" for your platform in the Sybase CEP Installation Guide .