公开(公告)号：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.

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

公开(公告)号：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.

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

公开(公告)号：US20130066866A1

公开(公告)日：2013-03-14

申请号：US13401195

申请日：2012-02-21

申请人： Eric S. Chan ,  Adel Ghoneimy ,  Dieter Gawlick ,  Terry M. Olkin

发明人： Eric S. Chan ,  Adel Ghoneimy ,  Dieter Gawlick ,  Terry M. Olkin

IPC分类号： G06F17/30

CPC分类号： G06F17/30699 ,  G06F17/30551

摘要： Systems, methods, and other embodiments associated with bi-temporal user profiling are described. An event is detected that occurs at a valid event time. In response to the event, a repository is accessed that stores data describing one or more user profiles that include a profile record valid time period specifying a time at which the given profile record is valid. A prior user profile record is retrieved that has a profile record valid time period that overlaps with the valid event time. An updated user profile record is created based, at least in part, on the event. The updated user profile record is saved with the valid event time demarcating the start of a profile valid time period. The prior user profile with the valid event time demarcating the end of the profile record valid time period is also saved for subsequent processing.

摘要翻译： 描述了与双时间用户分析相关联的系统，方法和其他实施例。 检测到在有效事件时间发生的事件。 响应于该事件，访问存储库，其存储描述一个或多个用户简档的数据，其中包括用于指定给定简档记录有效的时间的简档记录有效时间段。 检索先前的用户简档记录，其具有与有效事件时间重叠的简档记录有效时间段。 至少部分地基于事件创建更新的用户简档记录。 更新的用户配置文件记录与分配配置文件有效时间段的开始的有效事件时间一起被保存。 具有限定简档记录有效时间段的结束的有效事件时间的先前用户简档也被保存用于后续处理。

公开(公告)号：US08185508B2

公开(公告)日：2012-05-22

申请号：US12326822

申请日：2008-12-02

申请人： Srinivas S. Vemuri ,  Atrayee Mullick ,  Bipul Sinha ,  Amit Ganesh ,  Dieter Gawlick

发明人： Srinivas S. Vemuri ,  Atrayee Mullick ,  Bipul Sinha ,  Amit Ganesh ,  Dieter Gawlick

IPC分类号： G06F17/30

CPC分类号： G06F17/3051

摘要： Techniques are disclosed for creating and using a filter index in order to identify registered queries whose result sets are likely to have been changed by changes made to tables. The filter index entries are based on filter conditions. The filter conditions are created based on predicates contained in the registered queries. The filter conditions may include exclusive predicates and join predicates. Join predicates that join a table T1 with a table T2 may be instantiated by replacing references to table T2 with values extracted from table T2. Various techniques are described for recognizing situations in which a query can be included in, or excluded from, the set of likely-changed queries, without fully evaluating the filter conditions that correspond to the queries.

摘要翻译： 公开了用于创建和使用过滤器索引的技术，以便识别其结果集可能由于对表的改变而改变的注册查询。 过滤器索引条目基于过滤器条件。 过滤条件是根据注册查询中包含的谓词创建的。 过滤条件可能包括排除谓词和连接谓词。 可以通过用从表T2提取的值替换对表T2的引用来实例化加入具有表T2的表T1的连接谓词。 描述各种技术用于识别其中可以将查询包括在可能改变的查询集合中或从可能改变的查询集合中排除的情况，而不完全评估与查询相对应的过滤条件。

公开(公告)号：US20090077135A1

公开(公告)日：2009-03-19

申请号：US12102831

申请日：2008-04-14

申请人： Aravind Yalamanchi ,  Dieter Gawlick ,  Jayanta Banerjee

发明人： Aravind Yalamanchi ,  Dieter Gawlick ,  Jayanta Banerjee

IPC分类号： G06F17/30

CPC分类号： G06F17/30359

摘要： Techniques are provided for freeing up resources before operations that change the resources have successfully completed. Resources are freed up by committing database transactions that perform portions of operations before the operations themselves have successfully completed. If the operations fail to complete successfully, then “compensation information” is used to remove the effects of the committed changes that were performed as part of the operation. Techniques are also provided for allowing database transactions to update values without retaining exclusive locks on those values. Operational constraints set forth conditions that must be satisfied before an update is allowed to proceed. If an attempt is made to update a particular value that has changes that may be undone, then the database server determines a plurality of “possible result values” for the particular value. If the possible result values satisfy the operational constraint conditions, then the update is allowed to proceed.

