Posted by: Adam Jorgensen | September 8, 2010

White Paper Wednesday – Overview of StreamInsight

Hey folks,

It’s whitepaper Wednesday again and this week we’re talking about "Introducing Microsoft StreamInsight" by: Torsten Grabs, Roman Schindlauer, Ramkumar Krishnan, Jonathan Goldstein.  You can check it out here and read along: http://download.microsoft.com/download/F/D/5/FD5E855C-D895-45A8-9F3E-110AFADBE51A/Microsoft%20CEP%20Overview.docx

StreamInsight is a powerful new addition to the data processing lineup for Microsoft. Many folks don’t understand why this is bundled with SQL Server and from what I can tell it’s mostly for licensing purposes. IT doesn’t really below anywhere else and since it’s mostly API driven it needs to piggyback with another enterprise product. StreamInsight give you the ability to process significant amounts of data in real time, analyze it, make decisions based on that analysis. It’s some pretty cool stuff. The article takes you through the follow based on it’s summary:

"While typical relational database applications are query-driven, event-driven applications have become increasingly important. Event-driven applications are characterized by high event data rates, continuous queries, and millisecond latency requirements that make it impractical to persist the data in a relational database for processing. These requirements are shared by vertical markets such as manufacturing, oil and gas, utilities, financial services, health care, web analytics, and IT and data center monitoring. Event-driven applications use complex event processing (CEP) technology with the goal of identifying meaningful patterns, relationships and data abstractions from among seemingly unrelated events and trigger immediate response actions.

This paper provides an overview of the Microsoft SQL Server StreamInsight platform for complex event processing . StreamInsight allows software developers to create complex and innovative CEP solutions along two scenarios: (1) building packaged event-driven applications for low latency processing and (2) developing custom event-driven applications for businesses with high throughput, low latency needs. The paper describes the StreamInsight architecture and major components and demonstrates how to write continuous queries in a declarative way to analyze and process the events flowing through the system ."

Go check this out and keep your eyes peeled for all the other great whitepaper resources we’ll be reviewing on White Paper Wednesdays

—————————————————————————————————

As always check us out at BIDN.com for more great information all around SQL Server, SharePoint and Business Intelligence. Don’t forget about SQLLunch.com – Patrick Leblanc (Blog)|(Twitter) and I host a weekly presentation series with some of the best SQL Server folks in the world! Lastly, don’t forget to follow @BIDN for updates on blog postings and articles and me on twitter for all the latest updates@Adam_Jorgensen.

Advertisement

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Connecting to %s

Categories

Follow

Get every new post delivered to your Inbox.