Please download the dossier by clicking on the dossier button x
×

Automated validation of database index creation

  • US 10,061,678 B2
  • Filed: 06/26/2015
  • Issued: 08/28/2018
  • Est. Priority Date: 06/26/2015
  • Status: Active Grant
First Claim
Patent Images

1. A computing system comprising:

  • one or more processors; and

    a validation module, executing on the one or more processors, that operates to automatically validate creation of an index within a particular database entity in an environment that includes multiple database entities, the validation module configured to;

    automatically validate an overall index impact of the created index on the entire environment that includes the multiple databases by using a validation data store that contains validation data originating from a plurality of databases, wherein validating the overall index impact includes considering at least;

    a first performance impact of the created index on one or more first queries that utilize the created index; and

    a second performance impact of the created index on one or more second queries that do not utilize the created index; and

    automatically retaining or deleting the index based on a consideration of both the first performance impact and the second performance impact.

View all claims
  • 1 Assignment
Timeline View
Assignment View
    ×
    ×