Integrating databases with publish/subscribe
Integrating databases with publish/subscribe
复制标题
将数据库与发布/订阅集成
DOI：
--
复制
发表时间：
2005
期刊：
影响因子：
--
通讯作者：
K. Moody
中科院分区：
文献类型：
--
作者：
L. Vargas;J. Bacon;K. Moody
发布/订阅正在成为大规模、广泛分布的系统的适当通信范例。在本文中，我们描述了我们的工作集成主动数据库与发布/订阅，使用PostgreSQL和爱马仕作为实验环境。在所提出的体系结构中，每个数据库管理器定义和处理更改事件，与连续查询模型。可以跨越多个物理关系的已验证事件对应于安全视图的虚拟关系。客户端订阅感兴趣的事件，并可以通过基于内容的筛选表达式来优化其订阅。只要通过动态触发层检测到的数据库更改与某个活动订阅匹配，就会发布事件。数据库事件的安全性和路由以与传统爱马仕事件相同的方式处理。
Publish/subscribe is emerging as an appropriate communication paradigm for large-scale, widely-distributed systems. In this paper, we describe our work on integrating active databases with publish/subscribe, using PostgreSQL and Hermes as the experimental context. In the proposed architecture, each database manager defines and advertises change events, in contrast with a continuous query model. Advertised events, which may span a number of physical relations, correspond to the virtual relations of a security view. Clients subscribe to events of interest, and can refine their subscriptions through content-based filter expressions. An event is published whenever a database change, detected via a dynamic triggering layer, matches some active subscription. Security and routing of database events are handled in the same way as for conventional Hermes events.