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

1. 发明授权

US07831569B2 Preserving a query plan cache 有权
标题翻译：保留查询计划缓存
公开(公告)号：US07831569B2
公开(公告)日：2010-11-09
申请号：US11870118
申请日：2007-10-10
申请人： Robert Joseph Bestgen , Shantan Kethireddy , John Matthew Santosuosso
发明人： Robert Joseph Bestgen , Shantan Kethireddy , John Matthew Santosuosso
IPC分类号： G06F7/00
CPC分类号： G06F11/2097 , G06F11/2071 , G06F11/3476 , G06F17/30306
摘要： A method, apparatus, and program product are provided for preserving a query plan cache on a backup system having a dataspace containing a copy of data and a copy of a query plan cache from a production system. An update is initiated of at least a portion of the copy of the data on the backup system with a portion of the data on the production system. A merge is initiated of updated query plans in the query plan cache from the production system with corresponding query plans in the copy of the query plan cache on the backup system. Objects are correlated in the updated query plans in the copy of the query plan cache with the updated copy of the data on the backup system.
摘要翻译：提供了一种方法，装置和程序产品，用于在备份系统上保留查询计划缓存，该备份系统具有包含来自生产系统的数据副本和查询计划缓存副本的数据空间。在备份系统上的数据的副本的至少一部分的一个更新是在生产系统上的一部分数据发起的。在生产系统的查询计划缓存中启动更新的查询计划的合并，并在备份系统上的查询计划缓存的副本中具有对应的查询计划。对象在查询计划缓存的副本中的更新的查询计划中与备份系统上更新的数据副本相关联。

2. 发明申请

US20090100114A1 Preserving a Query Plan Cache 有权
标题翻译：保留查询计划缓存
公开(公告)号：US20090100114A1
公开(公告)日：2009-04-16
申请号：US11870118
申请日：2007-10-10
申请人： Robert Joseph Bestgen , Shantan Kethireddy , John Matthew Santosuosso
发明人： Robert Joseph Bestgen , Shantan Kethireddy , John Matthew Santosuosso
IPC分类号： G06F17/30
CPC分类号： G06F11/2097 , G06F11/2071 , G06F11/3476 , G06F17/30306
摘要： A method, apparatus, and program product are provided for preserving a query plan cache on a backup system having a dataspace containing a copy of data and a copy of a query plan cache from a production system. An update is initiated of at least a portion of the copy of the data on the backup system with a portion of the data on the production system. A merge is initiated of updated query plans in the query plan cache from the production system with corresponding query plans in the copy of the query plan cache on the backup system. Objects are correlated in the updated query plans in the copy of the query plan cache with the updated copy of the data on the backup system.
摘要翻译：提供了一种方法，装置和程序产品，用于在备份系统上保留查询计划缓存，该备份系统具有包含来自生产系统的数据副本和查询计划缓存副本的数据空间。在备份系统上的数据的副本的至少一部分的一个更新是在生产系统上的一部分数据发起的。在生产系统的查询计划缓存中启动更新的查询计划的合并，并在备份系统上的查询计划缓存的副本中具有对应的查询计划。对象在查询计划缓存的副本中的更新的查询计划中与备份系统上更新的数据副本相关联。

3. 发明授权

US08935231B2 Optimizing a query to a partitioned database table using a virtual maintained temporary index that spans multiple database partitions 有权
标题翻译：使用跨多个数据库分区的虚拟维护临时索引来优化对分区数据库表的查询
公开(公告)号：US08935231B2
公开(公告)日：2015-01-13
申请号：US12120582
申请日：2008-05-14
申请人： Robert Joseph Bestgen , Robert Victor Downer , Shantan Kethireddy
发明人： Robert Joseph Bestgen , Robert Victor Downer , Shantan Kethireddy
IPC分类号： G06F17/30
CPC分类号： G06F17/30327
摘要： A query optimizer optimizes a query to a partitioned database table by determining common characteristics of the partitions and generating a virtual maintained temporary index that spans multiple partitions. Using the virtual maintained temporary index allows the query optimizer to generate an access plan based on the virtual maintained temporary index, which relieves the optimizer from having to individually optimize access to each partition for partitions that share common characteristics.
摘要翻译：查询优化器通过确定分区的共同特征并生成跨多个分区的虚拟维护临时索引来优化对分区数据库表的查询。使用虚拟维护的临时索引允许查询优化器基于虚拟维护的临时索引生成访问计划，这减轻了优化器必须单独优化对共享共同特征的分区的每个分区的访问。

4. 发明授权

