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

1. 发明申请

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

2. 发明申请

US20050086195A1 Self-managing database architecture 有权
标题翻译：自我管理数据库架构
公开(公告)号：US20050086195A1
公开(公告)日：2005-04-21
申请号：US10934076
申请日：2004-09-03
申请人： Leng Leng Tan , Gianfranco Putzolu , Richard Sarwal , Alex Tsukerman , Gary Ngai , Graham Wood , Karl Dias , Mark Ramacher , Benoit Dageville , Mohamed Ziauddin , Tirthankar Lahiri , Sujatha Muthulingam , Vishwanath Karra , Francisco Sanchez , Hsiao-Te Su , Wanli Yang , Vasudha Krishnaswamy , Sushil Kumar
发明人： Leng Leng Tan , Gianfranco Putzolu , Richard Sarwal , Alex Tsukerman , Gary Ngai , Graham Wood , Karl Dias , Mark Ramacher , Benoit Dageville , Mohamed Ziauddin , Tirthankar Lahiri , Sujatha Muthulingam , Vishwanath Karra , Francisco Sanchez , Hsiao-Te Su , Wanli Yang , Vasudha Krishnaswamy , Sushil Kumar
IPC分类号： G06F7/00 , G06F17/00 , G06F17/30
CPC分类号： G06F17/30289 , Y10S707/99932 , Y10S707/99945
摘要： An intelligent database infrastructure wherein the management of all database components is performed by and within the database itself by integrating management of various components with a central management control. Each individual database component, as well as the central management control, is self-managing. A central management control module integrates and interacts with the various database components. The database is configured to automatically tune to varying workloads and configurations, correct or alert about bad conditions, and advise on ways to improve overall system performance.
摘要翻译：智能数据库基础设施，其中所有数据库组件的管理由数据库本身和数据库本身进行管理，通过集中管理各种组件与中央管理控制。每个单独的数据库组件以及中央管理控制都是自我管理的。中央管理控制模块集成并与各种数据库组件进行交互。数据库被配置为自动调整到不同的工作负载和配置，纠正或警告恶劣条件，并提供有关如何提高整体系统性能的建议。

3. 发明申请

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.
摘要翻译：提供了在数据库中捕获会话活动样本的技术。活动会话的会话活动在一段时间内被记录在特定时间。因此，会话活动的样本被用于数据库中的会话。

4. 发明申请

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

5. 发明申请

US20050086263A1 Self-managing performance statistics repository for databases 有权
标题翻译：数据库的自我管理性能统计信息库
公开(公告)号：US20050086263A1
公开(公告)日：2005-04-21
申请号：US10934771
申请日：2004-09-03
申请人： Gary Ngai , Michael Feng , Alex Tsukerman , Benoit Dageville , Mark Ramacher , Karl Dias , Graham Wood , Leng Leng Tan , Richard Sarwal , Sushil Kumar
发明人： Gary Ngai , Michael Feng , Alex Tsukerman , Benoit Dageville , Mark Ramacher , Karl Dias , Graham Wood , Leng Leng Tan , Richard Sarwal , Sushil Kumar
IPC分类号： G06F7/00
CPC分类号： G06F17/30306
摘要： A self-managing workload repository (AWR) infrastructure useful for a database server to collect and manage selected sets of important system performance statistics. Based on a schedule, the AWR runs automatically to collect data about the operation of the database system, and stores the data that it captures into the database. The AWR is advantageously designed to be lightweight and to self manage its use of storage space so as to avoid ending up with a repository of performance data that is larger than the database that it is capturing data about. The AWR is configured to automatically capture snapshots of statistics data on a periodic basis as well as purge stale data on a periodic basis. Both the frequency of the statistics data capture and length of time for which data is kept is adjustable. Manual snapshots and purging may also be performed. The AWR captured data allows for both system level and user level analysis to be automatically performed without unduly impacting system performance, e.g., by eliminating or reducing the requirement to repeat the workload in order to diagnose problems.
摘要翻译：自管理工作负载存储库（AWR）基础架构可用于数据库服务器收集和管理所选的重要系统性能统计信息。根据计划，AWR自动运行以收集有关数据库系统操作的数据，并将其捕获的数据存储到数据库中。 AWR有利地被设计为轻量级并且自我管理其对存储空间的使用，以避免最终获得比它正在捕获数据的数据库更大的性能数据库。 AWR配置为定期自动捕获统计数据的快照，并定期清除过期数据。统计数据捕获的频率和保存数据的时间长短都是可调的。也可以执行手动快照和清除。 AWR捕获的数据允许自动执行系统级别和用户级别分析，而不会不必要地影响系统性能，例如通过消除或减少重复工作负载以便诊断问题的要求。

