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

1. 发明授权

US09766933B2 Fine-grained capacity management of computing environments that may support a database 有权
公开(公告)号：US09766933B2
公开(公告)日：2017-09-19
申请号：US13309806
申请日：2011-12-02
申请人： John Mark Morris , P. Keith Muller , Douglas P. Brown
发明人： John Mark Morris , P. Keith Muller , Douglas P. Brown
IPC分类号： G06F7/00 , G06F17/00 , G06F17/30 , G06F9/50
CPC分类号： G06F9/5011 , G06F2209/504 , Y02D10/22
摘要： Computing capacity of a computing environment can be managed by controlling it associated processing capacity based on a target (or desired) capacity. In addition, fine-grained control over the processing capacity can be exercised. For example, a computing system can change the processing capacity (e.g., processing rate) of at least one processor operating based on a target capacity. The computing system may also be operable to change the processing capacity based on a measured processing capacity (e.g., a measured average of various processing rates of a processor taken over a period of time when a processor may have been operating at different processing rates over that period). By way of example, the processing rate of a processor can be switched between 1/8 and 2/8 of a maximum processing rate to achieve virtually any effective processing rates between them.

2. 发明授权

US09244793B1 Using target database system statistics in emulation 有权
标题翻译：在仿真中使用目标数据库系统统计
公开(公告)号：US09244793B1
公开(公告)日：2016-01-26
申请号：US12264671
申请日：2008-11-04
申请人： Douglas P. Brown , Jeffrey S Shelton
发明人： Douglas P. Brown , Jeffrey S Shelton
IPC分类号： G06F9/45 , G06F9/455 , G06F11/26 , G06F17/50
CPC分类号： G06F11/261 , G06F17/5022
摘要： A method, system, and computer program are disclosed. Statistics are read from a data dictionary on a target system. The statistics include statistics for a table in a database in the target system. The statistics are exported to a test system separate from the target system. A command is received to use the statistics in emulation. In response the statistics are copied to a cache in the test system and the target system is emulated on the test system using the statistics in the test system's cache.
摘要翻译：公开了一种方法，系统和计算机程序。从目标系统上的数据字典中读取统计信息。统计信息包括目标系统中数据库中表的统计信息。统计数据导出到与目标系统分开的测试系统。接收到使用统计信息进行仿真的命令。作为响应，将统计信息复制到测试系统中的缓存中，并使用测试系统缓存中的统计信息在测试系统上模拟目标系统。

3. 发明授权

US08924981B1 Calculating priority indicators for requests in a queue 有权
标题翻译：计算队列中请求的优先级指标
公开(公告)号：US08924981B1
公开(公告)日：2014-12-30
申请号：US12945064
申请日：2010-11-12
申请人： Douglas P. Brown , Thomas P. Julien , Louis M. Burger , Anita Richards
发明人： Douglas P. Brown , Thomas P. Julien , Louis M. Burger , Anita Richards
IPC分类号： G06F9/46 , G06F15/173 , G06F7/00
CPC分类号： G06F9/4881 , G06F17/30445 , G06F2209/483
摘要： Requests to be executed in the database system are received, where a plurality of the requests are provided in a queue for later execution. Priority indicators are calculated for assignment to corresponding ones of the plurality of requests in the queue, where the priority indicators are calculated based on delay times and predefined priority levels of the requests. The requests in the queue are executed in order according to the calculated priority indicators.
摘要翻译：接收在数据库系统中执行的请求，其中在队列中提供多个请求以供稍后执行。计算优先级指示符以分配给队列中的多个请求中的相应的请求，其中基于请求的延迟时间和预定义的优先级来计算优先级指示符。队列中的请求按照计算出的优先级指示按顺序执行。

4. 发明授权

US08818988B1 Database system having a regulator to provide feedback statistics to an optimizer 有权
标题翻译：数据库系统具有向优化器提供反馈统计信息的调节器
公开(公告)号：US08818988B1
公开(公告)日：2014-08-26
申请号：US12482780
申请日：2009-06-11
申请人： Douglas P. Brown , Anita Richards , Louis M. Burger , Stephen A. Brobst
发明人： Douglas P. Brown , Anita Richards , Louis M. Burger , Stephen A. Brobst
IPC分类号： G06F17/30
CPC分类号： G06F17/30306
摘要： A database system includes an optimizer to generate resource estimates regarding execution of a request in the database system, and a regulator to monitor execution of a request and to adjust a priority level of the request based on the monitored execution and based on the resource estimates provided by the optimizer. The regulator is executable to further feed back statistics regarding execution of the request to the optimizer to improve accuracy of resource estimates provided by the optimizer.
摘要翻译：数据库系统包括：优化器，用于生成关于在数据库系统中执行请求的资源估计;以及调节器，用于监视请求的执行，并且基于所监视的执行并基于提供的资源估计来调整请求的优先级由优化器。调节器可执行以进一步反馈关于执行请求的统计信息给优化器，以提高由优化器提供的资源估计的准确性。

5. 发明授权

US08434075B1 Branching optimization in a multi-database system 有权
标题翻译：在多数据库系统中分支优化
公开(公告)号：US08434075B1
公开(公告)日：2013-04-30
申请号：US12423885
申请日：2009-04-15
申请人： Douglas P. Brown , John Mark Morris
发明人： Douglas P. Brown , John Mark Morris
IPC分类号： G06F9/45 , G06F9/44 , G06F17/30
CPC分类号： G06F17/30463
摘要： Execution of a query is optimized. A plurality of plans for executing the query on a multi-database system are analyzed. A first plan having a first step and a second step is selected. The first step of the first plan is executed. The plan selection is re-evaluated before executing the second step of the first plan. A second plan of the plurality of plans for executing the query is executed to produce a result. The result is stored.
摘要翻译：对查询的执行进行了优化。分析了用于在多数据库系统上执行查询的多个计划。选择具有第一步骤和第二步骤的第一计划。执行第一个计划的第一步。在执行第一个计划的第二个步骤之前，重新评估计划选择。执行用于执行查询的多个计划的第二计划以产生结果。结果存储。

