公开(公告)号：US20080275956A1

公开(公告)日：2008-11-06

申请号：US11743276

申请日：2007-05-02

申请人： Abhishek Saxena ,  Neerja Bhatt

发明人： Abhishek Saxena ,  Neerja Bhatt

IPC分类号： G06F15/16

CPC分类号： G06F17/30368 ,  G06F17/30412 ,  G06F19/00 ,  G06Q10/02 ,  G06Q10/025 ,  G06Q40/08 ,  G06Q50/22 ,  G06Q50/24

摘要： Techniques for grouping events in a computing system are provided. A registrant sends, to a database server, a request to register to receive a single notification based the occurrence of multiple events that satisfy certain criteria, referred to as grouping attributes. Such registrations are referred to as grouping registrations. An eventing mechanism in the database server receives and maintains grouping registrations. When an event is received, the eventing mechanism determines whether the event has been registered for in an active grouping registration, i.e., one whose start time has passed but whose completion criteria are not yet satisfied. If so, then the eventing mechanism updates grouping data associated with the grouping registration. When the completion criteria of a grouping registration are satisfied, the eventing mechanism sends a notification to the registrant and/or other intended recipient(s). The notification may provide a summary of all the events in the group or provide details about a single event from the group, such as the latest event.

摘要翻译： 提供了在计算系统中对事件进行分组的技术。 注册人根据满足某些标准（称为分组属性）的多个事件的发生，向数据库服务器发送注册以接收单个通知的请求。 这种注册被称为分组注册。 数据库服务器中的事件处理机制接收并维护分组注册。 当接收到事件时，事件机制确定事件是否已经在活动分组登记中注册，即，其开始时间已经过去但其完成标准尚未满足的注册。 如果是，则事件机制更新与分组注册相关联的分组数据。 当满足分组登记的完成标准时，事件机制向注册者和/或其他预期接收者发送通知。 该通知可以提供组中的所有事件的摘要，或提供关于组中的单个事件的详细信息，例如最新事件。

公开(公告)号：US06502093B1

公开(公告)日：2002-12-31

申请号：US10099478

申请日：2002-03-14

申请人： Neerja Bhatt ,  Dieter Gawlick ,  Ekrem Soylemez

发明人： Neerja Bhatt ,  Dieter Gawlick ,  Ekrem Soylemez

IPC分类号： G06F1730

CPC分类号： G06F17/3051 ,  G06F17/30516 ,  Y10S707/954 ,  Y10S707/99933 ,  Y10S707/99934 ,  Y10S707/99935

摘要： A method and apparatus are provided for implementing a content-based publish-and-subscribe system in a relational database system. A subscriber may request for messages by using a query language supported by the database server. The queries are then used as subscription rules for determining whether an incoming message is to be sent to the subscriber. Evaluation of incoming messages against subscription rules involves a two-tier process. The first tier involves filtering out all the subscription rules that could not possibly apply to the incoming message. The second tier involves further evaluation of the incoming message, if needed, to determine which subscribers are to receive the incoming message. In another aspect of the embodiment, in cases where the publisher is the relational database system itself, queries that request for messages are not stored as subscription rules because publication of the messages is implicit. In this situation, a query is received from a client that is written in a query language supported by the database system. The query is a request for data stored in the database system that satisfies the query. A detection is made that the data stored in the database system has been changed and in response, the changed data is provided to the client.

摘要翻译： 提供了一种用于在关系数据库系统中实现基于内容的发布和订阅系统的方法和装置。 用户可以通过使用数据库服务器支持的查询语言来请求消息。 然后，查询用作订阅规则，用于确定是否要向订户发送传入消息。 根据订阅规则评估传入消息涉及两层过程。 第一层涉及过滤掉不可能应用于传入邮件的所有订阅规则。 第二层涉及进一步评估传入消息，如果需要，确定哪些订户将接收传入消息。 在该实施例的另一方面，在发布者是关系数据库系统本身的情况下，请求消息的查询不被存储为订阅规则，因为消息的发布是隐式的。 在这种情况下，从客户端接收到以数据库系统支持的查询语言编写的查询。 该查询是对满足查询的数据库系统中存储的数据的请求。 检测存储在数据库系统中的数据已被更改，并且作为响应，将改变的数据提供给客户端。

公开(公告)号：US20090158298A1

公开(公告)日：2009-06-18

申请号：US11954739

申请日：2007-12-12

申请人： Abhishek Saxena ,  Neerja Bhatt ,  James W. Stamos

发明人： Abhishek Saxena ,  Neerja Bhatt ,  James W. Stamos

IPC分类号： G06F9/44

CPC分类号： G06F9/542 ,  G06F11/3476 ,  G06F11/3495 ,  G06F16/2358 ,  G06F2201/86

摘要： A system for managing event monitors within a database is provided. The system can adjust the amount of notifications generated by those event monitors, so as to achieve an effective balance between probability of notification loss and available notification bandwidth, as well as provide a better quality of service to database users.

