SQL Server StreamIinsight - data processing in real time
Download as PPTX, PDF
0 likes412 views
SQL Server StreamIinsight - data processing in real time
- 1. SQL Server StreamInsightdata processing in real timeDenis ReznikHead of Web Development Department, DCTTrainer, Microsoft Innovation CenterMCT, MCITP, MCPD, MCTS, etc
- 2. StreamInsight仆仂于舒仆仆舒 仆舒 .Net 仗仍舒仂仄舒 仆亠仗亠于仆仂亶 亳 亳仆从亠仄亠仆舒仍仆仂亶 仂弍舒弍仂从亳 仗仂仂从仂于 仂弍亳亶 亳亰 舒亰仍亳仆 亳仂仆亳从仂于 于 亠亢亳仄亠 亠舒仍仆仂亞仂 于亠仄亠仆亳 ( 亰舒亟亠亢从仂亶, 弍仍亳亰从仂亶 从 仆仍)StreamInsightvs RDBMSEventrequestoutput streaminput streamresponse
- 6. 弌仂弍亳
- 7. 亟舒仗亠
- 8. 丿舒弍仍仂仆 亰舒仗仂仂于仂仂从亳亠 亟舒仆仆亠 仂亞舒仆亳亰仂于舒仆 于 仗仂仂从亳
- 9. 仂仂从 于仂亰仄仂亢仆仂 弍亠从仂仆亠仆舒 仗仂仍亠亟仂于舒亠仍仆仂 仂弍亳亶, 仂亟亠亢舒亳 亟舒仆仆亠
- 10. 亠 亠弍仂于舒仆亳 仗仂磲仂亠仆亳 仗仂 于亠仄亠仆亳 (仆仂 从舒亢亟仂亠 仂弍亳亠 亳仄亠亠 于亠仄亠仆仆 仄亠从)
- 12. 仂仆亳从 -> 弌仂亳亶 亰舒仗仂 (Standing Query) -> 亳亠仄仆亳从 (Sink)弌仂弍亳舒仆仆亠 仗仂仂从仂于 仗舒从仂于舒仆 于 仂弍亳
- 13. 仆仂于仆舒 亠亟亳仆亳舒 亟舒仆仆, 仂弍舒弍舒于舒亠仄舒 StreamInsight 亠于亠仂仄
- 14. 弌仂舒于仆亠 舒亳:
- 16. 亳仗 (Kind) 仂弍亳
- 17. 于亠仄亠仆仆亠 仄亠从亳 于磶舒仆仆亠 仂弍亳亠仄
- 18. 舒亞亰从舒 (Payload) 从舒 亟舒仆仆 .NET
- 19. 仂仍 亳 弌于仂亶于舒 仂弍亳 仍亠仄亠仆舒仆亠 亳仗
- 20. 亠 弍仂仍亠亠 32 仗仂仍亠亶
- 21. 亠仍亰 亳仗仂仍亰仂于舒 舒亳弍亟舒仗亠仂仍舒ﾑ/仗亳仆亳仄舒ﾑ 仂弍亳 亳亰 亳仂仆亳从舒 亟舒仆仆
- 22. 舒亰仄亠舒ﾑ 仂弍亳 于 仂亠亠亟亳 亟仍 仗仂仍亠亟ﾑ亠亶 仂弍舒弍仂从亳 亠于亠仂仄
- 23. 仂亟仆亠 舒亟舒仗亠 (Input adapters)
- 24. 仂亟仆亠 舒亟舒仗亠 (Output adapters) 丿舒弍仍仂仆 亰舒仗仂仂于弍舒弍仂从舒 仂弍亳亶 仂亞舒仆亳亰仂于舒仆舒 于 于亳亟亠 亰舒仗仂仂于
- 25. 丿舒弍仍仂仆 亰舒仗仂仂于 (query templates) 从, 仂仗亠亟亠仍ﾑ亳亠 弍亳亰仆亠-仍仂亞亳从 仂弍舒弍仂从亳 亟舒仆仆
- 26. 亅从亰亠仄仗仍 亰舒仗仂舒 (Query Instance = Query + Data Sources) 亰舒亠亞亳亳仂于舒仆仆舒 于磶从舒 舒弍仍仂仆舒 亰舒仗仂舒 仂仗亠亟亠仍亠仆仆仄亳 于仂亟仆仄 亳 于仂亟仆仄 舒亟舒仗亠仂仄舒亰于仂舒亳于舒仆亳亠Hosted DLL
- 27. 仆亠亞亳仂于舒仆 于 StreamInsight 仗亳仍仂亢亠仆亳亠
- 30. 仂亢亠 于仗仂仍仆 从舒从 亠于亳亠仄仂Tolling Station
- 32. Filtering
- 33. Joins
- 34. Unions
- 35. Aggregations
- 36. Event Windows
- 37. Hopping Window
- 38. Tumbling Window
- 39. Snapshot Window
- 41. Filtering
- 42. Joins
- 43. Unions
- 45. Avg
- 46. Sum
- 47. Count
- 48. Min
- 49. Max
- 52. Snapshot Window
- 53. Count WindowTime
- 55. 仂仍亠亰仆亠 仍从亳仂从仄亠仆舒亳 仗仂 StreamInsighthttp://msdn.microsoft.com/ru-ru/library/ee362541.aspx
- 56. A Hitchhiker's Guide to StreamInsight Querieshttp://blogs.msdn.com/b/streaminsight/archive/2010/06/08/hitchhiker-s-guide-to-streaminsight-queries.aspx
- 57. SQL Server 2008 R2 Update for Developers Training Kit http://www.microsoft.com/downloads/details.aspx?FamilyID=fffaad6a-0153-4d41-b289-a3ed1d637c0d&displaylang=en
- 59. 仂仗仂Denis ReznikHead of Web Development dpt.atDCTTrainer at MICMicrosoft MVP (SQL Server)Microsoft Certified TrainerDenisReznik@live.ruhttp://twitter.com/DenisReznikhttp://dev.net.ua/blogs/denisreznik/MCPD - Web Developer 4MCITP Database Developer 2008MCTS - .NET Framework 4, Web ApplicationsMCTS - SQL Server 2008, Database DevelopmentMCTS - .NET Framework 4, Data Access with ADO.NETMCTS - SQL Server 2008, Implementation and Maintenance