公开(公告)号：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。

公开(公告)号：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.

摘要翻译： 在作为数据库系统编程的计算机上接收到请求。 请求是从由查询和实用程序组成的组中选择的请求。 业务概念与请求相关联。 业务概念是从由定义请求的源的“谁”信息组成的组中选择的业务概念，“什么”定义要由请求执行的处理的信息，其中“定义请求将要的数据库对象的信息 影响。 计算机通过将与请求相关联的业务概念映射到工作负载来将接收的请求映射到数据库特征设置。 工作负载由工作负载定义（包括映射到请求的业务概念的工作负载分类属性）定义，工作负载限制属性定义了分配给工作负载的请求受到限制的条件。 基于工作负载定义，将数据库系统提交的请求提交到处理中。

公开(公告)号：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.

摘要翻译： 公开了一种用于识别由第一来源发送到数据库管理系统的请求的第二来源的方法，计算机程序和数据库系统。 从第一个源接收数据库消息。 数据库消息包括用于第二源标识参数的第二值。 第二个值标识第二个来源。 第二个源识别参数的第二个值存储在日志中。

公开(公告)号：US07395537B1

公开(公告)日：2008-07-01

申请号：US10730348

申请日：2003-12-08

申请人： Douglas P. Brown ,  Anita Richards ,  Bhashyam Ramesh ,  Caroline M. Ballinger ,  Richard D. Glick

发明人： Douglas P. Brown ,  Anita Richards ,  Bhashyam Ramesh ,  Caroline M. Ballinger ,  Richard D. Glick

IPC分类号： G06F9/46 ,  G06F7/00 ,  G06F15/16

CPC分类号： G06F17/30306 ,  Y10S707/99931 ,  Y10S707/99932

摘要： In a method, computer program and process for administering the workload of a database system as it executes one or more requests the one or more requests are sorted into one or more workload groups. Each workload group has an associated level of service desired from the database system. The one or more requests are executed in an order intended to achieve the levels of service associated with each of the workload groups. The system resources are assigned to the one or more workload groups as necessary to provide the level of service associated with each workload group. The execution of requests is monitored on a short-term basis to detect a deviation from the level of service greater than a short-term threshold. If such a deviation is detected, the assignment of system resources to workload groups is adjusted to reduce the deviation. Monitoring is also performed on a long-term basis to detect deviations from the expected level of service greater than a long-term threshold. If such a deviation is detected, the execution of requests is adjusted to better provide the expected level of service.

摘要翻译： 在一种方法中，用于在数据库系统执行一个或多个请求时管理数据库系统的工作负荷的计算机程序和过程被分类到一个或多个工作负载组中。 每个工作负载组都具有从数据库系统所需的相关级别的服务。 一个或多个请求按照旨在实现与每个工作负载组相关联的服务级别的顺序来执行。 根据需要将系统资源分配给一个或多个工作负载组，以提供与每个工作负荷组相关联的服务级别。 在短时间内监视请求的执行以检测与服务水平的偏差大于短期阈值。 如果检测到这种偏差，则调整系统资源到工作负载组的分配以减少偏差。 监测也是长期执行的，以检测与预期服务水平的偏差大于长期阈值。 如果检测到这种偏差，则调整请求的执行以更好地提供预期的服务水平。

公开(公告)号：US07860858B2

公开(公告)日：2010-12-28

申请号：US11328702

申请日：2006-01-10

申请人： Douglas P. Brown ,  Anita Richards ,  Bhashyam Ramesh

发明人： Douglas P. Brown ,  Anita Richards ,  Bhashyam Ramesh

IPC分类号： G06F17/30 ,  G06Q99/00

CPC分类号： G06F17/30457 ,  G06Q30/0283

摘要： Processing of a request is optimized. The request has one or more predicates. A list of the one or more predicates in the request is created and predicates for which an actual cost has not been stored or for which a cost cannot be estimated are pruned from the list. An access path for the each of the predicates is selected. The request is processed using the selected access paths producing one or more actual predicate costs. The one or more actual predicate costs are stored.

摘要翻译： 优化处理请求。 请求具有一个或多个谓词。 创建请求中一个或多个谓词的列表，并创建实际成本尚未存储的谓词，或从列表中修剪成本无法估计的谓词。 选择每个谓词的访问路径。 使用所选择的访问路径处理请求，产生一个或多个实际的谓词成本。 存储一个或多个实际谓词成本。

公开(公告)号：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调节器通信以监视数据库系统的系统状况和域内的操作环境事件，并且基于系统在域内的数据库系统之间提供动态查询优化 条件和操作环境事件。

公开(公告)号：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.

摘要翻译： 公开了一种用于将与数据库系统上的请求的处理相关的业务概念映射到数据库系统特征设置的方法，系统和计算机程序。 规则将基于与每个请求相关联的业务概念限制将提交到数据库系统进行处理和建立可用于将提交到数据库系统的每个请求映射到数据库功能设置的工作负载定义的请求。

公开(公告)号：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.

摘要翻译： 公开了一种在处理一个或多个请求时调节数据库系统的工作量的方法，计算机程序和系统。 请求被分组为工作负载组，并由数据库系统内的多个子系统中的一个或多个处理。 每个子系统都有资源。 系统有资源。 子系统资源和系统资源分配在各个工作负载组之间。 该方法，计算机程序和系统包括在子系统级别监视处理请求并调整子系统资源对工作负载组的分配，以实现子系统目标并在系统级监视请求的处理和调整 将系统资源分配给工作组，实现系统目标。 子系统被布置在分层网络中。 该方法包括每个子系统通过网络的层次结构报告其资源的消耗水平和每个子系统通过网络的层次结构报告根据层次结构向其报告的其他子系统的资源的消耗水平。

公开(公告)号：US07647280B1

公开(公告)日：2010-01-12

申请号：US10730629

申请日：2003-12-08

申请人： Bhashyam Ramesh ,  Douglas P. Brown

发明人： Bhashyam Ramesh ,  Douglas P. Brown

IPC分类号： G06Q99/00

CPC分类号： G06F17/30424 ,  G06F17/30442 ,  G06Q30/0283

摘要： Request processing is optimized. The request has elements. The method, computer program and database system includes selecting an access path for the request taking into consideration a stored actual request element cost, processing the request using the selected access path, producing one or more actual request element costs, and storing the one or more actual request element costs.

摘要翻译： 请求处理优化。 请求有元素。 所述方法，计算机程序和数据库系统包括：考虑所存储的实际请求单元成本，使用所选择的访问路径处理所述请求，产生一个或多个实际请求单元成本，以及存储所述一个或多个 实际请求元素成本。

公开(公告)号：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.