Solving Business Problems Using Events and StreamInsight with Allan Mitchell
Events happen in everyday life all the time. What you call an event differs on your perspective but they are a very real part of our lives. Being able to look at the multiple streams of data in our business environment and correlate them to drive real business value is potentially of huge benefit to your business. Being able to react in close to real time makes you more proactive. Analytics are typically driven from a data warehouse which is loaded once a day using a batch processing tool. The time lag of 24h could be very important and you may have missed an opportunity because of it.
Examples of where being able to process data close to the time of the event are fraud detection, trade risking and sensor monitoring. It is most certainly not just limited to these
StreamInsight was introduced along with the SQL Server 2008 R2 product release and it is Microsoft’s foray into the world of handling streaming event data efficiently and in close to real time. Handling streams of data is a very different paradigm to querying data held within a database and StreamInsight has a framework to handle this which is built around .Net.
This seminar is a deep dive into this technology. It is very interactive and delegates are encouraged to ask questions. If you have a laptop, install StreamInsight and bring it along. Whilst learning about StreamInsight we will see examples of its usage before finishing up with a detailed look at some more in depth solutions solving business problems. The agenda for the day is as follows:
9:00 Welcome and Introduction
9:30 The what/Where/When and Why of StreamInsight?
10:15 StreamInsight Architecture and Development Patterns.
11:00 Break
11:15 During this part of the day we will discuss the common terminology used within StreamInsight and also look at common requirements made on CEP/ESP Engines.
12:30 Lunch
13:30 Time. StreamInsight is acutely aware of time. If we don't understand time when working with StreamInsight then we are in trouble. This part of the day is something we must inderstand.
15:00 Break
15:15 StreamInsight allows us to create standing queries usinf LINQ. During this part of the day we will look at some of the LINQ constructs and show how they can be used to manipulate streams of events. For this we will mainly be using LinqPad as it is an excellent tool for showing off the querying capabilities. We will be looking at
1. Manipulating event times, duration
2. Joining Streams
3. Left Anti Semi Joins
4. Windowing
5. Extending the framework
and more.....
16:30 Putting it all together. This final section of the day will be spent looking at real world usages of StreamInsight. Hopefully it will make you realise just how you could implement it into your current business architecture
17:30 Close
This seminar will be taught by Allan Mitchell of Konesans Limited (www.konesans.com). Allan is a SQL Server MVP specialising in the movement and manipulation of data using such tools as Integration Services and StreamInsight. Allan has spoken at numerous conferences and community events around the world.
|