WSO2 CEP-多个执行计划的单个事件表 [英] WSO2 CEP - Single Event Table for Multiple Execution PLans

问题描述

最近几天，我一直在探索WSO2 CEP.

I have been exploring WSO2 CEP for last couple of days.

我正在考虑一种方案，其中单个查找表可用于多个执行计划.据我所知，存储数据所有数据的唯一方法是事件表.

I am considering a scenario where a single lookup table could be used in multiple execution plans. As far as I know, only way to store data all data is event table.

我的问题是:

1. 我可以一次加载一个事件表(可能由一个执行计划加载)并与其他执行计划共享该表吗?

1. Can I load an event table once(may be by one execution plan) and share that table with other execution plans?

如果Q1的答案为否，那么它将是同一数据的多个副本，存储在不同的执行计划中，对吗?有什么办法可以减少这种空间的利用?

If answer of Q1 is NO, then it will be multiple copies of same data storing in different execution plans, right ? Is there any way to reduce this space utilization ?

如果事件表不是正确的解决方案，还有哪些其他选择?

If event table is not the correct solution what are other options ?

在此先感谢您， -欧拜德

Thanks in Advance, -Obaid

推荐答案

事件表将在您的方案中起作用.但是，可能需要使用 RDBMS EventTable 或 Hazelcast EventTable 而不是内存中事件表.有了它们，您可以与多个执行计划共享单个表数据.

Event tables would work in your scenario. However, might you need to use RDBMS EventTable or Hazelcast EventTable instead of In-memory event tables. With them, you can share single table data with multiple execution plans.

如果您希望即使在服务器关闭后仍保留数据，则应使用RDBMS EventTables(与此同时，您也可以使用相应的DB浏览器(即H2浏览器，MySQL Workbench等)访问表数据.)如果您只想在运行时与多个执行计划共享一个事件表，则可以继续使用Hazelcast EventTable.

If you want your data to be preserved even after server shutdown, you should use RDBMS EventTables (with this you can also access your table data using respective DB browsers, i.e., H2 browser, MySQL Workbench, etc...). If you just want to share a single event table with multiple execution plans at runtime, you can go ahead with Hazelcast EventTable.

这篇关于WSO2 CEP-多个执行计划的单个事件表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！