Invention Grant
- Patent Title: Identifying and mitigating high-risk database queries through ranked variance analysis
-
Application No.: US15874539Application Date: 2018-01-18
-
Publication No.: US11030195B2Publication Date: 2021-06-08
- Inventor: Ratnesh Kumar Singh , Ambica Rajagopal , Akhilesh Raghavendrachar Srinivasachar Kaddi , Harikrishnan Choondani Velayudhan , Stephanie Trethaway
- Applicant: FMR LLC
- Applicant Address: US MA Boston
- Assignee: FMR LLC
- Current Assignee: FMR LLC
- Current Assignee Address: US MA Boston
- Agency: Proskauer Rose LLP
- Main IPC: G06F16/2453
- IPC: G06F16/2453 ; G06F16/23 ; G06F16/2455

Abstract:
Methods and apparatuses are described for system for identifying and mitigating high-risk database queries through ranked variance analysis. A server identifies database queries executed against databases in a production computing environment within a predetermined time period, each database query associated with execution plans and each execution plan having corresponding plan data elements. For each database query: the server generates execution variance data for the execution plans for a database query based upon the corresponding plan data elements, comprising: determining an execution time variance between the execution plans; and determining a buffer gets variance between the execution plans. The server ranks the database queries according to (i) the execution time variance, and (ii) the buffer gets variance. The server computing device identifies high-risk database queries based upon the rank, and adjusts execution settings for each of the identified high-risk database queries to mitigate performance degradation in the production computing environment.
Public/Granted literature
- US20190220534A1 IDENTIFYING AND MITIGATING HIGH-RISK DATABASE QUERIES THROUGH RANKED VARIANCE ANALYSIS Public/Granted day:2019-07-18
Information query