公开(公告)号：US08700674B2

公开(公告)日：2014-04-15

申请号：US12502890

申请日：2009-07-14

申请人： Chuck Bear ,  Rajat Venkatesh ,  Benjamin Vandiver ,  Sreenath Bodagala ,  Shilpa Lawande

发明人： Chuck Bear ,  Rajat Venkatesh ,  Benjamin Vandiver ,  Sreenath Bodagala ,  Shilpa Lawande

IPC分类号： G06F17/30 ,  G06F15/16

CPC分类号： G06F17/30312 ,  G06F3/061 ,  G06F3/0649 ,  G06F3/0685

摘要： Methods, systems and program products for database storage. In one implementation, data of a projection of a database is stored at least partly in grouped ROS format and partly in column format based on patterns of updating the projection data. The projection data is updated so that the updated projection is stored partly in grouped ROS format and partly in column format.

摘要翻译： 用于数据库存储的方法，系统和程序产品。 在一个实现中，基于更新投影数据的模式，数据库的投影的数据至少部分地以分组的ROS格式存储，并且部分地以列格式存储。 更新投影数据，使得更新的投影部分地以分组的ROS格式存储，部分以列格式存储。

公开(公告)号：US20110016157A1

公开(公告)日：2011-01-20

申请号：US12502890

申请日：2009-07-14

申请人： Chuck Bear ,  Rajat Venkatesh ,  Benjamin Vandiver ,  Sreenath Bodagala ,  Shilpa Lawande

发明人： Chuck Bear ,  Rajat Venkatesh ,  Benjamin Vandiver ,  Sreenath Bodagala ,  Shilpa Lawande

IPC分类号： G06F7/00 ,  G06F12/00

CPC分类号： G06F17/30312 ,  G06F3/061 ,  G06F3/0649 ,  G06F3/0685

摘要： Methods, systems and program products for database storage. In one implementation, data of a projection of a database is stored at least partly in grouped ROS format and partly in column format based on patterns of updating the projection data. The projection data is updated so that the updated projection is stored partly in grouped ROS format and partly in column format.

摘要翻译： 用于数据库存储的方法，系统和程序产品。 在一个实现中，基于更新投影数据的模式，数据库的投影的数据至少部分地以分组的ROS格式存储，并且部分地以列格式存储。 更新投影数据，使得更新的投影部分地以分组的ROS格式存储，部分以列格式存储。

公开(公告)号：US10380269B2

公开(公告)日：2019-08-13

申请号：US13155232

申请日：2011-06-07

申请人： Chuck Bear ,  Lakshmikant Shrinivas ,  Andrew Lamb

发明人： Chuck Bear ,  Lakshmikant Shrinivas ,  Andrew Lamb

IPC分类号： G06F17/30

摘要： Methods, systems and program products for query optimization using sideways information passing. In one implementation, a join clause in a query is identified that specifies an outer table of tuples to be joined with an inner table, the outer table having one or more attributes, and each of the attributes of the outer table having values stored in an attribute file that is distinct from attribute files in which the values of other attributes are stored. A plan for the query is created which, when executed, causes selection of a subset of tuples of the outer table to serve as input to the join clause in place of the outer table based on one or more predicates applied to the inner table.

公开(公告)号：US20120317094A1

公开(公告)日：2012-12-13

申请号：US13155232

申请日：2011-06-07

申请人： Chuck Bear ,  Lakshmikant Shrinivas ,  Andrew Lamb

发明人： Chuck Bear ,  Lakshmikant Shrinivas ,  Andrew Lamb

IPC分类号： G06F17/30

CPC分类号： G06F16/284 ,  G06F16/24542

摘要： Methods, systems and program products for query optimization using sideways information passing. In one implementation, a join clause in a query is identified that specifies an outer table of tuples to be joined with an inner table, the outer table having one or more attributes, and each of the attributes of the outer table having values stored in an attribute file that is distinct from attribute files in which the values of other attributes are stored. A plan for the query is created which, when executed, causes selection of a subset of tuples of the outer table to serve as input to the join clause in place of the outer table based on one or more predicates applied to the inner table.

摘要翻译： 使用侧向信息传递进行查询优化的方法，系统和程序产品。 在一个实现中，识别查询中的连接子句，其指定要与内部表连接的元组的外部表，外部表具有一个或多个属性，并且外部表的每个属性具有存储在 属性文件与其中存储其他属性的值的属性文件不同。 创建查询的计划，当执行时，根据应用于内部表的一个或多个谓词，执行外部表的元组的子集的选择，以作为连接子句的输入，而不是外部表。