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

11. 发明授权

US08650169B1 Method and mechanism for identifying transaction on a row of data 有权
标题翻译：用于识别一行数据上的事务的方法和机制
公开(公告)号：US08650169B1
公开(公告)日：2014-02-11
申请号：US10364209
申请日：2003-02-10
申请人： Kenneth R. Jacobs , Amit Ganesh , Jonathan Klein , Archna Kalra Johnson , Vivekanandhan Raja
发明人： Kenneth R. Jacobs , Amit Ganesh , Jonathan Klein , Archna Kalra Johnson , Vivekanandhan Raja
IPC分类号： G06F7/00
CPC分类号： G06F17/30551 , Y10S707/99938 , Y10S707/99952 , Y10S707/99953
摘要： A method and mechanism for identifying one or more transactions that have modified or created an object in a database system. Also disclosed is a method and mechanism to compensate for the effects of a transaction in a database system is disclosed. The disclosed approach can be applied to perform auditing for changes and/or transactions in a database system and for identifying the scope of changes and data accesses made by a transaction in the system.
摘要翻译：用于识别在数据库系统中修改或创建对象的一个或多个事务的方法和机制。还公开了一种补偿数据库系统中的事务的影响的方法和机制。所公开的方法可以应用于对数据库系统中的变更和/或交易执行审计，并且用于识别由系统中的交易进行的变更和数据访问的范围。

12. 发明授权

US07937368B2 Method and mechanism for identifying transaction on a row of data 有权
标题翻译：用于识别一行数据上的事务的方法和机制
公开(公告)号：US07937368B2
公开(公告)日：2011-05-03
申请号：US11436263
申请日：2006-05-17
申请人： Kenneth R. Jacobs , Amit Ganesh , Jonathan Klein , Archna Kalra Johnson , Vivekanandhan Raja
发明人： Kenneth R. Jacobs , Amit Ganesh , Jonathan Klein , Archna Kalra Johnson , Vivekanandhan Raja
IPC分类号： G06F17/00
CPC分类号： G06F17/30551 , Y10S707/99938 , Y10S707/99952 , Y10S707/99953
摘要： A method and mechanism for identifying one or more transactions that have modified or created an object in a database system. Also disclosed is a method and mechanism to compensate for the effects of a transaction in a database system is disclosed. The disclosed approach can be applied to perform auditing for changes and/or transactions in a database system and for identifying the scope of changes and data accesses made by a transaction in the system.
摘要翻译：用于识别在数据库系统中修改或创建对象的一个或多个事务的方法和机制。还公开了一种补偿数据库系统中的事务的影响的方法和机制。所公开的方法可以应用于对数据库系统中的变更和/或交易执行审计，并且用于识别由系统中的交易进行的变更和数据访问的范围。

13. 发明申请

US20060212492A1 Method and mechanism for identifying transaction on a row of data 有权
标题翻译：用于识别一行数据上的事务的方法和机制
公开(公告)号：US20060212492A1
公开(公告)日：2006-09-21
申请号：US11436263
申请日：2006-05-17
申请人： Kenneth Jacobs , Amit Ganesh , Jonathan Klein , Archna Johnson , Vivekanandhan Raja
发明人： Kenneth Jacobs , Amit Ganesh , Jonathan Klein , Archna Johnson , Vivekanandhan Raja
IPC分类号： G06F17/30
CPC分类号： G06F17/30551 , Y10S707/99938 , Y10S707/99952 , Y10S707/99953
摘要： A method and mechanism for identifying one or more transactions that have modified or created an object in a database system. Also disclosed is a method and mechanism to compensate for the effects of a transaction in a database system is disclosed. The disclosed approach can be applied to perform auditing for changes and/or transactions in a database system and for identifying the scope of changes and data accesses made by a transaction in the system.
摘要翻译：用于识别在数据库系统中修改或创建对象的一个或多个事务的方法和机制。还公开了一种补偿数据库系统中的事务的影响的方法和机制。所公开的方法可以应用于对数据库系统中的变更和/或交易执行审计，并且用于识别由系统中的交易进行的变更和数据访问的范围。

