专利快速检索-快速检索全球专利，免费商用专利数据库-IPRDB

1. 发明授权

US08832112B2 Encoded matrix index 有权
公开(公告)号：US08832112B2
公开(公告)日：2014-09-09
申请号：US12140816
申请日：2008-06-17
申请人： Robert J. Bestgen , Thomas J. Eggebraaten , Jeffrey W. Tenner
发明人： Robert J. Bestgen , Thomas J. Eggebraaten , Jeffrey W. Tenner
IPC分类号： G06F17/30 , G06F19/28
CPC分类号： G06F17/30324 , G06F19/28
摘要： A method, apparatus, and program product are provided for creating an Encoded Matrix Index for a column in a database table. An element of the column for all rows in the database table is compared to a corresponding reference value in a reference data structure, and in response to at least one value for the element of the column not matching the reference value, indicating a variation in a variation data structure and creating a value data structure. Queries executed using the Encoded Matrix Index include terms associated with a sub-column defined in a column of a database table. The variation data structure is accessed to determine whether any variation exists between rows belonging to a sub-column of the database table. If no variation exists, a value is accessed from the reference data structure; otherwise, a value for each row of the sub-column is accessed from a value data structure.

2. 发明申请

US20090313210A1 ENCODED MATRIX INDEX 有权
标题翻译：编码矩阵索引
公开(公告)号：US20090313210A1
公开(公告)日：2009-12-17
申请号：US12140816
申请日：2008-06-17
申请人： Robert J. Bestgen , Thomas J. Eggebraaten , Jeffrey W. Tenner
发明人： Robert J. Bestgen , Thomas J. Eggebraaten , Jeffrey W. Tenner
IPC分类号： G06F7/06 , G06F17/30
CPC分类号： G06F17/30324 , G06F19/28
摘要： A method, apparatus, and program product are provided for creating an Encoded Matrix Index for a column in a database table. An element of the column for all rows in the database table is compared to a corresponding reference value in a reference data structure, and in response to at least one value for the element of the column not matching the reference value, indicating a variation in a variation data structure and creating a value data structure. Queries executed using the Encoded Matrix Index include terms associated with a sub-column defined in a column of a database table. The variation data structure is accessed to determine whether any variation exists between rows belonging to a sub-column of the database table. If no variation exists, a value is accessed from the reference data structure; otherwise, a value for each row of the sub-column is accessed from a value data structure.
摘要翻译：提供了一种方法，装置和程序产品，用于为数据库表中的列创建编码矩阵索引。将数据库表中所有行的列的元素与参考数据结构中的对应参考值进行比较，并响应于不匹配参考值的列的元素的至少一个值，指示在变化数据结构和创建价值数据结构。使用编码矩阵索引执行的查询包括与数据库表的列中定义的子列相关联的术语。访问变体数据结构以确定属于数据库表的子列的行之间是否存在变化。如果不存在变化，则从参考数据结构访问值; 否则，从值数据结构访问子列的每一行的值。

3. 发明申请

US20120179712A1 ENCODED MATRIX INDEX 有权
标题翻译：编码矩阵索引
公开(公告)号：US20120179712A1
公开(公告)日：2012-07-12
申请号：US13422560
申请日：2012-03-16
申请人： Robert J. Bestgen , Thomas J. Eggebraaten , Jeffrey W. Tenner
发明人： Robert J. Bestgen , Thomas J. Eggebraaten , Jeffrey W. Tenner
IPC分类号： G06F17/30
CPC分类号： G06F17/30324 , G06F19/28
摘要： A method, apparatus, and program product are provided for creating an Encoded Matrix Index for a column in a database table. An element of the column for all rows in the database table is compared to a corresponding reference value in a reference data structure, and in response to at least one value for the element of the column not matching the reference value, indicating a variation in a variation data structure and creating a value data structure. Queries executed using the Encoded Matrix Index include terms associated with a sub-column defined in a column of a database table. The variation data structure is accessed to determine whether any variation exists between rows belonging to a sub-column of the database table. If no variation exists, a value is accessed from the reference data structure; otherwise, a value for each row of the sub-column is accessed from a value data structure.
摘要翻译：提供了一种方法，装置和程序产品，用于为数据库表中的列创建编码矩阵索引。将数据库表中所有行的列的元素与参考数据结构中的对应参考值进行比较，并响应于不匹配参考值的列的元素的至少一个值，指示在变化数据结构和创建价值数据结构。使用编码矩阵索引执行的查询包括与数据库表的列中定义的子列相关联的术语。访问变体数据结构以确定属于数据库表的子列的行之间是否存在变化。如果不存在变化，则从参考数据结构访问值; 否则，从值数据结构访问子列的每一行的值。

4. 发明授权