US08452756B2 Database execution detail repository 失效
标题翻译：数据库执行详细信息库
公开(公告)号：US08452756B2
公开(公告)日：2013-05-28
申请号：US11558104
申请日：2006-11-09
申请人： Mark John Anderson , Robert Joseph Bestgen , Daniel E. Beuch , Curtis Neal Boger , James Michael Flanagan , Scott Forstie , Shantan Kethireddy , Thomas Owen McKinley , Michael Donald Pfeifer
发明人： Mark John Anderson , Robert Joseph Bestgen , Daniel E. Beuch , Curtis Neal Boger , James Michael Flanagan , Scott Forstie , Shantan Kethireddy , Thomas Owen McKinley , Michael Donald Pfeifer
IPC分类号： G06F17/30 , G06F15/16
CPC分类号： G06F17/30471 , G06F17/30306
摘要： A database query optimizer includes an access plan storage mechanism that stores execution detail corresponding to a query statement in an access plan cache. By storing execution detail in the access plan cache along with the query statement, the execution detail is available when needed to debug database problems, even after a problem occurs. The execution detail stored in the access plan cache may be mined and analyzed after-the-fact, producing a very powerful tool for debugging database problems. Snapshots of the execution detail may also be created by a user. In addition, the user may setup autonomic snapshots and comparisons so that a user may be alerted from a degradation in database performance between two snapshots.
摘要翻译：数据库查询优化器包括访问计划存储机制，其存储与访问计划高速缓存中的查询语句相对应的执行细节。通过将访问计划高速缓存中的执行详细信息与查询语句一起存储，即使在发生问题后仍需要调试数据库问题，执行细节就可用。存储在访问计划缓存中的执行细节可以在事后进行挖掘和分析，为调试数据库问题提供了非常强大的工具。执行细节的快照也可以由用户创建。此外，用户可以设置自主快照和比较，使得可以从两个快照之间的数据库性能的降级中提醒用户。

5. 发明授权

US07734615B2 Performance data for query optimization of database partitions 有权
标题翻译：数据库分区查询优化的性能数据
公开(公告)号：US07734615B2
公开(公告)日：2010-06-08
申请号：US11138832
申请日：2005-05-26
申请人： Mark John Anderson , Robert Joseph Bestgen , Shantan Kethireddy , Jeffrey Wayne Tenner
发明人： Mark John Anderson , Robert Joseph Bestgen , Shantan Kethireddy , Jeffrey Wayne Tenner
IPC分类号： G06F17/30
CPC分类号： G06F17/30312
摘要： A method, apparatus, system, and signal-bearing medium that, in an embodiment, determine performance data for query optimization of a query directed to a database table having multiple partitions. The performance data for the query optimization is presented in a user interface, and an option is provided in the user interface to create a non-spanning index for any of the partitions mentioned in the performance data. In various embodiments, determining the performance data may include: determining the partitions that were unexpanded by the query optimization, determining the partitions that had a runtime estimate that was different from an actual query runtime by a threshold, determining whether any of the partitions had expansion forced by a client request, determining whether the query performed partition elimination, determining whether any of the partitions has an associated index that is unused by the query and that also has a key that is not present in all of the partitions, and determining a constraint for partition elimination.
摘要翻译：一种方法，装置，系统和信号承载介质，其在一个实施例中确定用于针对具有多个分区的数据库表的查询的查询优化的性能数据。查询优化的性能数据在用户界面中呈现，并且在用户界面中提供了一个选项，以便为演奏数据中提到的任何分区创建非跨度索引。在各种实施例中，确定性能数据可以包括：确定由查询优化未展开的分区，将具有与实际查询运行时间不同的运行时间估计的分区确定为阈值，确定是否有任何分区具有扩展通过客户端请求强制，确定查询是否执行分区消除，确定任何分区是否具有由查询未使用的关联索引，并且还具有不存在于所有分区中的密钥，以及确定约束用于分区消除。

6. 发明申请

US20080114718A1 APPARATUS AND METHOD FOR DATABASE EXECUTION DETAIL REPOSITORY 失效
标题翻译：数据库执行细节报告的装置和方法
公开(公告)号：US20080114718A1
公开(公告)日：2008-05-15
申请号：US11558104
申请日：2006-11-09
申请人： Mark John Anderson , Robert Joseph Bestgen , Daniel E. Beuch , Curtis Neal Boger , James Michael Flanagan , Scott Forstie , Shantan Kethireddy , Thomas Owen McKinley , Michael Donald Pfeifer
发明人： Mark John Anderson , Robert Joseph Bestgen , Daniel E. Beuch , Curtis Neal Boger , James Michael Flanagan , Scott Forstie , Shantan Kethireddy , Thomas Owen McKinley , Michael Donald Pfeifer
IPC分类号： G06F17/30
CPC分类号： G06F17/30471 , G06F17/30306
摘要： A database query optimizer includes an access plan storage mechanism that stores execution detail corresponding to a query statement in an access plan cache. By storing execution detail in the access plan cache along with the query statement, the execution detail is available when needed to debug database problems, even after a problem occurs. The execution detail stored in the access plan cache may be mined and analyzed after-the-fact, producing a very powerful tool for debugging database problems. Snapshots of the execution detail may also be created by a user. In addition, the user may setup autonomic snapshots and comparisons so that a user may be alerted from a degradation in database performance between two snapshots.
摘要翻译：数据库查询优化器包括访问计划存储机制，其存储与访问计划高速缓存中的查询语句相对应的执行细节。通过将访问计划高速缓存中的执行详细信息与查询语句一起存储，即使在发生问题后仍需要调试数据库问题，执行细节就可用。存储在访问计划缓存中的执行细节可以在事后进行挖掘和分析，为调试数据库问题提供了非常强大的工具。执行细节的快照也可以由用户创建。此外，用户可以设置自主快照和比较，使得可以从两个快照之间的数据库性能的降级中提醒用户。