6. 发明申请

US20050086242A1 Automatic workload repository battery of performance statistics 有权
标题翻译：自动工作负载库电池的性能统计
公开(公告)号：US20050086242A1
公开(公告)日：2005-04-21
申请号：US10934344
申请日：2004-09-03
申请人： Gary Ngai , Mark Ramacher , Graham Wood , Connie Green , Venkateshwaran Venkataramani , Karl Dias , Benoit Dageville , Michael Feng
发明人： Gary Ngai , Mark Ramacher , Graham Wood , Connie Green , Venkateshwaran Venkataramani , Karl Dias , Benoit Dageville , Michael Feng
IPC分类号： G06F7/00 , G06F17/00 , G06F17/30
CPC分类号： G06F17/30289 , Y10S707/99932 , Y10S707/99945
摘要： A self-managing workload repository infrastructure (or “AWR” for Automatic workload repository) which is useful for a database server to collect and manage useful system performance statistics. The AWR runs automatically to collect performance data about the operation of the database system, and stores the data that it captures into the database. The collection process is done inside the database, and the collection process is highly efficient as data is retrieved directly from the shared memory of the database kernel. The data captured allows both system level and user level analysis to be performed without unduly impacting system performance, e.g., by eliminating or reducing the requirement to repeat the workload in order to diagnose problems. The AWR is configured to automatically capture snapshots of statistics data on a periodic basis as well as purge stale data on a periodic basis. The captured performance data includes one or more of the top N (e.g., 20 or 30) statistics for activities involving a large set of objects, time-based statistics, cumulative statistics, sampled data and metrics and other data types.
摘要翻译：自管理工作负载存储库基础架构（或自动工作负载存储库的“AWR”），可用于数据库服务器收集和管理有用的系统性能统计信息。 AWR自动运行以收集有关数据库系统操作的性能数据，并将其捕获的数据存储到数据库中。收集过程在数据库内完成，并且收集过程非常有效，因为直接从数据库内核的共享内存中检索数据。捕获的数据允许执行系统级别和用户级别分析，而不会不必要地影响系统性能，例如通过消除或减少重复工作负载以便诊断问题的要求。 AWR配置为定期自动捕获统计数据的快照，并定期清除过期数据。捕获的性能数据包括涉及大量对象，基于时间的统计，累积统计，采样数据和度量以及其他数据类型的活动的前N（例如，20或30）统计信息中的一个或多个。

7. 发明申请

US20050216490A1 Automatic database diagnostic usage models 有权
标题翻译：自动数据库诊断使用模式
公开(公告)号：US20050216490A1
公开(公告)日：2005-09-29
申请号：US10916695
申请日：2004-08-11
申请人： Karl Dias , Graham Wood , Shivani Gupta , Sushil Kumar , Mark Ramacher , Uri Shaft , Leng Leng Tan , Venkateshwaran Venkataramani
发明人： Karl Dias , Graham Wood , Shivani Gupta , Sushil Kumar , Mark Ramacher , Uri Shaft , Leng Leng Tan , Venkateshwaran Venkataramani
IPC分类号： G06F7/00 , G06F17/30
CPC分类号： G06F17/30289
摘要： One or more usage models are provided for a database. Each usage model includes a set of rules that are used to analyze database performance. A usage model in one or more usage models is determined. Database information is determined based on the usage model. The database information is then analyzed based on rules associated with the usage model. One or more performance problems are determined based on the analysis.
摘要翻译：为数据库提供一个或多个使用模型。每个使用模型都包含一组用于分析数据库性能的规则。确定一个或多个使用模型中的使用模型。数据库信息是根据使用模式确定的。然后基于与使用模型相关联的规则来分析数据库信息。基于分析确定一个或多个性能问题。

8. 发明授权

