发明授权
US07890458B2 Capturing database workload while preserving original transactional and concurrency characteristics for replay
有权
捕获数据库工作负载,同时保留用于重放的原始事务和并发特性
- 专利标题: Capturing database workload while preserving original transactional and concurrency characteristics for replay
- 专利标题(中): 捕获数据库工作负载,同时保留用于重放的原始事务和并发特性
-
申请号: US11800239申请日: 2007-05-03
-
公开(公告)号: US07890458B2公开(公告)日: 2011-02-15
- 发明人: Karl Dias , Leonidas Galanis , Jonathan Klein , Venkateshwaran Venkataramani , Yujun Wang
- 申请人: Karl Dias , Leonidas Galanis , Jonathan Klein , Venkateshwaran Venkataramani , Yujun Wang
- 申请人地址: US CA Redwood Shores
- 专利权人: Oracle International Corporation
- 当前专利权人: Oracle International Corporation
- 当前专利权人地址: US CA Redwood Shores
- 代理机构: Hickman Palermo Truong & Becker LLP
- 代理商 Christian A. Nicholes
- 主分类号: G06F7/00
- IPC分类号: G06F7/00 ; G06F17/00
摘要:
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.
公开/授权文献
信息查询