微软流洞察
我正在寻找一些可能的选项，以使用 Microsoft StreamInsight 流式传输数据库级别上发生的所有更改。一种可能的方法是使用数据库触发器（我不认为这是一个好方法）。如果有人有这方面的经验，请提出建议。
我也对其他产品持开放态度，我真正想做的是监视数据变化并针对它们提出相应的事件。任何帮助将不胜感激:)
从评论中查看以下详细信息可能会有所帮助： 我们有一个信息系统，其中很少有用 C++ 编写的组件，很少有用 PowerBuilder 编写的，其余全部用 C# 编写。它们都位于公共数据库之上。简而言之，我们没有数据库的单一入口点。我们现在正在研究的是添加基于事件触发的可配置规则。这可以使用第三方规则引擎轻松实现。我们现在唯一的挑战是如何根据数据的变化生成这些事件。我从 SQL Server 端读到了大约 2 个选项： 变更跟踪 变更数据捕获 甚至不确定这是否有帮助。我还试图了解 StreamInsight 如何帮助我们实现这一目标。我希望这能让问题更加清晰。
I am looking for some possible options for streaming all changes happening on DB level using Microsoft StreamInsight. One possible way is using DB Triggers (which I don't thing is a good way). If anyone has some experience with this please suggest.
I am open to other products as well, what I really want to do is monitor data changes and raise corresponding events against them. Any help will be appreciated :)
Looking from the comments following details might help:
We have an information system with few components written in C++, few in PowerBuilder, rest all in C#. They all sit on top of common database. In short, we don't have single entry point to database. What we are looking into right now is to add configurable rules which get fired based on Events. This can be easily achieved using 3rd party rules engine. Our only challenge right now is how to generate these events based on change of data. I read about 2 options from SQL Server side:
Change Tracking
Change Data Capture
not sure even that can help. I was also trying to see how StreamInsight can help us achieve this. I hope this added more clarity to question.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
进行此类审核（合规性？）的原因是什么？你在监视什么？总的来说，我会说这是购买与构建的决定，我倾向于购买，但这取决于您正在监控的变化以及原因。
如果这是合规性业务要求，我会更倾向于使用处理合规性的第三方工具，因为其他人会担心特殊情况。
除非我没有预见到这种需求，否则我将 StreamInsight 视为一把锤子，而你正在寻找钉子。 IE 我不认为我会朝这个方向发展。
What is the reasoning for this type of audit (compliance?)? And what are you monitoring? In general, I would state this is a buy versus build decision and I would favor buy, but that depends on what changes you are monitoring and why.
If this is a compliance business requirement, I would be even more inclined to use a third party tool that handles compliance, as you have someone else worried about the exceptional cases.
Unless the need is something I am not envisioning, I see StreamInsight as a hammer and you are searching for nails. I.E. I don't think I would head that direction.
我不确定 StreamInsight 是否是您想要做的事情的正确解决方案。它非常擅长在时间上下文中对大量数据进行内存处理。一旦涉及到磁盘（即数据库），延迟就会急剧上升。
问题：您想要解决的业务问题是什么？您的关键用例是什么？
I'm not sure that StreamInsight is the right solution for what you are trying to do. It is really good at in-memory processing of high volumes of data within a temporal context. Once you get a disk involved (which you are with a database), your latency skyrockets.
Question: What is the business problem that you are trying to solve? What are your key use cases?