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

21. 发明授权

US07440935B2 Method and system for query directives and access plan hints 有权
标题翻译：查询指令和访问计划提示的方法和系统
公开(公告)号：US07440935B2
公开(公告)日：2008-10-21
申请号：US10839487
申请日：2004-05-05
申请人： Paul Reuben Day , Brian Robert Muras , Anne Marie Ryg
发明人： Paul Reuben Day , Brian Robert Muras , Anne Marie Ryg
IPC分类号： G06F7/00
CPC分类号： G06F17/30471 , G06F17/30306 , Y10S707/99932 , Y10S707/99934
摘要： A query plan modification system and method relates to a database system that includes a cost-based optimizer for generating access plans. The database system also permits a user to view an access plan that has been generated by a particular SQL query and modify the access plan if desired. The user specifies customizations that are associated with the access plan so that when that plan is executed, the customizations are executed as well. Exemplary customizations include specifying an initialization file specific to a query, specifying different implementation methods than those in the original access plan, prohibiting rebuilding of an access plan, and over-riding or ignoring a clause within the query that is used to generate the access plan.
摘要翻译：查询计划修改系统和方法涉及包括用于生成访问计划的基于成本的优化器的数据库系统。数据库系统还允许用户查看由特定SQL查询生成的访问计划，并根据需要修改访问计划。用户指定与访问计划相关联的自定义，以便在执行该计划时，还会执行自定义。示例性定制包括指定特定于查询的初始化文件，指定与原始访问计划中的不同的实现方法，禁止重建访问计划，以及覆盖或忽略用于生成访问计划的查询内的子句。

22. 发明申请

US20080133470A1 BACKGROUND INDEX BIMAPPING FOR FASTER QUERY PERFORMANCE 有权
标题翻译：背景索引用于更快的查询性能
公开(公告)号：US20080133470A1
公开(公告)日：2008-06-05
申请号：US12027067
申请日：2008-02-06
申请人： Paul Reuben Day , Brian Robert Muras
发明人： Paul Reuben Day , Brian Robert Muras
IPC分类号： G06F17/30
CPC分类号： G06F17/30324 , G06F17/30336 , G06F17/30492 , Y10S707/99931 , Y10S707/99932 , Y10S707/99933 , Y10S707/99934 , Y10S707/99935 , Y10S707/99942
摘要： A database engine and a system running a database engine utilize a dynamic bitmap updating routine to avoid the delay associated with building an entire bitmap. When running a query on a table, the database engine can build a bitmap over a column of the table that helps avoid unnecessary I/O operations to retrieve records. The database engine initializes the bitmap so that all elements have a value of “1”, or active, and proceeds to scan and retrieve the records of the table according to the bitmap using a first process. Any retrieved record is further analyzed to determine if it is part of the result set. Concurrently, a second process is initiated which continually updates the values within the bitmap according to a set of selection criteria. As the first process continues to operate, more and more elements of the bitmap are set to “0”, or inactive, so that the first process can avoid unnecessary I/O operations.
摘要翻译：数据库引擎和运行数据库引擎的系统利用动态位图更新例程来避免与构建整个位图相关的延迟。在表上运行查询时，数据库引擎可以在表的列上构建位图，以帮助避免不必要的I / O操作来检索记录。数据库引擎初始化位图，使所有元素的值为“1”或活动，然后继续使用第一个进程根据位图扫描和检索表的记录。进一步分析任何检索的记录，以确定它是否是结果集的一部分。同时，启动第二过程，其根据一组选择标准不断更新位图内的值。当第一个进程继续运行时，位图的越来越多的元素被设置为“0”或不活动，以便第一个进程可以避免不必要的I / O操作。

23. 发明授权

US07191174B2 Method, query optimizer, and computer program product for implementing live switchover to temporary sparse index for faster query performance 失效
标题翻译：方法，查询优化器和计算机程序产品，用于实时切换到临时稀疏索引，以提高查询性能
公开(公告)号：US07191174B2
公开(公告)日：2007-03-13
申请号：US10443921
申请日：2003-05-22
申请人： Paul Reuben Day , Brian Robert Muras
发明人： Paul Reuben Day , Brian Robert Muras
IPC分类号： G06F7/00 , G06F17/30
CPC分类号： G06F17/30321 , G06F17/30474 , G06F17/30501 , Y10S707/99932 , Y10S707/99933 , Y10S707/99935
摘要： A method, a query optimizer, and computer program product are provided for implementing live switchover to a temporary sparse index for faster query performance. A first plan using an existing index is used for processing a query. A temporary sparse index is built for the query simultaneously with the first plan processing the query. When the temporary sparse index is built, processing the query with the first plan is stopped and a live switchover to the temporary sparse index is provided. Then a second plan using the temporary sparse index is used to continue processing the query at a point where processing stopped with the first plan.
摘要翻译：提供了一种方法，查询优化器和计算机程序产品，用于实现对临时稀疏索引的实时切换，从而实现更快的查询性能。使用现有索引的第一个计划用于处理查询。为查询同时构建临时稀疏索引，第一个计划处理查询。当构建临时稀疏索引时，停止处理具有第一个计划的查询，并提供到临时稀疏索引的实时切换。然后使用临时稀疏索引的第二个计划在第一个计划的停止处继续处理查询。