摘要翻译： 提供了一种用于管理数据库内的事件监视器的系统。 该系统可以调整这些事件监视器产生的通知量，以便在通知丢失的概率和可用的通知带宽之间实现有效平衡，并为数据库用户提供更好的服务质量。

公开(公告)号：US20090019456A1

公开(公告)日：2009-01-15

申请号：US11777783

申请日：2007-07-13

申请人： Abhishek Saxena ,  Neerja Bhatt

发明人： Abhishek Saxena ,  Neerja Bhatt

IPC分类号： G06F9/54

CPC分类号： G06F17/30445

摘要： Techniques for processing events in parallel are provided. Multiple publishers publish events in parallel to a plurality of channels. Each channel is a queue that maintains a list of events that are awaiting to be processed by one or more slave processes. In one approach, all events that need to be persistent are published to a persistent channel, whereas all events that do not need to be persistent are published to one or more in-memory channels. In another approach, for each event, a publisher determines which channel of the plurality of channel to publish the event. The determination is based, at least in part, on the number of events in each channel and, optionally, the type of each event in each channel. In either approach, each event from a single publisher is published to the same channel.

摘要翻译： 提供并行处理事件的技术。 多个发布者将事件并行发布到多个通道。 每个通道是一个队列，用于维护等待由一个或多个从属进程处理的事件列表。 在一种方法中，需要持久化的所有事件被发布到持久性通道，而不需要持久性的所有事件被发布到一个或多个内存中通道。 在另一种方法中，对于每个事件，发布者确定多个频道的哪个频道来发布该事件。 该确定至少部分地基于每个通道中的事件的数量，以及可选地基于每个通道中的每个事件的类型。 在任一方法中，来自单个发布者的每个事件将发布到同一通道。

公开(公告)号：US06405191B1

公开(公告)日：2002-06-11

申请号：US09359170

申请日：1999-07-21

申请人： Neerja Bhatt ,  Dieter Gawlick ,  Ekrem Soylemez ,  Rahim Yaseem

发明人： Neerja Bhatt ,  Dieter Gawlick ,  Ekrem Soylemez ,  Rahim Yaseem

IPC分类号： G06F1730

CPC分类号： G06F17/3051 ,  G06F17/30516 ,  Y10S707/954 ,  Y10S707/99933 ,  Y10S707/99934 ,  Y10S707/99935

摘要： A method and apparatus are provided for implementing a content based publish-and-subscribe system in a relational database system. A subscriber may request for messages by using a query language supported by the database server. The queries are then used as subscription rules for determining whether an incoming message is to be sent to the subscriber. Evaluation of incoming messages against subscription rules involves a two-tier process. The first tier involves filtering out all the subscription rules that could not possibly apply to the incoming message. The second tier involves further evaluation of the incoming message, if needed, to determine which subscribers are to receive the incoming message. In another aspect of the embodiment, in cases where the publisher is the relational database system itself, queries that request for messages are not stored as subscription rules because publication of the messages is implicit.

摘要翻译： 提供了一种用于在关系数据库系统中实现基于内容的发布和订阅系统的方法和装置。 用户可以通过使用数据库服务器支持的查询语言来请求消息。 然后，查询用作订阅规则，用于确定是否要向订户发送传入消息。 根据订阅规则评估传入消息涉及两层过程。 第一层涉及过滤掉不可能应用于传入邮件的所有订阅规则。 第二层涉及进一步评估传入消息，如果需要，确定哪些订户将接收传入消息。 在该实施例的另一方面，在发布者是关系数据库系统本身的情况下，请求消息的查询不被存储为订阅规则，因为消息的发布是隐式的。

公开(公告)号：US08448186B2

公开(公告)日：2013-05-21

申请号：US11777783

申请日：2007-07-13

申请人： Abhishek Saxena ,  Neerja Bhatt

发明人： Abhishek Saxena ,  Neerja Bhatt

IPC分类号： G06F3/00 ,  G06F9/44 ,  G06F9/46 ,  G06F13/00

CPC分类号： G06F17/30445

摘要： Techniques for processing events in parallel are provided. Multiple publishers publish events in parallel to a plurality of channels. Each channel is a queue that maintains a list of events that are awaiting to be processed by one or more slave processes. In one approach, all events that need to be persistent are published to a persistent channel, whereas all events that do not need to be persistent are published to one or more in-memory channels. In another approach, for each event, a publisher determines which channel of the plurality of channel to publish the event. The determination is based, at least in part, on the number of events in each channel and, optionally, the type of each event in each channel. In either approach, each event from a single publisher is published to the same channel.

摘要翻译： 提供并行处理事件的技术。 多个发布者将事件并行发布到多个通道。 每个通道是一个队列，用于维护等待由一个或多个从属进程处理的事件列表。 在一种方法中，需要持久化的所有事件被发布到持久性通道，而不需要持久性的所有事件被发布到一个或多个内存中通道。 在另一种方法中，对于每个事件，发布者确定多个频道的哪个频道来发布该事件。 该确定至少部分地基于每个通道中的事件的数量，以及可选地基于每个通道中的每个事件的类型。 在任一方法中，来自单个发布者的每个事件将发布到同一通道。

