公开(公告)号：US07921102B2

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

申请号：US12839803

申请日：2010-07-20

Applicant: Michael W. Cain ,  Michael S. Faunce ,  Wei Hu ,  Shantan Kethireddy ,  Andrew Peter Passe ,  Ulrich Thiemann

Inventor： Michael W. Cain ,  Michael S. Faunce ,  Wei Hu ,  Shantan Kethireddy ,  Andrew Peter Passe ,  Ulrich Thiemann

IPC: G06F17/30

CPC classification number: G06F17/30336 ,  G06F17/30469

Abstract: A method, apparatus and program product is provided for optimizing a database query. A query syntax, system generated predicates, and requisite statistics of the database query are analyzed to determine if a predicate structure is a good candidate for a symbol table only data structure. The predicate structure is analyzed to determine if the predicate structure is already encompassed by an encoded vector index. The symbol table only data structure is generated for at least one column in a database table without generating a corresponding vector data structure from an encoded vector index if the predicate structure is a good candidate and not encompassed by an encoded vector index. The symbol table only data structure is maintained by detecting a change in data associated with the symbol table only data structure and updating the symbol table only data structure to reflect the change in the data.

Abstract translation: 提供了一种用于优化数据库查询的方法，装置和程序产品。 分析查询语法，系统生成的谓词和数据库查询的必要统计信息，以确定谓词结构是否仅是符号表格数据结构的良好候选。 分析谓词结构以确定谓词结构是否已被编码的向量索引包围。 如果谓词结构是一个很好的候选者并且不被编码的向量索引所包含，那么为数据库表中的至少一列生成符号表数据结构，而不从编码向量索引生成相应的向量数据结构。 仅通过检测与符号表仅数据结构相关联的数据的变化来维护仅符号表数据结构，并且仅更新符号表仅数据结构以反映数据的变化。

公开(公告)号：US20100287206A1

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

申请号：US12839803

申请日：2010-07-20

Applicant: Michael W. Cain ,  Michael S. Faunce ,  Wei Hu ,  Shantan Kethireddy ,  Andrew Peter Passe ,  Ulrich Thiemann

Inventor： Michael W. Cain ,  Michael S. Faunce ,  Wei Hu ,  Shantan Kethireddy ,  Andrew Peter Passe ,  Ulrich Thiemann

IPC: G06F17/30

CPC classification number: G06F17/30336 ,  G06F17/30469

Abstract: A method, apparatus and program product is provided for optimizing a database query. A query syntax, system generated predicates, and requisite statistics of the database query are analyzed to determine if a predicate structure is a good candidate for a symbol table only data structure. The predicate structure is analyzed to determine if the predicate structure is already encompassed by an encoded vector index. The symbol table only data structure is generated for at least one column in a database table without generating a corresponding vector data structure from an encoded vector index if the predicate structure is a good candidate and not encompassed by an encoded vector index. The symbol table only data structure is maintained by detecting a change in data associated with the symbol table only data structure and updating the symbol table only data structure to reflect the change in the data.

Abstract translation: 提供了一种用于优化数据库查询的方法，装置和程序产品。 分析查询语法，系统生成的谓词和数据库查询的必要统计信息，以确定谓词结构是否仅是符号表格数据结构的良好候选。 分析谓词结构以确定谓词结构是否已被编码的向量索引包围。 如果谓词结构是一个很好的候选者并且不被编码的向量索引所包含，那么为数据库表中的至少一列生成符号表数据结构，而不从编码向量索引生成相应的向量数据结构。 仅通过检测与符号表仅数据结构相关联的数据的变化来维护仅符号表数据结构，并且仅更新符号表仅数据结构以反映数据的变化。

公开(公告)号：US07792823B2

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

申请号：US12014562

申请日：2008-01-15

Applicant: Michael W. Cain ,  Michael S. Faunce ,  Wei Hu ,  Shantan Kethireddy ,  Andrew Peter Passe ,  Ulrich Thiemann

Inventor： Michael W. Cain ,  Michael S. Faunce ,  Wei Hu ,  Shantan Kethireddy ,  Andrew Peter Passe ,  Ulrich Thiemann

IPC: G06F17/30

