-
公开(公告)号：US20070130231A1
公开(公告)日：2007-06-07
申请号：US11295409
申请日：2005-12-06
申请人： Douglas Brown , Anita Richards , Bhashyam Ramesh
发明人： Douglas Brown , Anita Richards , Bhashyam Ramesh
IPC分类号： G06F17/30
CPC分类号： G06F11/3409 , G06F11/3452 , G06F2201/80 , G06F2201/81 , G06F2201/86 , G06F2201/87
摘要： A closed-loop supportability system for a database system includes a system health check administrator to allow the definition of supportability service level goals, a supportability regulator to regulate the execution of the database system to attempt to achieve the supportability service level goals, a supportability monitor to provide real-time views of the database system performance against the supportability rules, and a supportability correlator to provide analysis of the database system performance against the supportability rules.
摘要翻译： 用于数据库系统的闭环支持系统包括系统健康检查管理员，以允许定义可支持性服务级别目标，支持性调节器来调节数据库系统的执行以尝试实现可支持性服务级别目标，可支持性监视器 根据支持性规则提供数据库系统性能的实时视图，以及可支持性相关器，根据可支持性规则提供数据库系统性能分析。
-
公开(公告)号：US20070100793A1
公开(公告)日：2007-05-03
申请号：US11254374
申请日：2005-10-20
申请人： Douglas Brown , Bhashyam Ramesh , Anita Richards
发明人： Douglas Brown , Bhashyam Ramesh , Anita Richards
IPC分类号： G06F17/30
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.
摘要翻译： 公开了一种用于识别由第一来源发送到数据库管理系统的请求的第二来源的方法，计算机程序和数据库系统。 从第一个源接收数据库消息。 数据库消息包括用于第二源标识参数的第二值。 第二个值标识第二个来源。 第二个源识别参数的第二个值存储在日志中。
-
公开(公告)号：US20060026179A1
公开(公告)日：2006-02-02
申请号：US11027896
申请日：2004-12-30
申请人： Douglas Brown , Bhashyam Ramesh , Anita Richards
发明人： Douglas Brown , Bhashyam Ramesh , Anita Richards
IPC分类号： G06F7/00
CPC分类号： G06F16/217
摘要： The described technique is for use in analyzing performance of a database system as it executes requests that are sorted into multiple workload groups, where each workload group has an associated level of service that is desired from the database system. The technique involves gathering data that describes performance metrics for the database system as it executes the requests in at least one of the workload groups, organizing the data in a format that shows changes in the performance metrics over time, and delivering the data in this format for viewing by a human user.
摘要翻译： 所描述的技术用于分析数据库系统的性能，因为它执行分类到多个工作负荷组的请求，其中每个工作负荷组具有从数据库系统期望的相关联的服务级别。 该技术涉及收集描述数据库系统的性能指标的数据，因为它执行至少一个工作负载组中的请求，以随时间显示性能指标变化的格式组织数据，并以此格式传送数据 供人类用户观看。
-
公开(公告)号：US20070174346A1
公开(公告)日：2007-07-26
申请号：US11334615
申请日：2006-01-18
申请人： Douglas Brown , Anita Richards , Bhashyam Ramesh
发明人： Douglas Brown , Anita Richards , Bhashyam Ramesh
IPC分类号： G06F17/30
CPC分类号： G06F16/20
摘要： A method, computer program, and database system for configuring a model of a database system are disclosed. The database system has a configuration. Two or more ordered levels of configuration assistance are provided. Each of the levels offers a different combination of the following forms of assistance: no assistance, workload analysis, cost-based performance analysis, and simulation.
摘要翻译： 公开了一种用于配置数据库系统的模型的方法，计算机程序和数据库系统。 数据库系统有一个配置。 提供了两个或多个有序级别的配置帮助。 每个级别提供以下形式的帮助的不同组合：无需帮助，工作负载分析，基于成本的性能分析和模拟。
-
公开(公告)号：US20070162426A1
公开(公告)日：2007-07-12
申请号：US11328702
申请日：2006-01-10
申请人： Douglas Brown , Anita Richards , Bhashyam Ramesh
发明人： Douglas Brown , Anita Richards , Bhashyam Ramesh
CPC分类号： G06F17/30457 , G06Q30/0283
摘要： A method, computer system, and database system for optimizing processing of a request are disclosed. 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.
摘要翻译： 公开了一种优化处理请求的方法，计算机系统和数据库系统。 请求具有一个或多个谓词。 创建请求中一个或多个谓词的列表，并创建实际成本尚未存储的谓词，或从列表中修剪成本无法估计的谓词。 选择每个谓词的访问路径。 使用所选择的访问路径处理请求，产生一个或多个实际的谓词成本。 存储一个或多个实际谓词成本。
-
公开(公告)号：US07860858B2
公开(公告)日：2010-12-28
申请号：US11328702
申请日：2006-01-10
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.
摘要翻译： 优化处理请求。 请求具有一个或多个谓词。 创建请求中一个或多个谓词的列表，并创建实际成本尚未存储的谓词，或从列表中修剪成本无法估计的谓词。 选择每个谓词的访问路径。 使用所选择的访问路径处理请求，产生一个或多个实际的谓词成本。 存储一个或多个实际谓词成本。
-
7.发明申请公开(公告)号：US20090049024A1
公开(公告)日：2009-02-19
申请号：US11891919
申请日：2007-08-14
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调节器通信以监视数据库系统的系统状况和域内的操作环境事件，并且基于系统在域内的数据库系统之间提供动态查询优化 条件和操作环境事件。
-
公开(公告)号：US08280867B2
公开(公告)日：2012-10-02
申请号：US11254374
申请日：2005-10-20
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
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.
摘要翻译： 在一种方法中，用于在数据库系统执行一个或多个请求时管理数据库系统的工作负荷的计算机程序和过程被分类到一个或多个工作负载组中。 每个工作负载组都具有从数据库系统所需的相关级别的服务。 一个或多个请求按照旨在实现与每个工作负载组相关联的服务级别的顺序来执行。 根据需要将系统资源分配给一个或多个工作负载组，以提供与每个工作负荷组相关联的服务级别。 在短时间内监视请求的执行以检测与服务水平的偏差大于短期阈值。 如果检测到这种偏差，则调整系统资源到工作负载组的分配以减少偏差。 监测也是长期执行的，以检测与预期服务水平的偏差大于长期阈值。 如果检测到这种偏差，则调整请求的执行以更好地提供预期的服务水平。
-
公开(公告)号：US08645425B1
公开(公告)日：2014-02-04
申请号：US10786448
申请日：2004-02-25
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。
-
-
-
-
-
-
-
-
-
搜索结果
72 条记录 (耗时 0.026 秒)
