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

1. 发明授权

US07653826B1 Method and apparatus for query optimization and management of sleepy drives 有权
标题翻译：睡眠驱动器的查询优化和管理方法和装置
公开(公告)号：US07653826B1
公开(公告)日：2010-01-26
申请号：US12356434
申请日：2009-01-20
申请人： Paul Reuben Day , Randy L. Egan , Roger Alan Mittelstadt , Brian Robert Muras
发明人： Paul Reuben Day , Randy L. Egan , Roger Alan Mittelstadt , Brian Robert Muras
IPC分类号： G06F1/32
CPC分类号： G06F3/0634 , G06F3/0625 , G06F3/0676 , G06F17/30457 , Y02D10/154 , Y02D10/45
摘要： The invention, in an embodiment, relates to optimizing database performance by taking advantage of sleepy drives. The invention analyzes queries to indexes based on usage frequency, and determines whether to access an index stored on a sleepy drive, or perform an alternate access plan based on green optimization. Furthermore, the invention transfers data, such as, for example, indexes, files, data areas, journals, and statistics, between active and sleepy drives based on usage frequency. In another embodiment, the invention provides an improved sleepy drive which optimizes energy savings by a graduated degree based on a speed setting. In yet another embodiment, the invention controls when read-write heads are unloaded from disks to reduce drag and power consumption by a disk drive.
摘要翻译：在一个实施例中，本发明涉及通过利用睡眠驱动来优化数据库性能。本发明基于使用频率分析对索引的查询，并且确定是否访问存储在睡眠驱动器上的索引，或者基于绿色优化来执行替代访问计划。此外，本发明基于使用频率，在活动和睡眠驱动器之间传送数据，例如索引，文件，数据区域，期刊和统计信息。在另一个实施例中，本发明提供一种改进的睡眠驱动器，其基于速度设置优化节能度量级。在另一个实施例中，本发明控制读写头从盘上卸载以减少磁盘驱动器的阻力和功耗。

2. 发明授权

US08046354B2 Method and apparatus for re-evaluating execution strategy for a database query 失效
标题翻译：重新评估数据库查询执行策略的方法和装置
公开(公告)号：US08046354B2
公开(公告)日：2011-10-25
申请号：US10955737
申请日：2004-09-30
申请人： Paul Reuben Day , Lee William Jameson , Roger Alan Mittelstadt , Brian Robert Muras
发明人： Paul Reuben Day , Lee William Jameson , Roger Alan Mittelstadt , Brian Robert Muras
IPC分类号： G06F17/30
CPC分类号： G06F17/30463 , G06F17/30471 , G06F17/30474
摘要： A query facility for database queries saves and re-uses query execution strategies, and automatically detects that a strategy should be re-optimized as a result of changes to an indexed variable value. Preferably, the number of records evaluated and selected by the index value condition is dynamically monitored during execution, and an alternative query strategy is initiated when this number appears to be out of proportion to expectations. In an exemplary embodiment, an indexed search strategy is changed to a table scan strategy (or vice versa) as a result of a change to the number of records eliminated by the indexed value, although other examples are possible. Preferably, the query engine initiates an alternative search strategy and concurrently continues to execute the original search strategy as separate threads. Search results are obtained from whichever thread completes first.
摘要翻译：用于数据库查询的查询功能保存并重新使用查询执行策略，并自动检测到由于对索引变量值的更改，策略应重新优化。优选地，在执行期间动态地监视由索引值条件评估和选择的记录的数量，并且当该数量看起来与期望不成比例时，开始替代查询策略。在示例性实施例中，作为由索引值消除的记录数的改变的结果，索引的搜索策略被改变为表扫描策略（或反之亦然），尽管其他示例是可能的。优选地，查询引擎发起替代搜索策略并且同时继续执行原始搜索策略作为单独的线程。搜索结果从无论哪个线程首先完成。

3. 发明申请

