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

1. 发明授权

US10261888B2 Emulating an environment of a target database system 有权
公开(公告)号：US10261888B2
公开(公告)日：2019-04-16
申请号：US13650201
申请日：2012-10-12
申请人： Douglas P. Brown , Anita Richards , James Peter Colby, Jr. , Jeffrey S. Shelton
发明人： Douglas P. Brown , Anita Richards , James Peter Colby, Jr. , Jeffrey S. Shelton
IPC分类号： G06F9/455 , G06F11/36
摘要： A test system receives environment information of a target database system, where the environment information includes information relating to hardware and software components of the target database system, and one or more of: definitions of workloads in the target database system, and settings of a scheduler in the target database system. The test system emulates an environment of the target database system using the received environment information, and database software is executed in the emulated environment in the test system.

2. 发明授权

US08966493B1 Managing execution of multiple requests in a job using overall deadline for the job 有权
标题翻译：使用整个作业截止时间来管理作业中的多个请求的执行
公开(公告)号：US08966493B1
公开(公告)日：2015-02-24
申请号：US12942480
申请日：2010-11-09
申请人： Anita Richards , Douglas P. Brown
发明人： Anita Richards , Douglas P. Brown
IPC分类号： G06F9/46
CPC分类号： G06F9/4887
摘要： A database system receives information relating to a job requested by a requestor, where the job includes a plurality of requests. Execution of the requests of the job is managed using the received information, where managing the requests includes adjusting one or more of priority settings and resource estimates for the requests.
摘要翻译：数据库系统接收与请求者请求的作业有关的信息，其中作业包括多个请求。使用接收到的信息来管理作业的请求的执行，其中管理请求包括调整针对请求的一个或多个优先级设置和资源估计。

3. 发明授权

US08645425B1 Guiding the development of workload group definition classifications 有权
标题翻译：指导工作组定义分类的开发
公开(公告)号：US08645425B1
公开(公告)日：2014-02-04
申请号：US10786448
申请日：2004-02-25
申请人： Douglas P. Brown , Anita Richards , Bhashyam Ramesh
发明人： Douglas P. Brown , Anita Richards , Bhashyam Ramesh
IPC分类号： G06F7/00
CPC分类号： G06F17/30306
摘要： A method, computer program and database system are disclosed for guiding the development of workload group definition (WD) classifications for a database system having resources. WD classification information is provided where a workload group is a set of system requests having characteristics defined by a WD and a WD classification identifies one or more WDs with similar performance requirements. If WD classification is not acceptable, one or more of the following functions is performed until WD classification is acceptable: (a) splitting one or more WDs; and (b) merging two or more WDs.
摘要翻译：公开了一种方法，计算机程序和数据库系统，用于指导具有资源的数据库系统的工作负载组定义（WD）分类的开发。提供WD分类信息，其中工作负载组是具有由WD定义的特征的一组系统请求，并且WD分类识别具有相似性能要求的一个或多个WD。如果WD分类不可接受，则执行以下功能之一，直到WD分类是可接受的：（a）分割一个或多个WD; 和（b）合并两个或多个WD。

4. 发明授权

US08606749B1 Administering workload groups 有权
标题翻译：管理工作负载组
公开(公告)号：US08606749B1
公开(公告)日：2013-12-10
申请号：US12701670
申请日：2010-02-08
申请人： Douglas P. Brown , Anita Richards , Bhashyam Ramesh
发明人： Douglas P. Brown , Anita Richards , Bhashyam Ramesh
IPC分类号： G06F7/00 , G06F17/00
CPC分类号： G06F9/5038 , G06F2209/5021
摘要： A request is received at a computer programmed as a database system. The request is a request selected from the group consisting of a query and a utility. A business concept is associated with the request. The business concept is a business concept selected from the group consisting of “who” information defining the source of the request, “what” information defining the processing to be performed by the request, “where” information defining a database object that the request will affect. The computer maps the received request to a database feature setting by mapping the business concept associated with the request to a workload. The workload is defined by a workload definition including a workload classification attribute that maps to the business concept of the request, a workload throttling attribute that defines conditions under which requests assigned to the workload are throttled. Submission of the request to the database system for processing is delayed based on the workload definition.
摘要翻译：在作为数据库系统编程的计算机上接收到请求。请求是从由查询和实用程序组成的组中选择的请求。业务概念与请求相关联。业务概念是从由定义请求的源的“谁”信息组成的组中选择的业务概念，“什么”定义要由请求执行的处理的信息，其中“定义请求将要的数据库对象的信息影响。计算机通过将与请求相关联的业务概念映射到工作负载来将接收的请求映射到数据库特征设置。工作负载由工作负载定义（包括映射到请求的业务概念的工作负载分类属性）定义，工作负载限制属性定义了分配给工作负载的请求受到限制的条件。基于工作负载定义，将数据库系统提交的请求提交到处理中。

