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

1. 发明授权

US07526508B2 Self-managing database architecture 有权
标题翻译：自我管理数据库架构
公开(公告)号：US07526508B2
公开(公告)日：2009-04-28
申请号：US10934076
申请日：2004-09-03
申请人： Leng Leng Tan , Gianfranco Putzolu , Richard Sarwal , Alex Tsukerman , Gary C. Ngai , Graham Stephen 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 C. Ngai , Graham Stephen 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分类号： 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.
摘要翻译：智能数据库基础设施，其中所有数据库组件的管理由数据库本身和数据库本身进行管理，通过集中管理各种组件与中央管理控制。每个单独的数据库组件以及中央管理控制都是自我管理的。中央管理控制模块集成并与各种数据库组件进行交互。数据库被配置为自动调整到不同的工作负载和配置，纠正或警告恶劣条件，并提供有关如何提高整体系统性能的建议。

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. 发明授权

US07774312B2 Self-managing performance statistics repository for databases 有权
标题翻译：数据库的自我管理性能统计信息库
公开(公告)号：US07774312B2
公开(公告)日：2010-08-10
申请号：US10934771
申请日：2004-09-03
申请人： Gary Ngai , Michael Feng , Alex Tsukerman , Benoit Dageville , Mark Ramacher , Karl Dias , Graham S. Wood , Leng Leng Tan , Richard Sarwal , Sushil Kumar
发明人： Gary Ngai , Michael Feng , Alex Tsukerman , Benoit Dageville , Mark Ramacher , Karl Dias , Graham S. Wood , Leng Leng Tan , Richard Sarwal , Sushil Kumar
IPC分类号： G06F17/30
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捕获的数据允许自动执行系统级别和用户级别分析，而不会不必要地影响系统性能，例如通过消除或减少重复工作负载以便诊断问题的要求。

4. 发明申请

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捕获的数据允许自动执行系统级别和用户级别分析，而不会不必要地影响系统性能，例如通过消除或减少重复工作负载以便诊断问题的要求。

5. 发明授权

US07664798B2 Database performance baselines 有权
标题翻译：数据库性能基准
公开(公告)号：US07664798B2
公开(公告)日：2010-02-16
申请号：US10934345
申请日：2004-09-03
申请人： Graham Stephen Wood , Alex Tsukerman , Richard Sarwal , Gary Ngai , Mark Ramacher , Leng Leng Tan
发明人： Graham Stephen Wood , Alex Tsukerman , Richard Sarwal , Gary Ngai , Mark Ramacher , Leng Leng Tan
IPC分类号： G07F17/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.
摘要翻译：定义和存储性能基线的系统和方法。基线可以被定义为一对快照，每个快照包含相同的一组统计信息并具有与之相关联的时间戳值。本发明允许自动或手动地指定在一段时间内收集的统计数据，并将其用于比较。可以使用基线来手动或自动与当前系统性能进行比较，比较差异差值和设置阈值以监视当前系统性能。

6. 发明申请

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.
摘要翻译：定义和存储性能基线的系统和方法。基线可以被定义为一对快照，每个快照包含相同的一组统计信息并具有与之相关联的时间戳值。本发明允许自动或手动地指定在一段时间内收集的统计数据，并将其用于比较。可以使用基线来手动或自动与当前系统性能进行比较，比较差异差值和设置阈值以监视当前系统性能。

7. 发明申请

US20050097091A1 SQL tuning base 有权
标题翻译： SQL调优基础
公开(公告)号：US20050097091A1
公开(公告)日：2005-05-05
申请号：US10936468
申请日：2004-09-07
申请人： Mark Ramacher , Sreenath Bodagala , Benoit Dageville , Alex Tsukerman , Stephen Vivian , Mohamed Ziauddin
发明人： Mark Ramacher , Sreenath Bodagala , Benoit Dageville , Alex Tsukerman , Stephen Vivian , Mohamed Ziauddin
IPC分类号： G06F7/00 , G06F17/00 , G06F17/30
CPC分类号： G06F17/30474 , G06F17/30306 , Y10S707/99932 , Y10S707/99934 , Y10S707/99944
摘要： A computer readable medium storing a database query language statement tuning base in a tuning base memory location is disclosed. The tuning base includes tuning information for one or more query language statements. The tuning information for each statement includes one or more tuning actions for the statement, and a signature to allow an optimizer to identify the one or more tuning actions for the statement.
摘要翻译：公开了一种在调谐基础存储器位置中存储数据库查询语言调整基座的计算机可读介质。调优基础包括一个或多个查询语言语句的调整信息。每个语句的调整信息包括语句的一个或多个调整操作，以及允许优化器识别语句的一个或多个调优操作的签名。

