公开(公告)号：US07451448B1

公开(公告)日：2008-11-11

申请号：US09967068

申请日：2001-09-27

申请人： Ann Rhee ,  Sumanta Chatterjee ,  Juan Loaiza

发明人： Ann Rhee ,  Sumanta Chatterjee ,  Juan Loaiza

IPC分类号： G06F9/46 ,  G06F15/173 ,  G06F15/16

CPC分类号： G06F9/5027 ,  G06F2209/504 ,  Y02D10/22

摘要： A computer system is selectively quiesced by preventing selected resource consumers from starting new activity on a computer system, while allowing already-running activity to continue. Resource consumers are divided into resource consumer groups, and some groups are prevented from starting new activity while other groups are allowed to start new activity. A scheduler is used to alternate between resource plans, including a quiescence plan and an operations plan.

摘要翻译： 通过防止所选资源消费者在计算机系统上启动新活动，同时允许已经运行的活动继续，选择性地停止计算机系统。 资源消费者分为资源消费群体，一些群体被禁止开始新活动，而其他群体则被允许开始新的活动。 调度程序用于在资源计划之间进行交替，包括静默计划和操作计划。

公开(公告)号：US07017156B1

公开(公告)日：2006-03-21

申请号：US09967458

申请日：2001-09-27

申请人： Ann Rhee ,  Sumanta Chatterjee ,  Juan Loaiza

发明人： Ann Rhee ,  Sumanta Chatterjee ,  Juan Loaiza

IPC分类号： G06F9/46

CPC分类号： G06F9/4881 ,  G06F2209/5019

摘要： Access to computer system resources is regulated by computing an estimated execution time for an operation which seeks to use the resources. Once computed, the estimated execution time is used to make decisions about granting the operation access to the computer system resources. Operations which have an estimated execution time greater than a user-supplied maximum estimated execution time allowable for the operation are denied access to the computer system resources. Operations which are denied access are rescheduled for later operation, queued, or aborted.

摘要翻译： 对计算机系统资源的访问通过计算寻求使用资源的操作的估计执行时间来进行调节。 一旦计算出来，估计的执行时间用于作出关于授予对计算机系统资源的操作访问的决定。 估计执行时间大于操作允许的用户提供的最大估计执行时间的操作被拒绝访问计算机系统资源。 重新安排拒绝访问的操作，以便稍后操作，排队或中止。

公开(公告)号：US07526767B1

公开(公告)日：2009-04-28

申请号：US09967441

申请日：2001-09-27

申请人： Ann Rhee ,  Sumanta Chatterjee ,  Juan Loaiza

发明人： Ann Rhee ,  Sumanta Chatterjee ,  Juan Loaiza

IPC分类号： G06F9/46

CPC分类号： G06F9/5061

摘要： A resource scheduler is provided for allocating a computer system resource to database management system (DBMS) processes. The resource scheduler operates according to resource plans and resource allocation methods. Each plan allocates the resource according to a resource allocation method. During operation of the DBMS, any of the active plans and resource allocation method may be exchanged for alternate plans or resource allocation methods. The resource scheduler enforces an emphasis resource allocation method in which processor time is allocated in percentages to groups of database processes groupified according to common execution requirements. A selected plan includes multiple process groups and/or sub-plans. The resource scheduler allocates processor time in multiple levels among the sub-plans and groups of database processes. Database processes are automatically switched between the groups of a plan according to switch criteria.

摘要翻译： 提供资源调度器用于将计算机系统资源分配给数据库管理系统（DBMS）进程。 资源调度器根据资源计划和资源分配方式进行操作。 每个计划根据资源分配方法分配资源。 在DBMS的操作期间，可以为备用计划或资源分配方法交换任何活动计划和资源分配方法。 资源调度器执行强调资源分配方法，其中处理器时间按照按照常规执行要求分组的数据库进程的分组的百分比分配。 选定的计划包括多个进程组和/或子计划。 资源调度程序在数据库进程的子计划和组之间的多个级别中分配处理器时间。 数据库进程根据切换标准在计划组之间自动切换。

公开(公告)号：US07020878B1

公开(公告)日：2006-03-28

申请号：US09967459

申请日：2001-09-27

申请人： Ann Rhee ,  Sumanta Chatterjee ,  Juan Loaiza

发明人： Ann Rhee ,  Sumanta Chatterjee ,  Juan Loaiza

IPC分类号： G06F9/46

CPC分类号： G06F9/4881 ,  G06F2209/5019

