Database archiving performance benefit determination

1. A database archiving performance benefit determination system comprising:

a data reduction module to ascertain a reduction value representing a percentage reduction of data stored in a database;

a database setup module to ascertain a setup of the database, the setup including data layout information and statistics on the database; and

a performance modeling module, executed by a processor, to:

calculate performance changes for a Structured Query Language (SQL) statement associated with an execution plan of a database application, the execution plan including a sequence of steps the database follows to perform work contained in the SQL statement, wherein to calculate the performance changes for the SQL statement, the performance modeling module is to calculate an intermediate performance increase at a plurality of the sequential steps of the execution plan using the data layout information and the statistics on the database, and the reduction value representing the percentage reduction of data stored in the database; and

calculate an overall performance increase for archiving the database at the percentage reduction of data based upon the calculated intermediate performance increases for the database application.

2. The system of claim 1 , wherein the overall performance increase is calculated as a percentage performance increase.

3. The system of claim 1 , wherein the performance modeling module is trainable using actual performance data, and the overall performance increase is adjusted by a parameter determined from the actual performance data.

4. The system of claim 1 , wherein the performance modeling module generates a curve of data reduction versus the overall performance increase for the database application.

5. The system of claim 1 , wherein the intermediate performance increase at each of the plurality of the sequential steps is adjusted by a parameter determined from actual performance data.

6. The system of claim 1 , wherein the intermediate performance increase at the plurality of the sequential steps is adjusted by parameters determined from actual performance data.

7. A method for database archiving performance benefit determination, the method comprising:

ascertaining a reduction value representing a percentage reduction of data stored in a database;

ascertaining a setup of the database, the setup including data layout information and statistics on the database; and

calculating, by a processor, performance changes for a Structured Query Language (SQL) statement associated with an execution plan of a database application, the execution plan including a sequence of steps the database follows to perform work contained in the SQL statement, and wherein calculating the performance changes for the SQL statement includes calculating an intermediate performance increase at a plurality of the sequential steps of the execution plan using the data layout information and the statistics on the database, and the reduction value representing the percentage reduction of data stored in the database; and

calculating an overall performance increase for archiving the database at the percentage reduction of data based upon the calculated intermediate performance increases for the database application.

8. The method of claim 7 , wherein the overall performance increase is calculated as a percentage performance increase.

9. The method of claim 7 , further comprising generating a curve of data reduction versus the overall performance increase for the database application.

10. The method of claim 7 , wherein the intermediate performance increase at each of the plurality of the sequential steps is adjusted by a parameter determined from actual performance data.

11. The method of claim 7 , wherein the intermediate performance increase at the plurality of the sequential steps is adjusted by parameters determined from actual performance data.

12. The method of claim 7 , further comprising prompting a user to interactively change the reduction value based on archive goals.

13. A non-transitory computer readable medium storing machine readable instructions, the machine readable instructions when executed by a computer system, cause the computer system to:

ascertain a reduction value representing a percentage reduction of data stored in a database;

ascertaining ascertain a setup of the database, the setup including data layout information and statistics on the database;

calculate performance changes for a Structured Query Language (SQL) statement associated with an execution plan of a database application, the execution plan including a sequence of steps the database follows to perform work contained in the SQL statement, wherein to calculate the performance changes for the SQL statement, the machine readable instructions are to further cause the computer system to calculate an intermediate performance increase at a plurality of the sequential steps of the execution plan using the data layout information and the statistics on the database, and the reduction value representing the percentage reduction of data stored in the database; and

calculate an overall performance increase for archiving the database at the percentage reduction of data based upon the calculated intermediate performance increases for the database application.

14. The computer readable medium of claim 13 , wherein the intermediate performance increase at the plurality of the sequential steps is adjusted by parameters determined from actual performance data.