Microsoft SQL Server 2008 R2 Specifications download pdf (Page 165)

145

C H A P T E R 8

Complex Event Processing

with StreamInsight

icrosoft SQL Server StreamInsight is a complex event processing (CEP) engine. This

technology is a new offering in the SQL Server family, making its rst appearance

in SQL Server 2008 R2. It ships with the Standard, Enterprise, and Datacenter editions of

SQL Server 2008 R2. StreamInsight is both an engine built to process high-throughput

streams of data with low latency and a Microsoft .NET Framework platform for devel-

opers of CEP applications. The goal of a CEP application is to rapidly aggregate high

volumes of raw data for analysis as it streams from point to point. You can apply analyti-

cal techniques to trigger a response upon crossing a threshold or to nd trends or excep-

tions in the data without rst storing it in a data warehouse.

Complex Event Processing

Complex event processing is the task of sifting through streaming data to nd meaningful

information. It might involve performing calculations on the data to derive information,

or the information might be the revelation of signicant trends. As a development plat-

form, StreamInsight can support most types of CEP applications that you might need.

Complex Event Processing Applications

There are certain industries that regularly produce high volumes of streaming data.

Manufacturing and utilities companies use sensors, meters, and other devices to monitor

processes and alert users when the system identies events that could lead to a poten-

tial failure. Financial trading rms must monitor market prices for stocks, commodities,

and other nancial instruments and rapidly calculate prots or losses based on changing

conditions.

1 2 ... 160 161 162 163 164 165 166 167 168 169 170 ... 235 236

No comments

Microsoft SQL Server 2008 R2 Specifications Page 165