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

51. 发明申请

US20120054245A1 TRANSACTIONALLY CONSISTENT DATABASE REPLAY IN AN ENVIRONMENT WITH CONNECTION POOLING 有权
标题翻译：在连接池的环境中进行一致的数据库重复
公开(公告)号：US20120054245A1
公开(公告)日：2012-03-01
申请号：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.
摘要翻译：提供了一种方法，装置和计算机可读介质，用于在具有连接池的数据库环境中重放捕获的工作负载数据。重播系统包括管理连接池的调度器。在一个方面，调度员选择可用的连接，用于发送准备对数据库执行的数据库命令，但是防止发送或保留尚未准备好针对数据库执行的命令。命令可以存储在调度器中，直到数据库进入允许执行命令的状态。在另一方面，调度员可以使用可用的连接来发送命令到数据库实例，即使该命令尚未准备好被执行，只要至少一个阈值数量或百分比的连接仍然可用。

52. 发明授权

US07890458B2 Capturing database workload while preserving original transactional and concurrency characteristics for replay 有权
标题翻译：捕获数据库工作负载，同时保留用于重放的原始事务和并发特性
公开(公告)号：US07890458B2
公开(公告)日：2011-02-15
申请号：US11800239
申请日：2007-05-03
申请人： Karl Dias , Leonidas Galanis , Jonathan Klein , Venkateshwaran Venkataramani , Yujun Wang
发明人： Karl Dias , Leonidas Galanis , Jonathan Klein , Venkateshwaran Venkataramani , Yujun Wang
IPC分类号： G06F7/00 , G06F17/00
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.
摘要翻译：提供了一种用于捕获数据库系统工作负载并在数据库系统中重播该工作负载的方法和装置。根据一个方面，为了使测试数据库系统处于生产数据库系统实际受到的相同工作负载，生产系统中的数据库服务器捕获并记录数据库服务器从外部实体接收的工作负载。处理此捕获的工作负载。测试数据库系统中数据库服务器外部的进程将处理的工作负载发送到该数据库服务器。因此，测试数据库系统受到生产数据库系统最初遭受的相同工作量的影响。如果将测试数据库系统中存在的差异引入到生产数据库系统中，则上述技术允许数据库管理员确定生产数据库系统将如何展示。

53. 发明申请

US20080097996A1 Transactionally consistent database workload replay 有权
标题翻译：事务一致的数据库工作负载重播
公开(公告)号：US20080097996A1
公开(公告)日：2008-04-24
申请号：US11800238
申请日：2007-05-03
申请人： Karl Dias , Leonidas Galanis , Jonathan Klein , Venkateshwaran Venkataramani , Yujun Wang
发明人： Karl Dias , Leonidas Galanis , Jonathan Klein , Venkateshwaran Venkataramani , Yujun Wang
IPC分类号： G06F17/30
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.
摘要翻译：提供了一种用于捕获数据库系统工作负载并在数据库系统中重播该工作负载的方法和装置。根据一个方面，为了使测试数据库系统处于生产数据库系统实际受到的相同工作负载，生产系统中的数据库服务器捕获并记录数据库服务器从外部实体接收的工作负载。处理此捕获的工作负载。测试数据库系统中数据库服务器外部的进程将处理的工作负载发送到该数据库服务器。因此，测试数据库系统受到生产数据库系统最初遭受的相同工作量的影响。如果将测试数据库系统中存在的差异引入到生产数据库系统中，则上述技术允许数据库管理员确定生产数据库系统将如何展示。

54. 发明申请

US20080097960A1 Client-driven functionally equivalent database replay 有权
标题翻译：客户端驱动的功能等效数据库重播
公开(公告)号：US20080097960A1
公开(公告)日：2008-04-24
申请号：US11800224
申请日：2007-05-03
申请人： Karl Dias , Leonidas Galanis , Jonathan Klein , Venkateshwaran Venkataramani , Yujun Wang
发明人： Karl Dias , Leonidas Galanis , Jonathan Klein , Venkateshwaran Venkataramani , Yujun Wang
IPC分类号： G06F17/30
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.
摘要翻译：提供了一种用于捕获数据库系统工作负载并在数据库系统中重播该工作负载的方法和装置。根据一个方面，为了使测试数据库系统处于生产数据库系统实际受到的相同工作负载，生产系统中的数据库服务器捕获并记录数据库服务器从外部实体接收的工作负载。处理此捕获的工作负载。测试数据库系统中数据库服务器外部的进程将处理的工作负载发送到该数据库服务器。因此，测试数据库系统受到生产数据库系统最初遭受的相同工作量的影响。如果将测试数据库系统中存在的差异引入到生产数据库系统中，则上述技术允许数据库管理员确定生产数据库系统将如何展示。

55. 发明申请

