AUTOMATED VALIDATION OF DATABASE INDEX CREATION
First Claim
1. A computing system comprising:
- a validation module that operates to automatically validate index creation on a database entity in an environment that includes multiple databases,the validation module configured to automatically validate index impact of the created index by using a validation data store that contains validation data originating from a plurality of databases.
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
20 Claims
-
1. A computing system comprising:
-
a validation module that operates to automatically validate index creation on a database entity in an environment that includes multiple databases, the validation module configured to automatically validate index impact of the created index by using a validation data store that contains validation data originating from a plurality of databases. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14)
-
-
15. A computer-implemented method for a validation module to automatically validating index creation on a database entity in an environment that includes multiple databases, the method comprising:
-
an act of the validation module determining that creation of an index is to be validated; an act of the validation module communicating with a validation data store that contains validation data originating from a plurality of databases; and an act of evaluating validation data from the validation data store that was generated before and after the creation of the index to estimate index impact; and an act of recommending or performing reversion or keeping of the created index based on the estimated index impact. - View Dependent Claims (16, 17)
-
-
18. A computing system comprising:
a validation module that operates to 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, the validation module configured to evaluate the validation data generated prior to and after creation of the index to thereby generated an index impact estimate. - View Dependent Claims (19, 20)
Specification