Teradata 变更数据捕获

发布于 2024-08-31 09:58:08 字数 217 浏览 12 评论 0原文

我的团队正在考虑开发一个从数据库读取数据的实时应用程序(一堆图表、仪表等)。在后端,我们有一个大容量的 Teradata 数据库。我们期望其他一些应用程序不断地将数据输入到该数据库中。 现在我们想知道如何将数据库的更改提供给应用程序。在我们的例子中,从应用程序进行轮询并不是一个可行的选择。

Teradata 中是否有任何工具可以帮助我们实现这一目标?

任何有关这方面的指示将不胜感激

My team is thinking about developing a real time application (a bunch of charts, gauges etc) reading from the database. At the backend we have a high volume Teradata database. We expect some other applications to be constantly feeding in data into this database.
Now we are wondering about how to feed in the changes from the database to the application. Polling from the application would not be a viable option in our case.

Are there any tools that are available within Teradata that would help us achieve this?

Any directions on this would be greatly appreciated

如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。

扫码二维码加入Web技术交流群

发布评论

需要 登录 才能够评论, 你可以免费 注册 一个本站的账号。

评论(3

哎呦我呸! 2024-09-07 09:58:08

我们面临着类似的要求。但在我们的案例中,客户要求我们提供采购订单表的每日更改。这意味着我们必须每天运行一批脚本来捕获表中发生的更改。

因此我们开始每天收集数据,并将数据以稀疏历史格式存储在另一个表中。所以这里的过程很简单。我们在历史表中收集第一天日期的采购订单详细信息记录。然后第二天,我们将第二天的提要记录与历史记录进行比较,并识别该记录中的任何更改。如果采购订单记录列发生变化,我们会收集该记录并将其保存在最终报告表中,该表将显示给客户。

如果您每天运行一次批处理脚本,并且一天内会对记录进行多次更改,则此方法无法为您提供完整的更改。为此,您可能需要根据您的要求每天多次运行批处理脚本。

如果您找到任何其他解决方案,请告诉我们。希望这有帮助。

We faced similar requirement. But in our case client asked us to provide daily changes to a purchase orders table. That means we had to run a batch of scripts every day to capture the changes occuring to the table.

So we started to collect data every day and store the data in a sparse history format in another table. So the process is simple here. We collect a purchase order details record in the against first day's date in the history table. And then the next day we compare the next day's feed record against the history record and identify any change in that record. If there is a change in the purchase order record columns we collect that record and keep it in a final reporting table which will be shown to the client.

If you run the batch scripts every day once and there will be more than one change in a day to a record then this method cannot give you the full changes. For that you may need to run the batch scripts more than once every day based on your requirement.

Please let us know if you find any other solution. Hope this helps.

云之铃。 2024-09-07 09:58:08

有一个来自wisdomforce的变更数据捕获工具。
http://www.wisdomforce.com/resources/docs/databasesync/DatabaseSyncBestPracticesforTeradata。 pdf

在这种情况下它可能会起作用

There is a change data capture tool from wisdomforce.
http://www.wisdomforce.com/resources/docs/databasesync/DatabaseSyncBestPracticesforTeradata.pdf

It would it probably work in this case

半城柳色半声笛 2024-09-07 09:58:08

带有存储过程的触发器是一种选择吗?

CREATE TRIGGER dbname.triggername
AFTER INSERT ON db_name.tbl_name
REFERENCING stored_procedure

从理论上讲,您可以编写外部存储过程,该存储过程可以调用用 Java 或 C/C++ 等编写的 UDF,从而可以近乎实时地将行数据推送到您的应用程序。

Are triggers with stored procedures an option?

CREATE TRIGGER dbname.triggername
AFTER INSERT ON db_name.tbl_name
REFERENCING stored_procedure

Theoretically speaking, you can write external stored procedures which may call UDFs written in Java or C/C++ etc which can push the row data to your application in near real time.

~没有更多了~
我们使用 Cookies 和其他技术来定制您的体验包括您的登录状态等。通过阅读我们的 隐私政策 了解更多相关信息。 单击 接受 或继续使用网站,即表示您同意使用 Cookies 和您的相关数据。
原文