US20090182724A1 Database Query Optimization Using Index Carryover to Subset an Index 有权
标题翻译：数据库查询优化使用索引继承来分组索引
公开(公告)号：US20090182724A1
公开(公告)日：2009-07-16
申请号：US12013036
申请日：2008-01-11
申请人： Paul Reuben Day , Randy L. Egan , Roger Alan Mittelstadt
发明人： Paul Reuben Day , Randy L. Egan , Roger Alan Mittelstadt
IPC分类号： G06F17/30
CPC分类号： G06F17/30442
摘要： A method, apparatus and program product use a first index associated with a field in a database table to identify a range of records in the database table that includes instances of a first key value in the field and use the identified range of records to subset a second index associated with another field in a database table. The database query identifies the first key value for the field in the database table and the second key value for the other field in the database table. By doing so, information from an index may be carried over and applied to another index to subset the other index, often reducing the quantity of entries that are searched in the other index and improving performance.
摘要翻译：方法，装置和程序产品使用与数据库表中的字段相关联的第一索引来标识数据库表中的记录范围，其包括该字段中的第一键值的实例，并使用所识别的记录范围来子集与数据库表中另一个字段关联的第二个索引。数据库查询标识数据库表中字段的第一个键值，数据库表中另一个字段的第二个键值。通过这样做，来自索引的信息可以被转移并应用于另一个索引以对另一个索引进行子集，通常减少在另一个索引中搜索的条目的数量并提高性能。

4. 发明授权

US07882399B2 Intelligent job functionality 有权
标题翻译：智能作业功能
公开(公告)号：US07882399B2
公开(公告)日：2011-02-01
申请号：US11955465
申请日：2007-12-13
申请人： Paul Reuben Day , Roger Alan Mittelstadt , Brian Robert Muras , Anne Marie Ryg
发明人： Paul Reuben Day , Roger Alan Mittelstadt , Brian Robert Muras , Anne Marie Ryg
IPC分类号： G06F11/00
CPC分类号： G06F11/079 , G06F11/0715
摘要： A method, apparatus, and program product utilize intelligent job functionality to diagnose an error in a computer. After detecting an error in a first job processing a task, and in response to another attempt to perform the task, a job selection algorithm selects a predetermined job in which to perform the task and diagnose the error. The predetermined job can be the first job or a new job associated with a signature that corresponds to the task that experienced the error. The predetermined job can be used to diagnose the error in a debugging session. Alternately, the first job may enter a debug session immediately after experiencing an error.
摘要翻译：方法，装置和程序产品利用智能作业功能来诊断计算机中的错误。在检测到处理任务的第一作业中的错误，并且响应于执行任务的另一尝试，作业选择算法选择执行任务并诊断错误的预定作业。预定作业可以是与经历错误的任务对应的签名相关联的第一作业或新作业。预定作业可用于诊断调试会话中的错误。或者，第一个作业可能在遇到错误后立即进入调试会话。

5. 发明申请

US20090158091A1 Intelligent Job Functionality 有权
标题翻译：智能工作功能
公开(公告)号：US20090158091A1
公开(公告)日：2009-06-18
申请号：US11955465
申请日：2007-12-13
申请人： Paul Reuben Day , Roger Alan Mittelstadt , Brian Robert Muras , Anne Marie Ryg
发明人： Paul Reuben Day , Roger Alan Mittelstadt , Brian Robert Muras , Anne Marie Ryg
IPC分类号： G06F11/07
CPC分类号： G06F11/079 , G06F11/0715
摘要： A method, apparatus, and program product utilize intelligent job functionality to diagnose an error in a computer. After detecting an error in a first job processing a task, and in response to another attempt to perform the task, a job selection algorithm selects a predetermined job in which to perform the task and diagnose the error. The predetermined job can be the first job or a new job associated with a signature that corresponds to the task that experienced the error. The predetermined job can be used to diagnose the error in a debugging session. Alternately, the first job may enter a debug session immediately after experiencing an error.
摘要翻译：方法，装置和程序产品利用智能作业功能来诊断计算机中的错误。在检测到处理任务的第一作业中的错误，并且响应于执行任务的另一尝试，作业选择算法选择执行任务并诊断错误的预定作业。预定作业可以是与经历错误的任务对应的签名相关联的第一作业或新作业。预定作业可用于诊断调试会话中的错误。或者，第一个作业可能在遇到错误后立即进入调试会话。

