公开(公告)号：US08005792B2

公开(公告)日：2011-08-23

申请号：US11129717

申请日：2005-05-13

申请人： Russell John Green ,  Subhransu Basu ,  Shrikanth Shankar ,  Kumar Rajamani ,  Ho Chak Hung ,  Jaebock Lee

发明人： Russell John Green ,  Subhransu Basu ,  Shrikanth Shankar ,  Kumar Rajamani ,  Ho Chak Hung ,  Jaebock Lee

IPC分类号： G06F7/00

CPC分类号： G06F17/30356

摘要： Versioned metadata allows multiple versions of metadata for a given object to exist concurrently on a system thereby supporting the parallel execution of operations which would otherwise be mutually exclusive. Metadata updates are permitted while other objects maintain access to another version of the metadata through a versioning infrastructure. The versioning infrastructure allows the creation of new versions of metadata, maintains obsolete versions in the system as long as they are being used by any object, and deletes the obsolete versions once they are no longer in use.

摘要翻译： 版本化元数据允许给定对象的多个版本的元数据同时存在于系统上，从而支持并行执行否则将是相互排斥的操作。 允许元数据更新，而其他对象通过版本控制基础架构可以访问其他版本的元数据。 版本控制基础架构允许创建新的元数据版本，只要系统使用它们，就可以在系统中维护过时的版本，并在不再使用过时的版本后删除它们。

公开(公告)号：US07698310B2

公开(公告)日：2010-04-13

申请号：US11129617

申请日：2005-05-13

申请人： Subhransu Basu ,  Russell John Green ,  Shrikanth Shankar

发明人： Subhransu Basu ,  Russell John Green ,  Shrikanth Shankar

IPC分类号： G06F17/30

CPC分类号： G06F17/30902 ,  G06F21/6218 ,  G06F2221/2147 ,  Y10S707/99954

摘要： A system, method, computer program and article of manufacture for sharing metadata among cursors is provided. A metadata object marked as a versioned object can have multiple versions. Program units can share these versions of object metadata as opposed to copying the non-versioned object metadata into their memory. These program units may contain a pointer to an object's metadata but are otherwise void of the metadata information for the object. A locking protocol for the metadata ensures concurrency control and triggers dependency tracking. A locking protocol for the cursors controls cursor dependency status.

摘要翻译： 提供了一种用于在游标之间共享元数据的系统，方法，计算机程序和制品。 标记为版本化对象的元数据对象可以有多个版本。 程序单元可以共享对象元数据的这些版本，而不是将非版本化的对象元数据复制到其内存中。 这些程序单元可以包含指向对象的元数据的指针，但是否则该对象的元数据信息无效。 用于元数据的锁定协议确保并发控制并触发依赖关系跟踪。 光标的锁定协议控制游标依赖状态。

公开(公告)号：US20060004886A1

公开(公告)日：2006-01-05

申请号：US11129717

申请日：2005-05-13

申请人： Russell Green ,  Subhransu Basu ,  Shrikanth Shankar ,  Kuma Rajamani ,  Ho Hung ,  Jaebock Lee

发明人： Russell Green ,  Subhransu Basu ,  Shrikanth Shankar ,  Kuma Rajamani ,  Ho Hung ,  Jaebock Lee

IPC分类号： G06F12/00

CPC分类号： G06F17/30356

摘要： Versioned metadata allows multiple versions of metadata for a given object to exist concurrently on a system thereby supporting the parallel execution of operations which would otherwise be mutually exclusive. Metadata updates are permitted while other objects maintain access to another version of the metadata through a versioning infrastructure. The versioning infrastructure allows the creation of new versions of metadata, maintains obsolete versions in the system as long as they are being used by any object, and deletes the obsolete versions once they are no longer in use.

摘要翻译： 版本化元数据允许给定对象的多个版本的元数据同时存在于系统上，从而支持并行执行否则将是相互排斥的操作。 允许元数据更新，而其他对象通过版本控制基础架构可以访问其他版本的元数据。 版本控制基础架构允许创建新的元数据版本，只要系统使用它们，就可以在系统中维护过时的版本，并在不再使用过时的版本后删除它们。

公开(公告)号：US20080046454A1

公开(公告)日：2008-02-21

申请号：US11871529

