-
公开(公告)号：US07523094B1
公开(公告)日：2009-04-21
申请号：US12049343
申请日：2008-03-16
IPC分类号： G06F17/30
CPC分类号： G06F17/30457 , G06F17/30463 , Y10S707/99932 , Y10S707/99933
摘要： This is an example of a new method for optimization of database queries which uses an asynchronous task which keeps the most current status of the database objects by directly interfacing the existing storage management system. This asynchronous task in combination with query plan and cache data is able to aid in detecting and choosing “warm” query costing alternatives. The cold/warm status information of the asynchronous task helps query optimizer to determine: if it is suitable to use “warm” costing for a new query optimization; validate previous decisions to use a “warm”-optimized query plan, when it comes to potentially reuse and run with such a plan again; decide whether it's worthwhile to still cache such a plan in the plan cache.
摘要翻译： 这是用于优化数据库查询的新方法的示例，其使用异步任务，其通过直接接口现有的存储管理系统来保持数据库对象的最新状态。 这个异步任务结合查询计划和缓存数据能够帮助检测和选择“热”查询成本核算替代方案。 异步任务的冷/暖状态信息有助于查询优化器确定：是否适合对新查询优化使用“热”成本核算; 验证以前的决定以使用“温暖”优化的查询计划，当涉及潜在的重用并再次运行这样的计划时; 决定是否值得在计划缓存中缓存此类计划。
-
12.发明申请METHODS, SYSTEMS, AND COMPUTER PROGRAM PRODUCTS FOR USER-DRIVEN TARGETED QUERY RE-OPTIMIZATIONS USING DELTA VALUES 审中-公开方法，系统和计算机程序产品，用于使用DELTA VALUES的用户驱动的目标查询重新优化公开(公告)号：US20090077013A1
公开(公告)日：2009-03-19
申请号：US11857814
申请日：2007-09-19
申请人： Wei Hu , Shantan Kethireddy , Andrew P. Passe , Ulrich Thiemann
发明人： Wei Hu , Shantan Kethireddy , Andrew P. Passe , Ulrich Thiemann
IPC分类号： G06F7/00
CPC分类号： G06F16/24534 , G06F16/217
摘要： A method, system, and computer program product for user-driven targeted query re-optimizations using delta values are provided. The method includes displaying a query tree for a query via a graphical user interface (GUI), where the query tree includes a plurality of interconnected nodes in a tree structure, and outputting a delta value as a difference between an estimated and an actual performance metric of query execution. The method also includes receiving a request to provide alternative execution plans for a subtree of a selected node of the query tree, and displaying at least one alternative execution plan description for the subtree of the selected node. The method further includes receiving a re-optimization request for a user selected alternative execution plan description, and displaying a re-optimized query tree resulting from the re-optimization request.
摘要翻译： 提供了一种使用增量值进行用户驱动的目标查询重新优化的方法，系统和计算机程序产品。 该方法包括通过图形用户界面（GUI）显示用于查询的查询树，其中查询树包括树形结构中的多个互连节点，并且输出增量值作为估计和实际性能度量之间的差值 的查询执行。 该方法还包括接收对查询树的所选节点的子树提供替代执行计划的请求，以及显示所选节点的子树的至少一个备选执行计划描述。 该方法还包括接收对用户选择的替代执行计划描述的重新优化请求，以及显示由重新优化请求产生的重新优化的查询树。
-
13.发明申请Advising the generation of a maintained index over a subset of values in a column of a table 审中-公开建议在表的列中的值子集上生成维护的索引公开(公告)号：US20080091642A1
公开(公告)日：2008-04-17
申请号：US11548958
申请日：2006-10-12
申请人： Robert Joseph Bestgen , Robert Victor Downer , Wei Hu , Shantan Kethireddy , Andrew Peter Passe , Ulrich Thiemann
发明人： Robert Joseph Bestgen , Robert Victor Downer , Wei Hu , Shantan Kethireddy , Andrew Peter Passe , Ulrich Thiemann
IPC分类号： G06F17/30
CPC分类号： G06F16/24534
摘要： An apparatus, program product and method identify a range of values in a table and advise the generation of a maintained index over the identified range of values. Additionally, a method that determines a range of values and generates a maintained temporary index is also provided. By doing so, the maintained index that was advised may be generated over the range of values in the column and used to access data in the table.
摘要翻译： 设备，程序产品和方法识别表中的值范围，并建议在所识别的值范围内生成维护的索引。 此外，还提供了确定值的范围并生成维护的临时索引的方法。 通过这样做，建议的维护索引可以在列中的值范围内生成，并用于访问表中的数据。
-
公开(公告)号：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.
摘要翻译： 提供方法，系统和产品用于代码路径跟踪。 实施例包括识别要路径跟踪的软件代码中的仪表化跟踪点; 识别在软件代码中的仪表化跟踪点执行的功能; 识别在仪器化跟踪点执行的功能的参数; 并使用参数记录功能的描述，参数和执行功能的结果。
-
公开(公告)号：US20090281986A1
公开(公告)日：2009-11-12
申请号：US12117070
申请日：2008-05-08
IPC分类号： G06F17/30
CPC分类号： G06F17/30463 , 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.
摘要翻译： 本发明的实施例提供了用于优化能量效率的数据库查询的技术。 通常，查询优化器被配置为比较查询计划的能量需求，并选择需要最少能量执行的查询计划。 在一个实施例中，查询优化器还可以比较查询计划的时间性能，并且可以通过与能量需求和时间性能之间的相对优先级的用户偏好匹配来选择查询计划。
-
公开(公告)号：US20090276394A1
公开(公告)日：2009-11-05
申请号：US12114913
申请日：2008-05-05
IPC分类号： G06F7/06
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个表的通用表格式之间的所确定的匹配来获得 在计划中。
-
17.发明申请公开(公告)号：US20080301085A1
公开(公告)日：2008-12-04
申请号：US11755954
申请日：2007-05-31
IPC分类号： G06F7/00
CPC分类号： G06F16/24544
摘要： Embodiments of the invention provide techniques for generating database statistics for optimizing union queries. In general, working sets including samples of values in database columns are persistently maintained in a database. To optimize a union query, the working sets describing the columns included in the union query are combined to generate an ad hoc working set. The ad hoc working set is then used to generate a database statistic describing the combined columns. In another embodiment, working sets may also be maintained for generating statistics for optimizing non-union queries, thus enabling statistics to be refreshed more frequently.
摘要翻译： 本发明的实施例提供了用于生成用于优化联合查询的数据库统计的技术。 一般来说，包括数据库列中的值样本的工作集在数据库中持久保留。 要优化联合查询，组合描述联合查询中包含的列的工作集合以生成一个特设工作集。 然后，特设工作集用于生成描述组合列的数据库统计信息。 在另一个实施例中，还可以维护工作集合用于生成用于优化非联合查询的统计信息，从而使统计信息更频繁地刷新。
-
公开(公告)号：US09189047B2
公开(公告)日：2015-11-17
申请号：US12117047
申请日：2008-05-08
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.
摘要翻译： 本发明的实施例提供了用于优化能量效率的数据库查询的技术。 通常，查询优化器被配置为比较查询计划的能量需求，并选择需要最少能量执行的查询计划。 在一个实施例中，查询优化器还可以比较查询计划的时间性能，并且可以通过与能量需求和时间性能之间的相对优先级的用户偏好匹配来选择查询计划。
-
19.发明授权公开(公告)号：US08126873B2
公开(公告)日：2012-02-28
申请号：US11735095
申请日：2007-04-13
IPC分类号： G06F17/30
CPC分类号： G06F17/30463
摘要： 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.
摘要翻译： 一种优化数据库查询的方法，设备和程序产品。 为数据库查询生成查询计划，其中查询计划包含第一和第二子计划。 检索与第一个子计划相关联并在评估使用第一个子计划的上一个查询的另一个查询计划时生成的缓存优化数据。 使用检索到的优化数据评估第一个子计划的资源成本。 还对第二个分计划进行资源成本评估。 然后基于对第一和第二子计划的资源成本的评估来评估查询计划的资源成本。 基于对资源成本的评估来选择查询计划，并执行计划以生成结果集。
-
公开(公告)号：US08082265B2
公开(公告)日：2011-12-20
申请号：US12056344
申请日：2008-03-27
申请人： David Glenn Carlson , Wei Hu , Kevin James Kathmann , Shantan Kethireddy , Andrew Peter Passe , Ulrich Thiemann
发明人： David Glenn Carlson , Wei Hu , Kevin James Kathmann , Shantan Kethireddy , Andrew Peter Passe , Ulrich Thiemann
IPC分类号： G06F7/00
CPC分类号： G06F17/30474 , G06F17/30445 , G06F17/30457 , G06F17/30466
摘要： A method, apparatus and program product dynamically activate and/or deactivate buffers during execution of a database query. The dynamic deactivation and activation is based on the monitoring of information associated with the consumption of data by a plurality of threads during execution of an access plan for the database query. By doing so, the selection of a less optimal buffer position during optimization may be replaced with a more optimal buffer position during runtime, often resulting in improved query performance and parallelism.
摘要翻译： 方法，装置和程序产品在执行数据库查询期间动态地激活和/或停用缓冲器。 动态去激活和激活是基于在用于数据库查询的访问计划的执行期间监视与多个线程的数据消耗相关联的信息。 通过这样做，在优化期间选择较不优化的缓冲器位置可以在运行时期间用更优化的缓冲器位置代替，通常导致改进的查询性能和并行性。
-
-
-
-
-
-
-
-
-
搜索结果
33 条记录 (耗时 0.015 秒)
