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

1. 发明授权

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.
摘要翻译：在处理通过多数据库系统会话提交给多数据库系统的请求的多数据库系统中的多个数据库系统中，从即将到失败的数据库系统的故障中恢复。为请求创建查询带。查询频带被定义为在提交请求时唯一标识会话和多个会话中的请求以及由多数据库系统处理的多个请求的标识符。查询带附加到由多数据库系统发出的事务到即将到失败的数据库系统以执行查询。关于执行事务的状态由即将到来的数据库系统报告。状态包括查询带。状态被记录。检测到即将失败的数据库系统的故障。即将到失败的数据库系统的状态从记录状态重建为与使用查询带处理事务相关的状态。重建状态用于通过替代数据库系统继续处理事务。替代数据库系统是多数据库系统中的多个数据库系统之一。处理该请求以产生结果并存储结果。

2. 发明申请

US20130086590A1 MANAGING CAPACITY OF COMPUTING ENVIRONMENTS AND SYSTEMS THAT INCLUDE A DATABASE 审中-公开
标题翻译：管理计算环境的能力和包含数据库的系统
公开(公告)号：US20130086590A1
公开(公告)日：2013-04-04
申请号：US13250006
申请日：2011-09-30
申请人： John Mark Morris , Anita Richards , Douglas P. Brown
发明人： John Mark Morris , Anita Richards , Douglas P. Brown
IPC分类号： G06F9/46
CPC分类号： G06F9/5011 , G06F2209/504 , G06F2209/508 , Y02D10/22
摘要： Capacity of a computing environment that includes a database can be maintained at a target capacity by regulating the usage of one or more of the resources by one or more tasks or activities (e.g., database work). Moreover, the usage of the resource(s) can be regulated based on the extent of use of the resource(s) by one or more other activities not being regulated (e.g., non-database activities that cannot be regulated by a database system). In other words, a target capacity can be maintained by effectively adjusting the extent by which one or more tasks can access one more resources in consideration of the extent by which one or more of the resources are used by one or more other tasks or activities that are not being regulated with respect to their access of the resource(s).
摘要翻译：包括数据库的计算环境的容量可以通过一个或多个任务或活动（例如，数据库工作）来调节一个或多个资源的使用来维持在目标容量。此外，资源的使用可以基于一个或多个未受管制的其他活动（例如，不能被数据库系统管理的非数据库活动）的资源的使用程度来调节。。换句话说，考虑到一个或多个资源被一个或多个其他任务或活动使用的程度，有效调整一个或多个任务可以访问一个或多个资源的程度可以维持目标能力，对资源的访问没有受到管制。

3. 发明授权

US08359333B2 Virtual regulator for multi-database systems 有权
标题翻译：用于多数据库系统的虚拟调节器
公开(公告)号：US08359333B2
公开(公告)日：2013-01-22
申请号：US11716889
申请日：2007-03-12
申请人： Douglas P. Brown , Anita Richards , John Mark Morris , Todd A. Walter
发明人： Douglas P. Brown , Anita Richards , John Mark Morris , Todd A. Walter
IPC分类号： G06F7/00 , G06F17/30
CPC分类号： G06F17/30289 , G06F17/30067 , G06F17/30129 , G06F17/30979 , Y10S707/99932
摘要： A system for managing a plurality of systems, includes a domain comprised of a plurality of systems, wherein the systems are managed by one or more closed-loop system management (CLSM) regulators. A virtual regulator manages operational characteristics of the domain and the plurality of systems, by communicating with the CLSM regulators to monitor the systems' states, events and conditions within the domain and to adjust the systems' operational characteristics in response to the systems' states, events and conditions.
摘要翻译：用于管理多个系统的系统包括由多个系统组成的域，其中所述系统由一个或多个闭环系统管理（CLSM）调节器管理。虚拟调节器通过与CLSM监管者沟通来监控域内的状态，事件和状况以及响应于系统状态来调整系统的操作特性来管理域和多个系统的操作特性，事件和条件。

4. 发明申请