8. 发明授权

US08983934B2 SQL tuning base 有权
标题翻译： SQL调优基础
公开(公告)号：US08983934B2
公开(公告)日：2015-03-17
申请号：US10936468
申请日：2004-09-07
申请人： Mark Ramacher , Sreenath Bodagala , Benoit Dageville , Alex Tsukerman , Stephen J. Vivian , Mohamed Ziauddin
发明人： Mark Ramacher , Sreenath Bodagala , Benoit Dageville , Alex Tsukerman , Stephen J. Vivian , Mohamed Ziauddin
IPC分类号： G06F7/00 , G06F17/30
CPC分类号： G06F17/30474 , G06F17/30306 , Y10S707/99932 , Y10S707/99934 , Y10S707/99944
摘要： A computer readable medium storing a database query language statement tuning base in a tuning base memory location is disclosed. The tuning base includes tuning information for one or more query language statements. The tuning information for each statement includes one or more tuning actions for the statement, and a signature to allow an optimizer to identify the one or more tuning actions for the statement.
摘要翻译：公开了一种在调谐基础存储器位置中存储数据库查询语言调整基座的计算机可读介质。调优基础包括一个或多个查询语言语句的调整信息。每个语句的调整信息包括语句的一个或多个调优操作，以及允许优化器识别语句的一个或多个调优操作的签名。

9. 发明授权

US07587568B2 Method and system of reclaiming storage space in data storage systems 有权
标题翻译：在数据存储系统中回收存储空间的方法和系统
公开(公告)号：US07587568B2
公开(公告)日：2009-09-08
申请号：US10877158
申请日：2004-06-24
申请人： Sujatha Muthulingam , Alex Tsukerman , Vishwanath Karra , Nicholas Whyte
发明人： Sujatha Muthulingam , Alex Tsukerman , Vishwanath Karra , Nicholas Whyte
IPC分类号： G06F13/00 , G06F13/28
CPC分类号： G06F3/0608 , G06F3/064 , G06F3/0674 , G06F12/023
摘要： A method and system of reclaiming storage space in data storage systems is disclosed. In one embodiment, a high water mark of a data container is adjusted after data in the data container is compacted. As a result, unused space in the data container can be reclaimed.
摘要翻译：公开了一种在数据存储系统中回收存储空间的方法和系统。在一个实施例中，在数据容器中的数据被压缩之后调整数据容器的高水位标记。因此，可以回收数据容器中的未使用的空间。

10. 发明申请

US20050055492A1 Method and system of reclaiming storage space in data storage systems 有权
标题翻译：在数据存储系统中回收存储空间的方法和系统
公开(公告)号：US20050055492A1
公开(公告)日：2005-03-10
申请号：US10877158
申请日：2004-06-24
申请人： Sujatha Muthulingam , Alex Tsukerman , Vishwanath Karra , Nicholas Whyte
发明人： Sujatha Muthulingam , Alex Tsukerman , Vishwanath Karra , Nicholas Whyte
IPC分类号： G06F3/06 , G06F12/02 , G06F12/00
CPC分类号： G06F3/0608 , G06F3/064 , G06F3/0674 , G06F12/023
摘要： A method and system of reclaiming storage space in data storage systems is disclosed. In one embodiment, a high water mark of a data container is adjusted after data in the data container is compacted. As a result, unused space in the data container can be reclaimed.
摘要翻译：公开了一种在数据存储系统中回收存储空间的方法和系统。在一个实施例中，在数据容器中的数据被压缩之后调整数据容器的高水位标记。因此，可以回收数据容器中的未使用的空间。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式