CPC classification number: G06F17/30336 ,  G06F17/30469

Abstract: A method, apparatus and program product is provided for optimizing a database query. A query syntax, system generated predicates, and requisite statistics of the database query are analyzed to determine if a predicate structure is a good candidate for a symbol table only data structure. The predicate structure is analyzed to determine if the predicate structure is already encompassed by an encoded vector index. The symbol table only data structure is generated for at least one column in a database table without generating a corresponding vector data structure from an encoded vector index if the predicate structure is a good candidate and not encompassed by an encoded vector index. The symbol table only data structure is maintained by detecting a change in data associated with the symbol table only data structure and updating the symbol table only data structure to reflect the change in the data.

Abstract translation: 提供了一种用于优化数据库查询的方法，装置和程序产品。 分析查询语法，系统生成的谓词和数据库查询的必要统计信息，以确定谓词结构是否仅是符号表格数据结构的良好候选。 分析谓词结构以确定谓词结构是否已被编码的向量索引包围。 如果谓词结构是一个很好的候选者并且不被编码的向量索引所包含，那么为数据库表中的至少一列生成符号表数据结构，而不从编码向量索引生成相应的向量数据结构。 仅通过检测与符号表仅数据结构相关联的数据的变化来维护仅符号表数据结构，并且仅更新符号表仅数据结构以反映数据的变化。

公开(公告)号：US20090164412A1

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

申请号：US11962980

申请日：2007-12-21

Applicant: Robert Joseph Bestgen ,  David Glenn Carlson ,  Robert Victor Downer ,  Shantan Kethireddy

Inventor： Robert Joseph Bestgen ,  David Glenn Carlson ,  Robert Victor Downer ,  Shantan Kethireddy

IPC: G06F17/30

CPC classification number: G06F17/30545

Abstract: A method, apparatus and program product are provided for performing a query of a database. A database query is received, which includes first and second operations respectively configured to generate first and second disjoint results sets from a dataspace. The database query is analyzed to identify a set of attributes from the dataspace that are used by at least one of the first and second operations in the database query. During execution of the database query, a plurality of records from the dataspace is iteratively processed in a single pass, including, for each of the plurality of records, processing such record by retrieving the plurality of attributes for such record from the dataspace and performing each of the first and second operations on the record using the retrieved attributes for such record to build the first and second disjoint results sets.

Abstract translation: 提供了一种用于执行数据库查询的方法，装置和程序产品。 接收到数据库查询，其包括分别被配置为从数据空间生成第一和第二不相交结果集的第一和第二操作。 分析数据库查询以从数据库空间识别由数据库查询中的第一和第二操作中的至少一个使用的一组属性。 在执行数据库查询期间，数据空间中的多个记录在单次传递中被迭代处理，包括对于多个记录中的每个记录，通过从数据空间检索这样的记录的多个属性并执行每个记录 使用检索到的这种记录的属性来构建第一和第二不相交结果集的记录上的第一和第二操作。

公开(公告)号：US20090100114A1

公开(公告)日：2009-04-16

申请号：US11870118

申请日：2007-10-10

Applicant: Robert Joseph Bestgen ,  Shantan Kethireddy ,  John Matthew Santosuosso

Inventor： Robert Joseph Bestgen ,  Shantan Kethireddy ,  John Matthew Santosuosso

IPC: G06F17/30

CPC classification number: G06F11/2097 ,  G06F11/2071 ,  G06F11/3476 ,  G06F17/30306

Abstract: A method, apparatus, and program product are provided for preserving a query plan cache on a backup system having a dataspace containing a copy of data and a copy of a query plan cache from a production system. An update is initiated of at least a portion of the copy of the data on the backup system with a portion of the data on the production system. A merge is initiated of updated query plans in the query plan cache from the production system with corresponding query plans in the copy of the query plan cache on the backup system. Objects are correlated in the updated query plans in the copy of the query plan cache with the updated copy of the data on the backup system.