5. 发明授权

US08527473B1 Identifying database request sources in multi-database systems 有权
标题翻译：在多数据库系统中识别数据库请求源
公开(公告)号：US08527473B1
公开(公告)日：2013-09-03
申请号：US12344991
申请日：2008-12-29
申请人： Douglas P. Brown , John Mark Morris , Anita Richards
发明人： Douglas P. Brown , John Mark Morris , Anita Richards
IPC分类号： G06F7/00 , G06F17/00
CPC分类号： G06F17/30557
摘要： Recovering from a failure of a soon-to-fail database system among a plurality of database systems in a multi-database system in processing a request submitted to the multi-database system through a multi-database system session is accomplished. A query band is created for the request. The query band is defined to be an identifier that uniquely identifies the session and the request among the plurality of sessions and plurality of requests being processed by the multi-database system at the time that the request was submitted. The query band is attached to a transaction issued by the multi-database system to the soon-to-fail database system to execute the query. The status concerning execution of the transaction is reported by the soon-to-fail database system. The status includes the query band. The status is logged. The failure of the soon-to-fail database system is detected. The state of the soon-to-fail database system is reconstructed from the logged status as the state related to the processing of the transaction using the query band. The reconstructed state is used to continue processing of the transaction by an alternative database system. The alternative database system is one of the plurality of database systems in the multi-database system. The request is processed to produce a result and the result is stored.
摘要翻译：在处理通过多数据库系统会话提交给多数据库系统的请求的多数据库系统中的多个数据库系统中，从即将到失败的数据库系统的故障中恢复。为请求创建查询带。查询频带被定义为在提交请求时唯一标识会话和多个会话中的请求以及由多数据库系统处理的多个请求的标识符。查询带附加到由多数据库系统发出的事务到即将到失败的数据库系统以执行查询。关于执行事务的状态由即将到来的数据库系统报告。状态包括查询带。状态被记录。检测到即将失败的数据库系统的故障。即将到失败的数据库系统的状态从记录状态重建为与使用查询带处理事务相关的状态。重建状态用于通过替代数据库系统继续处理事务。替代数据库系统是多数据库系统中的多个数据库系统之一。处理该请求以产生结果并存储结果。

6. 发明授权

US10042674B2 Regulating capacity and managing services of computing environments and systems that include a database 有权
公开(公告)号：US10042674B2
公开(公告)日：2018-08-07
申请号：US13249922
申请日：2011-09-30
申请人： Douglas P. Brown , Thomas Julien , Anita Richards , Louis Burger
发明人： Douglas P. Brown , Thomas Julien , Anita Richards , Louis Burger
IPC分类号： G06F7/00 , G06F17/00 , G06F17/30 , G06F9/50
摘要： Capacity of a database system and/or a computing system that includes a database can be effectively changed from a current computing capacity to another computing capacity. This can be achieved by causing usage capacity of at least one of resource to be changed when the database is active. By way of example, capacity of a database system can be regulated by delaying the execution of the database work based on a target capacity. As a result, database work can take relatively longer to complete when the capacity of a database is effectively regulated to be below its full capacity. In effect, a portion of available capacity (excess capacity) can be made inaccessible to the database. However, excess capacity can be used to manage various services of the database in accordance with one or more service criteria (e.g., Service Level Goals or Agreements).

7. 发明授权

US08938644B2 Query execution plan revision for error recovery 有权
标题翻译：用于错误恢复的查询执行计划修订
公开(公告)号：US08938644B2
公开(公告)日：2015-01-20
申请号：US12960307
申请日：2010-12-03
申请人： Arthur Clark , Douglas P. Brown , Anita Richards , Donald R. Pederson
发明人： Arthur Clark , Douglas P. Brown , Anita Richards , Donald R. Pederson
IPC分类号： G06F11/00 , G06F11/07 , G06F11/14 , G06F11/34
CPC分类号： G06F11/0727 , G06F11/0793 , G06F11/142 , G06F11/143 , G06F11/3409 , G06F11/3419 , G06F11/3466 , G06F2201/80 , G06F2201/81 , G06F2201/815
摘要： A computer-implemented method, apparatus and article of manufacture for performing an automatic error recovery in a database system. Automatic error recovery is performed for a query execution plan, following errors, problems or failures that occur during execution, by automatically or manually deactivating and/or activating components, features or code paths, and then re-submitting the query execution plan for execution in the computer system.
摘要翻译：一种用于在数据库系统中执行自动错误恢复的计算机实现的方法，装置和制品。通过自动或手动去激活和/或激活组件，特征或代码路径，然后重新提交查询执行计划以执行查询执行计划，执行自动错误恢复，查询执行计划，执行后发生的错误，问题或故障计算机系统。

