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

1. 发明授权

US07941408B2 System, structure, interface, and semantics for implementing row versions: accessing past versions of a data item 有权
标题翻译：用于实现行版本的系统，结构，接口和语义：访问数据项的过去版本
公开(公告)号：US07941408B2
公开(公告)日：2011-05-10
申请号：US10934079
申请日：2004-09-03
申请人： Bipul Sinha , Vivekanandhan Raja , Amit Ganesh , Kenneth R. Jacobs
发明人： Bipul Sinha , Vivekanandhan Raja , Amit Ganesh , Kenneth R. Jacobs
IPC分类号： G06F7/00 , G06F17/00
CPC分类号： G06F17/30309
摘要： Disclosed is a mechanism, system, interface, and process to allow specification of a new table decoration clause to obtain one or more past version of one or more data items. The version query provides for a direct interface to get multiple versions of the row(s). In addition, information about the past versions can be retrieved and displayed along with the past versions. Also disclosed are algorithms, mechanisms, and processes that are employed to implement a query upon past versions. In one approach, the version query can be defined as either “rowid”-based access or non-rowid based access. With rowid based access, a given rowid is used to identify the data for which past versions are desired. Also disclosed is a process for determining one or more life intervals when given a key.
摘要翻译：公开了允许指定新的表装饰子句以获得一个或多个数据项的一个或多个过去版本的机制，系统，接口和过程。版本查询提供了一个直接接口来获取多个版本的行。此外，可以检索和显示过去版本的信息以及过去的版本。还公开了用于在过去版本上实现查询的算法，机制和过程。在一种方法中，版本查询可以被定义为基于“rowid”的访问或基于非rowid的访问。使用基于rowid的访问，给定的rowid用于标识需要过去版本的数据。还公开了当给予钥匙时确定一个或多个生命间隔的过程。

2. 发明授权

US09400812B2 Method and mechanism for determining life intervals for a key in an index 有权
标题翻译：确定索引中键的生命周期的方法和机制
公开(公告)号：US09400812B2
公开(公告)日：2016-07-26
申请号：US13209224
申请日：2011-08-12
申请人： Bipul Sinha , Vivekanandhan Raja , Amit Ganesh
发明人： Bipul Sinha , Vivekanandhan Raja , Amit Ganesh
IPC分类号： G06F7/00 , G06F17/00 , G06F17/30
CPC分类号： G06F17/30309
摘要： Disclosed is a mechanism, system, interface, and process to determine one or more life intervals when given a key. In addition, one or more life intervals can be determined for each key within a range of keys. This type of process is useful for auditing purposes or if it is desire to implement a query upon past versions when a key or range of keys is specified for the data for which past versions is desired. This facilitates algorithms, mechanisms, and processes to implement a query upon past versions.
摘要翻译：公开了一种在给予键时确定一个或多个生命周期的机制，系统，界面和过程。另外，可以在一系列键内为每个键确定一个或多个生命周期。这种类型的过程对于审计目的是有用的，或者如果希望在为期望的过去版本的数据指定密钥或密钥范围时希望在过去的版本上实现查询。这有助于算法，机制和过程来实现过去版本的查询。

3. 发明申请

US20050120064A1 Method and mechanism for determining life intervals for a key in an index 有权
标题翻译：确定索引中键的生命周期的方法和机制
公开(公告)号：US20050120064A1
公开(公告)日：2005-06-02
申请号：US10933828
申请日：2004-09-03
申请人： Bipul Sinha , Vivekanandhan Raja , Amit Ganesh
发明人： Bipul Sinha , Vivekanandhan Raja , Amit Ganesh
IPC分类号： G06F7/00 , G06F17/30
CPC分类号： G06F17/30309
摘要： Disclosed is a mechanism, system, interface, and process to determine one or more life intervals when given a key. In addition, one or more life intervals can be determined for each key within a range of keys. This type of process is useful for auditing purposes or if it is desire to implement a query upon past versions when a key or range of keys is specified for the data for which past versions is desired. This facilitates algorithms, mechanisms, and processes to implement a query upon past versions.
摘要翻译：公开了一种在给予键时确定一个或多个生命周期的机制，系统，界面和过程。另外，可以在一系列键内为每个键确定一个或多个生命周期。这种类型的过程对于审计目的是有用的，或者如果希望在为期望的过去版本的数据指定密钥或密钥范围时希望在过去的版本上实现查询。这有助于算法，机制和过程来实现过去版本的查询。

4. 发明授权

US08015161B2 Method and mechanism for determining life intervals for a key in an index 有权
标题翻译：确定索引中键的生命周期的方法和机制
公开(公告)号：US08015161B2
公开(公告)日：2011-09-06
申请号：US10933828
申请日：2004-09-03
申请人： Bipul Sinha , Vivekanandhan Raja , Amit Ganesh
发明人： Bipul Sinha , Vivekanandhan Raja , Amit Ganesh
IPC分类号： G06F7/00 , G06F17/00
CPC分类号： G06F17/30309
摘要： Disclosed is a mechanism, system, interface, and process to determine one or more life intervals when given a key. In addition, one or more life intervals can be determined for each key within a range of keys. This type of process is useful for auditing purposes or if it is desire to implement a query upon past versions when a key or range of keys is specified for the data for which past versions is desired. This facilitates algorithms, mechanisms, and processes to implement a query upon past versions.
摘要翻译：公开了一种当给予钥匙时确定一个或多个生命周期的机制，系统，界面和过程。另外，可以在一系列键内为每个键确定一个或多个生命周期。这种类型的过程对于审计目的是有用的，或者如果希望在为期望的过去版本的数据指定密钥或密钥范围时希望在过去的版本上实现查询。这有助于算法，机制和过程来实现过去版本的查询。

5. 发明授权

US08032496B2 Method and mechanism for row versioning 有权
标题翻译：行版本化的方法和机制
公开(公告)号：US08032496B2
公开(公告)日：2011-10-04
申请号：US10933832
申请日：2004-09-03
申请人： Bipul Sinha , Vivekanandhan Raja , Amit Ganesh
发明人： Bipul Sinha , Vivekanandhan Raja , Amit Ganesh
IPC分类号： G06F7/00 , G06F17/00
CPC分类号： G06F17/30309
摘要： Disclosed are algorithms, mechanisms, processes, mechanisms, and systems to implement a query upon past versions. In one approach, the version query can be defined as either “rowid”-based access or non-rowid based access. With rowid based access, a given rowid is used to identify the data for which past versions are desired. Also disclosed is a mechanism, system, interface, and process to allow specification of a new table decoration clause to obtain one or more past version of one or more data items. The version query provides for a direct interface to get multiple versions of the row(s). In addition, information about the past versions can be retrieved and displayed along with the past versions.
摘要翻译：公开了在过去版本上实现查询的算法，机制，过程，机制和系统。在一种方法中，版本查询可以被定义为基于“rowid”的访问或基于非rowid的访问。使用基于rowid的访问，给定的rowid用于标识需要过去版本的数据。还公开了允许指定新的表装饰子句以获得一个或多个数据项的一个或多个过去版本的机制，系统，接口和过程。版本查询提供了一个直接接口来获取多个版本的行。此外，可以检索和显示过去版本的信息以及过去的版本。

6. 发明申请

US20080243865A1 Maintaining global state of distributed transaction managed by an external transaction manager for clustered database systems 审中-公开
标题翻译：维护由集群数据库系统的外部事务管理器管理的分布式事务的全局状态
公开(公告)号：US20080243865A1
公开(公告)日：2008-10-02
申请号：US11729473
申请日：2007-03-28
申请人： Yong Hu , Bipul Sinha , Amit Ganesh , Juan Loaiza , Vivekanandhan Raja
发明人： Yong Hu , Bipul Sinha , Amit Ganesh , Juan Loaiza , Vivekanandhan Raja
IPC分类号： G06F17/30
CPC分类号： G06F16/27
摘要： In accordance with an embodiment of the present invention, a transaction tracking mechanism is provided by a database server cluster to keep track of a global state of a distributed transaction. The global state of the distributed transaction comprises one or more statuses that are associated with one or more transaction branches that are part of the distributed transaction. The global state may be associated with a global lock. Through using the global state in association with the global lock, problems such as partial commits, data inconsistency, access contentions and deadlocks may be avoided when the database server cluster processes the distributed transaction.
摘要翻译：根据本发明的实施例，由数据库服务器集群提供事务跟踪机制以跟踪分布式事务的全局状态。分布式事务的全局状态包括与作为分布式事务的一部分的一个或多个事务分支相关联的一个或多个状态。全局状态可能与全局锁相关联。通过使用与全局锁相关联的全局状态，当数据库服务器集群处理分布式事务时，可能会避免诸如部分提交，数据不一致，访问争用和死锁等问题。

7. 发明申请

US20050114409A1 Method and mechanism for row versioning 有权
标题翻译：行版本化的方法和机制
公开(公告)号：US20050114409A1
公开(公告)日：2005-05-26
申请号：US10933832
申请日：2004-09-03
申请人： Bipul Sinha , Vivekanandhan Raja , Amit Ganesh
发明人： Bipul Sinha , Vivekanandhan Raja , Amit Ganesh
IPC分类号： G06F7/00 , G06F17/30
CPC分类号： G06F17/30309
摘要： Disclosed are algorithms, mechanisms, processes, mechanisms, and systems to implement a query upon past versions. In one approach, the version query can be defined as either “rowid”-based access or non-rowid based access. With rowid based access, a given rowid is used to identify the data for which past versions are desired. Also disclosed is a mechanism, system, interface, and process to allow specification of a new table decoration clause to obtain one or more past version of one or more data items. The version query provides for a direct interface to get multiple versions of the row(s). In addition, information about the past versions can be retrieved and displayed along with the past versions.
摘要翻译：公开了在过去版本上实现查询的算法，机制，过程，机制和系统。在一种方法中，版本查询可以被定义为基于“rowid”的访问或基于非rowid的访问。使用基于rowid的访问，给定的rowid用于标识需要过去版本的数据。还公开了允许指定新的表装饰子句以获得一个或多个数据项的一个或多个过去版本的机制，系统，接口和过程。版本查询提供了一个直接接口来获取多个版本的行。此外，可以检索和显示过去版本的信息以及过去的版本。

8. 发明申请

US20060149791A1 Database-driven distributed recovery 审中-公开
标题翻译：数据库驱动的分布式恢复
公开(公告)号：US20060149791A1
公开(公告)日：2006-07-06
申请号：US11031275
申请日：2005-01-06
申请人： Bipul Sinha , Amit Ganesh , Vivekanandhan Raja
发明人： Bipul Sinha , Amit Ganesh , Vivekanandhan Raja
IPC分类号： G06F17/30
CPC分类号： G06F9/466 , G06F16/2365
摘要： A method and apparatus for database-driven distributed recovery is provided. According to one aspect, a transaction manager sends, to one or more resource managers, connection information that indicates how to connect to the transaction manager. A resource manager that receives the connection information establishes an association between the connection information and the distributed transaction for which the connection information was received. If the resource manager is ever in doubt concerning whether the distributed transaction should be committed, the resource manager uses the associated connection information to send, to the transaction manager, a request for status information. The transaction manager maintains status information that indicates whether the distributed transaction should be committed, and responds to the resource manager with the requested status information. The resource manager receives the status information and, based on the status information, either commits or rolls back its portion of the distributed transaction.
摘要翻译：提供了一种用于数据库驱动的分布式恢复的方法和装置。根据一个方面，事务管理器向一个或多个资源管理器发送指示如何连接到事务管理器的连接信息。接收连接信息的资源管理器建立连接信息和接收到连接信息的分布式事务之间的关联。如果资源管理器对于是否应该提交分布式事务是有疑问的，则资源管理器使用关联的连接信息向事务管理器发送状态信息请求。事务管理器维护状态信息，指示是否应该提交分布式事务，并使用所请求的状态信息来响应资源管理器。资源管理器接收状态信息，并根据状态信息提交或回滚其分布式事务的部分。

9. 发明申请

US20050120062A1 System, structure, interface, and semantics for implementing row versions: accessing past versions of a data item 有权
标题翻译：用于实现行版本的系统，结构，接口和语义：访问数据项的过去版本
公开(公告)号：US20050120062A1
公开(公告)日：2005-06-02
申请号：US10934079
申请日：2004-09-03
申请人： Bipul Sinha , Vivekanandhan Raja , Amit Ganesh , Kenneth Jacobs
发明人： Bipul Sinha , Vivekanandhan Raja , Amit Ganesh , Kenneth Jacobs
IPC分类号： G06F7/00 , G06F17/30
CPC分类号： G06F17/30309
摘要： Disclosed is a mechanism, system, interface, and process to allow specification of a new table decoration clause to obtain one or more past version of one or more data items. The version query provides for a direct interface to get multiple versions of the row(s). In addition, information about the past versions can be retrieved and displayed along with the past versions. Also disclosed are algorithms, mechanisms, and processes that are employed to implement a query upon past versions. In one approach, the version query can be defined as either “rowid”-based access or non-rowid based access. With rowid based access, a given rowid is used to identify the data for which past versions are desired. Also disclosed is a process for determining one or more life intervals when given a key.
摘要翻译：公开了允许指定新的表装饰子句以获得一个或多个数据项的一个或多个过去版本的机制，系统，接口和过程。版本查询提供了一个直接接口来获取多个版本的行。此外，可以检索和显示过去版本的信息以及过去的版本。还公开了用于在过去版本上实现查询的算法，机制和过程。在一种方法中，版本查询可以被定义为基于“rowid”的访问或基于非rowid的访问。使用基于rowid的访问，给定的rowid用于标识需要过去版本的数据。还公开了当给予钥匙时确定一个或多个生命间隔的过程。

10. 发明授权

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.
摘要翻译：提供了用于选择性地去除用户数据变化的方法和装置。在一个实施例中，该方法由逻辑恢复机制来实现。在接收到选择性地删除存储在数据库中的用户数据改变的请求时，该机制创建要填充的空的一组事务以进行选择性删除，识别一个或多个事务并将它们放置在因果集合中。该机制进一步识别逻辑上依赖于因果交易集合中的任何交易的其他交易。最后，既然确定了交易的因果集合，或者在识别完成之后，该机制还确定了因果集交易所做的用户数据更改。一个或多个补偿事务可以由逻辑恢复机制产生，逻辑恢复机制在执行时反转用户数据改变。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式