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

61. 发明授权

US09256642B2 Techniques for recommending parallel execution of SQL statements 有权
标题翻译：推荐并行执行SQL语句的技术
公开(公告)号：US09256642B2
公开(公告)日：2016-02-09
申请号：US12827926
申请日：2010-06-30
申请人： Hailing Yu , Peter Belknap , Thierry Cruanes , Benoit Dageville , Karl Dias , Khaled Yagoub
发明人： Hailing Yu , Peter Belknap , Thierry Cruanes , Benoit Dageville , Karl Dias , Khaled Yagoub
IPC分类号： G06F7/00 , G06F17/30
CPC分类号： G06F17/30445
摘要： Techniques for automatically recommending parallel execution of a SQL statement. In one set of embodiments, a first determination can be made regarding whether a SQL statement can be executed in parallel. Further, a second determination can be made regarding whether executing the SQL statement in parallel is faster than executing the statement in serial by a predetermined factor. If the first determination and second determination are positive (i.e., the statement can be executed in parallel and parallel execution is faster by the predetermined factor), a recommendation can be provided indicating that the SQL statement should be executed in parallel. In some embodiments, the recommendation can include a report specifying the degree of performance improvement gained from parallel execution, additional system resources consumed by parallel execution, and other statistics pertaining to the recommended parallel execution plan.
摘要翻译：自动推荐并行执行SQL语句的技术。在一组实施例中，可以首先确定是否可以并行执行SQL语句。此外，可以进行关于并行执行SQL语句是否比以预定因子串行执行语句更快的第二确定。如果第一确定和第二确定是正的（即，可以并行执行语句并且并行执行以预定因子更快），则可以提供指示应该并行执行SQL语句的建议。在一些实施例中，该建议可以包括指定从并行执行获得的性能改进程度的报告，并行执行消耗的附加系统资源以及与推荐的并行执行计划有关的其他统计信息。

62. 发明授权

US08341178B2 SQL performance analyzer 有权
标题翻译： SQL性能分析器
公开(公告)号：US08341178B2
公开(公告)日：2012-12-25
申请号：US12188981
申请日：2008-08-08
申请人： Peter Belknap , Benoit Dageville , Karl Dias , Khaled Yagoub
发明人： Peter Belknap , Benoit Dageville , Karl Dias , Khaled Yagoub
IPC分类号： G06F17/30
CPC分类号： G06F17/30306
摘要： Techniques are provided for analyzing performance differences for a set of database query language statements on two different database systems. The performance analysis is based on quantitative measurements and estimates of the execution of the set of database query language statements on the two different database systems. This performance analysis process may be used by database administrators to predict impacts to performance due to a change in a database system.
摘要翻译：提供了用于分析两个不同数据库系统上的一组数据库查询语言语句的性能差异的技术。性能分析基于对两个不同数据库系统上的数据库查询语言语句集的执行的定量测量和估计。数据库管理员可以使用此性能分析过程来预测由于数据库系统发生变化而对性能的影响。

63. 发明申请

US20120005189A1 TECHNIQUES FOR RECOMMENDING ALTERNATIVE SQL EXECUTION PLANS 有权
标题翻译：推荐替代性SQL执行计划的技术
公开(公告)号：US20120005189A1
公开(公告)日：2012-01-05
申请号：US12827943
申请日：2010-06-30
申请人： Hailing Yu , Peter Belknap , Benoit Dageville , Karl Dias , Khaled Yagoub
发明人： Hailing Yu , Peter Belknap , Benoit Dageville , Karl Dias , Khaled Yagoub
IPC分类号： G06F17/30
CPC分类号： G06F17/30463
摘要： Techniques for automatically recommending alternative execution plans for a SQL statement. In one set of embodiments, information pertaining to one or more execution plans for a SQL statement can be retrieved from a set of plan sources. The one or more execution plans can include the current execution plan for the statement and one or more historical execution plans. Based on the retrieved information, the performance of the one or more execution plans can be compared to each other. Based on the comparison, a recommendation can be provided to a user indicating that a particular execution plan (e.g., a historical execution plan) should be used in place of the current execution plan to execute the SQL statement.
摘要翻译：自动推荐SQL语句的替代执行计划的技术。在一组实施例中，可以从一组计划源检索关于SQL语句的一个或多个执行计划的信息。一个或多个执行计划可以包括该语句的当前执行计划和一个或多个历史执行计划。基于检索到的信息，可以将一个或多个执行计划的性能彼此进行比较。基于该比较，可以向用户提供指示使用特定执行计划（例如，历史执行计划）来代替执行SQL语句的当前执行计划的建议。