6. 发明授权

US08412700B2 Database query optimization using index carryover to subset an index 有权
标题翻译：数据库查询优化使用索引携带来子集索引
公开(公告)号：US08412700B2
公开(公告)日：2013-04-02
申请号：US12013036
申请日：2008-01-11
申请人： Paul Reuben Day , Randy L. Egan , Roger Alan Mittelstadt
发明人： Paul Reuben Day , Randy L. Egan , Roger Alan Mittelstadt
IPC分类号： G06F15/16 , G06F17/20
CPC分类号： G06F17/30442
摘要： A method, apparatus and program product use a first index associated with a field in a database table to identify a range of records in the database table that includes instances of a first key value in the field and use the identified range of records to subset a second index associated with another field in a database table. The database query identifies the first key value for the field in the database table and the second key value for the other field in the database table. By doing so, information from an index may be carried over and applied to another index to subset the other index, often reducing the quantity of entries that are searched in the other index and improving performance.
摘要翻译：方法，装置和程序产品使用与数据库表中的字段相关联的第一索引来标识数据库表中的记录范围，其包括该字段中的第一键值的实例，并使用所识别的记录范围来子集与数据库表中另一个字段关联的第二个索引。数据库查询标识数据库表中字段的第一个键值，数据库表中另一个字段的第二个键值。通过这样做，来自索引的信息可以被转移并应用于另一个索引以对另一个索引进行子集，通常减少在另一个索引中搜索的条目的数量并提高性能。

7. 发明授权

US08201173B2 Intelligent pre-started job affinity for non-uniform memory access computer systems 失效
标题翻译：智能预先启动与非均匀内存访问计算机系统相关的作业
公开(公告)号：US08201173B2
公开(公告)日：2012-06-12
申请号：US12015138
申请日：2008-01-16
申请人： Paul Reuben Day , Brian Robert Muras
发明人： Paul Reuben Day , Brian Robert Muras
IPC分类号： G06F9/455 , G06F9/46
CPC分类号： G06F9/5033
摘要： A method, apparatus, and program product select a pre-started job from among a plurality of pre-started jobs in which to perform a task in a computer system with a NUMA configuration. An attempt to perform a task is received as a connection. Information associated with the connection is compared to information associated with a plurality of pre-started jobs. In response to comparing the information, it is determined either that a pre-started job was previously used to perform the task or that no pre-started job was previously used to perform the task. In response to either determination, another pre-started job is determined in which to perform the task. The other pre-started job is determined based on affinity with the task, and may be reallocated to perform the task.
摘要翻译：一种方法，装置和程序产品从其中在具有NUMA配置的计算机系统中执行任务的多个预先启动的作业中选择预先启动的作业。作为连接接收到执行任务的尝试。与连接相关联的信息与与多个预启动作业相关联的信息进行比较。响应于比较信息，确定先前启动的作业以前用于执行任务或者没有预先启动的作业以前用于执行任务。响应于任一确定，确定执行任务的另一预先启动的作业。另一个预先启动的作业是根据与任务的亲和性确定的，并且可以被重新分配以执行该任务。

8. 发明授权

