# US 9,436,734 B2 · Relative performance prediction of a replacement database management system (DBMS)

> Agents: this data is available as JSON from the patentgrep API and MCP server — see https://patentgrep.com/llms.txt

- Number: US 9,436,734 B2
- Document ID: US9436734B2
- Status: Granted
- Kind: B2
- Application number: 14/058,261
- Filed: 2013-10-20
- Published: 2014-05-15
- Granted: 2016-09-06
- Earliest claimed: 2012-11-09
- Assignees: International Business Machines Corporation
- Applicants: International Business Machines Corporation
- Inventors: Austin Clifford; Enda McCallig
- Web page: https://patentgrep.com/patent/US9436734B2

## CPC

- G06F 16/24545: {Selectivity estimation or determination}
- G06F 11/3419: {by assessing time}
- G06F 16/21: Design, administration or maintenance of databases
- G06F 16/217: {Database tuning (G06F16/2282 takes precedence; database performance monitoring G06F11/3409)}
- G06F 11/3414: {Workload generation, e.g. scripts, playback}
- G06F 2201/865: Monitoring of software
- G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N)

## Abstract

Embodiments of the present invention provide a method, system and computer program product for pre-migration performance prediction of a database management system (DBMS). In an embodiment of the invention, a method for pre-migration performance prediction of a DBMS can include executing a calibration workload in a target DBMS to produce a conversion factor of cost of executing the calibration workload to temporal performance of executing the calibration workload. The method also can include subsequently submitting a sample workload from a database of a source DBMS for evaluation of cost of execution on an empty replica of the database in the target DBMS. Finally, the method can include predicting a temporal performance of the sample workload in the target DBMS as a product of the conversion factor and the cost of execution of the sample workload on the empty replica of the database in the target DBMS.

## Claims

### Claim 1

A method for pre-migration performance prediction of a database management system (DBMS), the method comprising:
executing a calibration workload in a target DBMS to produce a conversion factor of cost of executing the calibration workload to temporal performance of executing the calibration workload;
subsequently submitting a sample workload from a database of a source DBMS for evaluation of cost of execution on an empty replica of the database in the target DBMS; and,
predicting a temporal performance of the sample workload in the target DBMS as a product of the conversion factor and the cost of execution of the sample workload on the empty replica of the database in the target DBMS.

### Claim 2 (depends on 1)

The method of claim 1, wherein the calibration workload is an ad-hoc, decision support benchmark derived workload.

### Claim 3 (depends on 1)

The method of claim 1, wherein the sample workload is a selection of database queries captured over a duration of time in the source DBMS.

### Claim 4 (depends on 1)

The method of claim 1, wherein the cost of executing the calibration workload is determined from a query execution plan produced by submitting the calibration workload to a query optimizer of the target DBMS, and the cost of executing the sample workload is determined from a query execution plan produced by establishing optimization statistics from a query optimizer of the source DBMS in the query optimizer of the target DBMS and submitting the sample workload to the query optimizer of the target DBMS.

### Claim 5 (depends on 1)

The method of claim 1, wherein the empty replica of the database is produced from a set of dynamic data language (DDL) statements extracted from the database of the source DBMS.