-
公开(公告)号：US08732126B2
公开(公告)日：2014-05-20
申请号：US13207763
申请日：2011-08-11
CPC分类号： G06F17/30286
摘要： 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.
摘要翻译： 提供了一种用于捕获数据库系统工作负载并在数据库系统中重播该工作负载的方法和装置。 根据一个方面，为了使测试数据库系统处于生产数据库系统实际受到的相同工作负载，生产系统中的数据库服务器捕获并记录数据库服务器从外部实体接收的工作负载。 处理此捕获的工作负载。 测试数据库系统中数据库服务器外部的进程将处理的工作负载发送到该数据库服务器。 因此，测试数据库系统受到生产数据库系统最初遭受的相同工作量的影响。 如果将测试数据库系统中存在的差异引入到生产数据库系统中，则上述技术允许数据库管理员确定生产数据库系统将如何展示。
-
2.发明申请公开(公告)号：US20140006358A1
公开(公告)日：2014-01-02
申请号：US13538278
申请日：2012-06-29
IPC分类号： G06F17/30
CPC分类号： G06F17/30289
摘要： A method for replaying a simulation workload is provided. The simulation workload identifies a plurality of workload parts. Each workload part is at least a portion of a respective captured workload. In an embodiment, a first workload part is a portion of a first workload executed relative to a first capture database server and a second workload part is a portion of a second workload executed relative to a second capture database server. A portion of the first workload part and a portion of the second workload part may be replayed concurrently.
摘要翻译： 提供了一种重放模拟工作负载的方法。 模拟工作负载识别多个工作负载部分。 每个工作负载部分至少是相应捕获的工作负载的一部分。 在一个实施例中，第一工作负载部分是相对于第一捕获数据库服务器执行的第一工作负载的一部分，并且第二工作负荷部分是相对于第二捕获数据库服务器执行的第二工作负载的一部分。 可以同时重放第一工作负荷部分的一部分和第二工作负荷部分的一部分。
-
公开(公告)号：US07890457B2
公开(公告)日：2011-02-15
申请号：US11800238
申请日：2007-05-03
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.
摘要翻译： 提供了一种用于捕获数据库系统工作负载并在数据库系统中重播该工作负载的方法和装置。 根据一个方面，为了使测试数据库系统处于生产数据库系统实际受到的相同工作负载，生产系统中的数据库服务器捕获并记录数据库服务器从外部实体接收的工作负载。 处理此捕获的工作负载。 测试数据库系统中数据库服务器外部的进程将处理的工作负载发送到该数据库服务器。 因此，测试数据库系统受到生产数据库系统最初遭受的相同工作量的影响。 如果将测试数据库系统中存在的差异引入到生产数据库系统中，则上述技术允许数据库管理员确定生产数据库系统将如何展示。
-
4.发明申请公开(公告)号：US20130311642A1
公开(公告)日：2013-11-21
申请号：US13475514
申请日：2012-05-18
IPC分类号： G06F15/173
CPC分类号： G06F17/30371 , G06F11/3409 , G06F11/3452 , G06F17/30321 , G06F2201/80 , G06F2201/875 , G06N7/005 , H04L43/04 , H04L43/0817
摘要： Described herein are methods for determining patterns based on requests received by a server. Based on the determined patterns, insight into the types of requests received by the server can be gained. Additionally, performance statistics and query statistics can be aggregated in a useful way. For example, performance statistics may be summarized for each determined pattern. One technique for determining patterns includes determining a sequence of template identifiers identifying templates that correspond to sub-sequences of requests in a sequence of server requests. A model may be created based on the sequence of template identifiers. Based on the model, template patterns may be determined. Template patterns may further be grouped into pattern clusters.
摘要翻译： 这里描述了基于服务器接收的请求来确定模式的方法。 基于确定的模式，可以获得服务器接收到的请求的类型。 此外，可以以有用的方式汇总性能统计信息和查询统计信息。 例如，可以针对每个确定的模式总结性能统计。 用于确定模式的一种技术包括确定标识与服务器请求序列中的请求的子序列相对应的模板的模板标识符序列。 可以基于模板标识符的序列来创建模型。 基于该模型，可以确定模板图案。 模板图案可以进一步分组成模式簇。
-
5.发明授权Transactionally consistent database replay in an environment with connection pooling 有权在具有连接池的环境中事务一致的数据库重播公开(公告)号：US08438144B2
公开(公告)日：2013-05-07
申请号：US12870736
申请日：2010-08-27
申请人： Romain Colle , Karl Dias , Leonidas Galanis , Supiti Buranawatanachoke , Jonathan Giloni , Efstratios Papadomanolakis , Yujun Wang
发明人： Romain Colle , Karl Dias , Leonidas Galanis , Supiti Buranawatanachoke , Jonathan Giloni , Efstratios Papadomanolakis , Yujun Wang
IPC分类号： G06F17/30
CPC分类号： G06F17/303
摘要： A method, apparatus, and computer-readable medium is provided for replaying captured workload data in a database environment with connection pools. A replay system includes a dispatcher that manages a connection pool. In one aspect, the dispatcher selects available connections for sending database commands that are ready to be executed against a database, but prevents from being sent, or holds, commands that are not ready to be executed against the database. Commands may be stored at the dispatcher until the database advances to a state that allows the commands to be executed. In another aspect, the dispatcher may use an available connection to send a command to a database instance even though the command is not ready to be executed, as long as at least a threshold number or percentage of connections remains available.
摘要翻译： 提供了一种方法，装置和计算机可读介质，用于在具有连接池的数据库环境中重放捕获的工作负载数据。 重播系统包括管理连接池的调度器。 在一个方面，调度员选择可用的连接，用于发送准备对数据库执行的数据库命令，但是防止发送或保留尚未准备好针对数据库执行的命令。 命令可以存储在调度器中，直到数据库进入允许执行命令的状态。 在另一方面，调度员可以使用可用的连接来发送命令到数据库实例，即使该命令尚未准备好被执行，只要至少一个阈值数量或百分比的连接仍然可用。
-
公开(公告)号：US20120221519A1
公开(公告)日：2012-08-30
申请号：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/30
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应用系统中观察到的数据库更改。 重要的是，可以实现这种忠实的再现，而无需创建近似或模拟实际应用程序工作负载的事务行为的综合应用程序工作负载。 相反，真正的应用程序工作负载可以被使用或基本上被捕获。
-
公开(公告)号：US08024299B2
公开(公告)日：2011-09-20
申请号：US11800224
申请日：2007-05-03
CPC分类号： G06F17/30286
摘要： 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.
摘要翻译： 提供了一种用于捕获数据库系统工作负载并在数据库系统中重播该工作负载的方法和装置。 根据一个方面，为了使测试数据库系统处于生产数据库系统实际受到的相同工作负载，生产系统中的数据库服务器捕获并记录数据库服务器从外部实体接收的工作负载。 处理此捕获的工作负载。 测试数据库系统中数据库服务器外部的进程将处理的工作负载发送到该数据库服务器。 因此，测试数据库系统受到生产数据库系统最初遭受的相同工作量的影响。 如果将测试数据库系统中存在的差异引入到生产数据库系统中，则上述技术允许数据库管理员确定生产数据库系统将如何展示。
-
公开(公告)号：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
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.
摘要翻译： 提供了一种用于捕获数据库系统工作负载并在数据库系统中重播该工作负载的方法和装置。 根据一个方面，为了使测试数据库系统处于生产数据库系统实际受到的相同工作负载，生产系统中的数据库服务器捕获并记录数据库服务器从外部实体接收的工作负载。 处理此捕获的工作负载。 测试数据库系统中数据库服务器外部的进程将处理的工作负载发送到该数据库服务器。 因此，测试数据库系统受到生产数据库系统最初遭受的相同工作量的影响。 如果将测试数据库系统中存在的差异引入到生产数据库系统中，则上述技术允许数据库管理员确定生产数据库系统将如何展示。
-
9.发明申请Capturing database workload while preserving original transactional and concurrency characteristics for replay 有权捕获数据库工作负载，同时保留用于重放的原始事务和并发特性公开(公告)号：US20080097961A1
公开(公告)日：2008-04-24
申请号：US11800239
申请日：2007-05-03
IPC分类号： G06F17/30
CPC分类号： G06F11/3414 , G06F11/3419 , G06F11/3495 , G06F11/3688 , G06F2201/805 , G06F2201/87
摘要： 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.
摘要翻译： 提供了一种用于捕获数据库系统工作负载并在数据库系统中重播该工作负载的方法和装置。 根据一个方面，为了使测试数据库系统处于生产数据库系统实际受到的相同工作负载，生产系统中的数据库服务器捕获并记录数据库服务器从外部实体接收的工作负载。 处理此捕获的工作负载。 测试数据库系统中数据库服务器外部的进程将处理的工作负载发送到该数据库服务器。 因此，测试数据库系统受到生产数据库系统最初遭受的相同工作量的影响。 如果将测试数据库系统中存在的差异引入到生产数据库系统中，则上述技术允许数据库管理员确定生产数据库系统将如何展示。
-
公开(公告)号：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应用系统中观察到的数据库更改。 重要的是，可以实现这种忠实的再现，而无需创建近似或模拟实际应用程序工作负载的事务行为的综合应用程序工作负载。 相反，真正的应用程序工作负载可以被使用或基本上被捕获。
-
-
-
-
-
-
-
-
-
搜索结果
23 条记录 (耗时 0.018 秒)
