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

1. 发明授权

US07673291B2 Automatic database diagnostic monitor architecture 有权
标题翻译：自动数据库诊断监视器架构
公开(公告)号：US07673291B2
公开(公告)日：2010-03-02
申请号：US10775531
申请日：2004-02-09
申请人： Karl Dias , Shivani Gupta , Mark Ramacher , Uri Shaft , Venkateshwaran Venkataramani , Graham S. Wood , Juan Loaiza
发明人： Karl Dias , Shivani Gupta , Mark Ramacher , Uri Shaft , Venkateshwaran Venkataramani , Graham S. Wood , Juan Loaiza
IPC分类号： G06F9/44 , G06F12/00 , G06F11/00
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.
摘要翻译：提供了数据库中自我诊断性能问题的技术。这些技术包括对数据库系统中的一个或多个性能问题进行分类。然后确定用于量化一个或多个性能问题对数据库系统的影响的一个或多个值。量化值基于数据库系统中的操作性能来确定。然后确定基于一个或多个量化值的性能问题。产生性能问题的解决方案，并可以输出。

2. 发明授权

US07292961B2 Capturing session activity as in-memory snapshots using a time-based sampling technique within a database for performance tuning and problem diagnosis 有权
标题翻译：使用数据库中的基于时间的抽样技术将会话活动作为内存快照捕获，以进行性能调优和问题诊断
公开(公告)号：US07292961B2
公开(公告)日：2007-11-06
申请号：US10775733
申请日：2004-02-09
申请人： Karl Dias , Venkateshwaran Venkataramani , Mark Ramacher , Graham S. Wood , Juan Loaiza
发明人： Karl Dias , Venkateshwaran Venkataramani , Mark Ramacher , Graham S. Wood , Juan Loaiza
IPC分类号： G06F17/40
CPC分类号： G06F17/30306 , G06F17/30368
摘要： Techniques for capturing samples of session activity in a database are provided. Session activity for active sessions is recorded at certain times over a time period. Accordingly, a sample of session activity is taken for sessions in a database.
摘要翻译：提供了在数据库中捕获会话活动样本的技术。活动会话的会话活动在一段时间内被记录在特定时间。因此，会话活动的样本被用于数据库中的会话。

3. 发明申请

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

4. 发明申请

US20050055383A1 Capturing session activity as in-memory snapshots using a time-based sampling technique within a database for performance tuning and problem diagnosis 有权
标题翻译：使用数据库中的基于时间的抽样技术将会话活动作为内存快照捕获，以进行性能调优和问题诊断
公开(公告)号：US20050055383A1
公开(公告)日：2005-03-10
申请号：US10775733
申请日：2004-02-09
申请人： Karl Dias , Venkateshwaran Venkataramani , Mark Ramacher , Graham Wood , Juan Loaiza
发明人： Karl Dias , Venkateshwaran Venkataramani , Mark Ramacher , Graham Wood , Juan Loaiza
IPC分类号： G06F17/30
CPC分类号： G06F17/30306 , G06F17/30368
摘要： Techniques for capturing samples of session activity in a database are provided. Session activity for active sessions is recorded at certain times over a time period. Accordingly, a sample of session activity is taken for sessions in a database.
摘要翻译：提供了在数据库中捕获会话活动样本的技术。活动会话的会话活动在一段时间内被记录在特定时间。因此，会话活动的样本被用于数据库中的会话。

5. 发明授权

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

6. 发明申请

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

7. 发明授权

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

8. 发明授权

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

9. 发明授权

US08224977B2 Using local locks for global synchronization in multi-node systems 有权
标题翻译：在多节点系统中使用本地锁进行全局同步
公开(公告)号：US08224977B2
公开(公告)日：2012-07-17
申请号：US11936010
申请日：2007-11-06
申请人： Juan Loaiza , Sashikanth Chandrasekaran , Neil MacNaughton
发明人： Juan Loaiza , Sashikanth Chandrasekaran , Neil MacNaughton
IPC分类号： G06F15/16
CPC分类号： G06F9/526
摘要： Described herein are techniques for global synchronization that under various scenarios eliminate or defer the acquisition of global locks. In many cases, the need to acquire global locks is eliminated, thereby saving the overhead attendant to processing global locks.
摘要翻译：这里描述的是用于全局同步的技术，其在各种情况下消除或推迟对全局锁的采集。在许多情况下，消除了获取全局锁的需求，从而节省了处理全局锁的开销。

10. 发明授权

US07376744B2 Using local locks for global synchronization in multi-node systems 有权
标题翻译：在多节点系统中使用本地锁进行全局同步
公开(公告)号：US07376744B2
公开(公告)日：2008-05-20
申请号：US10435229
申请日：2003-05-09
申请人： Juan Loaiza , Sashikanth Chandrasekaran , Neil MacNaughton
发明人： Juan Loaiza , Sashikanth Chandrasekaran , Neil MacNaughton
IPC分类号： G06F13/00
CPC分类号： G06F9/526
摘要： Described herein are techniques for global synchronization that under various scenarios eliminate or defer the acquisition of global locks. In many cases, the need to acquire global locks is eliminated, thereby saving the overhead attendant to processing global locks.
摘要翻译：这里描述的是用于全局同步的技术，其在各种情况下消除或推迟对全局锁的采集。在许多情况下，消除了获取全局锁的需求，从而节省了处理全局锁的开销。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式