申请日：2007-10-12

申请人： Subhransu Basu ,  Ananth Raghavan ,  Shrikanth Shankar ,  Vikram Shukla

发明人： Subhransu Basu ,  Ananth Raghavan ,  Shrikanth Shankar ,  Vikram Shukla

IPC分类号： G06F17/30

CPC分类号： G06F17/30587 ,  Y10S707/953 ,  Y10S707/972 ,  Y10S707/99932 ,  Y10S707/99942 ,  Y10S707/99943

摘要： The concept of portioning is expanded with a variety of techniques. In particular, one technique involves partitioning an object at multiple levels, where at least one of the levels uses list-based partitioning. Further, a partitioning technique is provided which involves storing a data item in a default partition when the item does not map to any one of the list-based partitions for which a key value group has been defined. Techniques are also provided for efficiently splitting a partition.

摘要翻译： 分割的概念用各种技术扩展。 特别地，一种技术涉及在多个级别上划分对象，其中至少一个级别使用基于列表的分区。 此外，提供了一种分割技术，其涉及当项目不映射到已经定义了键值组的基于列表的分区中的任何一个时，将数据项存储在默认分区中。 还提供了用于有效地分割分区的技术。

公开(公告)号：US07774379B2

公开(公告)日：2010-08-10

申请号：US11871529

申请日：2007-10-12

申请人： Subhransu Basu ,  Ananth Raghavan ,  Shrikanth Shankar ,  Vikram Shukla

发明人： Subhransu Basu ,  Ananth Raghavan ,  Shrikanth Shankar ,  Vikram Shukla

IPC分类号： G06F17/30

CPC分类号： G06F17/30587 ,  Y10S707/953 ,  Y10S707/972 ,  Y10S707/99932 ,  Y10S707/99942 ,  Y10S707/99943

摘要： The concept of portioning is expanded with a variety of techniques. In particular, one technique involves partitioning an object at multiple levels, where at least one of the levels uses list-based partitioning. Further, a partitioning technique is provided which involves storing a data item in a default partition when the item does not map to any one of the list-based partitions for which a key value group has been defined. Techniques are also provided for efficiently splitting a partition.

公开(公告)号：US07765246B2

公开(公告)日：2010-07-27

申请号：US11871520

申请日：2007-10-12

申请人： Subhransu Basu ,  Ananth Raghavan ,  Shrikanth Shankar ,  Vikram Shukla

发明人： Subhransu Basu ,  Ananth Raghavan ,  Shrikanth Shankar ,  Vikram Shukla

IPC分类号： G06F12/00 ,  G06F17/30 ,  G06F7/00 ,  G06F17/00 ,  G06F9/45

CPC分类号： G06F17/30587 ,  Y10S707/953 ,  Y10S707/972 ,  Y10S707/99932 ,  Y10S707/99942 ,  Y10S707/99943

摘要： The concept of portioning is expanded with a variety of techniques. In particular, one technique involves partitioning an object at multiple levels, where at least one of the levels uses list-based partitioning. Further, a partitioning technique is provided which involves storing a data item in a default partition when the item does not map to any one of the list-based partitions for which a key value group has been defined. Techniques are also provided for efficiently splitting a partition.

摘要翻译： 分割的概念用各种技术扩展。 特别地，一种技术涉及在多个级别上划分对象，其中至少一个级别使用基于列表的分区。 此外，提供了一种分割技术，其涉及当项目不映射到已经定义了键值组的基于列表的分区中的任何一个时，将数据项存储在默认分区中。 还提供了用于有效地分割分区的技术。

公开(公告)号：US07299239B1

公开(公告)日：2007-11-20

申请号：US10308787

申请日：2002-12-02

申请人： Subhransu Basu ,  Ananth Raghavan ,  Shrikanth Shankar ,  Vikram Shukla

发明人： Subhransu Basu ,  Ananth Raghavan ,  Shrikanth Shankar ,  Vikram Shukla

IPC分类号： G06F7/00 ,  G06F17/00 ,  G06F17/30

CPC分类号： G06F17/30587 ,  Y10S707/953 ,  Y10S707/972 ,  Y10S707/99932 ,  Y10S707/99942 ,  Y10S707/99943

