Database workload capture and replay architecture

Data processing: database and file management or data structures – File or database maintenance – Synchronization

Reexamination Certificate

Rate now

  [ 0.00 ] – not rated yet Voters 0   Comments 0

Details

C709S248000

Reexamination Certificate

active

07984015

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.

REFERENCES:
patent: 5440735 (1995-08-01), Goldring
patent: 5448739 (1995-09-01), Jacobson
patent: 6041344 (2000-03-01), Bodamer et al.
patent: 6094684 (2000-07-01), Pallmann
patent: 6145121 (2000-11-01), Levy et al.
patent: 6167405 (2000-12-01), Rosensteel, Jr. et al.
patent: 6236997 (2001-05-01), Bodamer et al.
patent: 6253228 (2001-06-01), Ferris et al.
patent: 6629313 (2003-09-01), Rowe et al.
patent: 6769054 (2004-07-01), Sahin et al.
patent: 6775826 (2004-08-01), Zahavi et al.
patent: 6813731 (2004-11-01), Zahavi et al.
patent: 6877095 (2005-04-01), Allen
patent: 7076480 (2006-07-01), Scardo et al.
patent: 7194761 (2007-03-01), Champagne
patent: 7415522 (2008-08-01), Kaluskar et al.
patent: 2003/0172091 (2003-09-01), Norcott
patent: 2004/0015600 (2004-01-01), Tiwary et al.
patent: 2004/0221115 (2004-11-01), Sahin et al.
patent: 2005/0038849 (2005-02-01), Kaluskar et al.
patent: 2005/0055383 (2005-03-01), Dias et al.
patent: 2005/0131879 (2005-06-01), Ghosh et al.
patent: 2005/0131881 (2005-06-01), Ghosh et al.
patent: 2005/0186975 (2005-08-01), Yach et al.
patent: 1 610 238 (2005-12-01), None
patent: WO 02/097664 (2002-12-01), None
patent: WO 03/005202 (2003-01-01), None
patent: WO 03/009139 (2003-01-01), None
Dias, K., et al., “Automatic Performance Diagnosis and Tuning in Oracle”, XP-002470748, CIDR Conference, 2005, 12 pages.
European Patent Office, “International Search Report”, PCT/US2007/081966, dated Mar. 11, 2008, 14 pages.
Claims, PCT/US2007/081966, 6 pages.
“5 Schema Objects” downloaded from the Internet Apr. 12, 2007 < http://oracle-docs.dartmouth.edu/dba-docs/10gdoc/server.101/b10743/schema.htm > pp. 11-14.
“6 Application Builder Concepts” downloaded from the Internet Apr. 12, 2007 < http://oracle-docs.dartmouth.edu/dba-docs/10gdoc/appdev.101/b10992/mvl—fund.htm > p. 11.

LandOfFree

Say what you really think

Search LandOfFree.com for the USA inventors and patents. Rate them and share your experience with other people.

Rating

Database workload capture and replay architecture does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Database workload capture and replay architecture, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Database workload capture and replay architecture will most certainly appreciate the feedback.

Rate now

     

Profile ID: LFUS-PAI-O-2679314

  Search
All data on this website is collected from public sources. Our data reflects the most accurate information available at the time of publication.