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

31. 发明申请

US20070250517A1 Method and Apparatus for Autonomically Maintaining Latent Auxiliary Database Structures for Use in Executing Database Queries 审中-公开
标题翻译：用于自动维护潜在辅助数据库结构的方法和装置，用于执行数据库查询
公开(公告)号：US20070250517A1
公开(公告)日：2007-10-25
申请号：US11379503
申请日：2006-04-20
申请人： Robert Bestgen , Curtis Boger , David Carlson , Robert Downer , Steven Hoeschen , Kevin Kathmann , Shantan Kethireddy
发明人： Robert Bestgen , Curtis Boger , David Carlson , Robert Downer , Steven Hoeschen , Kevin Kathmann , Shantan Kethireddy
IPC分类号： G06F7/00
CPC分类号： G06F16/24539 , G06F16/22 , G06F16/2454 , G06F16/24561
摘要： A latent auxiliary database structure constructed for executing a query is automatically saved for reuse in subsequent query execution instances. The latent auxiliary database structure is not maintained concurrently with changes to records in the database tables. If a query execution strategy is subsequently invoked which uses the latent auxiliary database structure, a determination is made dynamically whether to update the previously saved latent structure from database changes recorded in one or more change logs, or to rebuild the latent structure from scratch. Where the cost of updating from the change log is deemed less than the cost of a rebuild from scratch, the previously saved latent structure is updated from the log.
摘要翻译：构建用于执行查询的潜在辅助数据库结构将自动保存，以便在后续查询执行实例中重用。潜在辅助数据库结构与数据库表中记录的更改不同时维护。如果随后调用使用潜在辅助数据库结构的查询执行策略，则动态确定是否从先前保存的潜在结构更新记录在一个或多个更改日志中的数据库更改，或从头重新构建潜在结构。在从更改日志更新成本被认为小于从头开始重建的成本的情况下，先前保存的潜在结构将从日志中更新。

32. 发明申请

US20070226176A1 Apparatus and method for optimizing a query to a partitioned database table using a virtual maintained temporary index that spans multiple database partitions 审中-公开
标题翻译：使用跨多个数据库分区的虚拟维护临时索引来优化对分区数据库表的查询的装置和方法
公开(公告)号：US20070226176A1
公开(公告)日：2007-09-27
申请号：US11388004
申请日：2006-03-23
申请人： Robert Bestgen , Robert Downer , Shantan Kethireddy
发明人： Robert Bestgen , Robert Downer , Shantan Kethireddy
IPC分类号： G06F17/30
CPC分类号： G06F16/2246
摘要： 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.
摘要翻译：查询优化器通过确定分区的共同特征并生成跨多个分区的虚拟维护临时索引来优化对分区数据库表的查询。使用虚拟维护的临时索引允许查询优化器基于虚拟维护的临时索引生成访问计划，这减轻了优化器必须单独优化对共享共同特征的分区的每个分区的访问。

33. 发明申请

US20060095406A1 Displaying explain data for a SQL query of a database 审中-公开
标题翻译：显示数据库的SQL查询的说明数据
公开(公告)号：US20060095406A1
公开(公告)日：2006-05-04
申请号：US10977801
申请日：2004-10-29
申请人： Robert Bestgen , Shantan Kethireddy , Michael Pfeifer
发明人： Robert Bestgen , Shantan Kethireddy , Michael Pfeifer
IPC分类号： G06F17/30
CPC分类号： G06F16/217 , G06F16/24547
摘要： Enabling a user to obtain and view graphic explain data with no need to activate a monitor and no need to wait for a job to complete before the explain data for a query may be viewed. Displaying explain data for an SQL query of a database that include executing an SQL query and displaying explain data for the SQL query while executing the SQL query. Displaying explain data includes identifying an access plan associated with the SQL query and generating explain data in dependence upon the access plan. Identifying an access plan may be carried out by retrieving an access plan identification from a cursor of a job control block and retrieving an access plan from an access plan cache in dependence upon the access plan identification.
摘要翻译：允许用户获取和查看图形说明数据，无需激活监视器，无需等待作业完成，才能查看查询的说明数据。显示数据库的SQL查询的解释数据，其中包括执行SQL查询并在执行SQL查询时显示SQL查询的说明数据。显示说明数据包括识别与SQL查询相关联的访问计划，并根据访问计划生成说明数据。识别访问计划可以通过从作业控制块的光标检索访问计划标识并且根据访问计划标识从访问计划高速缓存检索访问计划来执行访问计划。