7. 发明授权

US07958158B2 Aggregating database queries 失效
标题翻译：聚合数据库查询
公开(公告)号：US07958158B2
公开(公告)日：2011-06-07
申请号：US12142182
申请日：2008-06-19
申请人： Robert Joseph Bestgen , Wei Hu , Shantan Kethireddy , Andrew Peter Passe , Ulrich Thiemann
发明人： Robert Joseph Bestgen , Wei Hu , Shantan Kethireddy , Andrew Peter Passe , Ulrich Thiemann
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可能接收到的其他查询。所接收的查询可以被分段以用预测的查询进行调度。通过聚合要执行的查询，可以优化对每个硬盘驱动器的访问，从而降低执行查询所需的总体能量消耗。

8. 发明申请

US20090319475A1 Grouping Predicted Database Queries 失效
标题翻译：分组预测数据库查询
公开(公告)号：US20090319475A1
公开(公告)日：2009-12-24
申请号：US12142206
申请日：2008-06-19
申请人： Robert Joseph Bestgen , Wei Hu , Shantan Kethireddy , Andrew Peter Passe , Ulrich Thiemann
发明人： Robert Joseph Bestgen , Wei Hu , Shantan Kethireddy , Andrew Peter Passe , Ulrich Thiemann
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可能接收到的其他查询。所接收的查询可以被分段以用预测的查询进行调度。通过聚合要执行的查询，可以优化对每个硬盘驱动器的访问，从而降低执行查询所需的总体能量消耗。

9. 发明申请

US20090319474A1 Aggregating Database Queries 失效
标题翻译：聚合数据库查询
公开(公告)号：US20090319474A1
公开(公告)日：2009-12-24
申请号：US12142182
申请日：2008-06-19
申请人： Robert Joseph Bestgen , Wei Hu , Shantan Kethireddy , Andrew Peter Passe , Ulrich Thiemann
发明人： Robert Joseph Bestgen , Wei Hu , Shantan Kethireddy , Andrew Peter Passe , Ulrich Thiemann
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可能接收到的其他查询。所接收的查询可以被分段以用预测的查询进行调度。通过聚合要执行的查询，可以优化对每个硬盘驱动器的访问，从而降低执行查询所需的总体能量消耗。

10. 发明申请

US20090144307A1 Performing Hierarchical Aggregate Compression 审中-公开
标题翻译：执行层次聚合压缩
公开(公告)号：US20090144307A1
公开(公告)日：2009-06-04
申请号：US11946945
申请日：2007-11-29
申请人： Robert Joseph Bestgen , David Glenn Carlson , Robert Victor Downer , Shantan Kethireddy
发明人： Robert Joseph Bestgen , David Glenn Carlson , Robert Victor Downer , Shantan Kethireddy
IPC分类号： G06F17/30
CPC分类号： G06F16/24556
摘要： Methods, systems, and computer program products are provided for executing database rollup queries. Methods can include iterating through a database table which has been grouped and ordered on the different columns which are in the ROLLUP clause. In some embodiments, a GROUP BY ROLLUP construct can be executed while only requiring an additional one storage location per ordered column per each aggregate function to be performed on each database row. The higher level aggregate functions can be executed without relying on accessing any lower level aggregate results in some embodiments. A suitably grouped and ordered database table can have a multiple level hierarchical ROLLUP function executed in a single pass without having to retrieve lower level aggregate results.
摘要翻译：提供方法，系统和计算机程序产品用于执行数据库汇总查询。方法可以包括遍历已经在ROLLUP子句中的不同列上分组和排序的数据库表。在一些实施例中，可以执行GROUP BY ROLLUP构造，同时仅在每个数据库行上执行每个聚合函数需要每个排序列的附加一个存储位置。在一些实施例中，可以不依赖于访问任何较低级别的聚合结果来执行较高级别的聚合函数。适当分组和排序的数据库表可以具有在单次通过中执行的多级分层ROLLUP功能，而不必检索较低级别的聚合结果。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式