Automated validation of database index creation
First Claim
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.
1 Assignment
0 Petitions
Accused Products
Abstract
Automated validation of the creation of indices in an environment that include multiple and potential many databases, such as perhaps a cloud computing environment. A validation module validates index impact of a created index by using a validation data store that contains validation data originating from a database collection. Index impact may be estimated by evaluating validation data generated prior to and after the creation of the index to thereby determine whether the created index results in overall improved query performance on the database collection for those queries that target the newly indexed database entity. Such validation data need not even contain private data that was contained within the query itself, and might be, for instance, query performance data, or execution plans associated with the query, with private data redacted.
-
Citations
22 Claims
-
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 Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16)
-
-
17. A computer-implemented method, executed at a computer system comprising one or more processors, for a validation module to automatically validate creation of an index within a particular database entity in an environment that includes multiple database entities, the method comprising:
-
the validation module determining that creation of an index is to be validated; the validation module communicating with a validation data store that contains validation data originating from a plurality of databases; and evaluating validation data from the validation data store that was generated before and after the creation of the index to estimate index impact on the entire environment that includes the multiple database entities, wherein validating the overall index impact includes at least; estimating a first performance impact of the created index on one or more first queries that utilize the created index; and estimating 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 created index based on both the estimated first performance impact and the estimated second performance impact. - View Dependent Claims (18, 19)
-
-
20. A computing system comprising a validation module, wherein the validation module is configured to at least:
-
automatically validate index creation of an index of a database entity of a database using live workload data of the database entity, the live workload data including validation data generated prior to creation of the index and validation data generated after the creation of the index; evaluate the validation data generated prior to and after creation of the index to thereby generate an overall database performance impact estimate, including; a performance increase estimate on one or more first queries that utilize the created index; and an performance decrease estimate on one or more second queries that do not utilize the created index; and automatically retain the created index based on identifying that the overall database performance impact is improved or automatically delete the created index when it is determined that the overall database performance impact is degraded. - View Dependent Claims (21, 22)
-
Specification