64. 发明申请

US20120005188A1 TECHNIQUES FOR RECOMMENDING PARALLEL EXECUTION OF SQL STATEMENTS 有权
标题翻译：推荐使用SQL语句的并行执行技术
公开(公告)号：US20120005188A1
公开(公告)日：2012-01-05
申请号：US12827926
申请日：2010-06-30
申请人： Hailing Yu , Peter Belknap , Thierry Cruanes , Benoit Dageville , Karl Dias , Khaled Yagoub
发明人： Hailing Yu , Peter Belknap , Thierry Cruanes , Benoit Dageville , Karl Dias , Khaled Yagoub
IPC分类号： G06F17/30
CPC分类号： G06F17/30445
摘要： Techniques for automatically recommending parallel execution of a SQL statement. In one set of embodiments, a first determination can be made regarding whether a SQL statement can be executed in parallel. Further, a second determination can be made regarding whether executing the SQL statement in parallel is faster than executing the statement in serial by a predetermined factor. If the first determination and second determination are positive (i.e., the statement can be executed in parallel and parallel execution is faster by the predetermined factor), a recommendation can be provided indicating that the SQL statement should be executed in parallel. In some embodiments, the recommendation can include a report specifying the degree of performance improvement gained from parallel execution, additional system resources consumed by parallel execution, and other statistics pertaining to the recommended parallel execution plan.
摘要翻译：自动推荐并行执行SQL语句的技术。在一组实施例中，可以首先确定是否可以并行执行SQL语句。此外，可以进行关于并行执行SQL语句是否比以预定因子串行执行语句更快的第二确定。如果第一确定和第二确定是正的（即，可以并行执行语句并且并行执行以预定因子更快），则可以提供指示应该并行执行SQL语句的建议。在一些实施例中，该建议可以包括指定从并行执行获得的性能改进程度的报告，并行执行消耗的附加系统资源以及与推荐的并行执行计划有关的其他统计信息。

65. 发明授权

US07664778B2 SQL tuning sets 有权
标题翻译： SQL调优集
公开(公告)号：US07664778B2
公开(公告)日：2010-02-16
申请号：US10936449
申请日：2004-09-07
申请人： Khaled Yagoub , Benoit Dageville , Mohamed Ziauddin , Karl Dias
发明人： Khaled Yagoub , Benoit Dageville , Mohamed Ziauddin , Karl Dias
IPC分类号： G06F7/00 , G06F17/00
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.
摘要翻译：用于将每个查询语言语句的一个或多个数据库查询语言语句和性能信息存储为持久数据库对象的方法和系统。在一个或多个实施例中，该方法和系统将资源密集型语句和每个资源密集型语句的性能信息存储为第二持久数据库对象。

66. 发明申请

US20100030758A1 Hybrid optimization strategies in automatic SQL tuning 有权
标题翻译：自动SQL调优中的混合优化策略
公开(公告)号：US20100030758A1
公开(公告)日：2010-02-04
申请号：US12221131
申请日：2008-07-30
申请人： Peter Belknap , Khaled Yagoub , Karl Dias , Benoit Dageville , Thierry Cruanes , Anupam Singh
发明人： Peter Belknap , Khaled Yagoub , Karl Dias , Benoit Dageville , Thierry Cruanes , Anupam Singh
IPC分类号： G06F17/30
CPC分类号： G06F17/30463 , G06F17/30306 , G06F17/30471
摘要： Systems, methods, and other embodiments associated with hybrid optimization strategies in automatic SQL tuning are described. One example method includes receiving a first (e.g., cost-based) execution plan for a user structured query language statement (User SQL) from a first (e.g., cost-based) optimizer. The example method may also include receiving a second (e.g., rules-based) execution plan for the User SQL from a second, different (e.g., rules-based) query optimizer. The method may include identifying a preferred execution plan based on data produced by test executing the execution plans in a reproduced execution environment that reproduces at least a portion of an execution environment in which the user SQL runs. The method may also include controlling a database to execute the User SQL using the preferred execution plan.
摘要翻译：描述了与自动SQL调优中的混合优化策略相关联的系统，方法和其他实施例。一个示例性方法包括从第一（例如基于成本的）优化器接收用户结构化查询语言语句（User SQL）的第一（例如基于成本的）执行计划。示例性方法还可以包括从第二不同（例如，基于规则的）查询优化器接收针对用户SQL的第二（例如基于规则的）执行计划。该方法可以包括基于在再现执行用户SQL运行的执行环境的至少一部分的再现执行环境中执行执行计划的测试产生的数据来识别优选执行计划。该方法还可以包括控制数据库以使用优选的执行计划来执行User SQL。

