专利快速检索-快速检索全球专利，免费商用专利数据库-IPRDB

1. 发明授权

US10296629B2 Server supporting a consistent client-side cache 有权
公开(公告)号：US10296629B2
公开(公告)日：2019-05-21
申请号：US11876679
申请日：2007-10-22
申请人： Lakshminarayanan Chidambaran , Mehul Dilip Bastawala , Srinath Krishnaswamy , Tirthankar Lahiri , Juan R. Loaiza , Bipul Sinha , Srinivas S. Vemuri
发明人： Lakshminarayanan Chidambaran , Mehul Dilip Bastawala , Srinath Krishnaswamy , Tirthankar Lahiri , Juan R. Loaiza , Bipul Sinha , Srinivas S. Vemuri
IPC分类号： G06F7/00 , G06F17/30 , G06F17/00
摘要： A method, system, and computer program product is disclosed for interacting with a client supported by a client-side cache. Embodiments of a method, a system, and a computer program product are disclosed that retrieve a first snapshot, indicating a state of the database after a last database request by the client, associated with the client, determine any number of invalid cached results for the client based on the first snapshot, and transmit the any number of invalid cached results and a second snapshot, an update for the first snapshot.

2. 发明授权

US09697253B2 Consistent client-side cache 有权
公开(公告)号：US09697253B2
公开(公告)日：2017-07-04
申请号：US11875782
申请日：2007-10-19
申请人： Lakshminarayanan Chidambaran , Mehul Dilip Bastawala , Srinath Krishnaswamy , Tirthankar Lahiri , Juan R. Loaiza , Bipul Sinha , Srinivas S. Vemuri
发明人： Lakshminarayanan Chidambaran , Mehul Dilip Bastawala , Srinath Krishnaswamy , Tirthankar Lahiri , Juan R. Loaiza , Bipul Sinha , Srinivas S. Vemuri
IPC分类号： G06F17/30
CPC分类号： G06F17/3048
摘要： A method, system, and computer program product is disclosed for caching results in a client-side cache. Embodiments of a method, a system, and a computer program product are disclosed that associate a first snapshot of a database with a client that indicates a state of the database after a last database request by the client, and indicate any number of invalid cached results in the client cache for the client based upon the first snapshot. In some embodiments, the method further includes receiving a second snapshot that indicates a state of the database upon receipt of a database server request by the client, and updating the first snapshot with the second snapshot.

3. 发明申请

US20100036803A1 ADAPTIVE FILTER INDEX FOR DETERMINING QUERIES AFFECTED BY A DML OPERATION 有权
标题翻译：用于确定DML操作影响的自适应滤波器索引
公开(公告)号：US20100036803A1
公开(公告)日：2010-02-11
申请号：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分类号： G06F7/06 , 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的连接谓词。描述各种技术用于识别其中可以将查询包括在可能改变的查询集合中或从可能改变的查询集合中排除的情况，而不完全评估与查询相对应的过滤条件。

4. 发明授权

US08185508B2 Adaptive filter index for determining queries affected by a DML operation 有权
标题翻译：用于确定受DML操作影响的查询的自适应过滤器索引
公开(公告)号：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的连接谓词。描述各种技术用于识别其中可以将查询包括在可能改变的查询集合中或从可能改变的查询集合中排除的情况，而不完全评估与查询相对应的过滤条件。

5. 发明授权

US08037040B2 Generating continuous query notifications 有权
标题翻译：生成连续的查询通知
公开(公告)号：US08037040B2
公开(公告)日：2011-10-11
申请号：US12189078
申请日：2008-08-08
申请人： Srinivas S. Vemuri , Bipul Sinha , Amit Ganesh , Subramanyam B. Chitti
发明人： Srinivas S. Vemuri , Bipul Sinha , Amit Ganesh , Subramanyam B. Chitti
IPC分类号： G06F17/30
CPC分类号： G06F17/30516
摘要： Techniques are described to allow a query to be registered as a persistent stored entity within the database, and to generate notifications as and when the query result changes continuously as long as the query continues to be registered with the database. According to one aspect, for a table referenced in a query, a filter condition is generated based, at least in part, on a predicate of the query. Then, the database server determines whether the filter condition is satisfied by either a before image of a row, or an after image of the row, that was modified by a transaction. If the filter condition is satisfied by either the before image or the after image, then the query is added to a first set of queries whose result sets may have been affected by the transaction. From among the first set of queries, a second set of queries that have result sets that were actually affected by the transaction is determined. Notifications are then sent based on the second set of queries.
摘要翻译：描述技术来允许将查询注册为数据库内的持久存储实体，并且只要查询继续向数据库注册，就可以随着查询结果不断更改而生成通知。根据一个方面，对于在查询中引用的表，基于至少部分地基于查询的谓词生成过滤条件。然后，数据库服务器通过由事务修改的行的先前图像或行的后续图像来确定滤波器条件是否满足。如果过滤条件由前图像或后图像所满足，则将查询添加到其结果集可能受事务影响的第一组查询中。从第一组查询中，确定具有实际受事务影响的结果集的第二组查询。然后基于第二组查询发送通知。