Abstract translation: 提供了一种方法，装置和程序产品，用于在备份系统上保留查询计划缓存，该备份系统具有包含来自生产系统的数据副本和查询计划缓存副本的数据空间。 在备份系统上的数据的副本的至少一部分的一个更新是在生产系统上的一部分数据发起的。 在生产系统的查询计划缓存中启动更新的查询计划的合并，并在备份系统上的查询计划缓存的副本中具有对应的查询计划。 对象在查询计划缓存的副本中的更新的查询计划中与备份系统上更新的数据副本相关联。

公开(公告)号：US20080256025A1

公开(公告)日：2008-10-16

申请号：US11735133

申请日：2007-04-13

Applicant: Robert Joseph Bestgen ,  Michael S. Faunce ,  Wei Hu ,  Shantan Kethireddy ,  Andrew Peter Passe ,  Ulrich Thiemann

Inventor： Robert Joseph Bestgen ,  Michael S. Faunce ,  Wei Hu ,  Shantan Kethireddy ,  Andrew Peter Passe ,  Ulrich Thiemann

IPC: G06F17/30

CPC classification number: G06F17/30964 ,  G06F17/30424

Abstract: A method, apparatus and program product to optimize a database query. In a first system having a first dataspace, a query plan is generated for the database query. Remote statistics collection associated with the database query is initiated on a second system having a second dataspace. The remote statistics collection uses the second dataspace, which includes a current copy of at least a portion of the first dataspace on the first system. Database statistics are collected for the first system by analyzing the second dataspace and then communicating the collected database statistics to the first system for use in optimizing database queries executed by the first system.

Abstract translation: 一种优化数据库查询的方法，设备和程序产品。 在具有第一数据空间的第一系统中，为数据库查询生成查询计划。 在具有第二数据空间的第二系统上启动与数据库查询相关联的远程统计信息收集。 远程统计信息收集使用第二个数据空间，其中包含第一个系统上第一个数据空间的至少一部分的当前副本。 通过分析第二个数据空间来收集第一个系统的数据库统计信息，然后将收集的数据库统计信息传递给第一个系统，以便优化由第一个系统执行的数据库查询。

公开(公告)号：US20080256024A1

公开(公告)日：2008-10-16

申请号：US11735095

申请日：2007-04-13

Applicant: Robert Victor Downer ,  Wei Hu ,  Shantan Kethireddy ,  Andrew Peter Passe ,  Ulrich Thiemann

Inventor： Robert Victor Downer ,  Wei Hu ,  Shantan Kethireddy ,  Andrew Peter Passe ,  Ulrich Thiemann

IPC: G06F17/30

CPC classification number: G06F17/30463

Abstract: A method, apparatus and program product to optimize a database query. A query plan is generated for the database query where the query plan includes first and second subplans. Cached optimization data associated with the first subplan and generated during evaluation of another query plan for a previous query that uses the first subplan is retrieved. The first subplan is evaluated for resource cost using the retrieved optimization data. The second subplan is also evaluated for resource cost. The query plan is then evaluated for resource cost based upon the evaluations of resource cost for the first and second subplans. A query plan is selected based on evaluations of resource cost and the plan is executed to generate a result set.

Abstract translation: 一种优化数据库查询的方法，设备和程序产品。 为数据库查询生成查询计划，其中查询计划包含第一和第二子计划。 检索与第一个子计划相关联并在评估使用第一个子计划的上一个查询的另一个查询计划时生成的缓存优化数据。 使用检索到的优化数据评估第一个子计划的资源成本。 还对第二个分计划进行资源成本评估。 然后基于对第一和第二子计划的资源成本的评估来评估查询计划的资源成本。 基于对资源成本的评估来选择查询计划，并执行计划以生成结果集。

公开(公告)号：US20070027860A1

公开(公告)日：2007-02-01

申请号：US11191470

申请日：2005-07-28

Applicant: Robert Bestgen ,  Shantan Kethireddy ,  Jeffrey Tenner

Inventor： Robert Bestgen ,  Shantan Kethireddy ,  Jeffrey Tenner

IPC: G06F17/30

CPC classification number: G06F16/24544 ,  G06F16/24524

Abstract: A database facility supports database join queries in a database environment having at least one database table divided into multiple partitions based on a partition key value. The facility determines whether the values in a table joined to the partitioned table place an implicit limitation on the partition key, and eliminates from query evaluation any partitions which do not satisfy the implicit limitation. Preferably, the database uses a star schema organization, in which implicit limitations in a relatively small dimension table are used to eliminate partitions in a relatively large fact table.