67. 发明授权

US06125360A Incremental maintenance of materialized views containing one-to-N lossless joins 失效
标题翻译：包含一对N无损连接的物化视图的增量维护
公开(公告)号：US06125360A
公开(公告)日：2000-09-26
申请号：US109115
申请日：1998-07-02
申请人： Andrew Witkowski , Karl Dias
发明人： Andrew Witkowski , Karl Dias
IPC分类号： G06F17/30
CPC分类号： G06F17/30483 , G06F17/30306 , Y10S707/99932 , Y10S707/99934 , Y10S707/99936 , Y10S707/99943 , Y10S707/99944
摘要： A method and apparatus are provided for performing incremental refreshes to materialized views defined by one-to-N lossless joins. Each base table of the materialized view is selected to be processed as the current "selected table". The processing of the current selected table varies depending on whether the selected table is the right side table of an outer join. If the selected table is not the right table of an outer join, then the selected table is processed by (1) deleting rows from the materialized view based on rows of the selected table that have been updated or deleted in the selected table during the batch window, and (2) inserting rows into the materialized view based on updates and inserts into the selected table that occurred during the batch window. If the selected table is the right table of an outer join, then changes made to the selected table are processed in a way that reduces the number of changes that have to be made to the materialized view. According to one embodiment of the invention, operations performed during the incremental refresh are performed by issuing database statements (e.g. SQL queries) to a database server. The incremental refresh techniques described herein are "memoryless" in that they do not require a record of the sequence of changes that were made during a batch window. Techniques are described for performing the incremental refresh steps through the use of database commands and queries.
摘要翻译：提供了一种方法和装置，用于对由一对N无损连接定义的物化视图执行增量刷新。选择物化视图的每个基表作为当前的“选择的表”进行处理。当前所选表的处理取决于所选择的表是外连接的右侧表。如果所选表格不是外连接的右表，则所选表格由（1）根据在批次中所选表中已更新或删除的所选表格的行，从物化视图中删除行进行处理窗口，以及（2）根据在批处理窗口中发生的更新和插入到所选表中，将行插入物化视图。如果所选表格是外连接的右表，则对所选表进行的更改将以减少必须对实例化视图进行的更改次数的方式进行处理。根据本发明的一个实施例，在增量刷新期间执行的操作通过向数据库服务器发布数据库语句（例如，SQL查询）来执行。本文描述的增量刷新技术是“无记忆”，因为它们不需要在批处理窗口期间进行的变化序列的记录。描述了通过使用数据库命令和查询执行增量刷新步骤的技术。

68. 发明授权

US08380665B2 Application workload capture and replay system 有权
标题翻译：应用工作负载捕获和重放系统
公开(公告)号：US08380665B2
公开(公告)日：2013-02-19
申请号：US13076313
申请日：2011-03-30
申请人： Efstratios Papadomanolakis , Zhongtang Cai , Romain Colle , Benoit Dageville , Karl Dias , Leonidas Galanis , Rodney Graham , Bo Gong , Qinghui H. Altmar , Jae Young Yoon , Mehmet Fidanboylu , Tom Hsu
发明人： Efstratios Papadomanolakis , Zhongtang Cai , Romain Colle , Benoit Dageville , Karl Dias , Leonidas Galanis , Rodney Graham , Bo Gong , Qinghui H. Altmar , Jae Young Yoon , Mehmet Fidanboylu , Tom Hsu
IPC分类号： G06F17/00
CPC分类号： G06F11/3688
摘要： An application workload capture and replay system with a transactionally consistent application workload replay feature is provided. More particularly, the feature includes capture-phase components for capturing and recording a real application workload submitted to a production web application system and includes replay-phase components for replaying the captured application workload against a test web application system in a transactionally consistent manner. The feature provides guarantees about the order of database transactions that are caused when the workload is replayed such that there is a consistency between the replay-phase order of the database transactions and the order of those transactions that occurred when the workload was captured. These consistency guarantees facilitate a faithful reproduction of database changes observed in the production web application system in the test web application system using a captured real application workload. Significantly, this faithful reproduction may be accomplished without having to create a synthetic application workload that approximates or emulates the transactional behavior of the real application workload. Instead, a real application workload may be used as or substantially as it is captured.
摘要翻译：提供了具有事务一致的应用程序工作负载重放功能的应用程序工作负载捕获和重放系统。更具体地，该特征包括用于捕获和记录提交到生产web应用系统的真实应用工作负载的捕获相组件，并且包括用于以事务一致的方式针对测试web应用系统重放所捕获的应用工作负载的重放阶段组件。该功能提供了关于在重放工作负载时引起的数据库事务的顺序的保证，使得数据库事务的重放阶段顺序与捕获工作负载时发生的那些事务的顺序之间存在一致性。这些一致性保证有助于在测试Web应用系统中使用捕获的实际应用程序工作负载忠实地再现在生产Web应用系统中观察到的数据库更改。重要的是，可以实现这种忠实的再现，而无需创建近似或模拟实际应用程序工作负载的事务行为的综合应用程序工作负载。相反，真正的应用程序工作负载可以被使用或基本上被捕获。

