How to use Microsoft streaminsight to process and analyze Real-time Data

Document directory

• Preparations
• Basic Query
• Query Mode
• Official Guide

Streaminsight is a new module in SQL Server 2008 R2. It provides the complex event processing (CEP, complex event processing) function. That is, it provides nearly zero-latency continuous processing for infinite event sequences from multiple data sources. Streaminsight is a temporary query processing engine that allows applications to query and process events within a time window. The processing scope of streaming data includes simple aggregation, multi-data source event relevance, Event Mode detection, and even the establishment of complex event sequences and analysis models. The program model of streaminsight allows users to define these queries through LINQ, and supports seamless integration of query results into C # code. Preparations

Streaminsight query series (1) -- Preparations

Streaminsight query series (II) -- output query results in linqpad

Basic Query

Streaminsight query series (III)-filtering of basic query operations

Streaminsight query series (4) -- aggregation of basic query operations

Streaminsight query series (5)-User-Defined aggregation for basic query operations

Streaminsight query series (6)-grouping and aggregation of basic query operations

Streaminsight query series (7)-Basic sorting of basic query operations

Streaminsight query series (8)-sorting by groups for basic query operations

Streaminsight query series (9) -- the final ranking of basic query operations

Streaminsight query series (10)-connection to basic query operations

Query Mode

Streaminsight query series (11)-window alignment in query mode

Streaminsight query series (12)-event alignment in query mode

Streaminsight query series (13)-basic query mode

Streaminsight query series (14th)-distinct count of query modes

Streaminsight query series (15th)-window ratio of query mode

Streaminsight query series (16)-left Outer Join in query mode

Streaminsight query series (17)-query mode for dealing with transient and alarm flood

Streaminsight query series (18)-query mode trend discovery

Streaminsight query series (19th) -- query mode exception detection

Streaminsight query series (20)-detection gap events in query mode

Streaminsight query series (21)-use geographic data in query mode

Streaminsight query series (22)-continuous update of query mode

Streaminsight query series (23)-exponential smoothing of query modes

Streaminsight query series (24) -- query mode matching

Official Guide

Convenient guide to streaminsight query (Note: This ebook is only available in English and is expected to be translated by experts .)

 

Streaminsight (1)-Basic Concepts

Streaminsight (2)-stream and event

Streaminsight (3)-adapter

Streaminsight (4)-Example

Streaminsight (5)-LINQ syntax

Streaminsight (6)-Debugger

Video

How to use Microsoft streaminsight to process and analyze Real-time Data