24. 发明授权

US09135298B2 Autonomically generating a query implementation that meets a defined performance specification 有权
标题翻译：自动生成满足定义的性能规范的查询实现
公开(公告)号：US09135298B2
公开(公告)日：2015-09-15
申请号：US12107938
申请日：2008-04-23
申请人： Paul Reuben Day , Brian Robert Muras , Anne Marie Ryg
发明人： Paul Reuben Day , Brian Robert Muras , Anne Marie Ryg
IPC分类号： G06F17/30
CPC分类号： G06F17/30433 , G06F17/30463
摘要： A database query optimizer allows specifying a performance specification for a query. When an access plan is created, the actual performance for executing the query using the access plan is determined and compared to the performance specification for the query. If the actual performance does not satisfy the performance specification for the query, the query optimizer autonomically generates a different access plan to see if the performance improves. If an access plan that meets the performance specification is generated, the new access plan is stored in the access plan cache for the query. If no access plan can be generated that meets the performance specification for the query, the access plan that provided the best performance is selected and stored in the access plan cache for the query.
摘要翻译：数据库查询优化器允许为查询指定性能规范。当创建访问计划时，确定使用访问计划执行查询的实际性能，并将其与查询的性能规范进行比较。如果实际性能不符合查询的性能规范，则查询优化器将自动生成不同的访问计划，以查看性能是否提高。如果生成符合性能规范的访问计划，则新访问计划将存储在查询的访问计划缓存中。如果不能生成满足查询性能规范的访问计划，则提供最佳性能的访问计划被选择并存储在查询的访问计划缓存中。

25. 发明授权

US08285707B2 Method of querying relational database management systems 失效
标题翻译：查询关系数据库管理系统的方法
公开(公告)号：US08285707B2
公开(公告)日：2012-10-09
申请号：US11557601
申请日：2006-11-08
申请人： Paul Reuben Day , Thomas Owen McKinley , Brian Robert Muras
发明人： Paul Reuben Day , Thomas Owen McKinley , Brian Robert Muras
IPC分类号： G06F17/30 , G06F7/00
CPC分类号： G06F17/30477
摘要： Database management systems and methods for searching a database are disclosed. In one embodiment, an inspector examines a plan cache or a program containing embedded queries. A plurality of similar queries is identified, and an alias is generated that satisfies the plurality of queries. The alias may be executed on a database to output a result set. Queries belonging to the alias may be executed on the result set of the alias, rather than on the database. Accordingly, efficiency is improved and runtime costs are reduced as compared to conventional database management systems.
摘要翻译：公开了用于搜索数据库的数据库管理系统和方法。在一个实施例中，检查器检查计划高速缓存或包含嵌入式查询的程序。识别多个类似的查询，并且生成满足多个查询的别名。可以在数据库上执行别名以输出结果集。可以在别名的结果集上而不是在数据库上执行属于别名的查询。因此，与传统的数据库管理系统相比，提高了效率并降低了运行时间。

26. 发明授权

US07877377B2 Dropping tautological predicates from SQL queries for reusability 失效
标题翻译：从SQL查询中删除重言式谓词以实现可重用性
公开(公告)号：US07877377B2
公开(公告)日：2011-01-25
申请号：US10860403
申请日：2004-06-03
申请人： Paul Reuben Day , Brian Robert Muras
发明人： Paul Reuben Day , Brian Robert Muras
IPC分类号： G06F17/20 , G06F15/16
CPC分类号： G06F17/30457 , G06F17/3046
摘要： A database query optimizer creates a main access plan for a query, and also creates one or more subplans for the same query. The subplans are used in executing a query. When a subplan is generated, all tautological predicates (i.e., predicates that do not narrow the query) are dropped, thereby enhancing the reusability of stored subplans. When a query is processed, its tautological predicates are dropped, and if a subplan for the query with the dropped tautological predicates is found, the subplan is used to execute the query. If the query to be run has no main access plan in the cache, a main access plan is generated, and a subplan is also generated that corresponds to the query to be run, with all tautological predicates dropped. The same query may thus generate many subplans, enhancing the reusability of the query by storing each subplan in the access plan cache.
摘要翻译：数据库查询优化器为查询创建主访问计划，并为同一查询创建一个或多个子计划。这些子计划用于执行查询。当生成子计划时，所有重言式谓词（即，不缩小查询的谓词）被丢弃，从而增强了存储的子计划的可重用性。当查询被处理时，其重言式谓词被删除，并且如果找到具有丢弃的重言式谓词的查询的子计划，则使用子计划来执行查询。如果要运行的查询在缓存中没有主访问计划，则生成主访问计划，并且生成与要运行的查询相对应的子计划，所有重言式谓词都丢弃。因此，相同的查询可以生成许多子计划，通过将每个子计划存储在访问计划高速缓存中来增强查询的可重用性。