14. 发明授权

US07277900B1 Method and mechanism for rolling back a transaction on a row of data 有权
标题翻译：在一行数据上回滚事务的方法和机制
公开(公告)号：US07277900B1
公开(公告)日：2007-10-02
申请号：US10364065
申请日：2003-02-10
申请人： Amit Ganesh , Kenneth R. Jacobs , Jonathan Klein , Archna Kalra Johnson , Vivekanandhan Raja
发明人： Amit Ganesh , Kenneth R. Jacobs , Jonathan Klein , Archna Kalra Johnson , Vivekanandhan Raja
IPC分类号： G06F17/30
CPC分类号： G06F17/30551 , Y10S707/99938 , Y10S707/99952 , Y10S707/99953
摘要： A method and mechanism to compensate for the effects of a transaction in a database system is disclosed. Also disclosed is a method and mechanism for identifying one or more transactions that have modified or created an object in a database system. The disclosed approach can be applied to perform auditing for queries in a database system and for identifying the scope of changes and data accesses made by a transaction in the system.
摘要翻译：公开了一种补偿数据库系统中事务的影响的方法和机制。还公开了一种用于识别在数据库系统中修改或创建对象的一个或多个事务的方法和机制。所公开的方法可以应用于对数据库系统中的查询执行审计，并且用于识别由系统中的事务进行的更改和数据访问的范围。

15. 发明授权

US07873605B2 Apparatus to selectively remove the effects of transactions in online database and enable logical recovery 有权
标题翻译：用于选择性地消除在线数据库中事务的影响并启用逻辑恢复的装置
公开(公告)号：US07873605B2
公开(公告)日：2011-01-18
申请号：US11699689
申请日：2007-01-29
申请人： Manosiz Bhattacharyya , Bipul Sinha , Amit Ganesh
发明人： Manosiz Bhattacharyya , Bipul Sinha , Amit Ganesh
IPC分类号： G06F7/00 , G06F17/00
CPC分类号： G06F17/30377
摘要： A method and apparatus for selective removal of user data changes is provided. In one embodiment, the methodology is implemented by a logical recovery mechanism. Upon receiving a request to selectively remove user data changes stored in a database, the mechanism creates an empty set of transactions to be populated for selective removal, identifies one or more transactions and places them in the causal set of transactions. The mechanism further identifies other transactions that logically depend on any transaction already in the causal set of transactions. Finally, either while the causal set of transactions is being identified or after the identification is completed, the mechanism also determines user data changes made by the causal set of transactions. One or more compensating transactions may be generated by the logical recovery mechanism, which when executed, reverse the user data changes.
摘要翻译：提供了用于选择性地去除用户数据变化的方法和装置。在一个实施例中，该方法由逻辑恢复机制来实现。在接收到选择性地删除存储在数据库中的用户数据改变的请求时，该机制创建要填充的空的一组事务以进行选择性删除，识别一个或多个事务并将它们放置在因果集合中。该机制进一步识别逻辑上依赖于因果交易集合中的任何交易的其他交易。最后，既然确定了交易的因果集合，或者在识别完成之后，该机制还确定了因果集交易所做的用户数据更改。一个或多个补偿事务可以由逻辑恢复机制产生，逻辑恢复机制在执行时反转用户数据改变。

16. 发明申请

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的连接谓词。描述各种技术用于识别其中可以将查询包括在可能改变的查询集合中或从可能改变的查询集合中排除的情况，而不完全评估与查询相对应的过滤条件。

17. 发明授权

