Patent Document ID: 8676765
Application ID: 13181014
Patent Status: 1

Claim One:
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.