Analysing and Reporting on High Volume Real-Time Data

StreamInsight is part of SQL Server 2008 R2 and is designed to accept and query real-time data streams with volumes of thousands of records per second and it is all based on familiar .NET and LINQ technology.

There are two editions:

• Standard edition for data volumes less that 5000 events per second
• Premium edition for data volumes up to 100000 events per second

You need SQL Server 2008 R2 Data Centre Edition to get the Premium edition, while Standard edition comes with SQL Server 2008 R2 Standard and Enterprise Editions.
So how does it work?

• Firstly the data stream is read from the sources by an adaptor. StreamInsight comes with a set of standard Adaptors for typical data sources, bit new custom ones are typical created from these
• The data is then passed to the queries, which are written using the LINQ query language, operate on the data as it arrives
• The results of the queries is send as a data stream to output adaptors which in turn route the results to the system that needs them. This may be a reporting solution or a trading application and so on

Architecturally it looks like this:
(Click to enlarge)

StreamInsight typically runs as a Windows Service on a server, but can be embedded directly into a program if required.
Real-time decision making on high volume data can now become a part of any organisations analysis and reporting capabilities.

To find out more about StreamInsight and SQL Server 2008 R2 from Ballard Chalmers, please email us or please call Andrew Chalmers on 01342 410223.

Sign up to receive our regular email newsletter

Return to News