StreamInsight Breakthrough

100 %
0 %
Information about StreamInsight Breakthrough

Published on March 7, 2014

Author: YulianSlobodyan



Unobtrusive introduction to basic Complex Event Processing principles and building blocks. Review of the Microsoft StreamInsight.

MICROSOFT STREAMINSIGHT Yulian Slobodyan L’viv, 2011 Breakthrough Guide

Introduction to CEP

recap(Strategic, Tactical) strategic tactical

scenarioA Tokyo Metro

scenarioA.Info        Anno 1927 #1 annual passenger rides 3,160,000,000 passengers/year avg 6,330,000 passengers/day 24/7 mode 203.4 km system length 2009 profit ¥63,500,000,000

scenarioA.Issues.Take(1) Pushers 押し屋 oshiya

scenarioA.Strategic      Reporting Planning Data Mining Constraints Detection Forecasting

scenarioA.Tactical      Real-time Statistics & Monitoring On a Fly Analysis Traffic Optimization Systems Management Emergency Response

scenarioA.Solutions[“RDBMS”] Humans Request Data Services RDBMS Presentation tactical Sensors strategic

scenarioA.Solutions[“CEP”] CEP System Humans Services Presentation tactical Sensors strategic

Google(“CEP”)  Complex event processing (CEP) consists of      processing many events happening across all the layers of an organization identifying the most meaningful events within the event cloud analyzing their impact taking subsequent action in real time. CEP Products  Sybase CEP, StreamBase  Microsoft StreamInsight

Compare(RDBMS, CEP) RDBMS Request Paradigm Latency Throughput CEP On-Demand Continuous ~ sec * n ~ ms * n ~ 100 * n/sec ~ 10,000 * n/sec

Microsoft StreamInsight

StreamInsight.Info     CEP engine from Microsoft Part of MS SQL Server 2008/2008R2 Distributive Uses SQL Server license key to activate Two Editions:  Standard ( SQL Server Standard/Enterprise/Web)  Premium ( SQL Server Datacenter/Developer/Eval)  Current version: 1.1


StreamInsight.EventStream.Tra ce() Stream Insight Runtime Event Source Input Adapter Standin g Queries Output Adapter Event Sink

Data Event Model Event Event Kind Payload Timestamp Header StreamInsight.Event.Structure

StreamInsight.EventKind Average Average time - INSERT event - CTI (Current Time Increment) event

StreamInsight.EventModel  Point   Interval   “10:42:56.052 - item #123 passed the gate” “01:12:00-01:35:00 - active sensor #17” Edge   “12:00:00-∞ - temperature 17˚C” “13:00:00-∞ - temperature 18.5˚C”

payloa d StreamInsight.EventModel.Edg e C B A time



StreamInsight.Queries  Standard LINQ operations  Projection  Filtering  Joins  Unions  Grouping  Event Windows



Add a comment

Related presentations

Presentación que realice en el Evento Nacional de Gobierno Abierto, realizado los ...

In this presentation we will describe our experience developing with a highly dyna...

Presentation to the LITA Forum 7th November 2014 Albuquerque, NM

Un recorrido por los cambios que nos generará el wearabletech en el futuro

Um paralelo entre as novidades & mercado em Wearable Computing e Tecnologias Assis...

Microsoft finally joins the smartwatch and fitness tracker game by introducing the...

Related pages

Microsoft StreamInsight...

Find downloads, resources and technical support for implementing and managing SQL Server StreamInsight.
Read more

SQL Server 2014 | Microsoft

SQL Server is the foundation of Microsoft’s data platform delivering mission critical performance with in-memory technologies and faster insights on any ...
Read more

Microsoft Virtual Academy: Breakthrough Insights using SQL ...

Microsoft Virtual Academy: Breakthrough Insights using SQL Server 2012 : Reporting Services and Visualization (Module 2) - Introducing Self-Service ...
Read more

Data management and analytics overview | Microsoft

Microsoft’s data management solutions enable faster insights from any data, with high availability, simplified management and security, and comprehensive ...
Read more

SQL Server 2014: Unlocking Real-Time Insights - SQL Server ...

SQL Server Data Tools; StreamInsight; ... The journey to SQL Server 2014. ... In-memory in the box enables breakthrough performance.
Read more

Microsoft SQL Server

Microsoft StreamInsight. ... SQL Server is the foundation of Microsoft's ... SQL Server 2016 delivers breakthrough mission critical ...
Read more

SQL Server

Conoce los paths de estudio sobre SQL Server en Microsoft Virtual Academy
Read more

Breakthrough performance with in-memory technologies - SQL ...

StreamInsight; Data Quality ... Breakthrough performance with in-memory ... What is most impressive about Hekaton is that it achieves breakthrough ...
Read more

Microsoft Virtual Academy: Breakthrough Insights using SQL ...

In this session we will cover the new capabilities and enhancements in Reporting Services including Power View, Self-Service Alerting, improved SharePoint ...
Read more