34. 发明授权

US09411861B2 Multiple result sets generated from single pass through a dataspace 有权
标题翻译：从单次通过数据空间生成的多个结果集
公开(公告)号：US09411861B2
公开(公告)日：2016-08-09
申请号：US11962980
申请日：2007-12-21
申请人： 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分类号： G06F17/30545
摘要： A method, apparatus and program product are provided for performing a query of a database. A database query is received, which includes first and second operations respectively configured to generate first and second disjoint results sets from a dataspace. The database query is analyzed to identify a set of attributes from the dataspace that are used by at least one of the first and second operations in the database query. During execution of the database query, a plurality of records from the dataspace is iteratively processed in a single pass, including, for each of the plurality of records, processing such record by retrieving the plurality of attributes for such record from the dataspace and performing each of the first and second operations on the record using the retrieved attributes for such record to build the first and second disjoint results sets.
摘要翻译：提供了一种用于执行数据库查询的方法，装置和程序产品。接收到数据库查询，其包括分别被配置为从数据空间生成第一和第二不相交结果集的第一和第二操作。分析数据库查询以从数据库空间识别由数据库查询中的第一和第二操作中的至少一个使用的一组属性。在执行数据库查询期间，来自数据空间的多个记录在单次传递中被迭代地处理，包括对于多个记录中的每一个记录，通过从数据空间检索这样的记录的多个属性并且执行每个记录使用检索到的这种记录的属性来构建第一和第二不相交结果集的记录上的第一和第二操作。

35. 发明授权

US09189047B2 Organizing databases for energy efficiency 有权
标题翻译：组织能源效率数据库
公开(公告)号：US09189047B2
公开(公告)日：2015-11-17
申请号：US12117047
申请日：2008-05-08
申请人： Robert J. Bestgen , Wei Hu , Shantan Kethireddy , Andrew P. Passe , Ulrich Thiemann
发明人： Robert J. Bestgen , Wei Hu , Shantan Kethireddy , Andrew P. Passe , Ulrich Thiemann
IPC分类号： G06F17/30 , G06F1/32 , G06F1/20
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.
摘要翻译：本发明的实施例提供了用于优化能量效率的数据库查询的技术。通常，查询优化器被配置为比较查询计划的能量需求，并选择需要最少能量执行的查询计划。在一个实施例中，查询优化器还可以比较查询计划的时间性能，并且可以通过与能量需求和时间性能之间的相对优先级的用户偏好匹配来选择查询计划。

36. 发明授权

US08386463B2 Method and apparatus for dynamically associating different query execution strategies with selective portions of a database table 失效
标题翻译：用于将不同查询执行策略与数据库表的选择性部分动态关联的方法和装置
公开(公告)号：US08386463B2
公开(公告)日：2013-02-26
申请号：US11181713
申请日：2005-07-14
申请人： Robert Joseph Bestgen , Shantan Kethireddy , Jeffrey Wayne Tenner
发明人： Robert Joseph Bestgen , Shantan Kethireddy , Jeffrey Wayne Tenner
IPC分类号： G06F11/30
CPC分类号： G06F17/3053 , G06F17/30545
摘要： A query facility for database queries dynamically determines whether selective portions of a database table are likely to benefit from separate query execution strategies, and constructs an appropriate separate execution strategies accordingly. Preferably, the database contains at least one relatively large table comprising multiple partitions, each sharing the definitional structure of the table and containing a different respective discrete subset of the table records. The query facility compares metadata for different partitions to determine whether sufficiently large differences exist among the partitions, and in appropriate cases selects one or more partitions for separate execution strategies. Preferably, partitions are ranked for separate evaluation using a weighting formula which takes into account: (a) the number of indexes for the partition, (b) recency of change activity, and (c) the size of the partition.
摘要翻译：用于数据库查询的查询工具动态地确定数据库表的选择性部分是否可能受益于单独的查询执行策略，并相应地构建适当的单独的执行策略。优选地，数据库包含至少一个包括多个分区的相对较大的表，每个分区共享表的定义结构，并且包含表记录的不同相应离散子集。查询设施比较不同分区的元数据，以确定分区之间是否存在足够大的差异，并且在适当的情况下选择一个或多个分区用于单独的执行策略。优选地，使用考虑到的加权公式对分区进行分级评估：（a）分区的索引的数量，（b）更改活动的新近度，以及（c）分区的大小。

37. 发明授权