27. 发明授权

US07685101B2 Query directives and access plan hints 有权
标题翻译：查询指令和访问计划提示
公开(公告)号：US07685101B2
公开(公告)日：2010-03-23
申请号：US12175036
申请日：2008-07-17
申请人： Paul Reuben Day , Brian Robert Muras , Anne Marie Ryg
发明人： Paul Reuben Day , Brian Robert Muras , Anne Marie Ryg
IPC分类号： G06F17/00
CPC分类号： G06F17/30471 , G06F17/30306 , Y10S707/99932 , Y10S707/99934
摘要： A query plan modification system and method relate to a database system that includes a cost-based optimizer for generating access plans. The database system also permits a user to view an access plan that has been generated by a particular SQL query and modify the access plan if desired. The user specifies customizations that are associated with the access plan so that when that plan is executed, the customizations are executed as well. Exemplary customizations include specifying an initialization file specific to a query, specifying different implementation methods than those in the original access plan, prohibiting rebuilding of an access plan, and over-riding or ignoring a clause within the query that is used to generate the access plan.
摘要翻译：查询计划修改系统和方法涉及包括用于生成访问计划的基于成本的优化器的数据库系统。数据库系统还允许用户查看由特定SQL查询生成的访问计划，并根据需要修改访问计划。用户指定与访问计划相关联的自定义，以便在执行该计划时，还会执行自定义。示例性定制包括指定特定于查询的初始化文件，指定与原始访问计划中的不同的实现方法，禁止重建访问计划，以及覆盖或忽略用于生成访问计划的查询内的子句。

28. 发明申请

US20090133030A1 SYSTEM FOR ON DEMAND TASK OPTIMIZATION 有权
标题翻译：需求任务优化系统
公开(公告)号：US20090133030A1
公开(公告)日：2009-05-21
申请号：US12358725
申请日：2009-01-23
申请人： Paul Reuben Day , Brian Robert Muras
发明人： Paul Reuben Day , Brian Robert Muras
IPC分类号： G06F9/46
CPC分类号： G06F11/3409 , G06F11/3442
摘要： An apparatus and program product determine information indicative of a performance differential between operation of a computer with the standby resource activated and operation of the computer with the standby resource inactivated. The information is communicated to a user. The standby resource may be activated in response to the determination.
摘要翻译：设备和程序产品确定指示计算机的操作与激活的备用资源的操作之间的性能差异的信息以及停用了备用资源的计算机的操作。该信息被传送给用户。备用资源可以响应于该确定被激活。

29. 发明申请

US20090077487A1 Canceling window close commands 审中-公开
标题翻译：取消窗口关闭命令
公开(公告)号：US20090077487A1
公开(公告)日：2009-03-19
申请号：US12291454
申请日：2008-11-10
申请人： Paul Reuben Day , Brian Robert Muras
发明人： Paul Reuben Day , Brian Robert Muras
IPC分类号： G06F3/048 , G06F9/46
CPC分类号： G06F9/451
摘要： A computer system that, in an embodiment, receives a close command directed to a window, and determines whether the close command was received within a close threshold time of the display of the window. If the close command was received within the threshold time, in various embodiments, a close dialog is displayed, the window is faded, the window is shrunk, or a status message is displayed indicating that the window is closing. If a cancel command is received within a cancel-close threshold, the closing of the window is canceled. If the number of times the cancel command has been received for the window exceeds a cancel threshold, then in various embodiments, the close threshold is increased, magnification is recommended, a sound option is recommended, or speech recognition is recommended.
摘要翻译：在一个实施例中，计算机系统接收指向窗口的关闭命令，并且确定在窗口显示的接近阈值时间内是否接收到关闭命令。如果在阈值时间内接收到关闭命令，则在各种实施例中，显示关闭对话，窗口褪色，窗口缩小，或显示表示窗口关闭的状态消息。如果在取消 - 关闭阈值内接收到取消命令，则窗口的关闭被取消。如果已经为窗口接收到取消命令的次数超过了取消阈值，则在各种实施例中，提高关闭阈值，建议放大，推荐声音选项，或者推荐语音识别。

30. 发明授权

US07500140B2 System for on demand task optimization 有权
标题翻译：系统用于按需任务优化
公开(公告)号：US07500140B2
公开(公告)日：2009-03-03
申请号：US11013270
申请日：2004-12-15
申请人： Paul Reuben Day , Brian Robert Muras
发明人： Paul Reuben Day , Brian Robert Muras
IPC分类号： G06F11/00
CPC分类号： G06F11/3409 , G06F11/3442
摘要： An apparatus, method and program product determines information indicative of a performance differential between operation of a computer with the standby resource activated and operation of the computer with the standby resource inactivated. The information is communicated to a user. The standby resource may be activated in response to the determination.
摘要翻译：设备，方法和程序产品确定指示计算机的操作与激活的备用资源的操作之间的性能差异的信息以及使备用资源被停用的计算机的操作。该信息被传送给用户。备用资源可以响应于该确定被激活。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式