Bank of America Corporation
System for analyzing, optimizing, and remediating a proposed data query prior to query implementation

Abstract:

Embodiments of the invention enable analyzing, optimizing and remediating a proposed data query prior to query implementation. Embodiments receive a request from a user; in response, perform an initialization comprising connecting to a data management structure; exporting an explain text of the request in a known format; and disconnecting from the data management structure. In response to initialization, embodiments perform a shredding step comprising shredding the explain text of the request; and populating a plurality of metadata tables comprising a superset table required for internal processing. Next, embodiments define or redefine a machine learning algorithm comprising a plurality of rulesets by calling a plurality of macros to act on the request; access a historic log comprising identified performance tuning parameters configured for tuning queries; and use the identified performance tuning parameters and the machine learning algorithm, optimize the query, thereby resulting in an optimized query.