摘要： The concept of partitioning is expanded with a variety of techniques. In particular, one technique involves partitioning an object at multiple levels, where at least one of the levels uses list-based partitioning. Further, a partitioning technique is provided which involves storing a data item in a default partition when the item does not map to any one of the list-based partitions for which a key value group has been defined. Techniques are also provided for efficiently splitting a partition.

摘要翻译： 使用各种技术扩展分区的概念。 特别地，一种技术涉及在多个级别上划分对象，其中至少一个级别使用基于列表的分区。 此外，提供了一种分割技术，其涉及当项目不映射到已经定义了键值组的基于列表的分区中的任何一个时，将数据项存储在默认分区中。 还提供了用于有效地分割分区的技术。

公开(公告)号：US20080034181A1

公开(公告)日：2008-02-07

申请号：US11871520

申请日：2007-10-12

申请人： Subhransu Basu ,  Ananth Raghavan ,  Shrikanth Shankar ,  Vikram Shukla

发明人： Subhransu Basu ,  Ananth Raghavan ,  Shrikanth Shankar ,  Vikram Shukla

IPC分类号： G06F12/02

CPC分类号： G06F17/30587 ,  Y10S707/953 ,  Y10S707/972 ,  Y10S707/99932 ,  Y10S707/99942 ,  Y10S707/99943

摘要： The concept of portioning is expanded with a variety of techniques. In particular, one technique involves partitioning an object at multiple levels, where at least one of the levels uses list-based partitioning. Further, a partitioning technique is provided which involves storing a data item in a default partition when the item does not map to any one of the list-based partitions for which a key value group has been defined. Techniques are also provided for efficiently splitting a partition.

公开(公告)号：US20060004755A1

公开(公告)日：2006-01-05

申请号：US11129617

申请日：2005-05-13

申请人： Subhransu Basu ,  Russell Green ,  Shrikanth Shankar

发明人： Subhransu Basu ,  Russell Green ,  Shrikanth Shankar

IPC分类号： G06F17/30

CPC分类号： G06F17/30902 ,  G06F21/6218 ,  G06F2221/2147 ,  Y10S707/99954

摘要： A system, method, computer program and article of manufacture for sharing metadata among cursors is provided. A metadata object marked as a versioned object can have multiple versions. Program units can share these versions of object metadata as opposed to copying the non-versioned object metadata into their memory. These program units may contain a pointer to an object's metadata but are otherwise void of the metadata information for the object. A locking protocol for the metadata ensures concurrency control and triggers dependency tracking. A locking protocol for the cursors controls cursor dependency status.

摘要翻译： 提供了一种用于在游标之间共享元数据的系统，方法，计算机程序和制品。 标记为版本化对象的元数据对象可以有多个版本。 程序单元可以共享对象元数据的这些版本，而不是将非版本化的对象元数据复制到其内存中。 这些程序单元可以包含指向对象的元数据的指针，但是否则该对象的元数据信息无效。 用于元数据的锁定协议确保并发控制并触发依赖关系跟踪。 光标的锁定协议控制游标依赖状态。

公开(公告)号：US20090150336A1

公开(公告)日：2009-06-11

申请号：US11951933

申请日：2007-12-06

申请人： Subhransu Basu ,  Harmeek Singh Bedi ,  Ananth Raghavan

发明人： Subhransu Basu ,  Harmeek Singh Bedi ,  Ananth Raghavan

IPC分类号： G06F17/30

CPC分类号： G06F17/30595

摘要： Techniques are described herein for partitioning a database table using a virtual column as the partitioning key. A virtual column is defined by the database to contain results of a defining expression. Partitioning can be performed using a variety of partitioning schemes, such as range partitioning and hash partitioning. The partitions are automatically updated to reflect changes to the values in the base columns upon which the virtual column depends. Partition pruning and parallel-wise partition joins can be performed on database tables which have been partitioned on virtual columns.

摘要翻译： 这里描述了使用虚拟列作为分区键分割数据库表的技术。 虚拟列由数据库定义，以包含定义表达式的结果。 可以使用各种分区方案（如范围分区和散列分区）执行分区。 自动更新分区以反映对虚拟列所依赖的基本列中的值的更改。 可以在已经在虚拟列上分区的数据库表上执行分区修剪和并行分区连接。