Database management system with efficient version control
    2.
    发明申请
    Database management system with efficient version control 有权
    数据库管理系统具有高效的版本控制

    公开(公告)号:US20050033720A1

    公开(公告)日:2005-02-10

    申请号:US10636361

    申请日:2003-08-06

    IPC分类号: G06F9/46 G06F17/30 G06F7/00

    摘要: A two copy versioning scheme is proposed. The scheme provides efficient implementation for a high read load database and eliminates read dependencies. The versioning scheme provides efficient implementation for transactions executing under ANSI READ COMMITTED isolation, and is extensible to serializable isolation. The two-copy versioning scheme is garbage free meaning that all versions of data records are used during execution and is adapted to index scanning operations. A “deferred delete” scheme allows read transactions to complete data deallocation operations. Statements that require “snapshots” are efficiently supported.

    摘要翻译: 提出了一种双重版本控制方案。 该方案为高读取数据库提供了有效的实现,并消除了读取依赖关系。 版本控制方案为在ANSI READ COMMITTED隔离下执行的事务提供了有效的实现,并且可扩展到可序列化隔离。 双副本版本控制方案是无意义的,意味着在执行期间使用所有版本的数据记录,并适应于索引扫描操作。 “延迟删除”方案允许读取事务完成数据解除分配操作。 有效地支持需要“快照”的语句。

    Database management system with efficient version control
    3.
    发明授权
    Database management system with efficient version control 有权
    数据库管理系统具有高效的版本控制

    公开(公告)号:US07243088B2

    公开(公告)日:2007-07-10

    申请号:US10636361

    申请日:2003-08-06

    IPC分类号: G06F11/00 G06F17/30

    摘要: A two copy versioning scheme is proposed. The scheme provides efficient implementation for a high read load database and eliminates read dependencies. The versioning scheme provides efficient implementation for transactions executing under ANSI READ COMMITTED isolation, and is extensible to serializable isolation. The two-copy versioning scheme is garbage free meaning that all versions of data records are used during execution and is adapted to index scanning operations. A “deferred delete” scheme allows read transactions to complete data deallocation operations. Statements that require “snapshots” are efficiently supported.

    摘要翻译: 提出了一种双重版本控制方案。 该方案为高读取数据库提供了有效的实现,并消除了读取依赖关系。 版本控制方案为在ANSI READ COMMITTED隔离下执行的事务提供了有效的实现,并且可扩展到可序列化隔离。 双副本版本控制方案是无意义的,意味着在执行期间使用所有版本的数据记录,并适应于索引扫描操作。 “延迟删除”方案允许读取事务完成数据解除分配操作。 有效地支持需要“快照”的语句。

    DATABASE MANAGEMENT SYSTEM WITH EFFICIENT VERSION CONTROL
    4.
    发明申请
    DATABASE MANAGEMENT SYSTEM WITH EFFICIENT VERSION CONTROL 有权
    具有有效版本控制的数据库管理系统

    公开(公告)号:US20070233683A1

    公开(公告)日:2007-10-04

    申请号:US11757224

    申请日:2007-06-01

    IPC分类号: G06F17/30

    摘要: A two copy versioning scheme is proposed. The scheme provides efficient implementation for a high read load database and eliminates read dependencies. The versioning scheme provides efficient implementation for transactions executing under ANSI READ COMMITTED isolation, and is extensible to serializable isolation. The two-copy versioning scheme is garbage free meaning that all versions of data records are used during execution and is adapted to index scanning operations. A “deferred delete” scheme allows read transactions to complete data deallocation operations. Statements that require “snapshots” are efficiently supported.

    摘要翻译: 提出了一种双重版本控制方案。 该方案为高读取数据库提供了有效的实现,并消除了读取依赖关系。 版本控制方案为在ANSI READ COMMITTED隔离下执行的事务提供了有效的实现,并且可扩展到可序列化隔离。 双副本版本控制方案是无意义的,意味着在执行期间使用所有版本的数据记录,并适应于索引扫描操作。 “延迟删除”方案允许读取事务完成数据解除分配操作。 有效地支持需要“快照”的语句。

    Database management system with efficient version control
    6.
    发明授权
    Database management system with efficient version control 有权
    数据库管理系统具有高效的版本控制

    公开(公告)号:US08010497B2

    公开(公告)日:2011-08-30

    申请号:US11757224

    申请日:2007-06-01

    IPC分类号: G06F7/00

    摘要: A two copy versioning scheme is proposed. The scheme provides efficient implementation for a high read load database and eliminates read dependencies. The versioning scheme provides efficient implementation for transactions executing under ANSI READ COMMITTED isolation, and is extensible to serializable isolation. The two-copy versioning scheme is garbage free meaning that all versions of data records are used during execution and is adapted to index scanning operations. A “deferred delete” scheme allows read transactions to complete data deallocation operations. Statements that require “snapshots” are efficiently supported.

    摘要翻译: 提出了一种双重版本控制方案。 该方案为高读取数据库提供了有效的实现,并消除了读取依赖关系。 版本控制方案为在ANSI READ COMMITTED隔离下执行的事务提供了有效的实现,并且可扩展到可序列化隔离。 双副本版本控制方案是无意义的,意味着在执行期间使用所有版本的数据记录,并适应于索引扫描操作。 “延迟删除”方案允许读取事务完成数据解除分配操作。 有效地支持需要“快照”的语句。

    Method and apparatus for increasing transaction concurrency by early release of locks in groups
    8.
    发明授权
    Method and apparatus for increasing transaction concurrency by early release of locks in groups 有权
    通过提前发布锁组来增加事务并发性的方法和装置

    公开(公告)号:US07555481B1

    公开(公告)日:2009-06-30

    申请号:US10696416

    申请日:2003-10-28

    IPC分类号: G06F17/30

    摘要: Activity Duration Locking (ADL) provides an efficient simple solution to manage a potentially large number of concurrently active lock groups. The ADL scheme allows a transaction fine control over creation of lock groups and classification of locks into lock groups enabling faster releasing of locks in groups. The life time that the lock group is active defines a new lock duration. This allows a large number of lock durations to be defined with the creation of each new lock group and any number of lock durations can be active for a given transaction. A very general concept of lock duration is supported without using any a priori semantics to individual lock durations and the duration of a lock group may be determined by the transaction as desired.

    摘要翻译: 活动持续时间锁定(ADL)提供了一个有效的简单解决方案来管理潜在的大量并发活动锁组。 ADL方案允许事务精确控制锁组的创建和锁分类到锁组,从而能够更快地释放组中的锁。 锁组活动的使用寿命定义了新的锁定持续时间。 这允许通过创建每个新的锁组来定义大量锁定持续时间,并且对于给定的事务可以激活任何数量的锁定持续时间。 支持锁定持续时间的非常一般的概念,而不使用任何先验语义到单个锁定持续时间,并且锁定组的持续时间可以根据需要由事务来确定。