United States   Change   |   All Microsoft Sites

Home

SQL Server 2008 R2 – StreamInsight Technology

StreamInsight Runtime Technology

StreamInsight Runtime Technology

click image to enlarge

Overview

Data volumes are exploding with event data streaming from sources such as RFID, sensors and web logs across industries including manufacturing, financial services and utilities.  The size and frequency of the data make it challenging to store for data mining and analysis.  The ability to monitor, analyze and act on the data in motion provides significant opportunity to make more informed business decisions in near real-time.

 

Process large volumes of events across multiple data streams in less than a second

Process events with low latency so that action can be taken immediately based on the insights derived. Process high volumes of data and scale up as required. Scale up and define as many queries as is required to process these streams. Derive insights by correlating multiple event streams from multiple sources with near-zero latency for improved business decisions.

Combine real time event streams with historical data seamlessly using the same queries for better insights. Gain better insights by enriching “standing queries” with static reference data. Generate new event streams from large data warehouses for more focused data analysis and mining.

Monitor, Manage and Mine

Better manage your business through historical data mining and continuous insights

Mine KPIs from historical data to gain greater insight into your business. Monitor effectiveness of these KPIs using the data from event streams.

Create new KPIs and continuously refine your existing KPIs by mining historical and current data streams using the same or a different query.

 

 

 

 

Provides built-in support for out of order event handling and rich query semantics

Use the rich, extensible query language with built-in support for point-in-time and interval event types including intervals of unknown duration and temporal operators including the correct handling of missing events and events that arrive out of order. Events are processed correctly even when the order of event arrival is different from the order of event generation.

Derive meaningful and relevant information by finding complex patterns in the data/event streams and modeling them using query languages such as Language Integrated Query (LINQ). The language allows for complexities while providing a very easy way to define the queries. Queries are also combinable, enabling complex queries to be quickly and easily assembled from multiple simple queries.

Reduce development cost by utilizing existing skill sets and investments in Microsoft development platform

Benefit from increased productivity, ease of development and faster time to market with Language Integrated Query (LINQ), C# and Microsoft Visual Studio. Use extensions to the .NET framework to express queries in native C# syntax. Events are expressed in the .NET data types and can be extended to create new domain specific types and operators.

Reduce development time and cost by utilizing existing .NET skills and Microsoft Visual Studio as the integrated development environment. Easy availability of Microsoft developer platform skills will allow customers, solution developers and adapter developers to take advantage of the platform faster and in a more cost effective way.

Third party adapters help you decrease the time to market when developing your own custom or packaged solutions. Realize value from existing investments in Microsoft platforms and gain better insights from integration with existing data stores and enterprise event sources and targets. Third party adapters enable easier and quicker integration.

Use the adapter development kit to develop your own custom adapters or use industry specific third party adapters from one of the many Microsoft partners. Take advantage of an open and active collaborative environment to drive the adapter ecosystem.

Flexible deployment options

Flexible deployment options

click image to enlarge

Flexible deployment options

Take advantage of flexible deployment options to scale your processing needs. Use the deployment option that best suits the diverse processing needs of your business.

Use the embedded options to pre-process on the edge (i.e., in sensors and other devices). Use a regional hub for local processing of event streams from embedded engines (i.e., aggregation and correlation). Run complex analytics and mine insights with centralized processing with feeds from regional hubs to create a unified view.

Easy to manage and support

Use the query debugger to identify, fix, and test problems quickly and easily. The replay capabilities can help troubleshoot and tune queries for optimum resource utilization and predictable performance.

Have confidence in reliable access to worldwide Microsoft support and an extensive ecosystem of Microsoft partners with specialized knowledge and solution offerings.

Additional Resources

 

 

Take the next step

Download the Essential Backpack
TechNet IT Pros Start Here
MSDN Developers Start Here