利索-全球专利检索

  1. 登录
  2. 注册

搜索结果

42 条记录 (耗时 0.029 秒)

    Automatic database diagnostic monitor architecture
    1.
    发明申请
    Automatic database diagnostic monitor architecture 有权
    自动数据库诊断监视器架构

    公开(公告)号：US20050055673A1

    公开(公告)日：2005-03-10

    申请号：US10775531

    申请日：2004-02-09

    申请人： Karl Dias ,  Shivani Gupta ,  Mark Ramacher ,  Uri Shaft ,  Venkateshwaran Venkataramani ,  Graham Wood ,  Juan Loaiza

    发明人： Karl Dias ,  Shivani Gupta ,  Mark Ramacher ,  Uri Shaft ,  Venkateshwaran Venkataramani ,  Graham Wood ,  Juan Loaiza

    IPC分类号： G06F9/44

    CPC分类号： G06F17/30306 ,  G06F17/30371

    摘要： Techniques for self-diagnosing performance problems in a database are provided. The techniques include classifying one or more performance problems in a database system. One or more values for quantifying an impact of the one or more performance problems on the database system are then determined. The quantified values are determined based on the performance of operations in the database system. A performance problem based on the one or more quantified values is then determined. A solution for the performance problem is generated and may be outputted.

    摘要翻译： 提供了数据库中自我诊断性能问题的技术。 这些技术包括对数据库系统中的一个或多个性能问题进行分类。 然后确定用于量化一个或多个性能问题对数据库系统的影响的一个或多个值。 量化值基于数据库系统中的操作性能来确定。 然后确定基于一个或多个量化值的性能问题。 产生性能问题的解决方案，并可以输出。

    Time model
    5.
    发明申请
    Time model 有权
    时间模型

    公开(公告)号：US20050055672A1

    公开(公告)日：2005-03-10

    申请号：US10775513

    申请日：2004-02-09

    申请人： Mark Ramacher ,  Graham Wood ,  Juan Loaiza ,  Tirthankar Lahiri ,  Karl Dias

    发明人： Mark Ramacher ,  Graham Wood ,  Juan Loaiza ,  Tirthankar Lahiri ,  Karl Dias

    IPC分类号： G06F9/44

    CPC分类号： G06F17/30008 ,  Y10S707/99957

    摘要： Quantifying the impact of wasteful operations on a database system is provided. One or more operations that are determined to be wasteful are received. The impact of the wasteful operations on performance in a database may then be quantified. The database is monitored to determine when a wasteful operation is being performed. When a wasteful operation is detected, a time value is recorded of the time spent on processing the wasteful operation. The time value is stored and used to quantify an impact of a performance problem in a database. The time value may be stored and associated with other time values that are recorded for the same wasteful operation. Thus, the impact of wasteful operations that are performed and processed in a database may be determined.

    摘要翻译： 提供了浪费操作对数据库系统的影响。 接收到被确定为浪费的一个或多个操作。 然后可以量化浪费操作对数据库中的性能的影响。 监视数据库以确定何时执行浪费的操作。 当检测到浪费的操作时，记录处理浪费操作花费的时间的时间值。 时间值被存储并用于量化数据库中性能问题的影响。 时间值可以被存储并且与为相同的浪费操作记录的其他时间值相关联。 因此，可以确定在数据库中执行和处理的浪费操作的影响。

    Time model
    6.
    发明授权
    Time model 有权
    时间模型

    公开(公告)号：US07376682B2

    公开(公告)日：2008-05-20

    申请号：US10775513

    申请日：2004-02-09

    申请人： Mark Ramacher ,  Graham S. Wood ,  Juan Loaiza ,  Tirthankar Lahiri ,  Karl Dias

    发明人： Mark Ramacher ,  Graham S. Wood ,  Juan Loaiza ,  Tirthankar Lahiri ,  Karl Dias

    IPC分类号： G06F17/30

    CPC分类号： G06F17/30008 ,  Y10S707/99957

    摘要： Quantifying the impact of wasteful operations on a database system is provided. One or more operations that are determined to be wasteful are received. The impact of the wasteful operations on performance in a database may then be quantified. The database is monitored to determine when a wasteful operation is being performed. When a wasteful operation is detected, a time value is recorded of the time spent on processing the wasteful operation. The time value is stored and used to quantify an impact of a performance problem in a database. The time value may be stored and associated with other time values that are recorded for the same wasteful operation. Thus, the impact of wasteful operations that are performed and processed in a database may be determined.

    摘要翻译： 提供了浪费操作对数据库系统的影响。 接收到被确定为浪费的一个或多个操作。 然后可以量化浪费操作对数据库中的性能的影响。 监视数据库以确定何时执行浪费的操作。 当检测到浪费的操作时，记录处理浪费操作花费的时间的时间值。 时间值被存储并用于量化数据库中性能问题的影响。 时间值可以被存储并且与为相同的浪费操作记录的其他时间值相关联。 因此，可以确定在数据库中执行和处理的浪费操作的影响。

    Methods for automatic group switching according to a resource plan
    7.
    发明授权
    Methods for automatic group switching according to a resource plan 有权
    根据资源计划自动组切换的方法

    公开(公告)号：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的操作期间，可以为备用计划或资源分配方法交换任何活动计划和资源分配方法。 资源调度器执行强调资源分配方法，其中处理器时间按照按照常规执行要求分组的数据库进程的分组的百分比分配。 选定的计划包括多个进程组和/或子计划。 资源调度程序在数据库进程的子计划和组之间的多个级别中分配处理器时间。 数据库进程根据切换标准在计划组之间自动切换。

    System for allocating resource using the weight that represents a limitation on number of allowance active sessions associated with each resource consumer group
    8.
    发明授权
    System for allocating resource using the weight that represents a limitation on number of allowance active sessions associated with each resource consumer group 有权
    用于使用代表与每个资源消费者组相关联的允许活动会话的数量的限制的权重来分配资源的系统

    公开(公告)号：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的操作期间，任何或所有活动计划和资源分配方法可以被交换用于替代计划或资源分配方法。 在本发明的一个实施例中，资源调度器执行最大活动会话资源分配方法，其中通过限制根据共同执行需求分组的数据库进程组允许的活动会话的数量来分配系统资源。 选定的计划包括多个进程组和/或子计划。 资源调度程序根据其对活动会话号码的相关限制，在子计划和数据库进程组之间分配系统资源，具有较高活动会话限制的子计划和组比具有子计划和组的子计划和组具有访问更多的系统资源 活动会话限制较低