-
公开(公告)号：US20090150336A1
公开(公告)日：2009-06-11
申请号：US11951933
申请日：2007-12-06
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.
摘要翻译： 这里描述了使用虚拟列作为分区键分割数据库表的技术。 虚拟列由数据库定义，以包含定义表达式的结果。 可以使用各种分区方案（如范围分区和散列分区）执行分区。 自动更新分区以反映对虚拟列所依赖的基本列中的值的更改。 可以在已经在虚拟列上分区的数据库表上执行分区修剪和并行分区连接。
-
公开(公告)号：US08620888B2
公开(公告)日：2013-12-31
申请号：US11951933
申请日：2007-12-06
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.
摘要翻译： 这里描述了使用虚拟列作为分区键分割数据库表的技术。 虚拟列由数据库定义，以包含定义表达式的结果。 可以使用各种分区方案（如范围分区和散列分区）执行分区。 自动更新分区以反映对虚拟列所依赖的基本列中的值的更改。 可以在已经在虚拟列上分区的数据库表上执行分区修剪和并行分区连接。
-
公开(公告)号：US20090150366A1
公开(公告)日：2009-06-11
申请号：US11951918
申请日：2007-12-06
申请人： Subhransu Basu , Harmeek Singh Bedi
发明人： Subhransu Basu , Harmeek Singh Bedi
IPC分类号： G06F17/30
CPC分类号： G06F17/30595 , G06F17/30312 , G06F17/30418
摘要： Techniques are described herein for replacing a part of an expression in a query to a database with a virtual column. A virtual column is defined by the database to contain results of a defining expression. A part of an expression in a query is replaced with a virtual column whose defining expression is equal to the part of the expression in the query. The part of an expression in a query can be the entire expression. When an expression in a query can be replaced with more than one replacement expression involving virtual columns, the replacement expression with the least cost of query processing is selected.
摘要翻译： 本文描述了技术，用于将具有虚拟列的查询中的表达式的一部分替换为数据库。 虚拟列由数据库定义，以包含定义表达式的结果。 查询中表达式的一部分被替换为其定义表达式等于查询中表达式部分的虚拟列。 查询中的表达式的一部分可以是整个表达式。 当查询中的表达式可以被包含虚拟列的多个替换表达式替换时，将选择查询处理成本最低的替换表达式。
-
公开(公告)号：US08046352B2
公开(公告)日：2011-10-25
申请号：US11951918
申请日：2007-12-06
申请人： Subhransu Basu , Harmeek Singh Bedi
发明人： Subhransu Basu , Harmeek Singh Bedi
IPC分类号： G06F17/30
CPC分类号： G06F17/30595 , G06F17/30312 , G06F17/30418
摘要： Techniques are described herein for replacing a part of an expression in a query to a database with a virtual column. A virtual column is defined by the database to contain results of a defining expression. A part of an expression in a query is replaced with a virtual column whose defining expression is equal to the part of the expression in the query. The part of an expression in a query can be the entire expression. When an expression in a query can be replaced with more than one replacement expression involving virtual columns, the replacement expression with the least cost of query processing is selected.
摘要翻译： 本文描述了技术，用于将具有虚拟列的查询中的表达式的一部分替换为数据库。 虚拟列由数据库定义，以包含定义表达式的结果。 查询中表达式的一部分被替换为其定义表达式等于查询中表达式部分的虚拟列。 查询中的表达式的一部分可以是整个表达式。 当查询中的表达式可以被包含虚拟列的多个替换表达式替换时，将选择查询处理成本最低的替换表达式。
-
公开(公告)号：US20120036111A1
公开(公告)日：2012-02-09
申请号：US13278025
申请日：2011-10-20
申请人： Subhransu Basu , Harmeek Singh Bedi
发明人： Subhransu Basu , Harmeek Singh Bedi
IPC分类号： G06F17/30
CPC分类号： G06F16/2462 , G06F16/24545 , Y10S707/963
摘要： Techniques are described herein for performing column functions on virtual columns in database tables. A virtual column is defined by the database to contain results of a defining expression. Statistics are collected and maintained for virtual columns. Indexing is performed on virtual columns. Referential integrity is maintained between two tables using virtual columns as keys. Join predicate push-down operations are also performed using virtual columns.
摘要翻译： 这里描述了在数据库表中的虚拟列上执行列函数的技术。 虚拟列由数据库定义，以包含定义表达式的结果。 为虚拟列收集和维护统计信息。 在虚拟列上执行索引。 使用虚拟列作为关键字的两个表之间维护引用完整性。 连接谓词下拉操作也使用虚拟列执行。
-
公开(公告)号：US08078652B2
公开(公告)日：2011-12-13
申请号：US11951890
申请日：2007-12-06
申请人： Subhransu Basu , Harmeek Singh Bedi
发明人： Subhransu Basu , Harmeek Singh Bedi
IPC分类号： G06F17/30
CPC分类号： G06F17/30469 , G06F17/30536 , Y10S707/963
摘要： Techniques are described herein for performing column functions on virtual columns in database tables. A virtual column is defined by the database to contain results of a defining expression. Statistics are collected and maintained for virtual columns. Indexing is performed on virtual columns. Referential integrity is maintained between two tables using virtual columns as keys. Join predicate push-down operations are also performed using virtual columns.
摘要翻译： 这里描述了在数据库表中的虚拟列上执行列函数的技术。 虚拟列由数据库定义，以包含定义表达式的结果。 为虚拟列收集和维护统计信息。 在虚拟列上执行索引。 使用虚拟列作为关键字的两个表之间维护引用完整性。 连接谓词下拉操作也使用虚拟列执行。
-
公开(公告)号：US20090150413A1
公开(公告)日：2009-06-11
申请号：US11951890
申请日：2007-12-06
申请人： Subhransu Basu , Harmeek Singh Bedi
发明人： Subhransu Basu , Harmeek Singh Bedi
IPC分类号： G06F17/30
CPC分类号： G06F17/30469 , G06F17/30536 , Y10S707/963
摘要： Techniques are described herein for performing column functions on virtual columns in database tables. A virtual column is defined by the database to contain results of a defining expression. Statistics are collected and maintained for virtual columns. Indexing is performed on virtual columns. Referential integrity is maintained between two tables using virtual columns as keys. Join predicate push-down operations are also performed using virtual columns.
摘要翻译： 这里描述了在数据库表中的虚拟列上执行列函数的技术。 虚拟列由数据库定义，以包含定义表达式的结果。 为虚拟列收集和维护统计信息。 在虚拟列上执行索引。 使用虚拟列作为关键字的两个表之间维护引用完整性。 连接谓词下拉操作也使用虚拟列执行。
-
公开(公告)号：US20080046454A1
公开(公告)日：2008-02-21
申请号：US11871529
申请日：2007-10-12
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.
摘要翻译： 分割的概念用各种技术扩展。 特别地，一种技术涉及在多个级别上划分对象，其中至少一个级别使用基于列表的分区。 此外，提供了一种分割技术，其涉及当项目不映射到已经定义了键值组的基于列表的分区中的任何一个时，将数据项存储在默认分区中。 还提供了用于有效地分割分区的技术。
-
公开(公告)号：US20080034181A1
公开(公告)日：2008-02-07
申请号：US11871520
申请日：2007-10-12
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.
-
公开(公告)号：US07774379B2
公开(公告)日：2010-08-10
申请号：US11871529
申请日：2007-10-12
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.
-
-
-
-
-
-
-
-
-
搜索结果
16 条记录 (耗时 0.018 秒)