公开(公告)号：US20090177622A1

公开(公告)日：2009-07-09

申请号：US12007325

申请日：2008-01-09

申请人： Ying Hu ,  Seema Sundara ,  Jagannathan Srinivasan

发明人： Ying Hu ,  Seema Sundara ,  Jagannathan Srinivasan

IPC分类号： G06F17/30

CPC分类号： G06F17/30336

摘要： A method, system, and computer program product provides improved performance for rebuild of user-defined indexes during partition maintenance operations (partition split, merge, and move). A method of maintaining a index of a partitioned database table comprises performing a partition maintenance operation on the partitioned database table wherein a plurality of rows of the partitioned database table are moved from one partition to another, storing mapping information for at least some of the plurality of moved rows, including an old mapping for each of the moved rows and a corresponding new mapping for each of the moved rows, and when rebuilding the index, replacing an old mapping in the index for each of the plurality of moved rows with the corresponding stored new mapping for each of the plurality of moved rows.

摘要翻译： 方法，系统和计算机程序产品提供了在分区维护操作（分区拆分，合并和移动）期间重建用户定义索引的改进性能。 维护分区数据库表的索引的方法包括对分区数据库表执行分区维护操作，其中分区数据库表的多行被从一个分区移动到另一分区，存储多个分区数据库表中的至少一个的映射信息 移动的行，包括每个移动的行的旧映射和每个被移动的行的对应的新映射，以及当重建索引时，用对应的多个移动的行中的每一个代替索引中的旧映射 为多个移动的行中的每一个存储新的映射。

公开(公告)号：US20090019005A1

公开(公告)日：2009-01-15

申请号：US11827796

申请日：2007-07-13

申请人： Ying Hu ,  Seema Sundara ,  Jagannathan Srinivasan

发明人： Ying Hu ,  Seema Sundara ,  Jagannathan Srinivasan

IPC分类号： G06F17/30

CPC分类号： G06F17/30457

摘要： Systems, methodologies, media, and other embodiments associated with supporting materialized views with user-defined aggregates are described. One example system includes logic for exposing a set of interface actions to support a user-defined aggregate in a materialized view associated with a base table. The materialized view may store both the user-defined aggregate and a user-defined aggregate context that facilitates logically connecting the user-defined aggregate to the base table. The example system may also include logic for supporting the user-defined aggregate. The support may be based on the set of interface actions. Example systems and methods may, therefore, facilitate incremental updating of the materialized view and/or rewriting a query to access the materialized view.

摘要翻译： 描述了使用用户定义的聚合来支持物化视图的系统，方法，介质和其他实施例。 一个示例系统包括用于在与基表相关联的物化视图中暴露一组接口动作以支持用户定义的聚合的逻辑。 物化视图可以存储用户定义的聚合和有助于将用户定义的聚合逻辑连接到基表的用户定义的聚合上下文。 示例系统还可以包括用于支持用户定义的聚合的逻辑。 支持可以基于一组接口动作。 因此，示例系统和方法可以促进物化视图的增量更新和/或重写查询以访问物化视图。

公开(公告)号：US20080288473A1

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

申请号：US11804508

申请日：2007-05-18

申请人： Ying Hu ,  Seema Sundara ,  Jagannathan Srinivasan

发明人： Ying Hu ,  Seema Sundara ,  Jagannathan Srinivasan

IPC分类号： G06F17/30

CPC分类号： G06F17/30522 ,  G06F17/30533

摘要： Systems, methodologies, media, and other embodiments associated with supporting queries with hard time constraints are described. One exemplary system embodiment includes logic for accepting a query having a hard time constraint. The example system may also include logic for selectively rewriting the query having the hard time constraint into a query having a row limitation or a sample percentage limitation. In one example, the row limitation or sample percentage limitation are computed by repetitively comparing an estimated query execution time to the hard time constraint. The example system may also include logic for establishing a timer(s) associated with the rewritten query.

摘要翻译： 描述了与支持具有硬时间约束的查询相关联的系统，方法，媒体和其他实施例。 一个示例性系统实施例包括用于接受具有硬时间约束的查询的逻辑。 示例系统还可以包括用于选择性地将具有硬时间约束的查询重写到具有行限制或样本百分比限制的查询中的逻辑。 在一个示例中，通过将估计的查询执行时间与硬时间约束重复比较来计算行限制或抽样百分比限制。 示例系统还可以包括用于建立与重写查询相关联的定时器的逻辑。

公开(公告)号：US20050182762A1

公开(公告)日：2005-08-18

申请号：US11104718

申请日：2005-04-12

申请人： Jagannathan Srinivasan ,  Seema Sundara ,  Nipun Agarwal ,  Ying Hu ,  Timothy Chorma

