-
1.发明授权公开(公告)号：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.
摘要翻译： 一种优化数据库查询的方法，设备和程序产品。 为数据库查询生成查询计划，其中查询计划包含第一和第二子计划。 检索与第一个子计划相关联并在评估使用第一个子计划的上一个查询的另一个查询计划时生成的缓存优化数据。 使用检索到的优化数据评估第一个子计划的资源成本。 还对第二个分计划进行资源成本评估。 然后基于对第一和第二子计划的资源成本的评估来评估查询计划的资源成本。 基于对资源成本的评估来选择查询计划，并执行计划以生成结果集。
-
3.发明申请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.
摘要翻译： 设备，程序产品和方法识别表中的值范围，并建议在所识别的值范围内生成维护的索引。 此外，还提供了确定值的范围并生成维护的临时索引的方法。 通过这样做，建议的维护索引可以在列中的值范围内生成，并用于访问表中的数据。
-
4.发明申请公开(公告)号：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.
摘要翻译： 本发明的实施例提供了用于生成用于优化联合查询的数据库统计的技术。 一般来说，包括数据库列中的值样本的工作集在数据库中持久保留。 要优化联合查询，组合描述联合查询中包含的列的工作集合以生成一个特设工作集。 然后，特设工作集用于生成描述组合列的数据库统计信息。 在另一个实施例中，还可以维护工作集合用于生成用于优化非联合查询的统计信息，从而使统计信息更频繁地刷新。
-
公开(公告)号：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可能接收到的其他查询。 所接收的查询可以被分段以用预测的查询进行调度。 通过聚合要执行的查询，可以优化对每个硬盘驱动器的访问，从而降低执行查询所需的总体能量消耗。
-
公开(公告)号：US20100036805A1
公开(公告)日：2010-02-11
申请号：US12185853
申请日：2008-08-05
申请人： Thomas William Blamer , Wei Hu , Kevin James Kathmann , Shantan Kethireddy , Andrew Peter Passe , Ulrich Thiemann
发明人： Thomas William Blamer , Wei Hu , Kevin James Kathmann , Shantan Kethireddy , Andrew Peter Passe , Ulrich Thiemann
IPC分类号： G06F17/30
CPC分类号： G06F16/24539
摘要： Embodiments of the invention provide techniques for maintaining I/O value caches for database queries. Each maintained cache may be configured for use with a particular database query. Each cache may be persistently maintained in a system, meaning the cache is not automatically deleted after some period of time, and may thus be used to process subsequent instances of the same query. By use of the maintained cache, executing subsequent instances of the query may be avoided, thus saving time and system resources. Further, the maintained cache may be adapted to process other queries having similar characteristics to the initial query. The data included in each cache may be refreshed as required by changes to the underlying data.
摘要翻译： 本发明的实施例提供了用于维护用于数据库查询的I / O值高速缓存的技术。 每个维护的缓存可以被配置为与特定数据库查询一起使用。 每个高速缓存可以被持续地维护在系统中，这意味着高速缓存在一段时间之后不被自动删除，并且因此可以用于处理同一查询的后续实例。 通过使用维护的缓存，可以避免执行后续的查询实例，从而节省时间和系统资源。 此外，维护的高速缓存可以适于处理具有与初始查询相似的特征的其他查询。 每个缓存中包括的数据可以根据底层数据的更改的要求进行刷新。
-
公开(公告)号：US20100036804A1
公开(公告)日：2010-02-11
申请号：US12185844
申请日：2008-08-05
申请人： Thomas William Blamer , Wei Hu , Kevin James Kathmann , Shantan Kethireddy , Andrew Peter Passe , Ulrich Thiemann
发明人： Thomas William Blamer , Wei Hu , Kevin James Kathmann , Shantan Kethireddy , Andrew Peter Passe , Ulrich Thiemann
IPC分类号： G06F17/30
CPC分类号： G06F16/24552
摘要： Embodiments of the invention provide techniques for maintaining I/O value caches for database queries. Each maintained cache may be configured for use with a particular database query. Each cache may be persistently maintained in a system, meaning the cache is not automatically deleted after some period of time, and may thus be used to process subsequent instances of the same query. By use of the maintained cache, executing subsequent instances of the query may be avoided, thus saving time and system resources. Further, the maintained cache may be adapted to process other queries having similar characteristics to the initial query. The data included in each cache may be refreshed as required by changes to the underlying data.
摘要翻译： 本发明的实施例提供了用于维护用于数据库查询的I / O值高速缓存的技术。 每个维护的缓存可以被配置为与特定数据库查询一起使用。 每个高速缓存可以被持续地维护在系统中，这意味着高速缓存在一段时间之后不被自动删除，并且因此可以用于处理同一查询的后续实例。 通过使用维护的缓存，可以避免执行后续的查询实例，从而节省时间和系统资源。 此外，维护的高速缓存可以适于处理具有与初始查询相似的特征的其他查询。 每个缓存中包括的数据可以根据底层数据的更改的要求进行刷新。
-
公开(公告)号：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可能接收到的其他查询。 所接收的查询可以被分段以用预测的查询进行调度。 通过聚合要执行的查询，可以优化对每个硬盘驱动器的访问，从而降低执行查询所需的总体能量消耗。
-
公开(公告)号：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.
摘要翻译： 方法，装置和程序产品在执行数据库查询期间动态地激活和/或停用缓冲器。 动态去激活和激活是基于在用于数据库查询的访问计划的执行期间监视与多个线程的数据消耗相关联的信息。 通过这样做，在优化期间选择较不优化的缓冲器位置可以在运行时期间用更优化的缓冲器位置代替，通常导致改进的查询性能和并行性。
-
-
-
-
-
-
-
-
-
搜索结果
32 条记录 (耗时 0.027 秒)
