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

1. 发明申请

US20060059170A1 Advisor framework, systems, methods and software for implementing the same 有权
标题翻译：顾问框架，系统，方法和软件实现相同
公开(公告)号：US20060059170A1
公开(公告)日：2006-03-16
申请号：US10925831
申请日：2004-08-24
申请人： Karl Dias , Alex Tsukerman , Gregory Smith , Leng Tan
发明人： Karl Dias , Alex Tsukerman , Gregory Smith , Leng Tan
IPC分类号： G06F7/00
CPC分类号： G06F17/30306 , G06F17/3056
摘要： Various embodiments of the invention provide solutions that can offer a consistent framework for tools that assist in the configuration, tuning, and/or troubleshooting of a database and/or an RDBMS. Merely by way of example, one set of embodiments provides a software framework for an advisor component of a database and/or RDBMS. In accordance with some embodiments, the framework might specify a common data model for such advisor components. The data model can include, merely by way of example, a set of one or more findings (which might, in some cases, describe the result of an analysis of a circumstance in the database, RDBMS, and/or a mid-tier application used with the database) and/or a set of one or more recommendations (which might provide suggestions for addressing the circumstance). In particular embodiments. In particular embodiments, the data model might include a set of on or more rationales, which can explain the recommendations. In some cases, the software framework might include a task associated with the advisor component and/or one or more interfaces, which can include, inter alia, user interfaces and/or APIs. Other sets of embodiments can provide methods, systems and/or software programs for implementing an advisor framework.
摘要翻译：本发明的各种实施例提供可以为协助数据库和/或RDBMS的配置，调整和/或故障排除的工具提供一致的框架的解决方案。仅仅作为示例，一组实施例为数据库和/或RDBMS的顾问组件提供了软件框架。根据一些实施例，框架可以为这种顾问组件指定公共数据模型。数据模型可以仅包括一个或多个发现（在某些情况下可能描述数据库中的情境分析的结果，RDBMS和/或中间层应用程序）与数据库一起使用）和/或一组一个或多个建议（可能提供解决情况的建议）。在特定实施例中，数据模型可以包括一组或多个理由，其可以解释建议。在一些情况下，软件框架可以包括与顾问组件和/或一个或多个接口相关联的任务，其特别可以包括用户界面和/或API。其他实施例集合可以提供用于实现顾问框架的方法，系统和/或软件程序。

2. 发明授权

US07873606B2 Advisor framework, systems, methods and software for implementing the same 有权
标题翻译：顾问框架，系统，方法和软件实现相同
公开(公告)号：US07873606B2
公开(公告)日：2011-01-18
申请号：US10925831
申请日：2004-08-24
申请人： Karl Dias , Alex Tsukerman , Gregory S. Smith , Leng Tan
发明人： Karl Dias , Alex Tsukerman , Gregory S. Smith , Leng Tan
IPC分类号： G06F7/00 , G06F17/00
CPC分类号： G06F17/30306 , G06F17/3056
摘要： Various embodiments of the invention provide solutions that can offer a consistent framework for tools that assist in the configuration, tuning, and/or troubleshooting of a database and/or an RDBMS. Merely by way of example, one set of embodiments provides a software framework for an advisor component of a database and/or RDBMS. In accordance with some embodiments, the framework might specify a common data model for such advisor components. The data model can include, merely by way of example, a set of one or more findings (which might, in some cases, describe the result of an analysis of a circumstance in the database, RDBMS, and/or a mid-tier application used with the database) and/or a set of one or more recommendations (which might provide suggestions for addressing the circumstance). In particular embodiments. In particular embodiments, the data model might include a set of on or more rationales, which can explain the recommendations. In some cases, the software framework might include a task associated with the advisor component and/or one or more interfaces, which can include, inter alia, user interfaces and/or APIs. Other sets of embodiments can provide methods, systems and/or software programs for implementing an advisor framework.
摘要翻译：本发明的各种实施例提供可以为协助数据库和/或RDBMS的配置，调整和/或故障排除的工具提供一致的框架的解决方案。仅仅作为示例，一组实施例为数据库和/或RDBMS的顾问组件提供了软件框架。根据一些实施例，框架可以为这种顾问组件指定公共数据模型。数据模型可以仅包括一个或多个发现（在某些情况下可能描述数据库中的情境分析的结果，RDBMS和/或中间层应用程序）与数据库一起使用）和/或一组一个或多个建议（可能提供解决情况的建议）。在特定实施例中，数据模型可以包括一组或多个理由，其可以解释建议。在一些情况下，软件框架可以包括与顾问组件和/或一个或多个接口相关联的任务，其特别可以包括用户界面和/或API。其他实施例集合可以提供用于实现顾问框架的方法，系统和/或软件程序。