US08738632B2 Encoded matrix index 有权
标题翻译：编码矩阵索引
公开(公告)号：US08738632B2
公开(公告)日：2014-05-27
申请号：US13422560
申请日：2012-03-16
申请人： Robert J. Bestgen , Thomas J. Eggebraaten , Jeffrey W. Tenner
发明人： Robert J. Bestgen , Thomas J. Eggebraaten , Jeffrey W. Tenner
IPC分类号： G06F17/30
CPC分类号： G06F17/30324 , G06F19/28
摘要： A method, apparatus, and program product are provided for creating an Encoded Matrix Index for a column in a database table. An element of the column for all rows in the database table is compared to a corresponding reference value in a reference data structure, and in response to at least one value for the element of the column not matching the reference value, indicating a variation in a variation data structure and creating a value data structure. Queries executed using the Encoded Matrix Index include terms associated with a sub-column defined in a column of a database table. The variation data structure is accessed to determine whether any variation exists between rows belonging to a sub-column of the database table. If no variation exists, a value is accessed from the reference data structure; otherwise, a value for each row of the sub-column is accessed from a value data structure.
摘要翻译：提供了一种方法，装置和程序产品，用于为数据库表中的列创建编码矩阵索引。将数据库表中所有行的列的元素与参考数据结构中的对应参考值进行比较，并响应于不匹配参考值的列的元素的至少一个值，指示在变化数据结构和创建价值数据结构。使用编码矩阵索引执行的查询包括与数据库表的列中定义的子列相关联的术语。访问变体数据结构以确定属于数据库表的子列的行之间是否存在变化。如果不存在变化，则从参考数据结构访问值; 否则，从值数据结构访问子列的每一行的值。

5. 发明授权

US07937385B2 Obtaining a plan for executing a query in a relational database 失效
标题翻译：获取在关系数据库中执行查询的计划
公开(公告)号：US07937385B2
公开(公告)日：2011-05-03
申请号：US12114913
申请日：2008-05-05
申请人： Robert J. Bestgen , Wei Hu , Shantan Kethireddy , Andrew P. Passe , Ulrich Thiemann
发明人： Robert J. Bestgen , Wei Hu , Shantan Kethireddy , Andrew P. Passe , Ulrich Thiemann
IPC分类号： G06F17/30
CPC分类号： G06F17/3048 , G06F17/30463
摘要： A plan for executing a query in a relational database is obtained. A query for accessing data in the relational database is received. The query specifies N tables in the relational database from which data is to be retrieved. A determination is made whether a syntax of the query matches a syntax of a plan in a plan cache for executing the query. Matches are identified between generic table formats of the N tables specified in the query to generic table formats of N tables specified in the plan responsive to the syntax of the query matching the syntax of a plan in the plan cache for executing the query. The plan for executing the query is obtained based on whether the syntax of the query matches the syntax of the plan and based on identified matches between the generic table formats of the N tables specified in the query to the generic table formats of the N tables specified in the plan.
摘要翻译：获得在关系数据库中执行查询的计划。接收到关系数据库中访问数据的查询。该查询指定要从中检索数据的关系数据库中的N个表。确定查询的语法是否符合用于执行查询的计划高速缓存中的计划的语法。在查询中指定的N个表的通用表格式之间的匹配在计划中指定的N个表的通用表格式中被标识，响应于查询的语法，该查询的语法与计划缓存中用于执行查询的计划的语法相匹配。执行查询的计划是基于查询的语法是否符合计划的语法，并且基于查询中指定的N个表的通用表格格式与指定的N个表的通用表格式之间的所确定的匹配来获得在计划中。

6. 发明申请

US20090282272A1 Organizing Databases for Energy Efficiency 有权
标题翻译：组织能源效率数据库
公开(公告)号：US20090282272A1
公开(公告)日：2009-11-12
申请号：US12117047
申请日：2008-05-08
申请人： Robert J. Bestgen , Wei Hu , Shantan Kethireddy , Andrew P. Passe , Ulrich Thiemann
发明人： Robert J. Bestgen , Wei Hu , Shantan Kethireddy , Andrew P. Passe , Ulrich Thiemann
IPC分类号： G06F1/32
CPC分类号： G06F1/3203 , G06F1/206 , G06F17/30312 , Y02D10/16 , Y02D10/45
摘要： Embodiments of the invention provide techniques for optimizing database queries for energy efficiency. In general, a query optimizer is configured to compare energy requirements of query plans, and to select a query plan requiring minimal energy to execute. In one embodiment, the query optimizer may also compare time performance of the query plans, and may select a query plan by matching to a user preference for a relative priority between energy requirements and time performance.
摘要翻译：本发明的实施例提供了用于优化能量效率的数据库查询的技术。通常，查询优化器被配置为比较查询计划的能量需求，并选择需要最少能量执行的查询计划。在一个实施例中，查询优化器还可以比较查询计划的时间性能，并且可以通过与能量需求和时间性能之间的相对优先级的用户偏好匹配来选择查询计划。

7. 发明申请