Abstract translation: 数据库设施支持数据库环境中的数据库连接查询，其中至少有一个基于分区键值划分成多个分区的数据库表。 该设施确定连接到分区表的表中的值是否对分区关键字产生隐式限制，并且从查询评估中排除不满足隐式限制的任何分区。 优选地，数据库使用星型模式组织，其中使用相对较小维度表中的隐含限制来消除较大事实表中的分区。

公开(公告)号：US09563538B2

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

申请号：US13443140

申请日：2012-04-10

Applicant: Robert J. Bestgen ,  Robert D. Driesch, Jr. ,  Wei Hu ,  Shantan Kethireddy ,  Edward J. Miller ,  Andrew P. Passe ,  Ulrich Thiemann

Inventor： Robert J. Bestgen ,  Robert D. Driesch, Jr. ,  Wei Hu ,  Shantan Kethireddy ,  Edward J. Miller ,  Andrew P. Passe ,  Ulrich Thiemann

IPC: G06F9/44 ,  G06F11/36 ,  G06F11/34 ,  G06F9/45

CPC classification number: G06F11/3636 ,  G06F8/443 ,  G06F11/3476 ,  G06F11/3612 ,  G06F2201/865

Abstract: Methods, systems, and products are provided for code path tracking. Embodiments include identifying an instrumented trace point in software code to be path tracked; identifying a function executed at the instrumented trace point in the software code; identifying parameters for the function executed at the instrumented trace point; and recording a description of the function, the parameters, and the result of the execution of the function using the parameters.

Abstract translation: 提供方法，系统和产品用于代码路径跟踪。 实施例包括识别要路径跟踪的软件代码中的仪表化跟踪点; 识别在软件代码中的仪表化跟踪点执行的功能; 识别在仪器化跟踪点执行的功能的参数; 并使用参数记录功能的描述，参数和执行功能的结果。

公开(公告)号：US09047135B2

公开(公告)日：2015-06-02

申请号：US12691891

申请日：2010-01-22

Applicant: Stephanie A. Foege ,  Andres Gonzalez, Jr. ,  Shantan Kethireddy ,  Meryl Lo ,  Annita Tomko

Inventor： Stephanie A. Foege ,  Andres Gonzalez, Jr. ,  Shantan Kethireddy ,  Meryl Lo ,  Annita Tomko

IPC: G06F15/173 ,  G06F15/177 ,  G06F13/00 ,  G06F3/00 ,  G06F9/50

CPC classification number: G06F9/5077

Abstract: A qualitative resource assignment wizard receives qualitative information for a logical partition (LPAR) and calculates computer resource assignments for the LPAR based on the qualitative information and a set of conversion functions. For example, the qualitative resource assignment wizard may calculate a processing unit assignment, a memory assignment, and an I/O slot assignment for the LPAR. The qualitative information may be input by a user, for example, utilizing a graphical user interface (GUI). In one embodiment, the conversion functions are calculated during a training phase, in which a user periodically provides qualitative information while resource usage data is gathered. The wizard may reside in a hardware management console (HMC) or other administrative console and/or may be a component of a hypervisor or other partition management code. Software code associated with the wizard may be provided by a network server application to a client system for enabling a user to remotely input the qualitative information.

Abstract translation: 定性资源分配向导接收逻辑分区（LPAR）的定性信息，并根据定性信息和一组转换函数计算LPAR的计算机资源分配。 例如，定性资源分配向导可以计算LPAR的处理单元分配，存储器分配和I / O时隙分配。 定性信息可由用户输入，例如利用图形用户界面（GUI）。 在一个实施例中，在训练阶段期间计算转换功能，其中用户在收集资源使用数据的同时周期性地提供定性信息。 该向导可以驻留在硬件管理控制台（HMC）或其他管理控制台中，和/或可以是管理程序或其他分区管理代码的组件。 与向导关联的软件代码可以由网络服务器应用程序提供给客户端系统，以使用户能够远程输入定性信息。