Invention Grant
- Patent Title: Filtering workload for database replay
- Patent Title (中): 过滤数据库重播的工作负载
-
Application No.: US13207763Application Date: 2011-08-11
-
Publication No.: US08732126B2Publication Date: 2014-05-20
- Inventor: Karl Dias , Leonidas Galanis , Jonathan Klein , Venkateshwaran Venkataramani , Yujun Wang
- Applicant: Karl Dias , Leonidas Galanis , Jonathan Klein , Venkateshwaran Venkataramani , Yujun Wang
- Applicant Address: US CA Redwood Shores
- Assignee: Oracle International Corporation
- Current Assignee: Oracle International Corporation
- Current Assignee Address: US CA Redwood Shores
- Agency: Hickman Palermo Truong Becker Bingham Wong LLP
- Main IPC: G06F7/04
- IPC: G06F7/04 ; G06F17/30

Abstract:
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.
Public/Granted literature
- US20110295801A1 FILTERING WORKLOAD FOR DATABASE REPLAY Public/Granted day:2011-12-01
Information query