US07603340B2 Automatic workload repository battery of performance statistics 有权
标题翻译：自动工作负载库电池的性能统计
公开(公告)号：US07603340B2
公开(公告)日：2009-10-13
申请号：US10934344
申请日：2004-09-03
申请人： Gary Ngai , Mark Ramacher , Graham Wood , Connie Green , Venkateshwaran Venkatatamani , Karl Dias , Benoit Dageville , Michael Feng
发明人： Gary Ngai , Mark Ramacher , Graham Wood , Connie Green , Venkateshwaran Venkatatamani , Karl Dias , Benoit Dageville , Michael Feng
IPC分类号： G06F7/00 , G06F17/30
CPC分类号： G06F17/30289 , Y10S707/99932 , Y10S707/99945
摘要： A self-managing workload repository infrastructure (or “AWR” for Automatic workload repository) which is useful for a database server to collect and manage useful system performance statistics. The AWR runs automatically to collect performance data about the operation of the database system, and stores the data that it captures into the database. The collection process is done inside the database, and the collection process is highly efficient as data is retrieved directly from the shared memory of the database kernel. The data captured allows both system level and user level analysis to be performed without unduly impacting system performance, e.g., by eliminating or reducing the requirement to repeat the workload in order to diagnose problems. The AWR is configured to automatically capture snapshots of statistics data on a periodic basis as well as purge stale data on a periodic basis. The captured performance data includes one or more of the top N (e.g., 20 or 30) statistics for activities involving a large set of objects, time-based statistics, cumulative statistics, sampled data and metrics and other data types.
摘要翻译：自管理工作负载存储库基础架构（或自动工作负载存储库的“AWR”），可用于数据库服务器收集和管理有用的系统性能统计信息。 AWR自动运行以收集有关数据库系统操作的性能数据，并将其捕获的数据存储到数据库中。收集过程在数据库内完成，并且收集过程非常有效，因为直接从数据库内核的共享内存中检索数据。捕获的数据允许执行系统级别和用户级别分析，而不会不必要地影响系统性能，例如通过消除或减少重复工作负载以便诊断问题的要求。 AWR配置为定期自动捕获统计数据的快照，并定期清除过期数据。捕获的性能数据包括涉及大量对象，基于时间的统计，累积统计，采样数据和度量以及其他数据类型的活动的前N（例如，20或30）统计信息中的一个或多个。

9. 发明申请

US20090106756A1 Automatic Workload Repository Performance Baselines 有权
标题翻译：自动工作负载存储库性能基准
公开(公告)号：US20090106756A1
公开(公告)日：2009-04-23
申请号：US12111011
申请日：2008-04-28
申请人： Mike Feng , Mark Ramacher , Gary Ngai , Graham Wood , John Beresniewicz
发明人： Mike Feng , Mark Ramacher , Gary Ngai , Graham Wood , John Beresniewicz
IPC分类号： G06F9/46
CPC分类号： G06F11/3495 , G06F11/3409 , G06F11/3428 , G06F11/3616
摘要： Techniques that improve manageability of systems. Techniques are provided for creating different types of baselines that are more flexible and dynamic in nature. A future-based baseline may be created defining a period of time, wherein at least a portion of the period of time is in the future. A baseline may be created that is a composite of multiple baselines. In general, baselines may be specified having one or more periods of time that are either contiguous or non-contiguous. A template for creating a set of baselines based on a set of time periods may also be created, where the template can be used to create a baseline for each of the set of time periods. A moving window baseline may be created having an associated time window that changes with passage of time, where accordingly the data associated with the baseline may also dynamically change with passage of time.
摘要翻译：提高系统可管理性的技术。提供了技术来创建不同类型的基础，这些基准在本质上更加灵活和动态。可以创建定义一段时间的基于未来的基线，其中至少一部分时间段在将来。可以创建一个基准，该基准是多个基线的组合。通常，可以指定具有连续或不连续的一个或多个时间段的基线。还可以创建用于基于一组时间段来创建一组基线的模板，其中可以使用该模板为每组时间段创建基准。可以创建具有随时间变化而变化的相关联的时间窗口的移动窗口基线，其中因此与基线相关联的数据也随着时间的推移而动态地改变。

10. 发明申请

US20050086246A1 Database performance baselines 有权
标题翻译：数据库性能基准
公开(公告)号：US20050086246A1
公开(公告)日：2005-04-21
申请号：US10934345
申请日：2004-09-03
申请人： Graham Wood , Alex Tsukerman , Richard Sarwal , Gary Ngai , Mark Ramacher , Leng Leng Tan
发明人： Graham Wood , Alex Tsukerman , Richard Sarwal , Gary Ngai , Mark Ramacher , Leng Leng Tan
IPC分类号： G06F7/00 , G06F17/00 , G06F17/30
CPC分类号： G06F17/30289 , Y10S707/99932 , Y10S707/99945
摘要： Systems and methods to define and store performance baselines. A baseline may be defined as a pair of snapshots, each snapshot containing the same set of statistics and having a timestamp value associated therewith. The present invention allows for the designation, automatically or manually, of statistics collected over a certain period of time to be stored and used for comparison. Baselines may be used, for example, to manually or automatically compare with current system performance, compare difference-difference values and set thresholds to monitor current system performance.
摘要翻译：定义和存储性能基线的系统和方法。基线可以被定义为一对快照，每个快照包含相同的一组统计信息并具有与之相关联的时间戳值。本发明允许自动或手动地指定在一段时间内收集的统计数据，并将其用于比较。可以使用基线来手动或自动与当前系统性能进行比较，比较差异差值和设置阈值以监视当前系统性能。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式