6. 发明申请

US20100036831A1 GENERATING CONTINUOUS QUERY NOTIFICATIONS 有权
标题翻译：生成连续查询通知
公开(公告)号：US20100036831A1
公开(公告)日：2010-02-11
申请号：US12189078
申请日：2008-08-08
申请人： Srinivas S. Vemuri , Bipul Sinha , Amit Ganesh , Subramanyam B. Chitti
发明人： Srinivas S. Vemuri , Bipul Sinha , Amit Ganesh , Subramanyam B. Chitti
IPC分类号： G06F17/30
CPC分类号： G06F17/30516
摘要： Techniques are described to allow a query to be registered as a persistent stored entity within the database, and to generate notifications as and when the query result changes continuously as long as the query continues to be registered with the database. According to one aspect, for a table referenced in a query, a filter condition is generated based, at least in part, on a predicate of the query. Then, the database server determines whether the filter condition is satisfied by either a before image of a row, or an after image of the row, that was modified by a transaction. If the filter condition is satisfied by either the before image or the after image, then the query is added to a first set of queries whose result sets may have been affected by the transaction. From among the first set of queries, a second set of queries that have result sets that were actually affected by the transaction is determined. Notifications are then sent based on the second set of queries.
摘要翻译：描述技术来允许将查询注册为数据库内的持久存储实体，并且只要查询继续向数据库注册，就可以随着查询结果不断更改而生成通知。根据一个方面，对于在查询中引用的表，基于至少部分地基于查询的谓词生成过滤条件。然后，数据库服务器通过由事务修改的行的先前图像或行的后续图像来确定滤波器条件是否满足。如果过滤条件由前图像或后图像所满足，则将查询添加到其结果集可能受事务影响的第一组查询中。从第一组查询中，确定具有实际受事务影响的结果集的第二组查询。然后基于第二组查询发送通知。

7. 发明授权

US06957236B1 Providing a useable version of a data item 有权
标题翻译：提供数据项的可用版本
公开(公告)号：US06957236B1
公开(公告)日：2005-10-18
申请号：US10263493
申请日：2002-10-02
申请人： Amit Ganesh , Srinivas S. Vemuri , Roger J. Bamford
发明人： Amit Ganesh , Srinivas S. Vemuri , Roger J. Bamford
IPC分类号： G06F12/00 , G06F9/46 , G06F17/30
CPC分类号： G06F9/466 , G06F17/30362 , Y10S707/99955
摘要： Techniques are provided for providing a data item to a transaction in a multi-versioning system in which the data item may exist on multiple versions of a data block, and were versioning is performed at the granularity of the data block. According to one aspect of the invention, the technique involves locating, within volatile memory, a first version of a data block that includes a first version of the data item. It is then determined whether the first version of the data item is useable by the transaction without respect to whether the first version of the data block is generally useable by the transaction. If the first version of the data item is usable by the transaction, then the data item is established as a candidate that can be provided to the transaction. Thus, the data item within a block may be considered a candidate to be provided to a transaction even when the version of the data block on which the data item resides would otherwise disqualify the data block from being seen by that transaction. If the first version of the data item is not usable by the transaction, then a version of the data item that is usable by the transaction is obtained from a second version of the data block that is different from the first version.
摘要翻译：提供了用于向多版本系统中的事务提供数据项的技术，其中数据项可以存在于数据块的多个版本上，并且以数据块的粒度执行版本控制。根据本发明的一个方面，该技术涉及在易失性存储器内定位包括数据项的第一版本的数据块的第一版本。然后确定该事务的第一版本的数据项是否可用，而不考虑该数据块的第一版本是否通常可被该事务使用。如果数据项的第一个版本可以由事务使用，则数据项被建立为可以提供给事务的候选。因此，即使当数据项所驻留的数据块的版本否则将使数据块被该事务看不到资格时，块内的数据项也可以被认为是被提供给事务的候选者。如果数据项的第一版本不能被事务使用，则可以从与第一版本不同的数据块的第二版本获得事务可使用的数据项的版本。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式