-
公开(公告)号：US09189047B2
公开(公告)日：2015-11-17
申请号：US12117047
申请日：2008-05-08
Applicant: Robert J. Bestgen , Wei Hu , Shantan Kethireddy , Andrew P. Passe , Ulrich Thiemann
Inventor： Robert J. Bestgen , Wei Hu , Shantan Kethireddy , Andrew P. Passe , Ulrich Thiemann
CPC classification number: G06F1/3203 , G06F1/206 , G06F17/30312 , Y02D10/16 , Y02D10/45
Abstract: 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.
Abstract translation: 本发明的实施例提供了用于优化能量效率的数据库查询的技术。 通常，查询优化器被配置为比较查询计划的能量需求，并选择需要最少能量执行的查询计划。 在一个实施例中，查询优化器还可以比较查询计划的时间性能，并且可以通过与能量需求和时间性能之间的相对优先级的用户偏好匹配来选择查询计划。
-
公开(公告)号：US08312007B2
公开(公告)日：2012-11-13
申请号：US12117070
申请日：2008-05-08
Applicant: Robert J. Bestgen , Wei Hu , Shantan Kethireddy , Andrew P. Passe , Ulrich Thiemann
Inventor： Robert J. Bestgen , Wei Hu , Shantan Kethireddy , Andrew P. Passe , Ulrich Thiemann
CPC classification number: G06F17/30463 , Y02D10/45
Abstract: 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.
Abstract translation: 本发明的实施例提供了用于优化能量效率的数据库查询的技术。 通常，查询优化器被配置为比较查询计划的能量需求，并选择需要最少能量执行的查询计划。 在一个实施例中，查询优化器还可以比较查询计划的时间性能，并且可以通过与能量需求和时间性能之间的相对优先级的用户偏好匹配来选择查询计划。
-
公开(公告)号：US20080183684A1
公开(公告)日：2008-07-31
申请号：US11627672
申请日：2007-01-26
Applicant: Robert J. Bestgen , Michael S. Faunce , Wei Hu , Shantan Kethireddy , Andrew P. Passe , Ulrich Thiemann
Inventor： Robert J. Bestgen , Michael S. Faunce , Wei Hu , Shantan Kethireddy , Andrew P. Passe , Ulrich Thiemann
IPC: G06F17/30
CPC classification number: G06F16/24542
Abstract: Methods, apparatus, and products are disclosed for caching an access plan for a query that include: receiving, in a SQL module of a DBMS, a SQL query that specifies data for retrieval from a database, the database characterized by database statistics, the SQL query characterized by one or more host variable values; generating, by the SQL module, an access plan in dependence upon the SQL query; calculating, by the SQL module, a routing code for the SQL query in dependence upon the host variable values of the SQL query and a portion of the database statistics; and storing, by the SQL module, the access plan in an access plan cache, including associating with the access plan the routing code for the SQL query and the portion of the database statistics used to calculate the routing code.
Abstract translation: 公开了用于缓存查询的访问计划的方法，装置和产品，其包括：在DBMS的SQL模块中接收指定用于从数据库检索的数据的SQL查询，数据库统计特征的数据库，SQL 查询由一个或多个主机变量值表征; 由SQL模块生成依赖于SQL查询的访问计划; 根据SQL查询的主机变量值和数据库统计的一部分，由SQL模块计算SQL查询的路由代码; 并且由SQL模块将访问计划存储在访问计划高速缓存中，包括与访问计划关联，用于SQL查询的路由代码和用于计算路由代码的数据库统计信息的部分。
-
公开(公告)号：US20120198423A1
公开(公告)日：2012-08-02
申请号：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
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: 提供方法，系统和产品用于代码路径跟踪。 实施例包括识别要路径跟踪的软件代码中的仪表化跟踪点; 识别在软件代码中的仪表化跟踪点执行的功能; 识别在仪器化跟踪点执行的功能的参数; 并使用参数记录功能的描述，参数和执行功能的结果。
-
公开(公告)号：US07937385B2
公开(公告)日：2011-05-03
申请号：US12114913
申请日：2008-05-05
Applicant: Robert J. Bestgen , Wei Hu , Shantan Kethireddy , Andrew P. Passe , Ulrich Thiemann
Inventor： Robert J. Bestgen , Wei Hu , Shantan Kethireddy , Andrew P. Passe , Ulrich Thiemann
IPC: G06F17/30
CPC classification number: G06F17/3048 , G06F17/30463
Abstract: 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.
Abstract translation: 获得在关系数据库中执行查询的计划。 接收到关系数据库中访问数据的查询。 该查询指定要从中检索数据的关系数据库中的N个表。 确定查询的语法是否符合用于执行查询的计划高速缓存中的计划的语法。 在查询中指定的N个表的通用表格式之间的匹配在计划中指定的N个表的通用表格式中被标识，响应于查询的语法，该查询的语法与计划缓存中用于执行查询的计划的语法相匹配。 执行查询的计划是基于查询的语法是否符合计划的语法，并且基于查询中指定的N个表的通用表格格式与指定的N个表的通用表格式之间的所确定的匹配来获得 在计划中。
-
Patent Agency Ranking
公开(公告)号：US20090282272A1
公开(公告)日：2009-11-12
申请号：US12117047
申请日：2008-05-08
Applicant: Robert J. Bestgen , Wei Hu , Shantan Kethireddy , Andrew P. Passe , Ulrich Thiemann
Inventor： Robert J. Bestgen , Wei Hu , Shantan Kethireddy , Andrew P. Passe , Ulrich Thiemann
IPC: G06F1/32
CPC classification number: G06F1/3203 , G06F1/206 , G06F17/30312 , Y02D10/16 , Y02D10/45
Abstract: 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.
Abstract translation: 本发明的实施例提供了用于优化能量效率的数据库查询的技术。 通常，查询优化器被配置为比较查询计划的能量需求，并选择需要最少能量执行的查询计划。 在一个实施例中，查询优化器还可以比较查询计划的时间性能，并且可以通过与能量需求和时间性能之间的相对优先级的用户偏好匹配来选择查询计划。
-
公开(公告)号：US20080168427A1
公开(公告)日：2008-07-10
申请号：US11621666
申请日：2007-01-10
Applicant: Robert J. Bestgen , Robert D. Driesch , Wei Hu , Shantan Kethireddy , Edward J. Miller , Andrew P. Passe , Ulrich Thiemann
Inventor： Robert J. Bestgen , Robert D. Driesch , Wei Hu , Shantan Kethireddy , Edward J. Miller , Andrew P. Passe , Ulrich Thiemann
IPC: G06F9/44
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: 提供方法，系统和产品用于代码路径跟踪。 实施例包括识别要路径跟踪的软件代码中的仪表化跟踪点; 识别在软件代码中的仪表化跟踪点执行的功能; 识别在仪器化跟踪点执行的功能的参数; 并使用参数记录功能的描述，参数和执行功能的结果。
-
公开(公告)号：US08214807B2
公开(公告)日：2012-07-03
申请号：US11621666
申请日：2007-01-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
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: 提供方法，系统和产品用于代码路径跟踪。 实施例包括识别要路径跟踪的软件代码中的仪表化跟踪点; 识别在软件代码中的仪表化跟踪点执行的功能; 识别在仪器化跟踪点执行的功能的参数; 并使用参数记录功能的描述，参数和执行功能的结果。
-
公开(公告)号：US20090281986A1
公开(公告)日：2009-11-12
申请号：US12117070
申请日：2008-05-08
Applicant: Robert J. Bestgen , Wei Hu , Shantan Kethireddy , Andrew P. Passe , Ulrich Thiemann
Inventor： Robert J. Bestgen , Wei Hu , Shantan Kethireddy , Andrew P. Passe , Ulrich Thiemann
IPC: G06F17/30
CPC classification number: G06F17/30463 , Y02D10/45
Abstract: 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.
Abstract translation: 本发明的实施例提供了用于优化能量效率的数据库查询的技术。 通常，查询优化器被配置为比较查询计划的能量需求，并选择需要最少能量执行的查询计划。 在一个实施例中，查询优化器还可以比较查询计划的时间性能，并且可以通过与能量需求和时间性能之间的相对优先级的用户偏好匹配来选择查询计划。
-
公开(公告)号：US20090276394A1
公开(公告)日：2009-11-05
申请号：US12114913
申请日：2008-05-05
Applicant: Robert J. Bestgen , Wei Hu , Shantan Kethireddy , Andrew P. Passe , Ulrich Thiemann
Inventor： Robert J. Bestgen , Wei Hu , Shantan Kethireddy , Andrew P. Passe , Ulrich Thiemann
IPC: G06F7/06
CPC classification number: G06F17/3048 , G06F17/30463
Abstract: 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.
Abstract translation: 获得在关系数据库中执行查询的计划。 接收到关系数据库中访问数据的查询。 该查询指定要从中检索数据的关系数据库中的N个表。 确定查询的语法是否符合用于执行查询的计划高速缓存中的计划的语法。 在查询中指定的N个表的通用表格式之间的匹配在计划中指定的N个表的通用表格式中被标识，响应于查询的语法，该查询的语法与计划缓存中用于执行查询的计划的语法相匹配。 执行查询的计划是基于查询的语法是否符合计划的语法，并且基于查询中指定的N个表的通用表格格式与指定的N个表的通用表格式之间的所确定的匹配来获得 在计划中。
-
-
-
-
-
-
-
-
-
Search Results
14
records
(took 0.014 seconds)
