Published on March 7, 2014
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
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
Find downloads, resources and technical support for implementing and managing SQL Server StreamInsight.
SQL Server is the foundation of Microsoft’s data platform delivering mission critical performance with in-memory technologies and faster insights on any ...
Microsoft Virtual Academy: Breakthrough Insights using SQL Server 2012 : Reporting Services and Visualization (Module 2) - Introducing Self-Service ...
Microsoft’s data management solutions enable faster insights from any data, with high availability, simplified management and security, and comprehensive ...
SQL Server Data Tools; StreamInsight; ... The journey to SQL Server 2014. ... In-memory in the box enables breakthrough performance.
Microsoft StreamInsight. ... SQL Server is the foundation of Microsoft's ... SQL Server 2016 delivers breakthrough mission critical ...
Conoce los paths de estudio sobre SQL Server en Microsoft Virtual Academy
StreamInsight; Data Quality ... Breakthrough performance with in-memory ... What is most impressive about Hekaton is that it achieves breakthrough ...
In this session we will cover the new capabilities and enhancements in Reporting Services including Power View, Self-Service Alerting, improved SharePoint ...