摘要： One embodiment of the present invention provides a resource scheduler for allocating a computer system resource, such as memory or mass storage, within a processor, to database management system (DBMS) processes. The resource scheduler operates according to resource plans and resource allocation methods. One or more plans may be configured and loaded with the DBMS. Each plan allocates the resource according to an associated resource allocation method. During operation of the DBMS, any or all of the active plans and resource allocation methods may be exchanged for alternate plans or resource allocation methods. In one embodiment of the invention the resource scheduler enforces a maximum active sessions resource allocation method in which system resources are allocated by limiting the number of active sessions allowed in groups of database processes grouped according to common execution requirements. A selected plan includes multiple process groups and/or sub-plans. The resource scheduler allocates system resources among the sub-plans and groups of database processes according to their associated limits on active session numbers, with sub-plans and groups having higher active session limits getting access to more system resources than sub-plans and groups having lower active session limits.

摘要翻译： 本发明的一个实施例提供了一种资源调度器，用于将处理器内的诸如存储器或大容量存储的计算机系统资源分配给数据库管理系统（DBMS）处理。 资源调度器根据资源计划和资源分配方式进行操作。 一个或多个计划可以配置并加载到DBMS。 每个计划根据相关资源分配方法分配资源。 在DBMS的操作期间，任何或所有活动计划和资源分配方法可以被交换用于替代计划或资源分配方法。 在本发明的一个实施例中，资源调度器执行最大活动会话资源分配方法，其中通过限制根据共同执行需求分组的数据库进程组允许的活动会话的数量来分配系统资源。 选定的计划包括多个进程组和/或子计划。 资源调度程序根据其对活动会话号码的相关限制，在子计划和数据库进程组之间分配系统资源，具有较高活动会话限制的子计划和组比具有子计划和组的子计划和组具有访问更多的系统资源 活动会话限制较低

公开(公告)号：US06341303B1

公开(公告)日：2002-01-22

申请号：US09141664

申请日：1998-08-28

申请人： Ann Rhee ,  Sumanta K. Chatterjee ,  Juan R. Loaiza ,  Kesavan Srinivasan

发明人： Ann Rhee ,  Sumanta K. Chatterjee ,  Juan R. Loaiza ,  Kesavan Srinivasan

IPC分类号： G06F900

CPC分类号： G06F9/4881

摘要： A scheduler for allocating a computer system resource, such as processor time, among processes (e.g., database processes) according to a plan. A scheduling plan may include multiple sub-plans, and each plan and sub-plan may include multiple classes of processes with associated weights or values. Within a plan, the resource is first allocated to the classes and/or sub-plans included in a first level of the plan according to their associated weights. Any unallocated portion of the resource is then allocated to classes/sub-plans in subsequent levels, in turn, according to their assigned weights. If a given class of processes is empty when the resource is allocated in a level including the class, the allocation that would have been allotted to the class may be carried over into the next level. An active scheduling plan may be dynamically replaced during system operations.

摘要翻译： 用于根据计划在处理（例如，数据库处理）中分配诸如处理器时间的计算机系统资源的调度器。 调度计划可以包括多个子计划，并且每个计划和子计划可以包括具有相关联权重或值的多个进程类。 在计划中，资源首先根据其相关权重分配给计划第一级中包含的类和/或子计划。 然后将资源的任何未分配部分根据其分配的权重分配给后续级别中的类/子计划。 如果在包含该类的级别中分配资源时给定类的进程是空的，那么分配给该类的分配可能会被转移到下一级。 可以在系统操作期间动态地替换主动调度计划。

公开(公告)号：US06457008B1

公开(公告)日：2002-09-24

申请号：US09141666

申请日：1998-08-28

申请人： Ann Rhee ,  Sumanta K. Chatterjee ,  Juan R. Loaiza ,  Kesavan Srinivasan

发明人： Ann Rhee ,  Sumanta K. Chatterjee ,  Juan R. Loaiza ,  Kesavan Srinivasan

IPC分类号： G06F1700

CPC分类号： G06F9/4881 ,  G06F9/524

摘要： One embodiment of the present invention provides a resource scheduler for allocating a computer system resource, such as execution time within a processor, to database management system (DBMS) processes. The resource scheduler operates according to scheduling plans and policies. One or more plans may be configured and loaded with the DBMS. Each plan allocates the resource according to an associated policy but only one plan is active at a time. During operation of the DBMS, either or both of the active plan and policy may be exchanged for an alternate plan or policy without halting operation of the DBMS or the computer system.

摘要翻译： 本发明的一个实施例提供了一种用于将计算机系统资源（诸如处理器内的执行时间）分配给数据库管理系统（DBMS）进程的资源调度器。 资源调度器根据调度计划和策略进行操作。 一个或多个计划可以配置并加载到DBMS。 每个计划根据相关策略分配资源，但一次只有一个计划处于活动状态。 在DBMS的操作期间，可以在不停止DBMS或计算机系统的操作的情况下将活动计划和策略中的一个或两个交换为替代计划或策略。