The patent badge is an abbreviated version of the USPTO patent document. The patent badge does contain a link to the full patent document.
The patent badge is an abbreviated version of the USPTO patent document. The patent badge covers the following: Patent number, Date patent was issued, Date patent was filed, Title of the patent, Applicant, Inventor, Assignee, Attorney firm, Primary examiner, Assistant examiner, CPCs, and Abstract. The patent badge does contain a link to the full patent document (in Adobe Acrobat format, aka pdf). To download or print any patent click here.
Patent No.:
Date of Patent:
Jul. 19, 2011
Filed:
May. 03, 2007
Karl Dias, Foster City, CA (US);
Leonidas Galanis, San Jose, CA (US);
Jonathan Klein, Redwood City, CA (US);
Venkateshwaran Venkataramani, Sunnyvale, CA (US);
Yujun Wang, Cupertino, CA (US);
Richard Sarwal, Portola Valley, CA (US);
Leng Tan, Sunnyvale, CA (US);
Graham Wood, El Granada, CA (US);
Benoit Dageville, Foster City, CA (US);
Chao Liang, Fremont, CA (US);
Sanjay Kaluskar, Menlo Park, CA (US);
Karl Dias, Foster City, CA (US);
Leonidas Galanis, San Jose, CA (US);
Jonathan Klein, Redwood City, CA (US);
Venkateshwaran Venkataramani, Sunnyvale, CA (US);
Yujun Wang, Cupertino, CA (US);
Richard Sarwal, Portola Valley, CA (US);
Leng Tan, Sunnyvale, CA (US);
Graham Wood, El Granada, CA (US);
Benoit Dageville, Foster City, CA (US);
Chao Liang, Fremont, CA (US);
Sanjay Kaluskar, Menlo Park, CA (US);
Oracle International Corporation, Redwood Shores, CA (US);
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.