United States Change | All Microsoft Sites
Microsoft Home | Servers and Tools
StreamInsight™ Runtime Technology
click image to enlarge
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 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.
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.
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.
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
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.
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.
The Microsoft StreamInsight™ Client package installs a subset of Microsoft StreamInsight™ which lets you implement only the client side functionality: Connecting to an existing StreamInsight™ server, managing queries, and using the debugger tool. It does not support running an embedded server or creating a StreamInsight™ service. The Microsoft StreamInsight™ Client does not require a license.
International download options will be available in May 2010.
Microsoft StreamInsight™ has two different methods to complete the installation process:
Attended Installation – an interactive user interface will guide you through the set-up process and obtain all of the information and consent required to complete the installation. This includes the displaying, acknowledgement, and archiving of the applicable StreamInsight™ license terms.
Un-attended Installation – this is a DOS command line set-up process that does not have an interactive user interface to guide you through the set-up process. In this case, you will be required to enter a parameter during installation that indicates your acceptance of the license terms.
You can find a copy of the Microsoft StreamInsight™ for Microsoft® SQL Server® 2008 R2 license terms on the Microsoft® SQL Server® 2008 R2 End User License Agreements page for your review.
System Requirements
Supported Operating Systems: Windows Server 2008; Windows 7; Windows Vista; Windows XP (all x86 and x64) Notes: Windows XP and Windows Server 2003 (x86 and x64) with restrictions: the debugging tool has limited functionality on these versions.
Other Requirements: This component also requires Microsoft .NET Framework 3.5 SP1
Instructions
Microsoft StreamInsight™ is a development platform. When installed, it is represented as a set of DLLs and executable tools. Installation instructions for the .msi file:
Make sure to uninstall previous versions of Microsoft StreamInsight™ first.
Download and run StreamInsight.msi
If you intend to install and use the StreamInsight™ service, or use the persisted metadata store in your own embedded server, you will need SQL Server CE. Install SQL Server CE through the included .msi. The SQL Server CE .msi will be put into the redist subfolder of the StreamInsight™ installation folder (typically C:\Program Files\Microsoft StreamInsight 1.0 x64 (en)\redist).
Note that on some client configurations, the StreamInsight™ help file (StreamInsight.chm) may not open due to security requirements in recent versions of Windows. The message "Navigation to the webpage was canceled" is displayed. To resolve the problem, right-click the file, select Properties and then click Unblock.
StreamInsight™: Complex Event Processing