Inside Sybase CEP Engine, streams, windows, and queries can combine to route data along a single path, separate it along multiple paths, or merge it from multiple paths into one. Multiple CCL queries can be pipelined together, in which each successive query subscribes to the data stream published by the previous query.
The following figure shows a sequential pipeline of two queries:
Windows and Row Propagation
In cases where a CCL window is used as a data source and destination in a query chain, the window policy has no effect on how quickly rows are propagated down the chain. Windows retain the state of rows, but do not actually "hold on" to the rows themselves. Regardless of the window policy, rows travel down the chain as quickly as the system can accommodate.
Several queries can also subscribe to the same data source and then publish their results to different streams, thus creating a branch in the pipeline. Each branch may then go on to be processed independently by other queries:
Finally, a single query can subscribe to data from multiple sources and publish the results to a single stream. This very common occurrence in CCL queries is shown in the following figure:
