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

1. 发明授权

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.
摘要翻译：用于识别在数据库系统中修改或创建对象的一个或多个事务的方法和机制。还公开了一种补偿数据库系统中的事务的影响的方法和机制。所公开的方法可以应用于对数据库系统中的变更和/或交易执行审计，并且用于识别由系统中的交易进行的变更和数据访问的范围。

2. 发明授权

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.
摘要翻译：用于识别在数据库系统中修改或创建对象的一个或多个事务的方法和机制。还公开了一种补偿数据库系统中的事务的影响的方法和机制。所公开的方法可以应用于对数据库系统中的变更和/或交易执行审计，并且用于识别由系统中的交易进行的变更和数据访问的范围。

3. 发明授权

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.
摘要翻译：公开了一种补偿数据库系统中事务的影响的方法和机制。还公开了一种用于识别在数据库系统中修改或创建对象的一个或多个事务的方法和机制。所公开的方法可以应用于对数据库系统中的查询执行审计，并且用于识别由系统中的事务进行的更改和数据访问的范围。

4. 发明授权

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用于标识需要过去版本的数据。还公开了当给予钥匙时确定一个或多个生命间隔的过程。

5. 发明授权

US6105025A Method for using an index as a workspace for deferred enforcement of uniqueness constraints 失效
标题翻译：使用索引作为工作空间来延缓执行唯一性约束的方法
公开(公告)号：US6105025A
公开(公告)日：2000-08-15
申请号：US612562
申请日：1996-03-08
申请人： Kenneth R. Jacobs , Robert J. Jenkins
发明人： Kenneth R. Jacobs , Robert J. Jenkins
IPC分类号： G06F17/30
CPC分类号： G06F17/30327 , Y10S707/99933 , Y10S707/99934 , Y10S707/99938 , Y10S707/99952
摘要： The present invention provides a uniqueness-required index and a corresponding non-uniqueness count to support deferred uniqueness constraint enforcement. A uniqueness-required index stores duplicate occurrences of indexed data values that occur during statement or transaction processing. The non-uniqueness count associated with the uniqueness-required index provides a count of the number of indexed data values that occur more than once in the index. Where a non-uniqueness count is not equal to zero, a uniqueness constraint violation remains unresolved. Where an unresolved constraint violation exists at enforcement time, the effects of the processing are removed. A currently non-unique count can be used to represent the number of uniqueness-required indexes that are "currently non-unique". The currently non-unique count can be examined to determine whether there are any unresolved uniqueness constraint violations. Constraints can be enforced at the end of the processing of a statement, a transaction, or within a transaction at a savepoint.
摘要翻译：本发明提供了唯一性要求的索引和相应的非唯一性计数以支持延迟的唯一性约束执行。唯一性要求的索引存储在语句或事务处理期间发生的索引数据值的重复出现。与唯一性要求索引相关联的非唯一性计数提供了索引中多次发生的索引数据值的数量的计数。在非唯一性计数不等于零的情况下，唯一性约束违规仍未得到解决。在执行时间存在未解决的约束违规的情况下，处理的影响被删除。当前不唯一的计数可用于表示“当前不唯一”的唯一性要求索引的数量。可以检查当前不唯一的计数，以确定是否存在任何未解决的唯一性约束违规。约束可以在处理语句，事务或在保存点的事务中结束时执行。

6. 发明授权

US6047285A Method for using an index as a workspace for deferred enforcement of uniqueness constraints 失效
公开(公告)号：US6047285A
公开(公告)日：2000-04-04
申请号：US56392
申请日：1998-04-06
申请人： Kenneth R. Jacobs , Robert J. Jenkins
发明人： Kenneth R. Jacobs , Robert J. Jenkins
IPC分类号： G06F17/30
CPC分类号： G06F17/30327 , Y10S707/99933 , Y10S707/99934 , Y10S707/99938 , Y10S707/99952
摘要： The present invention provides a uniqueness-required index and a corresponding non-uniqueness count to support deferred uniqueness constraint enforcement. A uniqueness-required index stores duplicate occurrences of indexed data values that occur during statement or transaction processing. The non-uniqueness count associated with the uniqueness-required index provides a count of the number of indexed data values that occur more than once in the index. Where a non-uniqueness count is not equal to zero, a uniqueness constraint violation remains unresolved. Where an unresolved constraint violation exists at enforcement time, the effects of the processing are removed. A currently non-unique count can be used to represent the number of uniqueness-required indexes that are "currently non-unique". The currently non-unique count can be examined to determine whether there are any unresolved uniqueness constraint violations. Constraints can be enforced at the end of the processing of a statement, a transaction, or within a transaction at a savepoint.

7. 发明授权

US5870758A Method and apparatus for providing isolation levels in a database system 失效
标题翻译：在数据库系统中提供隔离级别的方法和装置
公开(公告)号：US5870758A
公开(公告)日：1999-02-09
申请号：US613026
申请日：1996-03-11
申请人： Roger J. Bamford , Kenneth R. Jacobs
发明人： Roger J. Bamford , Kenneth R. Jacobs
IPC分类号： G06F17/30 , G06F17/40
CPC分类号： G06F17/30362 , Y10S707/99938 , Y10S707/99952 , Y10S707/99953
摘要： A method and system for providing isolation levels in a database system is provided. A serializable isolation level is provided by causing all statements in a transaction to see a "snapshot" of the database. A snapshot includes only those changes made to the database by a particular set of transactions. For example, the snapshot for a given transaction may include only the changes made by transactions that committed prior to the execution of the given transaction. The set of all transactions whose changes are included in a particular snapshot of the database is referred to as the snapshot set. Concurrently executing transactions may update the database while a serializable transaction is being executed. Updates that are not included in the snapshot of the serializable transaction are undone prior to processing each statement in the serializable transaction to recreate the data as it existed in the snapshot. If a serializable transaction attempts to update data that was updated by a transaction that is not in the snapshot set of the serializable transaction, then the serializable transaction is rolled back. A read committed isolation level is provided by establishing a different snapshot for each statement in a transaction.
摘要翻译：提供了一种用于在数据库系统中提供隔离级别的方法和系统。通过使事务中的所有语句都可以看到数据库的“快照”来提供可序列化的隔离级别。快照仅包含由特定事务集合对数据库所做的更改。例如，给定事务的快照可能仅包括在执行给定事务之前提交的事务所做的更改。更改包含在数据库的特定快照中的所有事务的集合称为快照集。同时执行的事务可能在执行可序列化事务时更新数据库。不包括在可序列化事务的快照中的更新在处理可序列化事务中的每个语句之前将被撤销，以重新创建快照中存在的数据。如果可序列化事务尝试更新由可序列化事务的快照集中的事务更新的数据，则可序列化事务将回滚。通过为事务中的每个语句建立不同的快照来提供读提交的隔离级别。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式