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

1. 发明授权

US09213740B2 System and methodology for automatic tuning of database query optimizer 有权
标题翻译：自动调整数据库查询优化器的系统和方法
公开(公告)号：US09213740B2
公开(公告)日：2015-12-15
申请号：US11871022
申请日：2007-10-11
申请人： Mihnea Andrei , Xun Cheng , Edwin Anthony Seputis , Xiao Ming Zhou
发明人： Mihnea Andrei , Xun Cheng , Edwin Anthony Seputis , Xiao Ming Zhou
IPC分类号： G06F17/30
CPC分类号： G06F17/30442 , G06F17/30424 , G06F17/30463
摘要： System and methodology for automatic tuning of database query optimizer is described. In one embodiment, in a database system having an optimizer for selecting a query plan for executing a database query, a method of the present invention is described for automatically tuning query performance to prevent query performance regression that may occur during upgrade of the database system from a prior version to a new version, the method comprises steps of: in response to receiving a given database query for execution, specifying a query plan generated by the prior version's optimizer as a baseline best plan for executing the given database query; generating at least one new query plan using the new version's optimizer; learning performance for each new query plan generated by recording corresponding query execution metrics; if a given new query plan is observed to have better performance than the best plan previously specified, specifying that given new query plan to be the best plan for executing the given database query; if a given new query plan is observed to have worse performance than the best plan previously specified, specifying that given new query plan to be a bad plan to be avoided in the future; and automatically tuning future execution of the given database query by using the query plan that the system learned was the best plan.
摘要翻译：描述了数据库查询优化器自动调优的系统和方法。在一个实施例中，在具有用于选择用于执行数据库查询的查询计划的优化器的数据库系统中，描述了本发明的方法，用于自动调整查询性能以防止在数据库系统升级期间可能发生的查询性能回归该方法包括以下步骤：响应于接收给定的数据库查询以执行，将由先前版本的优化器生成的查询计划指定为用于执行给定数据库查询的基准最佳计划; 使用新版本的优化器生成至少一个新的查询计划; 通过记录相应的查询执行指标生成的每个新查询计划的学习性能; 如果观察到给定的新查询计划具有比先前指定的最佳方案更好的性能，则指定给定的新查询计划是执行给定数据库查询的最佳计划; 如果观察到给定的新查询计划的性能比先前指定的最佳方案更差，则指定给定的新查询计划是将来避免的坏计划; 并通过使用系统学到的查询计划来自动调整给定数据库查询的未来执行情况。

2. 发明申请

US20090100004A1 System And Methodology For Automatic Tuning Of Database Query Optimizer 有权
标题翻译：数据库查询优化器自动调优的系统和方法
公开(公告)号：US20090100004A1
公开(公告)日：2009-04-16
申请号：US11871022
申请日：2007-10-11
申请人： Mihnea Andrei , Xun Cheng , Edwin A. Seputis , Xiao Ming Zhou
发明人： Mihnea Andrei , Xun Cheng , Edwin A. Seputis , Xiao Ming Zhou
IPC分类号： G06F17/30
CPC分类号： G06F17/30442 , G06F17/30424 , G06F17/30463
摘要： System and methodology for automatic tuning of database query optimizer is described. In one embodiment, in a database system having an optimizer for selecting a query plan for executing a database query, a method of the present invention is described for automatically tuning query performance to prevent query performance regression that may occur during upgrade of the database system from a prior version to a new version, the method comprises steps of: in response to receiving a given database query for execution, specifying a query plan generated by the prior version's optimizer as a baseline best plan for executing the given database query; generating at least one new query plan using the new version's optimizer; learning performance for each new query plan generated by recording corresponding query execution metrics; if a given new query plan is observed to have better performance than the best plan previously specified, specifying that given new query plan to be the best plan for executing the given database query; if a given new query plan is observed to have worse performance than the best plan previously specified, specifying that given new query plan to be a bad plan to be avoided in the future; and automatically tuning future execution of the given database query by using the query plan that the system learned was the best plan.
摘要翻译：描述了数据库查询优化器自动调优的系统和方法。在一个实施例中，在具有用于选择用于执行数据库查询的查询计划的优化器的数据库系统中，描述了本发明的方法，用于自动调整查询性能以防止在数据库系统升级期间可能发生的查询性能回归该方法包括以下步骤：响应于接收给定的数据库查询以执行，将由先前版本的优化器生成的查询计划指定为用于执行给定数据库查询的基准最佳计划; 使用新版本的优化器生成至少一个新的查询计划; 通过记录相应的查询执行指标生成的每个新查询计划的学习性能; 如果观察到给定的新查询计划具有比先前指定的最佳方案更好的性能，则指定给定的新查询计划是执行给定数据库查询的最佳计划; 如果观察到给定的新查询计划的性能比先前指定的最佳方案更差，则指定给定的新查询计划是将来避免的坏计划; 并通过使用系统学到的查询计划来自动调整给定数据库查询的未来执行情况。

3. 发明授权