摘要翻译： 提供了在更改资源成功完成的操作之前释放资源的技术。 通过在操作本身已经成功完成之前提交执行部分操作的数据库事务来释放资源。 如果操作无法成功完成，则使用“补偿信息”来消除作为操作一部分而执行的所作出的更改的影响。 还提供了允许数据库事务更新值而不保留这些值的排他锁的技术。 操作约束规定了允许进行更新之前必须满足的条件。 如果尝试更新具有可以被撤销的变化的特定值，则数据库服务器确定特定值的多个“可能的结果值”。 如果可能的结果值满足操作约束条件，则允许进行更新。

公开(公告)号：US07127467B2

公开(公告)日：2006-10-24

申请号：US10254383

申请日：2002-09-24

申请人： Aravind Yalamanchi ,  Dieter Gawlick ,  Jagannathan Srinivasan

发明人： Aravind Yalamanchi ,  Dieter Gawlick ,  Jagannathan Srinivasan

IPC分类号： G06F17/30

CPC分类号： G06F17/2241 ,  G06F17/2247 ,  G06F17/30289 ,  G06F17/30917 ,  Y10S707/961 ,  Y10S707/99933 ,  Y10S707/99943

摘要： A method for managing expressions includes receiving a first query that includes a first conditional expression. The first expression is then represented as data in a column of a table. A second query is received that specifies a first set of criteria, and the second query is executed to select data based at least on whether expressions in the column satisfy the first set of criteria. In an embodiment, the second query further specifies a second set of criteria, wherein executing the second query includes selecting data based on whether data in columns other than the expression column satisfy the second criteria. A special index is defined, which can be created on the column that stores the expressions as data, to filter large sets of expressions efficiently. A method of evaluating an expression set stored as data in a table classifies each predicate from each expression, and filters the expression set based on the predicate classification.

公开(公告)号：US06377953B1

公开(公告)日：2002-04-23

申请号：US09222010

申请日：1998-12-30

申请人： Dieter Gawlick ,  Samuel Defazio ,  Pankaj Tandon

发明人： Dieter Gawlick ,  Samuel Defazio ,  Pankaj Tandon

IPC分类号： G06F1730

CPC分类号： G06F17/30569 ,  Y10S707/99942 ,  Y10S707/99943 ,  Y10S707/99944

摘要： A method and system are provided for handling within a database system data items that are associated with data types that are not supported by the database language used to the database system. The data types are registered with the database system by storing, in the database, metadata that indicates the structure, physical layout, and constraints that apply to the data types. The database system uses the structure and physical layout information to access individual elements of data items. The database system validates data items using the constraint information, which includes constraints that dictate what values are valid for certain elements based on what values are supplied for other elements. Data items associated with many different data types may be stored in the same table. Applications can access the data items through a transformation view that transforms the data items from their native format to a format expected by the applications.

摘要翻译： 提供了一种方法和系统，用于在数据库系统内处理与用于数据库系统的数据库语言不支持的数据类型相关联的数据项。 数据类型通过在数据库中存储指示应用于数据类型的结构，物理布局和约束的元数据来向数据库系统注册。 数据库系统使用结构和物理布局信息来访问数据项的各个元素。 数据库系统使用约束信息来验证数据项，约束信息包括根据为其他元素提供的值来指定哪些值对某些元素有效的约束。 与许多不同数据类型相关联的数据项可以存储在同一个表中。 应用程序可以通过转换视图来访问数据项，转换视图将数据项从本机格式转换为应用程序所期望的格式。

公开(公告)号：US06889231B1

公开(公告)日：2005-05-03

申请号：US10308924

申请日：2002-12-02

申请人： Benny Souder ,  Dieter Gawlick ,  Jim Stamos ,  Alan Downing

发明人： Benny Souder ,  Dieter Gawlick ,  Jim Stamos ,  Alan Downing

IPC分类号： G06F7/00 ,  G06F17/30

CPC分类号： G06F17/30575 ,  Y10S707/99944 ,  Y10S707/99945 ,  Y10S707/99948 ,  Y10S707/99953

摘要： Techniques for sharing information in a wide variety of contexts allows both an explicit capture process and an implicit capture process to add information items to a staging area. An information sharing system supports both implicit and explicit consumption of information items that are stored in the staging area. A rules engine allows users to create and register rules that customize the behavior of the capture processes, the consuming processes, and propagation processes that propagate information from the staging areas to designated destinations. Exactly-once handling of sequence of items is achieved for items maintained in volatile memory. DDL operations are recorded, and operations are asynchronously performed based on the previously-performed DDL operations.