US06983286B1 Method and apparatus for accessing data as it existed at a previous point in time 有权
标题翻译：用于访问在先前时间点存在的数据的方法和装置
公开(公告)号：US06983286B1
公开(公告)日：2006-01-03
申请号：US10325211
申请日：2002-12-18
申请人： Bipul Sinha , Namit Jain , Amit Ganesh , Archna Kalra Johnson , Srinivas Vemuri
发明人： Bipul Sinha , Namit Jain , Amit Ganesh , Archna Kalra Johnson , Srinivas Vemuri
IPC分类号： G06F17/30
CPC分类号： G06F17/30551 , Y10S707/99943
摘要： Techniques are provided for sharing of flashback cursors by adding a time domain property to flashback cursors. This time domain property defines the range of flashback times for which the flashback cursor is valid. According to one embodiment, this “validity range” is closed at the lower bound and open at the upper bound. A subsequent flashback query can share an existing flashback cursor if the flashback time of the subsequent flashback query falls within the validity range of the existing flashback cursor. In one embodiment, the validity range of a flashback cursor is established based on times associated with indexes used to process the flashback query for which the flashback cursor was made. Consequently, an existing flashback cursor is less likely to be used by a subsequent flashback query when it would be inefficient to do so.
摘要翻译：提供了通过向闪回光标添加时域属性来共享闪回光标的技术。此时域属性定义闪回光标有效的闪回时间范围。根据一个实施例，该“有效范围”在下限处封闭并在上限处打开。如果后续闪回查询的闪回时间落在现有闪回游标的有效范围内，后续闪回查询可以共享现有闪回游标。在一个实施例中，闪回光标的有效范围基于与用于处理闪回光标的闪回查询的索引相关联的时间来建立。因此，当这样做的效率低下时，现有的闪回游标不太可能被随后的闪回查询使用。

18. 发明授权

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的连接谓词。描述各种技术用于识别其中可以将查询包括在可能改变的查询集合中或从可能改变的查询集合中排除的情况，而不完全评估与查询相对应的过滤条件。

19. 发明授权

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.
摘要翻译：描述技术来允许将查询注册为数据库内的持久存储实体，并且只要查询继续向数据库注册，就可以随着查询结果不断更改而生成通知。根据一个方面，对于在查询中引用的表，基于至少部分地基于查询的谓词生成过滤条件。然后，数据库服务器通过由事务修改的行的先前图像或行的后续图像来确定滤波器条件是否满足。如果过滤条件由前图像或后图像所满足，则将查询添加到其结果集可能受事务影响的第一组查询中。从第一组查询中，确定具有实际受事务影响的结果集的第二组查询。然后基于第二组查询发送通知。

20. 发明授权

US07752181B2 System and method for performing a data uniqueness check in a sorted data set 有权
标题翻译：用于在排序数据集中执行数据唯一性检查的系统和方法
公开(公告)号：US07752181B2
公开(公告)日：2010-07-06
申请号：US10984113
申请日：2004-11-08
申请人： Jonathan Klein , Bipul Sinha , Amit Ganesh
发明人： Jonathan Klein , Bipul Sinha , Amit Ganesh
IPC分类号： G06F17/30
CPC分类号： G06F17/30312 , G06F17/30371
摘要： Embodiments of the present invention include a method for performing a data uniqueness check in a set of sorted data blocks comprising accessing data to be inserted into the set of sorted data blocks, determining a proper data block of the set of sorted data blocks for which the data to be inserted should be located based on a first sorting key. The method further includes examining the proper data block for an existing data entry and if the proper data block is empty, the method further includes inserting the data to be inserted into the proper data block of the set of sorted data blocks.
摘要翻译：本发明的实施例包括一种用于在一组分类数据块中执行数据唯一性检查的方法，包括访问要插入到该排序数据块集合中的数据，确定该排序数据块集合中的适当数据块，应插入的数据应基于第一个排序键来定位。该方法还包括检查现有数据条目的正确数据块，如果正确的数据块为空，则该方法还包括将要插入的数据插入到该排序数据块集合的正确数据块中。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式