Chapter 59. Real-time BI with StreamInsight

 

Allan Mitchell

In this chapter, we’re going to look at a product that was new to the SQL Server suite in 2008 R2. That product is StreamInsight, Microsoft’s first iteration of a complex event processing (CEP) engine. Don’t worry if you’ve never heard this term; by the end of the chapter, everything will become clear, and you’ll be thinking about ways to use it in your business. This chapter begins by introducing the architecture of StreamInsight and showing how it might be used. Following this introduction, the focus of the chapter is on the heavy lifting of the analytics: the querying of the streams. Being able to write your CEP applications in languages such as C# and leverage existing developer potential means that building an application and processing events can be achieved quickly. Later in this chapter, we’ll further explore what a developer needs to know to build a successful and flexible StreamInsight application.

We’ll start with some basics before moving on to some quite powerful design patterns and windowing of data.

What is StreamInsight?

What are events and event streams?

Deployment

Architecture

How does querying streams differ from querying an RDBMS?

Where is StreamInsight useful?

Querying the streams

Summary

About the author