US20080168427A1 Code Path Tracking 有权
标题翻译：代码路径跟踪
公开(公告)号：US20080168427A1
公开(公告)日：2008-07-10
申请号：US11621666
申请日：2007-01-10
申请人： Robert J. Bestgen , Robert D. Driesch , Wei Hu , Shantan Kethireddy , Edward J. Miller , Andrew P. Passe , Ulrich Thiemann
发明人： Robert J. Bestgen , Robert D. Driesch , Wei Hu , Shantan Kethireddy , Edward J. Miller , Andrew P. Passe , Ulrich Thiemann
IPC分类号： G06F9/44
CPC分类号： G06F11/3636 , G06F8/443 , G06F11/3476 , G06F11/3612 , G06F2201/865
摘要： 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.
摘要翻译：提供方法，系统和产品用于代码路径跟踪。实施例包括识别要路径跟踪的软件代码中的仪表化跟踪点; 识别在软件代码中的仪表化跟踪点执行的功能; 识别在仪器化跟踪点执行的功能的参数; 并使用参数记录功能的描述，参数和执行功能的结果。

8. 发明授权

US08214807B2 Code path tracking 有权
标题翻译：代码路径跟踪
公开(公告)号：US08214807B2
公开(公告)日：2012-07-03
申请号：US11621666
申请日：2007-01-10
申请人： Robert J. Bestgen , Robert D. Driesch, Jr. , Wei Hu , Shantan Kethireddy , Edward J. Miller , Andrew P. Passe , Ulrich Thiemann
发明人： Robert J. Bestgen , Robert D. Driesch, Jr. , Wei Hu , Shantan Kethireddy , Edward J. Miller , Andrew P. Passe , Ulrich Thiemann
IPC分类号： G06F9/44
CPC分类号： G06F11/3636 , G06F8/443 , G06F11/3476 , G06F11/3612 , G06F2201/865
摘要： 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.
摘要翻译：提供方法，系统和产品用于代码路径跟踪。实施例包括识别要路径跟踪的软件代码中的仪表化跟踪点; 识别在软件代码中的仪表化跟踪点执行的功能; 识别在仪器化跟踪点执行的功能的参数; 并使用参数记录功能的描述，参数和执行功能的结果。

9. 发明授权

US08037059B2 Implementing aggregation combination using aggregate depth lists and cube aggregation conversion to rollup aggregation for optimizing query processing 失效
标题翻译：使用聚合深度列表和多维数据集聚合转换实现聚合组合以进行汇总聚合，以优化查询处理
公开(公告)号：US08037059B2
公开(公告)日：2011-10-11
申请号：US12113259
申请日：2008-05-01
申请人： Robert J. Bestgen , David G. Carlson , Robert V. Downer , Shantan Kethireddy
发明人： Robert J. Bestgen , David G. Carlson , Robert V. Downer , Shantan Kethireddy
IPC分类号： G06F17/30
CPC分类号： G06F17/30442 , Y10S707/99931 , Y10S707/99933 , Y10S707/99935
摘要： A process combines multiple grouping sets into single rollup sets with depth lists defining the levels of grouping that must be performed. Grouping sets are identified that are contained within other sets and combined into single rollups with depth lists. Cube aggregation conversion to rollup aggregation is provided for optimizing database query processing. Natural sets of rollup hierarchies within a cube are recognized and the cube is converted into those rollup hierarchies. Once converted, the rollup aggregation is performed to significantly reduce required processing.
摘要翻译：一个进程将多个分组集合组合成单个汇总集合，其深度列表定义必须执行的分组级别。识别分组集合，其包含在其他集合中，并且与深度列表组合成单个汇总。提供了多维数据集汇总转换为汇总汇总，用于优化数据库查询处理。多维数据集中的自然集合层次结构被识别，并将多维数据集转换为这些汇总层次结构。一旦转换，执行汇总汇总以显着减少所需的处理。

10. 发明申请

US20110137890A1 Join Order for a Database Query 失效
标题翻译：加入订单数据库查询
公开(公告)号：US20110137890A1
公开(公告)日：2011-06-09
申请号：US12630950
申请日：2009-12-04
申请人： Robert J. Bestgen , Robert V. Downer , Brian R. Muras
发明人： Robert J. Bestgen , Robert V. Downer , Brian R. Muras
IPC分类号： G06F17/30
CPC分类号： G06F17/30466
摘要： In an embodiment, a portion of the execution plan is executed to produce a portion of records in a partial result set. If a first join of a table is performed that eliminates more than a first threshold number of records from the partial result set, a determination is made whether an estimated cost of a forced primary join is less than an estimated cost of a star join. If the estimated cost of the forced primary join is less than the estimated cost of the star join, then the table is moved first in a join order in the execution plan, the portion of the records in the partial result set is discarded, and the execution is re-started with a different portion of the execution plan to produce a different portion of the records.
摘要翻译：在一个实施例中，执行执行计划的一部分以产生部分结果集中的一部分记录。如果执行表的第一次连接，其从部分结果集中消除超过第一阈值数量的记录，则确定强制主连接的估计成本是否小于星形联接的估计成本。如果强制主连接的估计成本小于星形连接的估计成本，则首先在执行计划中以连接顺序移动表，部分结果集中的部分记录将被丢弃，以执行计划的不同部分重新开始执行以产生记录的不同部分。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式