Sybase CEP Continuous Computation Language (CCL) constructs the queries that process data received by the Sybase CEP Server.
Most CCL queries take data from one or more continuous data streams, analyze or manipulate the data, and then output the results to a destination, which is usually another continuous data stream.
CCL is based on SQL, which is the industry-standard query language for use with relational databases. SQL users will find many similarities between CCL and SQL. Like SQL, CCL supports sophisticated data selection and calculation capabilities, including such features as data grouping, aggregations and joins. However, CCL has been extended to include features that are required to support the manipulation of data during real-time continuous processing, such as windows on data streams, pattern and event matching, and output timing controls.
The key distinguishing feature of CCL is its ability to continuously process dynamic data. An SQL query typically executes only once each time it is submitted to a database server and must be resubmitted every time a user or an application needs to re-execute the query. By contrast, a CCL query is continuous, that is, once it is submitted to the Sybase CEP Server, it is registered for continuous execution and stays active indefinitely, executing each time data arrives from one of its data sources.
CCL queries are converted to an executable form by the CCL Compiler. Compilation is typically performed from the Sybase CEP Studio, but it can also be performed by directly invoking the CCL Compiler from the command line or through an API call using one of the Sybase CEP SDKs.