8. 发明授权

US08280867B2 Identifying database request sources 有权
标题翻译：识别数据库请求源
公开(公告)号：US08280867B2
公开(公告)日：2012-10-02
申请号：US11254374
申请日：2005-10-20
申请人： Douglas P. Brown , Bhashyam Ramesh , Anita Richards
发明人： Douglas P. Brown , Bhashyam Ramesh , Anita Richards
IPC分类号： G06F17/30 , G06F15/163 , G06F9/54 , G06F13/14
CPC分类号： G06F17/30557
摘要： A method, computer program, and database system are disclosed for identifying a second source of a request sent to a database management system by a first source. A database message is received from the first source. The database message includes a second value for a second source-identifying parameter. The second value identifies a second source. The second value for the second source-identifying parameter is stored in a log.
摘要翻译：公开了一种用于识别由第一来源发送到数据库管理系统的请求的第二来源的方法，计算机程序和数据库系统。从第一个源接收数据库消息。数据库消息包括用于第二源标识参数的第二值。第二个值标识第二个来源。第二个源识别参数的第二个值存储在日志中。

9. 发明申请

US20120144234A1 AUTOMATIC ERROR RECOVERY MECHANISM FOR A DATABASE SYSTEM 有权
标题翻译：一种数据库系统的自动错误恢复机制
公开(公告)号：US20120144234A1
公开(公告)日：2012-06-07
申请号：US12960307
申请日：2010-12-03
申请人： Arthur Clark , Douglas P. Brown , Anita Richards , Donald R. Pederson
发明人： Arthur Clark , Douglas P. Brown , Anita Richards , Donald R. Pederson
IPC分类号： G06F11/14
CPC分类号： G06F11/0727 , G06F11/0793 , G06F11/142 , G06F11/143 , G06F11/3409 , G06F11/3419 , G06F11/3466 , G06F2201/80 , G06F2201/81 , G06F2201/815
摘要： A computer-implemented method, apparatus and article of manufacture for performing an automatic error recovery in a database system. Automatic error recovery is performed for a query execution plan, following errors, problems or failures that occur during execution, by automatically or manually deactivating and/or activating components, features or code paths, and then re-submitting the query execution plan for execution in the computer system.
摘要翻译：一种用于在数据库系统中执行自动错误恢复的计算机实现的方法，装置和制品。通过自动或手动去激活和/或激活组件，特征或代码路径，然后重新提交查询执行计划以执行查询执行计划，执行自动错误恢复，查询执行计划，执行后发生的错误，问题或故障计算机系统。

10. 发明授权

US07805436B2 Arrival rate throttles for workload management 有权
标题翻译：工作量管理的到达率限制
公开(公告)号：US07805436B2
公开(公告)日：2010-09-28
申请号：US11811496
申请日：2007-06-11
申请人： Anita Richards , Douglas P. Brown
发明人： Anita Richards , Douglas P. Brown
IPC分类号： G06F17/30
CPC分类号： G06F17/30289 , G06F9/505 , G06F11/3419 , G06F11/3433 , G06F11/3495 , G06F2201/86 , G06F2209/5019 , G06F2209/508
摘要： A computer-implemented method, system and article of manufacture for managing workloads in a computer system, comprising monitoring system conditions and operating environment events that impact on the operation of the computer system, regulating execution of one or more queries based on the monitored system conditions and operating environment events using arrival rate throttles, and performing the queries to access data in a database for presentation and use to a user.
摘要翻译：一种用于管理计算机系统中的工作负载的计算机实现的方法，系统和制品，包括监视影响计算机系统的操作的系统状况和操作环境事件，基于所监视的系统条件来调节一个或多个查询的执行以及使用到达速率限制的操作环境事件，以及执行查询以访问数据库中的数据以呈现和使用给用户。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式