StreamInsight

The last BI stack component to discuss is StreamInsight, Microsoft’s complex event processing (CEP) engine that premiered with SQL Server 2008 R2. CEP engines process data streams where the magnitude and frequency of data is extremely high. Think about sensor data or financial market data as examples; in both cases, you can imagine the immense volume of data and the speed with which it streams in. Ordinarily, keeping up with this kind of data feed is very difficult; CEP seeks to make it manageable.

In the case of StreamInsight, its code, written in C++, runs very “close to the metal,” allowing for low latency in processing. An adapter architecture is used to abstract away interfaces with specific source and destination data systems. ...

Get Programming Microsoft® SQL Server® 2012 now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.