6. 发明申请

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).
摘要翻译：包括数据库的计算环境的容量可以通过一个或多个任务或活动（例如，数据库工作）来调节一个或多个资源的使用来维持在目标容量。此外，资源的使用可以基于一个或多个未受管制的其他活动（例如，不能被数据库系统管理的非数据库活动）的资源的使用程度来调节。。换句话说，考虑到一个或多个资源被一个或多个其他任务或活动使用的程度，有效调整一个或多个任务可以访问一个或多个资源的程度可以维持目标能力，对资源的访问没有受到管制。

7. 发明授权

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监管者沟通来监控域内的状态，事件和状况以及响应于系统状态来调整系统的操作特性来管理域和多个系统的操作特性，事件和条件。

8. 发明授权

US08280869B1 Sharing intermediate results 有权
标题翻译：共享中间结果
公开(公告)号：US08280869B1
公开(公告)日：2012-10-02
申请号：US12500680
申请日：2009-07-10
申请人： Louis Martin Burger , Thomas Patrick Julien , Douglas P. Brown , Jeffrey S. Shelton
发明人： Louis Martin Burger , Thomas Patrick Julien , Douglas P. Brown , Jeffrey S. Shelton
IPC分类号： G06F17/00
CPC分类号： G06F17/30501
摘要： A temporary computer-stored first-unit intermediate result is generated while executing a first unit of work on a computer-based database management system. The first-unit intermediate result has properties. It is determined that the properties of the first-unit intermediate result are similar to properties of a second-unit intermediate result to be generated for a second unit of work when the second unit of work is executed on the computer-based database management system. In response, the first-unit intermediate result is saved for use in executing the second unit of work.
摘要翻译：在基于计算机的数据库管理系统上执行第一工作单元时，生成临时计算机存储的第一单元中间结果。第一单元中间结果具有属性。确定当在基于计算机的数据库管理系统上执行第二工作单元时，第一单元中间结果的属性类似于将为第二工作单元生成的第二单元中间结果的属性。作为响应，第一单元中间结果被保存用于执行第二单元工作。

9. 发明授权

US07693847B1 Administering workload groups 有权
标题翻译：管理工作负载组
公开(公告)号：US07693847B1
公开(公告)日：2010-04-06
申请号：US10889796
申请日：2004-07-13
申请人： Douglas P. Brown , Anita Richards , Bhashyam Ramesh
发明人： Douglas P. Brown , Anita Richards , Bhashyam Ramesh
IPC分类号： G06F17/00 , G06F9/46
CPC分类号： G06F9/5038 , G06F2209/5021
摘要： A method, system and computer program for mapping business concepts related to the processing of requests on a database system to database system feature settings is disclosed. Rules limit the requests that will be submitted to the database system for processing and establish workload definitions that can be used to map each request submitted to the database system for processing to database feature settings, based on business concepts associated with each request.
摘要翻译：公开了一种用于将与数据库系统上的请求的处理相关的业务概念映射到数据库系统特征设置的方法，系统和计算机程序。规则将基于与每个请求相关联的业务概念限制将提交到数据库系统进行处理和建立可用于将提交到数据库系统的每个请求映射到数据库功能设置的工作负载定义的请求。

10. 发明授权

US07657501B1 Regulating the workload of a database system 有权
标题翻译：调节数据库系统的工作量
公开(公告)号：US07657501B1
公开(公告)日：2010-02-02
申请号：US10915609
申请日：2004-08-10
申请人： Douglas P. Brown , Anita Richards , Bhashyam Ramesh
发明人： Douglas P. Brown , Anita Richards , Bhashyam Ramesh
IPC分类号： G06F7/00
CPC分类号： G06F17/30474 , G06F9/5083 , G06F17/30545 , G06F2209/508 , Y10S707/99932
摘要： A method, computer program and system for regulating the workload of a database system as it processes one or more requests are disclosed. The requests are grouped into workload groups and are processed by one or more of a plurality of subsystems within the database system. Each subsystem has resources. The system has resources. The subsystem resources and the system resources are allocated across the workload groups. The method, computer program and system include monitoring, at a subsystem level, the processing of the requests and adjusting the allocation of subsystem resources to workload groups to achieve a subsystem goal and monitoring, at a system level, the processing of the requests and adjusting the allocation of system resources to workload groups to achieve a system goal. The subsystems are arranged in a hierarchical network. The method includes each subsystem reporting through the hierarchy of the network the consumption level of its resources and each subsystem reporting through the hierarchy of the network the consumption level of the resources of other subsystems reporting to it according to the hierarchy.
摘要翻译：公开了一种在处理一个或多个请求时调节数据库系统的工作量的方法，计算机程序和系统。请求被分组为工作负载组，并由数据库系统内的多个子系统中的一个或多个处理。每个子系统都有资源。系统有资源。子系统资源和系统资源分配在各个工作负载组之间。该方法，计算机程序和系统包括在子系统级别监视处理请求并调整子系统资源对工作负载组的分配，以实现子系统目标并在系统级监视请求的处理和调整将系统资源分配给工作组，实现系统目标。子系统被布置在分层网络中。该方法包括每个子系统通过网络的层次结构报告其资源的消耗水平和每个子系统通过网络的层次结构报告根据层次结构向其报告的其他子系统的资源的消耗水平。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式