-
1.发明申请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.
摘要翻译： 设备，程序产品和方法识别表中的值范围，并建议在所识别的值范围内生成维护的索引。 此外，还提供了确定值的范围并生成维护的临时索引的方法。 通过这样做，建议的维护索引可以在列中的值范围内生成，并用于访问表中的数据。
-
2.发明授权公开(公告)号：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.
摘要翻译： 一种优化数据库查询的方法，设备和程序产品。 为数据库查询生成查询计划，其中查询计划包含第一和第二子计划。 检索与第一个子计划相关联并在评估使用第一个子计划的上一个查询的另一个查询计划时生成的缓存优化数据。 使用检索到的优化数据评估第一个子计划的资源成本。 还对第二个分计划进行资源成本评估。 然后基于对第一和第二子计划的资源成本的评估来评估查询计划的资源成本。 基于对资源成本的评估来选择查询计划，并执行计划以生成结果集。
-
公开(公告)号：US20080256024A1
公开(公告)日：2008-10-16
申请号：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.
摘要翻译： 一种优化数据库查询的方法，设备和程序产品。 为数据库查询生成查询计划，其中查询计划包含第一和第二子计划。 检索与第一个子计划相关联并在评估使用第一个子计划的上一个查询的另一个查询计划时生成的缓存优化数据。 使用检索到的优化数据评估第一个子计划的资源成本。 还对第二个分计划进行资源成本评估。 然后基于对第一和第二子计划的资源成本的评估来评估查询计划的资源成本。 基于对资源成本的评估来选择查询计划，并执行计划以生成结果集。
-
公开(公告)号：US07958158B2
公开(公告)日：2011-06-07
申请号：US12142182
申请日：2008-06-19
IPC分类号： G06F7/00
CPC分类号： G06F17/30442 , Y02D10/45
摘要： Embodiments of the invention provide techniques for aggregating database queries for energy efficiency. In one embodiment, queries received by a DBMS are aggregated and staged according to hard-disk drives required for query execution. Each group of queries accessing a given drive may be dispatched for execution together. Further, the queries received by a DBMS may be matched to patterns of previously received queries. The matching patterns may be used to predict other queries which are likely to be received by the DBMS. The received queries may be staged to be dispatched with the predicted queries. By aggregating queries to be executed, access to each hard-disk drive may be optimized, thus reducing the overall energy consumption required for executing the queries.
摘要翻译： 本发明的实施例提供了用于聚合用于能量效率的数据库查询的技术。 在一个实施例中，由DBMS接收的查询根据查询执行所需的硬盘驱动器进行聚合和分段。 可以一起调度访问给定驱动器的每组查询。 此外，由DBMS接收的查询可以与之前接收到的查询的模式相匹配。 匹配模式可用于预测DBMS可能接收到的其他查询。 所接收的查询可以被分段以用预测的查询进行调度。 通过聚合要执行的查询，可以优化对每个硬盘驱动器的访问，从而降低执行查询所需的总体能量消耗。
-
公开(公告)号：US20090319475A1
公开(公告)日：2009-12-24
申请号：US12142206
申请日：2008-06-19
IPC分类号： G06F17/30
CPC分类号： G06F17/30442 , Y02D10/45
摘要： Embodiments of the invention provide techniques for aggregating database queries for energy efficiency. In one embodiment, queries received by a DBMS are aggregated and staged according to hard-disk drives required for query execution. Each group of queries accessing a given drive may be dispatched for execution together. Further, the queries received by a DBMS may be matched to patterns of previously received queries. The matching patterns may be used to predict other queries which are likely to be received by the DBMS. The received queries may be staged to be dispatched with the predicted queries. By aggregating queries to be executed, access to each hard-disk drive may be optimized, thus reducing the overall energy consumption required for executing the queries.
摘要翻译： 本发明的实施例提供了用于聚合用于能量效率的数据库查询的技术。 在一个实施例中，由DBMS接收的查询根据查询执行所需的硬盘驱动器进行聚合和分段。 可以一起调度访问给定驱动器的每组查询。 此外，由DBMS接收的查询可以与之前接收到的查询的模式相匹配。 匹配模式可用于预测DBMS可能接收到的其他查询。 所接收的查询可以被分段以用预测的查询进行调度。 通过聚合要执行的查询，可以优化对每个硬盘驱动器的访问，从而降低执行查询所需的总体能量消耗。
-
公开(公告)号：US20090319474A1
公开(公告)日：2009-12-24
申请号：US12142182
申请日：2008-06-19
IPC分类号： G06F17/30
CPC分类号： G06F17/30442 , Y02D10/45
摘要： Embodiments of the invention provide techniques for aggregating database queries for energy efficiency. In one embodiment, queries received by a DBMS are aggregated and staged according to hard-disk drives required for query execution. Each group of queries accessing a given drive may be dispatched for execution together. Further, the queries received by a DBMS may be matched to patterns of previously received queries. The matching patterns may be used to predict other queries which are likely to be received by the DBMS. The received queries may be staged to be dispatched with the predicted queries. By aggregating queries to be executed, access to each hard-disk drive may be optimized, thus reducing the overall energy consumption required for executing the queries.
摘要翻译： 本发明的实施例提供了用于聚合用于能量效率的数据库查询的技术。 在一个实施例中，由DBMS接收的查询根据查询执行所需的硬盘驱动器进行聚合和分段。 可以一起调度访问给定驱动器的每组查询。 此外，由DBMS接收到的查询可以匹配先前接收到的查询的模式。 匹配模式可用于预测DBMS可能接收到的其他查询。 所接收的查询可以被分段以用预测的查询进行调度。 通过聚合要执行的查询，可以优化对每个硬盘驱动器的访问，从而降低执行查询所需的总体能量消耗。
-
公开(公告)号：US07991763B2
公开(公告)日：2011-08-02
申请号：US11735133
申请日：2007-04-13
申请人： Robert Joseph Bestgen , Michael S. Faunce , Wei Hu , Shantan Kethireddy , Andrew Peter Passe , Ulrich Thiemann
发明人： Robert Joseph Bestgen , Michael S. Faunce , Wei Hu , Shantan Kethireddy , Andrew Peter Passe , Ulrich Thiemann
IPC分类号： G06F17/30
CPC分类号： G06F17/30964 , G06F17/30424
摘要： 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.
摘要翻译： 一种优化数据库查询的方法，设备和程序产品。 在具有第一数据空间的第一系统中，为数据库查询生成查询计划。 在具有第二数据空间的第二系统上启动与数据库查询相关联的远程统计信息收集。 远程统计信息收集使用第二个数据空间，其中包含第一个系统上第一个数据空间的至少一部分的当前副本。 通过分析第二个数据空间来收集第一个系统的数据库统计信息，然后将收集的数据库统计信息传递给第一个系统，以便优化由第一个系统执行的数据库查询。
-
公开(公告)号：US20080256025A1
公开(公告)日：2008-10-16
申请号：US11735133
申请日：2007-04-13
申请人： Robert Joseph Bestgen , Michael S. Faunce , Wei Hu , Shantan Kethireddy , Andrew Peter Passe , Ulrich Thiemann
发明人： Robert Joseph Bestgen , Michael S. Faunce , Wei Hu , Shantan Kethireddy , Andrew Peter Passe , Ulrich Thiemann
IPC分类号： G06F17/30
CPC分类号： G06F17/30964 , G06F17/30424
摘要： 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.
摘要翻译： 一种优化数据库查询的方法，设备和程序产品。 在具有第一数据空间的第一系统中，为数据库查询生成查询计划。 在具有第二数据空间的第二系统上启动与数据库查询相关联的远程统计信息收集。 远程统计信息收集使用第二个数据空间，其中包含第一个系统上第一个数据空间的至少一部分的当前副本。 通过分析第二个数据空间来收集第一个系统的数据库统计信息，然后将收集的数据库统计信息传递给第一个系统，以便优化由第一个系统执行的数据库查询。
-
公开(公告)号：US08015202B2
公开(公告)日：2011-09-06
申请号：US12142206
申请日：2008-06-19
IPC分类号： G06F7/00
CPC分类号： G06F17/30442 , Y02D10/45
摘要： Embodiments of the invention provide techniques for aggregating database queries for energy efficiency. In one embodiment, queries received by a DBMS are aggregated and staged according to hard-disk drives required for query execution. Each group of queries accessing a given drive may be dispatched for execution together. Further, the queries received by a DBMS may be matched to patterns of previously received queries. The matching patterns may be used to predict other queries which are likely to be received by the DBMS. The received queries may be staged to be dispatched with the predicted queries. By aggregating queries to be executed, access to each hard-disk drive may be optimized, thus reducing the overall energy consumption required for executing the queries.
摘要翻译： 本发明的实施例提供了用于聚合用于能量效率的数据库查询的技术。 在一个实施例中，由DBMS接收的查询根据查询执行所需的硬盘驱动器进行聚合和分段。 可以一起调度访问给定驱动器的每组查询。 此外，由DBMS接收到的查询可以匹配先前接收到的查询的模式。 匹配模式可用于预测DBMS可能接收到的其他查询。 所接收的查询可以被分段以用预测的查询进行调度。 通过聚合要执行的查询，可以优化对每个硬盘驱动器的访问，从而降低执行查询所需的总体能量消耗。
-
公开(公告)号：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.
摘要翻译： 这是用于优化数据库查询的新方法的示例，其使用异步任务，其通过直接接口现有的存储管理系统来保持数据库对象的最新状态。 这个异步任务结合查询计划和缓存数据能够帮助检测和选择“热”查询成本核算替代方案。 异步任务的冷/暖状态信息有助于查询优化器确定：是否适合对新查询优化使用“热”成本核算; 验证以前的决定以使用“温暖”优化的查询计划，当涉及潜在的重用并再次运行这样的计划时; 决定是否值得在计划缓存中缓存此类计划。
-
-
-
-
-
-
-
-
-
搜索结果
194 条记录 (耗时 0.043 秒)