US20080162418A1 Automated block size management for database objects 有权
标题翻译：数据库对象的自动块大小管理
公开(公告)号：US20080162418A1
公开(公告)日：2008-07-03
申请号：US11716890
申请日：2007-03-12
申请人： John Mark Morris , Anita Richards , Douglas P. Brown
发明人： John Mark Morris , Anita Richards , Douglas P. Brown
IPC分类号： G06F17/30
CPC分类号： G06F17/30289 , G06F17/30067 , G06F17/30129 , G06F17/30979 , Y10S707/99932
摘要： A system and method for managing database systems, wherein the database systems perform database queries to retrieve data stored by the database systems. One or more regulators are used for managing the database systems, wherein a database tuning agent function of the regulator uses statistics on physical and logical data access in order to perform automated block size management for database objects.
摘要翻译：一种用于管理数据库系统的系统和方法，其中数据库系统执行数据库查询以检索由数据库系统存储的数据。一个或多个调节器用于管理数据库系统，其中调节器的数据库调优代理功能使用关于物理和逻辑数据访问的统计信息，以便为数据库对象执行自动化块大小管理。

5. 发明申请

US20080162417A1 Workload priority influenced data temperature 有权
标题翻译：工作负载优先级影响数据温度
公开(公告)号：US20080162417A1
公开(公告)日：2008-07-03
申请号：US11716880
申请日：2007-03-12
申请人： John Mark Morris , Anita Richards , Douglas P. Brown
发明人： John Mark Morris , Anita Richards , Douglas P. Brown
IPC分类号： G06F17/30
CPC分类号： G06F17/30289 , G06F17/30067 , G06F17/30129 , G06F17/30979 , Y10S707/99932
摘要： A system and method for managing one or more database systems, wherein the database systems perform database queries to retrieve data stored by the database systems. One or more regulators are used for managing the database systems, wherein the regulators monitor workload priority influenced data temperature in order to allocate resources for the systems. The data temperature is a measure of physical accesses to logical data, and the workload priority is used to further define data temperature, in order to optimize data storage placement and data access decisions.
摘要翻译：一种用于管理一个或多个数据库系统的系统和方法，其中数据库系统执行数据库查询以检索由数据库系统存储的数据。一个或多个调节器用于管理数据库系统，其中监管者监视工作负载优先级影响的数据温度，以便为系统分配资源。数据温度是物理访问逻辑数据的度量，并且工作负载优先级用于进一步定义数据温度，以便优化数据存储位置和数据访问决策。

6. 发明授权

US09116929B2 Workload priority influenced data temperature 有权
标题翻译：工作负载优先级影响数据温度
公开(公告)号：US09116929B2
公开(公告)日：2015-08-25
申请号：US11716880
申请日：2007-03-12
申请人： John Mark Morris , Anita Richards , Douglas P. Brown
发明人： John Mark Morris , Anita Richards , Douglas P. Brown
IPC分类号： G06F7/00 , G06F17/30
CPC分类号： G06F17/30289 , G06F17/30067 , G06F17/30129 , G06F17/30979 , Y10S707/99932
摘要： A system and method for managing one or more database systems, wherein the database systems perform database queries to retrieve data stored by the database systems. One or more regulators are used for managing the database systems, wherein the regulators monitor workload priority influenced data temperature in order to allocate resources for the systems. The data temperature is a measure of physical accesses to logical data, and the workload priority is used to further define data temperature, in order to optimize data storage placement and data access decisions.
摘要翻译：一种用于管理一个或多个数据库系统的系统和方法，其中数据库系统执行数据库查询以检索由数据库系统存储的数据。一个或多个调节器用于管理数据库系统，其中监管者监视工作负载优先级影响的数据温度，以便为系统分配资源。数据温度是物理访问逻辑数据的度量，并且工作负载优先级用于进一步定义数据温度，以便优化数据存储位置和数据访问决策。

7. 发明申请

US20090049024A1 Dynamic query optimization between systems based on system conditions 审中-公开
标题翻译：基于系统条件的系统之间的动态查询优化
公开(公告)号：US20090049024A1
公开(公告)日：2009-02-19
申请号：US11891919
申请日：2007-08-14
申请人： Douglas P. Brown , Olli Pekka Kostamaa , John Mark Morris , Bhashyam Ramesh , Anita Richards
发明人： Douglas P. Brown , Olli Pekka Kostamaa , John Mark Morris , Bhashyam Ramesh , Anita Richards
IPC分类号： G06F17/30
CPC分类号： G06F16/2453
摘要： A computer-implemented system, method and article of manufacture for managing a plurality of database systems in a domain, wherein each of the database systems are managed by one or more closed-loop system management (CLSM) regulators. A virtual regulator manages the domain, wherein the virtual regulator communicates with the CLSM regulators to monitor the database systems' system conditions and operating environment events within the domain and to provide for dynamic query optimization between the database systems within in the domain based on the system conditions and operating environment events.
摘要翻译：一种用于管理域中的多个数据库系统的计算机实现的系统，方法和制品，其中每个数据库系统由一个或多个闭环系统管理（CLSM）调节器管理。虚拟调节器管理域，其中虚拟调节器与CLSM调节器通信以监视数据库系统的系统状况和域内的操作环境事件，并且基于系统在域内的数据库系统之间提供动态查询优化条件和操作环境事件。