公开(公告)号：US08069155B2

公开(公告)日：2011-11-29

申请号：US12350055

申请日：2009-01-07

申请人： Abhishek Saxena ,  Neerja Bhatt ,  Daniel ManHung Wong ,  Jinqiang Han

发明人： Abhishek Saxena ,  Neerja Bhatt ,  Daniel ManHung Wong ,  Jinqiang Han

IPC分类号： G06F7/00 ,  G06F17/00 ,  G06F7/04 ,  G06F17/30 ,  H04N7/16

CPC分类号： G06F21/445 ,  G06F17/30306

摘要： One embodiment of the present invention provides a database server for securing database event notifications. The server includes a session key creation mechanism configured to create a session key when a client registers for an event, a storage mechanism configured to store the session key on the database server, a data accessing mechanism configured to access registration metadata to obtain the session key when the event occurs, a connection mechanism configured to establish a communication channel between the database server and the client, a mutual authenticating mechanism configured to using the session key to mutually authenticate the client and the database server during event notification, and an event notifying mechanism configured to send the event notification to the client.

摘要翻译： 本发明的一个实施例提供一种用于保护数据库事件通知的数据库服务器。 服务器包括会话密钥创建机构，被配置为当客户端注册事件时创建会话密钥，被配置为在数据库服务器上存储会话密钥的存储机制，被配置为访问注册元数据以获得会话密钥的数据访问机制 当事件发生时，配置为在数据库服务器和客户端之间建立通信信道的连接机制，配置为在事件通知期间使用会话密钥来相互认证客户端和数据库服务器的相互认证机制，以及事件通知机制 配置为将事件通知发送给客户端。

公开(公告)号：US08005802B2

公开(公告)日：2011-08-23

申请号：US10452850

申请日：2003-05-30

申请人： Edwina Lu ,  Lik Wong ,  Sanjay Kaluskar ,  James Stamos ,  Neerja Bhatt ,  Wei Wang

发明人： Edwina Lu ,  Lik Wong ,  Sanjay Kaluskar ,  James Stamos ,  Neerja Bhatt ,  Wei Wang

IPC分类号： G06F17/30

CPC分类号： G06F17/30575 ,  Y10S707/99939 ,  Y10S707/99942 ,  Y10S707/99943

摘要： Described herein are various approaches that allow rules to be used to specify actions, that alleviate the complexity and burden of developing and maintaining rules in a rules-based messaging system, and that provide more efficient ways of evaluating rules. The approaches allow rules to specify user-defined transformation functions for transforming messages, to specify when and how to perform row migration, and to specify other types of actions. Rules are grouped into rule sets. Several types of rule sets, referred to as positive and negative rule sets, allow users to use rules that are less complex to develop and maintain. Rule sets are evaluated more efficiently by attempting to evaluate the rule set with less information than is needed to evaluate all the rules in the rule set. Also, the results of rules evaluations that are based on a set of values are cached for later retrieval.

摘要翻译： 这里描述了允许规则用于指定动作的各种方法，其减轻了在基于规则的消息传递系统中开发和维护规则的复杂性和负担，并且提供了更有效的评估规则的方式。 这些方法允许规则指定用于转换消息的用户定义的转换功能，指定何时以及如何执行行迁移，并指定其他类型的操作。 规则分为规则集。 称为正和负规则集的几种类型的规则集允许用户使用开发和维护不太复杂的规则。 通过尝试使用比评估规则集中的所有规则所需的信息更少的信息来评估规则集，可以更有效地评估规则集。 此外，基于一组值的规则评估结果被缓存以供以后检索。

公开(公告)号：US07565379B2

公开(公告)日：2009-07-21

申请号：US10452761

申请日：2003-05-30

申请人： Edwina Lu ,  Lik Wong ,  Sanjay Kaluskar ,  James Stamos ,  Neerja Bhatt ,  Wei Wang

发明人： Edwina Lu ,  Lik Wong ,  Sanjay Kaluskar ,  James Stamos ,  Neerja Bhatt ,  Wei Wang

IPC分类号： G06F17/00

CPC分类号： G06F7/00 ,  Y10S707/99945

摘要： In some messaging system architectures, messages can cycle back to the originator of a message, who may then propagate the message, causing the cycle to be repeated. Described herein are techniques that use rules and fields in a redo log, to manage message flows such that undesired cycles are prevented. The techniques may be used in messaging systems that have various topologies.

摘要翻译： 在一些消息系统架构中，消息可以循环回到消息的发起者，然后谁可以传播消息，导致重复循环。 这里描述的是使用重做日志中的规则和字段来管理消息流的技术，从而防止不期望的周期。 这些技术可以用于具有各种拓扑的消息系统中。