US08041708B2 Optimizing execution of database queries containing user-defined functions 失效
标题翻译：优化包含用户定义函数的数据库查询的执行
公开(公告)号：US08041708B2
公开(公告)日：2011-10-18
申请号：US12167353
申请日：2008-07-03
申请人： Paul Reuben Day , Brian Robert Muras
发明人： Paul Reuben Day , Brian Robert Muras
IPC分类号： G06F17/30 , G06F7/00
CPC分类号： G06F17/30471 , Y10S707/99933 , Y10S707/99943
摘要： A query engine (or optimizer) which supports database queries having user-defined functions maintains historical execution data with respect to each of multiple user-defined functions. The historical execution data is dynamically updated based on query execution performance. When executing a query having user-defined functions, the query engine uses the historical execution data to predict an optimal evaluation ordering for the query conditions and, preferably, to dynamically adjust the evaluation order when appropriate. Preferably, the historical execution data includes historical execution time of the user-defined function and proportion of evaluated records which satisfied the query parameters.
摘要翻译：支持具有用户定义功能的数据库查询的查询引擎（或优化器）维护关于多个用户定义的功能中的每一个的历史执行数据。历史执行数据根据查询执行性能动态更新。当执行具有用户定义功能的查询时，查询引擎使用历史执行数据来预测查询条件的最佳评估排序，并且优选地，在适当时动态地调整评估顺序。优选地，历史执行数据包括用户定义的功能的历史执行时间和满足查询参数的评估记录的比例。

9. 发明授权

US07917498B2 Method and system for dynamic join reordering 有权
标题翻译：动态连接重新排序的方法和系统
公开(公告)号：US07917498B2
公开(公告)日：2011-03-29
申请号：US11959109
申请日：2007-12-18
申请人： Paul Reuben Day , Brian Robert Muras
发明人： Paul Reuben Day , Brian Robert Muras
IPC分类号： G06F7/00 , G06F17/30
CPC分类号： G06F17/30474 , G06F17/30498 , Y10S707/99932 , Y10S707/99933 , Y10S707/99935 , Y10S707/99945
摘要： A database engine and a system running a database engine utilize a dynamic join reordering feature to change the order of two or more join operations while a query is executing. The database engine starts execution of the query with an initial join order setting but monitors the execution of the query to determine whether the initial join order or some other join order would provide better runtime performance. If another join order would provide better performance, then the database engine can change the join order during query execution and complete the query using the new join order.
摘要翻译：数据库引擎和运行数据库引擎的系统利用动态连接重排序功能在查询执行时更改两个或多个连接操作的顺序。数据库引擎使用初始连接顺序设置启动查询的执行，但监视查询的执行，以确定初始连接顺序或其他连接顺序是否能提供更好的运行时性能。如果另一个连接顺序将提供更好的性能，那么数据库引擎可以在查询执行期间更改连接顺序，并使用新的连接顺序完成查询。

10. 发明申请

US20090119249A1 TRACKING PREMATURE TERMINATION OF A DATABASE QUERY 有权
标题翻译：跟踪数据库查询的临时终止
公开(公告)号：US20090119249A1
公开(公告)日：2009-05-07
申请号：US12353599
申请日：2009-01-14
申请人： Paul Reuben Day , Brian Robert Muras
发明人： Paul Reuben Day , Brian Robert Muras
IPC分类号： G06F17/30
CPC分类号： G06F17/30522 , G06F17/30312 , Y10S707/99932 , Y10S707/99933
摘要： An apparatus and program product that utilize at least one prematurely terminated processing of a database query to improve the processing of the database query. Due to the difficulty of conventional techniques to improve the execution and/or performance of long processing queries, (e.g., advanced user knowledge, assistance from an expert, etc.), users typically terminate long processing queries. As a result, long processing queries may not be improved, and because of the limited options, users may continue to prematurely terminate long processing queries. However, information related to the premature terminations of a database query may be utilized by a DBMS to generate and/or implement suggestions to improve the processing of the database query, resulting in improved query processing, improved performance, fewer premature terminations, and more satisfied users.
摘要翻译：一种利用至少一个过早终止的数据库查询处理以改进数据库查询的处理的装置和程序产品。由于常规技术难以改进长处理查询的执行和/或性能（例如，高级用户知识，来自专家的帮助等），用户通常终止长处理查询。因此，长处理查询可能无法改善，并且由于选项有限，用户可能会继续提前终止长处理查询。然而，与数据库查询的过早终止有关的信息可被DBMS利用以产生和/或实施改进数据库查询处理的建议，从而改进查询处理，改进的性能，更少的过早终止以及更满意用户

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式