US09703825B2 Maintenance of a pre-computed result set 有权
公开(公告)号：US09703825B2
公开(公告)日：2017-07-11
申请号：US14056541
申请日：2013-10-17
申请人： Xiao Ming Zhou , Xun Cheng , Haiyan Du , Nitesh Maheshwari , Prabhas Kumar Samanta
发明人： Xiao Ming Zhou , Xun Cheng , Haiyan Du , Nitesh Maheshwari , Prabhas Kumar Samanta
IPC分类号： G06F17/30
CPC分类号： G06F17/30383
摘要： A method, a system and a computer program product for maintaining a pre-computed result set are disclosed. A server coupled to a data source determines whether an object stored in the data source received an update. The server identifies at least one identifier associated with a pre-computed result set based on that determination. The pre-computed result set is computed based on the object. The server computes an updated pre-computed result set using the identifier by applying the received update to the pre-computed result set.

4. 发明申请

US20150112922A1 Maintenance of a Pre-Computed Result Set 有权
标题翻译：维护预计算结果集
公开(公告)号：US20150112922A1
公开(公告)日：2015-04-23
申请号：US14056541
申请日：2013-10-17
申请人： Xiao Ming Zhou , Xun Cheng , Haiyan Du , Nitesh Maheshwari , Prabhas Kumar Samanta
发明人： Xiao Ming Zhou , Xun Cheng , Haiyan Du , Nitesh Maheshwari , Prabhas Kumar Samanta
IPC分类号： G06F17/30
CPC分类号： G06F17/30383
摘要： A method, a system and a computer program product for maintaining a pre-computed result set are disclosed. A server coupled to a data source determines whether an object stored in the data source received an update. The server identifies at least one identifier associated with a pre-computed result set based on that determination. The pre-computed result set is computed based on the object. The server computes an updated pre-computed result set using the identifier by applying the received update to the pre-computed result set.
摘要翻译：公开了一种用于维持预先计算的结果集合的方法，系统和计算机程序产品。耦合到数据源的服务器确定存储在数据源中的对象是否接收到更新。服务器基于该确定来识别与预先计算的结果集相关联的至少一个标识符。基于对象计算预计算结果集。服务器通过将接收到的更新应用于预先计算的结果集，使用标识符来计算更新的预先计算的结果集。

5. 发明授权

US08484210B2 Representing markup language document data in a searchable format in a database system 有权
标题翻译：在数据库系统中以可搜索格式表示标记语言文档数据
公开(公告)号：US08484210B2
公开(公告)日：2013-07-09
申请号：US12488358
申请日：2009-06-19
申请人： Tat-Keong Loh , Xiao Ming Zhou , Mohyuddin Rehmattullah , Michelle Lim
发明人： Tat-Keong Loh , Xiao Ming Zhou , Mohyuddin Rehmattullah , Michelle Lim
IPC分类号： G06F7/00 , G06F17/30
CPC分类号： G06F7/00 , G06F17/30 , G06F17/30911
摘要： Systems, methods, computer program product embodiments for representing markup language document data in a searchable format in a database system are provided. An embodiment includes parsing a markup language document into a data stream, the data stream including a plurality of fields in a predefined format having a symbol table for at least one field of the data stream, and optimized field size based on a maximum value of data within each field, and storing the data stream in data storage.
摘要翻译：提供了用于在数据库系统中表示可搜索格式的标记语言文档数据的系统，方法，计算机程序产品实施例。实施例包括将标记语言文档解析成数据流，所述数据流包括具有用于数据流的至少一个字段的符号表的预定格式的多个字段，以及基于数据的最大值的优化字段大小并且将数据流存储在数据存储器中。

6. 发明申请

US20100325169A1 Representing Markup Language Document Data in a Searchable Format in a Database System 有权
标题翻译：在数据库系统中以可搜索的格式表示标记语言文档数据
公开(公告)号：US20100325169A1
公开(公告)日：2010-12-23
申请号：US12488358
申请日：2009-06-19
申请人： Tat-Keong Loh , Xiao Ming Zhou , Mohyuddin Rehmattullah , Michelle Lim
发明人： Tat-Keong Loh , Xiao Ming Zhou , Mohyuddin Rehmattullah , Michelle Lim
IPC分类号： G06F7/00
CPC分类号： G06F7/00 , G06F17/30 , G06F17/30911
摘要： Systems, methods, computer program product embodiments for representing markup language document data in a searchable format in a database system are provided. An embodiment includes parsing a markup language document into a data stream, the data stream including a plurality of fields in a predefined format having a symbol table for at least one field of the data stream, and optimized field size based on a maximum value of data within each field, and storing the data stream in data storage.
摘要翻译：提供了用于在数据库系统中表示可搜索格式的标记语言文档数据的系统，方法，计算机程序产品实施例。实施例包括将标记语言文档解析成数据流，所述数据流包括具有用于数据流的至少一个字段的符号表的预定格式的多个字段，以及基于数据的最大值的优化字段大小并且将数据流存储在数据存储器中。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式