-
公开(公告)号: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
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.
摘要翻译: 公开了一种在调谐基础存储器位置中存储数据库查询语言调整基座的计算机可读介质。 调优基础包括一个或多个查询语言语句的调整信息。 每个语句的调整信息包括语句的一个或多个调整操作,以及允许优化器识别语句的一个或多个调优操作的签名。
-
公开(公告)号: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
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.
摘要翻译: 公开了一种在调谐基础存储器位置中存储数据库查询语言调整基座的计算机可读介质。 调优基础包括一个或多个查询语言语句的调整信息。 每个语句的调整信息包括语句的一个或多个调优操作,以及允许优化器识别语句的一个或多个调优操作的签名。
-
公开(公告)号: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.
摘要翻译: 智能数据库基础设施,其中所有数据库组件的管理由数据库本身和数据库本身进行管理,通过集中管理各种组件与中央管理控制。 每个单独的数据库组件以及中央管理控制都是自我管理的。 中央管理控制模块集成并与各种数据库组件进行交互。 数据库被配置为自动调整到不同的工作负载和配置,纠正或警告恶劣条件,并提供有关如何提高整体系统性能的建议。
-
公开(公告)号: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
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.
摘要翻译: 智能数据库基础设施,其中所有数据库组件的管理由数据库本身和数据库本身进行管理,通过集中管理各种组件与中央管理控制。 每个单独的数据库组件以及中央管理控制都是自我管理的。 中央管理控制模块集成并与各种数据库组件进行交互。 数据库被配置为自动调整到不同的工作负载和配置,纠正或警告恶劣条件,并提供有关如何提高整体系统性能的建议。
-
公开(公告)号:US20050125427A1
公开(公告)日:2005-06-09
申请号:US10936778
申请日:2004-09-07
申请人: Benoit Dageville , Mohamed Ziauddin , Khaled Yagoub , Mohamed Zait , Dinesh Das , Karl Dias , Mark Ramacher , Leng Tan
发明人: Benoit Dageville , Mohamed Ziauddin , Khaled Yagoub , Mohamed Zait , Dinesh Das , Karl Dias , Mark Ramacher , Leng Tan
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.
摘要翻译: 公开了一种用于在优化器处接收数据库查询语言语句和关于语句的性能信息的方法,并且针对具有性能信息的语句生成一个或多个调优操作。
-
公开(公告)号: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
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.
摘要翻译: 公开了一种用于在优化器处接收数据库查询语言语句和关于语句的性能信息的方法,并且针对具有性能信息的语句生成一个或多个调优操作。
-
公开(公告)号:US07664730B2
公开(公告)日:2010-02-16
申请号:US10936205
申请日:2004-09-07
CPC分类号: G06F17/30474 , G06F17/30306 , Y10S707/99932 , Y10S707/99934 , Y10S707/99944
摘要: A method, apparatus, and computer program product with a persistent data structure for storing a profile of tuning information for a query statement separately from the query statement. The profile in the persistent data structure includes a statement signature to identify the query statement, and an action to tune the statement.
摘要翻译: 一种具有持久数据结构的方法,装置和计算机程序产品,用于与查询语句分开地存储用于查询语句的调整信息的简档。 持久性数据结构中的配置文件包括用于标识查询语句的语句签名,以及调整语句的操作。
-
公开(公告)号:US20050120001A1
公开(公告)日:2005-06-02
申请号:US10936426
申请日:2004-09-07
申请人: Khaled Yagoub , Benoit Dageville , Mohamed Ziauddin , Mohamed Zait , Karl Dias
发明人: Khaled Yagoub , Benoit Dageville , Mohamed Ziauddin , Mohamed Zait , Karl Dias
CPC分类号: G06F17/30474 , G06F17/30306 , Y10S707/99932 , Y10S707/99934 , Y10S707/99944
摘要: A method to addresses structural performance problems of a database query language statement is provided. The method includes receiving a database query language statement at an optimizer, evaluating choices in a search space to generate an execution plan for the statement, and producing annotations to record one or more reasons for selecting each choice while generating the execution plan.
摘要翻译: 提供了解决数据库查询语言语句结构性能问题的方法。 该方法包括在优化器处接收数据库查询语言语句,评估搜索空间中的选择以生成语句的执行计划,以及生成注释以记录在生成执行计划时选择每个选择的一个或多个原因。
-
公开(公告)号:US07805411B2
公开(公告)日:2010-09-28
申请号:US10935908
申请日:2004-09-07
申请人: Mohamed Ziauddin , Benoit Dageville , Mohamed Zait , Dinesh Das
发明人: Mohamed Ziauddin , Benoit Dageville , Mohamed Zait , Dinesh Das
CPC分类号: G06F17/30474 , G06F17/30306 , Y10S707/99932 , Y10S707/99934 , Y10S707/99944
摘要: Auto-tuning can be performed by receiving a database query language statement and performance information related to the statement, determining whether one or more performance statistics of the statement are available or missing in the performance information, and determining an auto-tuning hint for each missing statistic.
摘要翻译: 可以通过接收与该语句相关的数据库查询语言语句和性能信息来确定语句的一个或多个性能统计信息是否在性能信息中可用或丢失来执行自动调整,以及确定每个缺失的自动调整提示 统计。
-
公开(公告)号:US07664778B2
公开(公告)日:2010-02-16
申请号:US10936449
申请日:2004-09-07
申请人: Khaled Yagoub , Benoit Dageville , Mohamed Ziauddin , Karl Dias
发明人: Khaled Yagoub , Benoit Dageville , Mohamed Ziauddin , Karl Dias
CPC分类号: G06F17/30474 , G06F17/30306 , Y10S707/99932 , Y10S707/99934 , Y10S707/99944
摘要: A method and system for storing one or more database query language statements and performance information for each query language statement as a persistent database object. In one or more embodiments, the method and system stores the resource intensive statements and the performance information for each resource intensive statement as a second persistent database object.
摘要翻译: 用于将每个查询语言语句的一个或多个数据库查询语言语句和性能信息存储为持久数据库对象的方法和系统。 在一个或多个实施例中,该方法和系统将资源密集型语句和每个资源密集型语句的性能信息存储为第二持久数据库对象。
-
-
-
-
-
-
-
-
-