US20130311642A1 AUTOMATED DISCOVERY OF TEMPLATE PATTERNS BASED ON RECEIVED SERVER REQUESTS 有权
标题翻译：根据接收到的服务器要求自动发现模板模式
公开(公告)号：US20130311642A1
公开(公告)日：2013-11-21
申请号：US13475514
申请日：2012-05-18
申请人： Konstantinos Morfonios , Leonidas Galanis , Neoklis Polyzotis , Karl Dias
发明人： Konstantinos Morfonios , Leonidas Galanis , Neoklis Polyzotis , Karl Dias
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.
摘要翻译：这里描述了基于服务器接收的请求来确定模式的方法。基于确定的模式，可以获得服务器接收到的请求的类型。此外，可以以有用的方式汇总性能统计信息和查询统计信息。例如，可以针对每个确定的模式总结性能统计。用于确定模式的一种技术包括确定标识与服务器请求序列中的请求的子序列相对应的模板的模板标识符序列。可以基于模板标识符的序列来创建模型。基于该模型，可以确定模板图案。模板图案可以进一步分组成模式簇。

56. 发明授权

US08438144B2 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.
摘要翻译：提供了一种方法，装置和计算机可读介质，用于在具有连接池的数据库环境中重放捕获的工作负载数据。重播系统包括管理连接池的调度器。在一个方面，调度员选择可用的连接，用于发送准备对数据库执行的数据库命令，但是防止发送或保留尚未准备好针对数据库执行的命令。命令可以存储在调度器中，直到数据库进入允许执行命令的状态。在另一方面，调度员可以使用可用的连接来发送命令到数据库实例，即使该命令尚未准备好被执行，只要至少一个阈值数量或百分比的连接仍然可用。

57. 发明授权

US08024299B2 Client-driven functionally equivalent database replay 有权
标题翻译：客户端驱动的功能等效数据库重播
公开(公告)号：US08024299B2
公开(公告)日：2011-09-20
申请号：US11800224
申请日：2007-05-03
申请人： Karl Dias , Leonidas Galanis , Jonathan Klein , Venkateshwaran Venkataramani , Yujun Wang
发明人： Karl Dias , Leonidas Galanis , Jonathan Klein , Venkateshwaran Venkataramani , Yujun Wang
IPC分类号： G06F7/22 , G06F17/40
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.
摘要翻译：提供了一种用于捕获数据库系统工作负载并在数据库系统中重播该工作负载的方法和装置。根据一个方面，为了使测试数据库系统处于生产数据库系统实际受到的相同工作负载，生产系统中的数据库服务器捕获并记录数据库服务器从外部实体接收的工作负载。处理此捕获的工作负载。测试数据库系统中数据库服务器外部的进程将处理的工作负载发送到该数据库服务器。因此，测试数据库系统受到生产数据库系统最初遭受的相同工作量的影响。如果将测试数据库系统中存在的差异引入到生产数据库系统中，则上述技术允许数据库管理员确定生产数据库系统将如何展示。

58. 发明授权

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。其他实施例集合可以提供用于实现顾问框架的方法，系统和/或软件程序。

59. 发明申请

US20080097961A1 Capturing database workload while preserving original transactional and concurrency characteristics for replay 有权
标题翻译：捕获数据库工作负载，同时保留用于重放的原始事务和并发特性
公开(公告)号：US20080097961A1
公开(公告)日：2008-04-24
申请号：US11800239
申请日：2007-05-03
申请人： Karl Dias , Leonidas Galanis , Jonathan Klein , Venkateshwaran Venkataramani , Yujun Wang
发明人： Karl Dias , Leonidas Galanis , Jonathan Klein , Venkateshwaran Venkataramani , Yujun Wang
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.
摘要翻译：提供了一种用于捕获数据库系统工作负载并在数据库系统中重播该工作负载的方法和装置。根据一个方面，为了使测试数据库系统处于生产数据库系统实际受到的相同工作负载，生产系统中的数据库服务器捕获并记录数据库服务器从外部实体接收的工作负载。处理此捕获的工作负载。测试数据库系统中数据库服务器外部的进程将处理的工作负载发送到该数据库服务器。因此，测试数据库系统受到生产数据库系统最初遭受的相同工作量的影响。如果将测试数据库系统中存在的差异引入到生产数据库系统中，则上述技术允许数据库管理员确定生产数据库系统将如何展示。

60. 发明授权

US07292961B2 Capturing session activity as in-memory snapshots using a time-based sampling technique within a database for performance tuning and problem diagnosis 有权
标题翻译：使用数据库中的基于时间的抽样技术将会话活动作为内存快照捕获，以进行性能调优和问题诊断
公开(公告)号：US07292961B2
公开(公告)日：2007-11-06
申请号：US10775733
申请日：2004-02-09
申请人： Karl Dias , Venkateshwaran Venkataramani , Mark Ramacher , Graham S. Wood , Juan Loaiza
发明人： Karl Dias , Venkateshwaran Venkataramani , Mark Ramacher , Graham S. Wood , Juan Loaiza
IPC分类号： G06F17/40
CPC分类号： G06F17/30306 , G06F17/30368
摘要： Techniques for capturing samples of session activity in a database are provided. Session activity for active sessions is recorded at certain times over a time period. Accordingly, a sample of session activity is taken for sessions in a database.
摘要翻译：提供了在数据库中捕获会话活动样本的技术。活动会话的会话活动在一段时间内被记录在特定时间。因此，会话活动的样本被用于数据库中的会话。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式