US08126873B2 Portable and iterative re-usable suboptimization of database queries 失效
标题翻译：数据库查询的便携式和迭代可重用的次优选项
公开(公告)号：US08126873B2
公开(公告)日：2012-02-28
申请号：US11735095
申请日：2007-04-13
申请人： Robert Victor Downer , Wei Hu , Shantan Kethireddy , Andrew Peter Passe , Ulrich Thiemann
发明人： Robert Victor Downer , Wei Hu , Shantan Kethireddy , Andrew Peter Passe , Ulrich Thiemann
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.
摘要翻译：一种优化数据库查询的方法，设备和程序产品。为数据库查询生成查询计划，其中查询计划包含第一和第二子计划。检索与第一个子计划相关联并在评估使用第一个子计划的上一个查询的另一个查询计划时生成的缓存优化数据。使用检索到的优化数据评估第一个子计划的资源成本。还对第二个分计划进行资源成本评估。然后基于对第一和第二子计划的资源成本的评估来评估查询计划的资源成本。基于对资源成本的评估来选择查询计划，并执行计划以生成结果集。

38. 发明授权

US08082265B2 Database query processing with dynamically activated buffers 失效
标题翻译：使用动态激活的缓冲区进行数据库查询处理
公开(公告)号：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.
摘要翻译：方法，装置和程序产品在执行数据库查询期间动态地激活和/或停用缓冲器。动态去激活和激活是基于在用于数据库查询的访问计划的执行期间监视与多个线程的数据消耗相关联的信息。通过这样做，在优化期间选择较不优化的缓冲器位置可以在运行时期间用更优化的缓冲器位置代替，通常导致改进的查询性能和并行性。

39. 发明授权

US07991763B2 Database query optimization utilizing remote statistics collection 有权
标题翻译：利用远程统计收集的数据库查询优化
公开(公告)号：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.
摘要翻译：一种优化数据库查询的方法，设备和程序产品。在具有第一数据空间的第一系统中，为数据库查询生成查询计划。在具有第二数据空间的第二系统上启动与数据库查询相关联的远程统计信息收集。远程统计信息收集使用第二个数据空间，其中包含第一个系统上第一个数据空间的至少一部分的当前副本。通过分析第二个数据空间来收集第一个系统的数据库统计信息，然后将收集的数据库统计信息传递给第一个系统，以便优化由第一个系统执行的数据库查询。

40. 发明申请

US20110185062A1 Qualitative Assignment of Resources to a Logical Partition In a Multipartitioned Computer System 有权
标题翻译：将资源定性分配给多分区计算机系统中的逻辑分区
公开(公告)号：US20110185062A1
公开(公告)日：2011-07-28
申请号：US12691891
申请日：2010-01-22
申请人： Stephanie A. Foege , Andres Gonzalez, JR. , Shantan Kethireddy , Meryl Lo , Annita Tomko
发明人： Stephanie A. Foege , Andres Gonzalez, JR. , Shantan Kethireddy , Meryl Lo , Annita Tomko
IPC分类号： G06F15/173 , G06F12/00 , G06F12/02
CPC分类号： G06F9/5077
摘要： A qualitative resource assignment wizard receives qualitative information for a logical partition (LPAR) and calculates computer resource assignments for the LPAR based on the qualitative information and a set of conversion functions. For example, the qualitative resource assignment wizard may calculate a processing unit assignment, a memory assignment, and an I/O slot assignment for the LPAR. The qualitative information may be input by a user, for example, utilizing a graphical user interface (GUI). In one embodiment, the conversion functions are calculated during a training phase, in which a user periodically provides qualitative information while resource usage data is gathered. The wizard may reside in a hardware management console (HMC) or other administrative console and/or may be a component of a hypervisor or other partition management code. Software code associated with the wizard may be provided by a network server application to a client system for enabling a user to remotely input the qualitative information.
摘要翻译：定性资源分配向导接收逻辑分区（LPAR）的定性信息，并根据定性信息和一组转换函数计算LPAR的计算机资源分配。例如，定性资源分配向导可以计算LPAR的处理单元分配，存储器分配和I / O时隙分配。定性信息可由用户输入，例如利用图形用户界面（GUI）。在一个实施例中，在训练阶段期间计算转换函数，其中用户在收集资源使用数据的同时周期性地提供定性信息。该向导可以驻留在硬件管理控制台（HMC）或其他管理控制台中，和/或可以是管理程序或其他分区管理代码的组件。与向导关联的软件代码可以由网络服务器应用程序提供给客户端系统，以使用户能够远程输入定性信息。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式