摘要翻译： 在各种上下文中共享信息的技术允许显式捕获进程和隐式捕获进程将信息项添加到分段区域。 信息共享系统支持存储在分段区域中的信息项的隐式和显式消耗。 规则引擎允许用户创建和注册规则，自定义捕获进程的行为，消费过程以及将信息从分段区域传播到指定目的地的传播过程。 对于易失性存储器中维护的项目，实际上完成了对项目顺序的处理。 记录DDL操作，并根据先前执行的DDL操作异步执行操作。

公开(公告)号：US6058389A

公开(公告)日：2000-05-02

申请号：US961597

申请日：1997-10-31

申请人： Sashikanth Chandra ,  Dieter Gawlick ,  Sandeep Jain ,  Hasan Rizvi ,  Premal Shah ,  Alvin To

发明人： Sashikanth Chandra ,  Dieter Gawlick ,  Sandeep Jain ,  Hasan Rizvi ,  Premal Shah ,  Alvin To

IPC分类号： G06F17/30

CPC分类号： G06F17/3056 ,  G06F17/30321 ,  G06F9/546 ,  G06F2209/548 ,  Y10S707/99931

摘要： An advanced message queuing system is integrated into a database system. A queue is an ordered list of messages. Messages are requests for processing by an application. Messages are database objects and can represent events or data. Messages comprise user data and control information such as a queue name. Each queue is part of a table in a relational database. A queue table holds a set of queues. Dictionary tables store configuration information describing queues and queue tables. Messages are entered into a queue by instructing the database system using an enqueuing command attached to a message and control information. The control information describes how to order, schedule, and execute the message, and can include a result queue name into which a result message is written after execution. The system responds to a dequeuing command by delivering a copy of a message from the queue. A user can define message order within a queue, message delay factors, and exception processing. Messages may be retained in their queues after delivery and can be preserved, queried, documented, correlated, reviewed and tracked, alone or in a set comprising a transaction, regardless of message state or execution state. The system can be used to develop large-scale, message-oriented distributed applications. Existing development tools for database applications can also be used to develop queuing applications. Administrative functions to create, delete, and specify access control for queues are provided. The system provides transactional integrity; a single transaction applies to both the database and the queue. A single transaction log is maintained.

摘要翻译： 高级消息队列系统被集成到数据库系统中。 队列是消息的有序列表。 消息是应用程序处理的请求。 消息是数据库对象，可以表示事件或数据。 消息包括诸如队列名称的用户数据和控制信息。 每个队列是关系数据库中表的一部分。 队列表包含一组队列。 字典表存储描述队列和队列表的配置信息。 通过使用附加到消息和控制信息的入队命令来指示数据库系统，将消息输入队列。 控制信息描述如何订购，调度和执行消息，并且可以包括在执行结果消息之后写入的结果队列名称。 系统通过从队列传递消息的副本来响应出队命令。 用户可以定义队列内的消息顺序，消息延迟因子和异常处理。 消息可以在交付之后保留在他们的队列中，并且可以单独地或在包括事务的集合中被保留，查询，记录，关联，审查和跟踪，而不管消息状态或执行状态如何。 该系统可用于开发大规模，面向消息的分布式应用程序。 数据库应用程序的现有开发工具也可用于开发排队应用程序。 提供了管理功能来创建，删除和指定队列的访问控制。 系统提供事务完整性; 单个事务也适用于数据库和队列。 维护一个事务日志。

公开(公告)号：US5233835A

公开(公告)日：1993-08-10

申请号：US945569

申请日：1992-09-16

申请人： Dieter Gawlick

发明人： Dieter Gawlick

IPC分类号： B60T11/28 ,  B60T11/224 ,  B60T15/36

CPC分类号： B60T11/224

摘要： A two-stage brake valve includes a stepped valve bore and pressure piston defining a first stage with a large effective area and a second stage with a smaller effective area. The two stages become effective in succession so that, initially the first stage is used to fill a system and then, following a transitional phase, the second stage generates an operating pressure. A relief channel communicates the pressure chamber of the first stage with a reservoir. A relief valve closes the relief channel in response to an excess pressure generated by operation of the second stage.

摘要翻译： 两级制动阀包括阶梯式阀孔和限定具有大的有效面积的第一级的压力活塞和具有较小有效面积的第二级。 这两个阶段是连续有效的，因此，最初使用第一阶段填充系统，然后在过渡阶段之后，第二阶段产生一个操作压力。 释放通道将第一级的压力室与储存器连通。 安全阀响应于由第二级的操作而产生的过大的压力而关闭释放通道。