8. 发明授权

US07657508B2 Automated block size management for database objects 有权
标题翻译：数据库对象的自动块大小管理
公开(公告)号：US07657508B2
公开(公告)日：2010-02-02
申请号：US11716890
申请日：2007-03-12
申请人： John Mark Morris , Anita Richards , Douglas P. Brown
发明人： John Mark Morris , Anita Richards , Douglas P. Brown
IPC分类号： G06F17/30
CPC分类号： G06F17/30289 , G06F17/30067 , G06F17/30129 , G06F17/30979 , Y10S707/99932
摘要： A system and method for managing database systems, wherein the database systems perform database queries to retrieve data stored by the database systems. One or more regulators are used for managing the database systems, wherein a database tuning agent function of the regulator uses statistics on physical and logical data access in order to perform automated block size management for database objects.
摘要翻译：一种用于管理数据库系统的系统和方法，其中数据库系统执行数据库查询以检索由数据库系统存储的数据。一个或多个调节器用于管理数据库系统，其中调节器的数据库调优代理功能使用关于物理和逻辑数据访问的统计信息，以便为数据库对象执行自动化块大小管理。

9. 发明申请

US20080162583A1 Virtual regulator for multi-databases systems 有权
标题翻译：多数据库系统的虚拟调节器
公开(公告)号：US20080162583A1
公开(公告)日：2008-07-03
申请号：US11716889
申请日：2007-03-12
申请人： Douglas P. Brown , Anita Richards , John Mark Morris , Todd A. Walter
发明人： Douglas P. Brown , Anita Richards , John Mark Morris , Todd A. Walter
IPC分类号： G06F17/30
CPC分类号： G06F17/30289 , G06F17/30067 , G06F17/30129 , G06F17/30979 , Y10S707/99932
摘要： A system for managing a plurality of systems, includes a domain comprised of a plurality of systems, wherein the systems are managed by one or more closed-loop system management (CLSM) regulators. A virtual regulator manages operational characteristics of the domain and the plurality of systems, by communicating with the CLSM regulators to monitor the systems' states, events and conditions within the domain and to adjust the systems' operational characteristics in response to the systems' states, events and conditions.
摘要翻译：用于管理多个系统的系统包括由多个系统组成的域，其中所述系统由一个或多个闭环系统管理（CLSM）调节器管理。虚拟调节器通过与CLSM监管者沟通来监控域内的状态，事件和状况以及响应于系统状态来调整系统的操作特性来管理域和多个系统的操作特性，事件和条件。

10. 发明申请

US20130173586A1 SYSTEM, METHOD, AND COMPUTER-READABLE MEDIUM FOR REDUCING RESPONSE TIME VARIATION IN A WORKLOAD MANAGEMENT SYSTEM 审中-公开
标题翻译：系统，方法和计算机可读介质，用于减少工作负载管理系统中的响应时间变化
公开(公告)号：US20130173586A1
公开(公告)日：2013-07-04
申请号：US13415027
申请日：2012-03-08
申请人： John Mark Morris , Douglas P. Brown , Donald Pederson
发明人： John Mark Morris , Douglas P. Brown , Donald Pederson
IPC分类号： G06F17/30
CPC分类号： G06F16/24
摘要： A system, method, and computer readable medium are provided for reducing response time variation in a workload management system for a database system. When a query response is generated in response to a database query from a client, a determination may be made as to whether response time of the query response is less than a predetermined amount of time. Delivery of the query response to the client is delayed when an amount of time associated with the query response is less than the predetermined amount of time.
摘要翻译：提供了一种用于减少用于数据库系统的工作负载管理系统中的响应时间变化的系统，方法和计算机可读介质。当响应于来自客户端的数据库查询产生查询响应时，可以确定查询响应的响应时间是否小于预定的时间量。当与查询响应相关联的时间量小于预定时间量时，对客户端的查询响应的传送被延迟。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式