发明人： Jagannathan Srinivasan ,  Seema Sundara ,  Nipun Agarwal ,  Ying Hu ,  Timothy Chorma

IPC分类号： G06F17/30

CPC分类号： G06F17/30336 ,  G06F17/30339 ,  Y10S707/99943

摘要： A domain index for a partitioned database can be created using a user-defined indexing scheme. Partition maintenance operations performed on the partitioned database objects cause corresponding partition maintenance operations to be performed on the domain indexes. The user-supplied partitioning code is partition operation-unaware.

摘要翻译： 可以使用用户定义的索引方案创建分区数据库的域索引。 对分区数据库对象执行的分区维护操作会导致对域索引执行相应的分区维护操作。 用户提供的分区代码是分区操作 - 不知道。

公开(公告)号：US07953728B2

公开(公告)日：2011-05-31

申请号：US11804502

申请日：2007-05-18

申请人： Ying Hu ,  Seema Sundara ,  Jagannathan Srinivasan

发明人： Ying Hu ,  Seema Sundara ,  Jagannathan Srinivasan

IPC分类号： G06F17/30

CPC分类号： G06F17/30536

摘要： Systems, methodologies, media, and other embodiments associated with supporting queries with soft time constraints are described. One exemplary system embodiment includes logic for accepting a query having a soft time constraint. The example system may also include logic for rewriting the query having the soft time constraint into a query having a row limitation or a sample percentage limitation. In one example, the row limitation or sample percentage limitation are computed by repetitively comparing an estimated query execution time to the soft time constraint.

摘要翻译： 描述了与支持具有软时间约束的查询相关联的系统，方法，媒体和其他实施例。 一个示例性系统实施例包括用于接受具有软时间约束的查询的逻辑。 示例系统还可以包括用于将具有软时间约束的查询重写为具有行限制或样本百分比限制的查询的逻辑。 在一个示例中，通过将估计的查询执行时间与软时间约束重复比较来计算行限制或样本百分比限制。

公开(公告)号：US07844600B2

公开(公告)日：2010-11-30

申请号：US11827796

申请日：2007-07-13

申请人： Ying Hu ,  Seema Sundara ,  Jagannathan Srinivasan

发明人： Ying Hu ,  Seema Sundara ,  Jagannathan Srinivasan

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

CPC分类号： G06F17/30457

摘要： Systems, methodologies, media, and other embodiments associated with supporting materialized views with user-defined aggregates are described. One example system includes logic for exposing a set of interface actions to support a user-defined aggregate in a materialized view associated with a base table. The materialized view may store both the user-defined aggregate and a user-defined aggregate context that facilitates logically connecting the user-defined aggregate to the base table. The example system may also include logic for supporting the user-defined aggregate. The support may be based on the set of interface actions. Example systems and methods may, therefore, facilitate incremental updating of the materialized view and/or rewriting a query to access the materialized view.

摘要翻译： 描述了使用用户定义的聚合来支持物化视图的系统，方法，介质和其他实施例。 一个示例系统包括用于在与基表相关联的物化视图中暴露一组接口动作以支持用户定义的聚合的逻辑。 物化视图可以存储用户定义的聚合和有助于将用户定义的聚合逻辑连接到基表的用户定义的聚合上下文。 示例系统还可以包括用于支持用户定义的聚合的逻辑。 支持可以基于一组接口动作。 因此，示例系统和方法可以促进物化视图的增量更新和/或重写查询以访问物化视图。

公开(公告)号：US20090030874A1

公开(公告)日：2009-01-29

申请号：US12027918

申请日：2008-02-07

申请人： Dinesh Das ,  Wesley Lin ,  Seema Sundara

发明人： Dinesh Das ,  Wesley Lin ,  Seema Sundara

IPC分类号： G06F7/06

CPC分类号： G06F17/30463 ,  G06F17/30312 ,  G06F17/30471

摘要： In one embodiment, a database server registers one or more functions included in a user-defined index that includes one or more auxiliary properties. The database server receives a query that specifies one or more parameters. A query optimizer generates a plurality of execution plans for evaluating the query. The query optimizer estimates a plurality of total costs respectively associated with the plurality of execution plans, where estimating a particular total cost associated with a particular execution plan comprises: invoking the one or more functions with one or more function arguments based on the one or more parameters; receiving one or more index costs that are associated with using the one or more auxiliary properties of the user-defined index to evaluate the query; and determining the particular total cost based on the one or more index costs. From the plurality of execution plans, the query optimizer selects an optimal execution plan that is associated with an optimal total cost of the plurality of total costs.