3. 发明授权

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.
摘要翻译：智能数据库基础设施，其中所有数据库组件的管理由数据库本身和数据库本身进行管理，通过集中管理各种组件与中央管理控制。每个单独的数据库组件以及中央管理控制都是自我管理的。中央管理控制模块集成并与各种数据库组件进行交互。数据库被配置为自动调整到不同的工作负载和配置，纠正或警告恶劣条件，并提供有关如何提高整体系统性能的建议。

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. 发明申请

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.
摘要翻译：智能数据库基础设施，其中所有数据库组件的管理由数据库本身和数据库本身进行管理，通过集中管理各种组件与中央管理控制。每个单独的数据库组件以及中央管理控制都是自我管理的。中央管理控制模块集成并与各种数据库组件进行交互。数据库被配置为自动调整到不同的工作负载和配置，纠正或警告恶劣条件，并提供有关如何提高整体系统性能的建议。

6. 发明授权

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

7. 发明授权

US07984015B2 Database workload capture and replay architecture 有权
标题翻译：数据库工作负载捕获和重播架构
公开(公告)号：US07984015B2
公开(公告)日：2011-07-19
申请号：US11800122
申请日：2007-05-03
申请人： Karl Dias , Leonidas Galanis , Jonathan Klein , Venkateshwaran Venkataramani , Yujun Wang , Richard Sarwal , Leng Tan , Graham Wood , Benoit Dageville , Chao Liang , Sanjay Kaluskar
发明人： Karl Dias , Leonidas Galanis , Jonathan Klein , Venkateshwaran Venkataramani , Yujun Wang , Richard Sarwal , Leng Tan , Graham Wood , Benoit Dageville , Chao Liang , Sanjay Kaluskar
IPC分类号： G06F7/00 , G06F17/00
CPC分类号： G06F17/30377
摘要： A method and apparatus for capturing database system workload and replaying that workload in a database system is provided. According to one aspect, in order to subject a test database system to the same workload to which the production database system actually would be subjected, a database server in the production system captures and records workload that the database server receives from external entities. This captured workload is processed. Processes external to a database server in the test database system send the processed workload to that database server. As a result, the test database system is subjected to the same workload to which the production database system originally was subjected. The foregoing technique permits a database administrator to determine how the production database system will fare if the difference that is present in the test database system is introduced into the production database system.
摘要翻译：提供了一种用于捕获数据库系统工作负载并在数据库系统中重播该工作负载的方法和装置。根据一个方面，为了使测试数据库系统处于生产数据库系统实际受到的相同工作负载，生产系统中的数据库服务器捕获并记录数据库服务器从外部实体接收的工作负载。处理此捕获的工作负载。测试数据库系统中数据库服务器外部的进程将处理的工作负载发送到该数据库服务器。因此，测试数据库系统受到生产数据库系统最初遭受的相同工作量的影响。如果将测试数据库系统中存在的差异引入到生产数据库系统中，则上述技术允许数据库管理员确定生产数据库系统将如何展示。

8. 发明授权

US07937623B2 Diagnosability system 有权
标题翻译：诊断系统
公开(公告)号：US07937623B2
公开(公告)日：2011-05-03
申请号：US12252056
申请日：2008-10-15
申请人： Mark Ramacher , Gary Ngai , Benoit Dageville , Karl Dias , Yair Sarig , Marcus Fallen , Ajith Kumar Mysorenagarajarao , John Beresniewicz , Mike Feng , Jonathan Klein , Hailing Yu , Leng Tan , Balasubrahmanya Kuchibhotla , Uri Shaft , Venkateshwaran Venkataramani , Amir Valiani
发明人： Mark Ramacher , Gary Ngai , Benoit Dageville , Karl Dias , Yair Sarig , Marcus Fallen , Ajith Kumar Mysorenagarajarao , John Beresniewicz , Mike Feng , Jonathan Klein , Hailing Yu , Leng Tan , Balasubrahmanya Kuchibhotla , Uri Shaft , Venkateshwaran Venkataramani , Amir Valiani
IPC分类号： G06F11/00
CPC分类号： G06F11/0778 , G06F11/0748 , G06F11/0781 , H04L41/0681 , H04L41/16
摘要： A diagnosability system for automatically collecting, storing, communicating, and analyzing diagnostic data for one or more monitored systems. The diagnosability system comprises several components configured for the collection, storage, communication, and analysis of diagnostic data for a condition detected in monitored system. The diagnosability system enables targeted dumping of diagnostic data so that only diagnostic data that is relevant for diagnosing the condition detected in the monitored system is collected and stored. This in turn enables first failure analysis thereby reducing the time needed to resolve the condition detected in the monitored system.
摘要翻译：用于自动收集，存储，通信和分析一个或多个受监控系统的诊断数据的诊断系统。诊断系统包括被配置用于收集，存储，通信和分析诊断数据的几个组件，用于在被监控系统中检测到的状况。诊断系统能够有针对性地倾倒诊断数据，以便仅收集和存储与监视系统中检测到的病症相关的诊断数据。这反过来使得能够进行第一次故障分析，从而减少解决在被监视系统中检测到的状况所需的时间。

