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

1. 发明授权

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.
摘要翻译：用于数据库查询的查询功能保存并重新使用查询执行策略，并自动检测到由于对索引变量值的更改，策略应重新优化。优选地，在执行期间动态地监视由索引值条件评估和选择的记录的数量，并且当该数量看起来与期望不成比例时，开始替代查询策略。在示例性实施例中，作为由索引值消除的记录数的改变的结果，索引的搜索策略被改变为表扫描策略（或反之亦然），尽管其他示例是可能的。优选地，查询引擎发起替代搜索策略并且同时继续执行原始搜索策略作为单独的线程。搜索结果从无论哪个线程首先完成。

2. 发明授权

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.
摘要翻译：在一个实施例中，本发明涉及通过利用睡眠驱动来优化数据库性能。本发明基于使用频率分析对索引的查询，并且确定是否访问存储在睡眠驱动器上的索引，或者基于绿色优化来执行替代访问计划。此外，本发明基于使用频率，在活动和睡眠驱动器之间传送数据，例如索引，文件，数据区域，期刊和统计信息。在另一个实施例中，本发明提供一种改进的睡眠驱动器，其基于速度设置优化节能度量级。在另一个实施例中，本发明控制读写头从盘上卸载以减少磁盘驱动器的阻力和功耗。

3. 发明授权

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.
摘要翻译：方法，装置和程序产品利用智能作业功能来诊断计算机中的错误。在检测到处理任务的第一作业中的错误，并且响应于执行任务的另一尝试，作业选择算法选择执行任务并诊断错误的预定作业。预定作业可以是与经历错误的任务对应的签名相关联的第一作业或新作业。预定作业可用于诊断调试会话中的错误。或者，第一个作业可能在遇到错误后立即进入调试会话。

4. 发明申请

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.
摘要翻译：方法，装置和程序产品利用智能作业功能来诊断计算机中的错误。在检测到处理任务的第一作业中的错误，并且响应于执行任务的另一尝试，作业选择算法选择执行任务并诊断错误的预定作业。预定作业可以是与经历错误的任务对应的签名相关联的第一作业或新作业。预定作业可用于诊断调试会话中的错误。或者，第一个作业可能在遇到错误后立即进入调试会话。

5. 发明授权

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.
摘要翻译：方法，装置和程序产品使用与数据库表中的字段相关联的第一索引来标识数据库表中的记录范围，其包括该字段中的第一键值的实例，并使用所识别的记录范围来子集与数据库表中另一个字段关联的第二个索引。数据库查询标识数据库表中字段的第一个键值，数据库表中另一个字段的第二个键值。通过这样做，来自索引的信息可以被转移并应用于另一个索引以对另一个索引进行子集，通常减少在另一个索引中搜索的条目的数量并提高性能。

6. 发明申请

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.
摘要翻译：方法，装置和程序产品使用与数据库表中的字段相关联的第一索引来标识数据库表中的记录范围，其包括该字段中的第一键值的实例，并使用所识别的记录范围来子集与数据库表中另一个字段关联的第二个索引。数据库查询标识数据库表中字段的第一个键值，数据库表中另一个字段的第二个键值。通过这样做，来自索引的信息可以被转移并应用于另一个索引以对另一个索引进行子集，通常减少在另一个索引中搜索的条目的数量并提高性能。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式