摘要翻译： 在一个实施例中，数据库服务器注册包括在包括一个或多个辅助属性的用户定义索引中的一个或多个功能。 数据库服务器接收一个指定一个或多个参数的查询。 查询优化器生成用于评估查询的多个执行计划。 查询优化器估计与多个执行计划分别相关联的多个总成本，其中估计与特定执行计划相关联的特定总成本包括：基于一个或多个参数调用具有一个或多个函数参数的一个或多个函数 参数; 接收与使用所述用户定义的索引的所述一个或多个辅助属性相关联的一个或多个索引成本来评估所述查询; 以及基于所述一个或多个索引成本确定所述特定总成本。 从多个执行计划中，查询优化器选择与多个总成本的最佳总成本相关联的最优执行计划。

公开(公告)号：US07987164B2

公开(公告)日：2011-07-26

申请号：US12007325

申请日：2008-01-09

申请人： Ying Hu ,  Seema Sundara ,  Jagannathan Srinivasan

发明人： Ying Hu ,  Seema Sundara ,  Jagannathan Srinivasan

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

CPC分类号： G06F17/30336

摘要： A method, system, and computer program product provides improved performance for rebuild of user-defined indexes during partition maintenance operations (partition split, merge, and move). A method of maintaining a index of a partitioned database table comprises performing a partition maintenance operation on the partitioned database table wherein a plurality of rows of the partitioned database table are moved from one partition to another, storing mapping information for at least some of the plurality of moved rows, including an old mapping for each of the moved rows and a corresponding new mapping for each of the moved rows, and when rebuilding the index, replacing an old mapping in the index for each of the plurality of moved rows with the corresponding stored new mapping for each of the plurality of moved rows.

摘要翻译： 方法，系统和计算机程序产品提供了在分区维护操作（分区拆分，合并和移动）期间重建用户定义索引的改进性能。 维护分区数据库表的索引的方法包括对分区数据库表执行分区维护操作，其中分区数据库表的多行被从一个分区移动到另一分区，存储多个分区数据库表中的至少一个的映射信息 移动的行，包括每个移动的行的旧映射和每个被移动的行的对应的新映射，以及当重建索引时，用对应的多个移动的行中的每一个代替索引中的旧映射 为多个移动的行中的每一个存储新的映射。

公开(公告)号：US07925647B2

公开(公告)日：2011-04-12

申请号：US12027918

申请日：2008-02-07

申请人： Dinesh Das ,  Wesley Lin ,  Seema Sundara

发明人： Dinesh Das ,  Wesley Lin ,  Seema Sundara

IPC分类号： G06F17/30

CPC分类号： G06F17/30463 ,  G06F17/30312 ,  G06F17/30471

摘要： In one embodiment, a database server registers one or more functions included in a user-defined index that includes one or more auxiliary properties. The database server receives a query that specifies one or more parameters. A query optimizer generates a plurality of execution plans for evaluating the query. The query optimizer estimates a plurality of total costs respectively associated with the plurality of execution plans, where estimating a particular total cost associated with a particular execution plan comprises: invoking the one or more functions with one or more function arguments based on the one or more parameters; receiving one or more index costs that are associated with using the one or more auxiliary properties of the user-defined index to evaluate the query; and determining the particular total cost based on the one or more index costs. From the plurality of execution plans, the query optimizer selects an optimal execution plan that is associated with an optimal total cost of the plurality of total costs.

摘要翻译： 在一个实施例中，数据库服务器注册包括在包括一个或多个辅助属性的用户定义索引中的一个或多个功能。 数据库服务器接收一个指定一个或多个参数的查询。 查询优化器生成用于评估查询的多个执行计划。 查询优化器估计与多个执行计划分别相关联的多个总成本，其中估计与特定执行计划相关联的特定总成本包括：基于一个或多个参数调用具有一个或多个函数参数的一个或多个函数 参数; 接收与使用所述用户定义的索引的所述一个或多个辅助属性相关联的一个或多个索引成本来评估所述查询; 以及基于所述一个或多个索引成本确定所述特定总成本。 从多个执行计划中，查询优化器选择与多个总成本的最佳总成本相关联的最优执行计划。

公开(公告)号：US20100161680A1

公开(公告)日：2010-06-24

申请号：US12317362

申请日：2008-12-22

申请人： Medha Atre ,  Seema Sundara ,  Jagannathan Srinivasan

发明人： Medha Atre ,  Seema Sundara ,  Jagannathan Srinivasan

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

CPC分类号： G06F17/30554

摘要： Systems, methods, and other embodiments associated with visualizing data using summary graphs are described. One example method includes constructing a summary graph for display. The summary graph represents the data as a summary node having a plurality of property edges connected to the summary node. The summary node represents the set of values for the node in the data.

摘要翻译： 描述了使用概要图形与可视化数据相关联的系统，方法和其他实施例。 一个示例性方法包括构建用于显示的摘要图。 汇总图表示作为具有连接到汇总节点的多个属性边缘的汇总节点的数据。 汇总节点表示数据中节点的值集合。