Automatic regression management for multi-tenant databases

A computing system for multi-tenant database management, comprising:

• memory;
• one or more hardware processors coupled to the memory;
• and
• one or more computer readable storage media storing instructions that, when loaded into the memory, cause the one or more hardware processors to perform operations comprising:
• detecting, in a first tenant, performance regression of executing a query using a current query plan;
• responsive to detecting the performance regression, evaluating one or more candidate solutions for resolving the performance regression;
• identifying, from the one or more candidate solutions evaluated for their ability to resolve the detected performance regression, an effective solution that resolves the performance regression, wherein the effective solution is configured to generate an updated query plan, which has better performance than the current query plan for executing the query;
• responsive to identifying the effective solution for the first tenant, constructing a knowledge object representing the query or the current query plan associated with the detected performance regression, wherein the knowledge object specifies the identified effective solution, wherein the knowledge object comprises a pattern definition, wherein the pattern definition specifies a pattern of the detected performance regression;
• and
• distributing, to a second tenant, the knowledge object that was constructed based on regression detection and identification of the effective solution in the first tenant,
• wherein the first tenant and the second tenant represent two different user groups of a multi-tenancy environment.

One or more non-transitory computer-readable media having encoded thereon computer-executable instructions causing one or more processors to perform a method for multi-tenant database management, the method comprising:

• detecting, in a first tenant, performance regression of executing an incoming query with a query syntax using a current query plan;
• responsive to detecting the performance regression, evaluating one or more candidate solutions for resolving the performance regression;
• detecting, in a first tenant, performance regression of executing a query using a current query plan;
• responsive to detecting the performance regression, evaluating one or more candidate solutions for resolving the performance regression;
• identifying, from the one or more candidate solutions evaluated for their ability to resolve the detected performance regression, an effective solution that resolves the performance regression, wherein the effective solution is configured to generate an updated query plan, which has better performance than the current query plan for executing the query;
• responsive to identifying the effective solution for the first tenant, constructing a knowledge object representing the query or the current query plan associated with the detected performance regression, wherein the knowledge object specifies the identified effective solution, wherein the knowledge object comprises a pattern definition, wherein the pattern definition specifies a pattern of the detected performance regression;
• and
• distributing, to a second tenant, the knowledge object that was constructed based on regression detection and identification of the effective solution in the first tenant,
• wherein the first tenant and the second tenant represent two different user groups of a multi-tenancy environment.