I want to inquire if StreamInsight provides built-in support for sampling events.
I am currently trying to solve for a university project relating to the Football challenge a query. I have 15000 events every second and to optimize the processing I wanted to sample the data and use statistics to estimate the the values.
I am very new to StreamInsight and maybe missing something. Thanking you in advance!
StreamInsight could easily handle this, even on a decent laptop. You wouldn't have to sample the data ... you could feed all of it through StreamInsight and then aggregate the events to get your statistical estimates. If there is something other
than the standard aggregates that you want to do, you can write a User Defined Aggregate (UDA) that can do just about anything you can dream of. ;-)
DevBiker (aka J Sawyer)
Microsoft MVP - Sql Server (StreamInsight)
If I answered your question, please mark as answer.
If my post was helpful, please mark as helpful.
Thanks for your reply. Its nice to hear that StreamInsight is powerful enough. I was just thinking sampling will even further enhance the performance where accuracy
and precision is not the most important measure and it would be a good feature in some situations.