69. 发明授权

US08380664B2 Transactionally consistent replay of application workloads 有权
标题翻译：事务上一致地重播应用程序工作负载
公开(公告)号：US08380664B2
公开(公告)日：2013-02-19
申请号：US13034526
申请日：2011-02-24
申请人： Efstratios Papadomanolakis , Zhongtang Cai , Romain Colle , Benoit Dageville , Karl Dias , Leonidas Galanis , Rodney Graham , Bo Gong , Qinghui H. Altmar , Jae Young Yoon , Mehmet Fidanboylu , Tom Hsu
发明人： Efstratios Papadomanolakis , Zhongtang Cai , Romain Colle , Benoit Dageville , Karl Dias , Leonidas Galanis , Rodney Graham , Bo Gong , Qinghui H. Altmar , Jae Young Yoon , Mehmet Fidanboylu , Tom Hsu
IPC分类号： G06F17/00
CPC分类号： G06F17/30557
摘要： A database system providing transactionally consistent replay of application workloads. In a database system, a method providing transactionally consistent replay of application workloads comprises the steps of: during a replay phase in which a plurality of application requests that were previously submitted to an application server system during a capture phase are being replayed, receiving, at a database server, a database request to execute a database command against a database. The database request specifies an application request identifier that identifies a particular application request of the plurality of application requests. The particular application request caused the database command to be executed previously during the capture phase. In response to receiving the database request, determining, based on the application request identifier in the database request, whether to delay execution of the database command at least until a particular replay-phase database transaction has been committed.
摘要翻译：数据库系统提供事务性一致的应用程序工作负载重播。在数据库系统中，提供事务性地一致地重放应用工作负载的方法包括以下步骤：在重放阶段，其中在捕获阶段期间先前提交给应用服务器系统的多个应用请求正在被重播，数据库服务器，针对数据库执行数据库命令的数据库请求。数据库请求指定标识多个应用请求的特定应用请求的应用请求标识符。特定的应用程序请求导致数据库命令在捕获阶段之前执行。响应于接收到数据库请求，基于数据库请求中的应用请求标识确定是否延迟数据库命令的执行至少直到特定的重放阶段数据库事务被提交。

70. 发明授权

US08095514B2 Treemap visualizations of database time 有权
标题翻译：数据库时间的Treemap可视化
公开(公告)号：US08095514B2
公开(公告)日：2012-01-10
申请号：US12365827
申请日：2009-02-04
申请人： John Beresniewicz , Jonathan Helfman , Hsiao-Te Su , Nancy Chen , Karl Dias , Graham Wood
发明人： John Beresniewicz , Jonathan Helfman , Hsiao-Te Su , Nancy Chen , Karl Dias , Graham Wood
IPC分类号： G06F17/30
CPC分类号： G06F17/30554 , G06F17/30592 , G06F17/30961 , Y10S707/99945
摘要： Particular embodiments generally relate to displaying database time using a treemap. A set of database time values is determined for a set of dimensions. The database time values measure performance of one or more databases by the time the database takes to respond to a request. The set of database time values is correlated to a set of cells in the treemap. A size of the cell is determined based on the database time value associated with it. For example, the database time value is correlated to an area of the cell. A layout of the set of cells is determined and the treemap is displayed using the layout. For example, the largest values of database time may be shown with the largest sized cells. This makes it easier for an administrator to review and analyze the database performance across multiple dimensions and determine problem areas affecting the performance of the one or more databases.
摘要翻译：具体实施方案一般涉及使用树形图显示数据库时间。为一组维度确定一组数据库时间值。数据库时间值衡量数据库响应请求时所需的一个或多个数据库的性能。数据库时间值集合与树形图中的一组单元格相关联。基于与其相关联的数据库时间值来确定单元的大小。例如，数据库时间值与单元的区域相关。确定一组单元格的布局，并使用布局显示树状图。例如，数据库时间的最大值可以用最大尺寸的单元显示。这使管理员更容易查看和分析多个维度的数据库性能，并确定影响一个或多个数据库性能的问题区域。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式