9. 发明申请

US20090106278A1 DIAGNOSABILITY SYSTEM 有权
标题翻译：诊断系统
公开(公告)号：US20090106278A1
公开(公告)日：2009-04-23
申请号：US12252056
申请日：2008-10-15
申请人： Mark Ramacher , Gary Ngai , Benoit Dageville , Karl Dias , Yair Sarig , Marcus Fallen , Ajith Kumar Mysorenagarajarao , John Beresniewicz , Mike Feng , Jonathan Klein , Hailing Yu , Leng Tan , Balasubrahmanyam Kuchibhotla , Uri Shaft , Venkateshwaran Venkataramani , Amir Valiani
发明人： Mark Ramacher , Gary Ngai , Benoit Dageville , Karl Dias , Yair Sarig , Marcus Fallen , Ajith Kumar Mysorenagarajarao , John Beresniewicz , Mike Feng , Jonathan Klein , Hailing Yu , Leng Tan , Balasubrahmanyam Kuchibhotla , Uri Shaft , Venkateshwaran Venkataramani , Amir Valiani
IPC分类号： G06F11/30 , G06F17/30
CPC分类号： G06F11/0778 , G06F11/0748 , G06F11/0781 , H04L41/0681 , H04L41/16
摘要： A diagnosability system for automatically collecting, storing, communicating, and analyzing diagnostic data for one or more monitored systems. The diagnosability system comprises several components configured for the collection, storage, communication, and analysis of diagnostic data for a condition detected in monitored system. The diagnosability system enables targeted dumping of diagnostic data so that only diagnostic data that is relevant for diagnosing the condition detected in the monitored system is collected and stored. This in turn enables first failure analysis thereby reducing the time needed to resolve the condition detected in the monitored system.
摘要翻译：用于自动收集，存储，通信和分析一个或多个受监控系统的诊断数据的诊断系统。诊断系统包括被配置用于收集，存储，通信和分析诊断数据的几个组件，用于在被监控系统中检测到的状况。诊断系统能够有针对性地倾倒诊断数据，以便仅收集和存储与监视系统中检测到的病症相关的诊断数据。这反过来使得能够进行第一次故障分析，从而减少解决在被监视系统中检测到的状况所需的时间。

10. 发明授权

US07747606B2 Automatic SQL tuning advisor 有权
标题翻译：自动SQL调优顾问
公开(公告)号：US07747606B2
公开(公告)日：2010-06-29
申请号：US10936778
申请日：2004-09-07
申请人： Benoit Dageville , Mohamed Ziauddin , Khaled Yagoub , Mohamed Zait , Dinesh Das , Karl Dias , Mark Ramacher , Leng Leng Tan
发明人： Benoit Dageville , Mohamed Ziauddin , Khaled Yagoub , Mohamed Zait , Dinesh Das , Karl Dias , Mark Ramacher , Leng Leng Tan
IPC分类号： G06F7/00 , G06F17/30
CPC分类号： G06F17/30474 , G06F17/30306 , Y10S707/99932 , Y10S707/99934 , Y10S707/99944
摘要： A method for receiving a database query language statement and performance information about the statement at an optimizer and generating one or more tuning actions for the statement with the performance information is disclosed.
摘要翻译：公开了一种用于在优化器处接收数据库查询语言语句和关于语句的性能信息的方法，并且针对具有性能信息的语句生成一个或多个调优操作。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式