Patent ID: 11947535
Assignee: BANK OF AMERICA CORPORATION
Field: Computer technology (Electrical engineering)
Classification: CPC G | IPC G

Claim 0:
1. A computing platform, comprising:
at least one processor;
a communication interface communicatively coupled to the at least one processor; and
a memory storing computer-readable instructions that, when executed by the at least one processor, cause the computing platform to:
receive, from a user device, a database query;
analyze the database query to determine whether it meets first criteria, wherein determining whether the database query meets first criteria includes determining whether the database query matches a pre-stored optimized query having data that was previously modified using one or more data reorganization processes and is stored in an optimized query cache;
responsive to determining that the database query meets the first criteria:
execute the database query; and
transmit an output of the executed database query to the user device;

responsive to determining that the database query does not meet the first criteria:
retrieve data associated with the database query;
execute, based on one or more machine learning datasets, the one or more data reorganization processes on the data associated with the database query to output modified data, wherein executing, based on the one or more machine learning datasets, the one or more data reorganization processes on the data associated with the database query to output modified data includes using a job function of a user of the user device and the one or more machine learning datasets to generate one or more modified data tables including a number of columns identified using machine learning and a number of rows identified using machine learning, wherein the number of columns identified using machine learning and the number of rows identified using machine learning are fewer than a number of columns and a number of rows in the data associated with the database query;
generate, based on the modified data, an updated query;
store, in the optimized query cache, the updated query and the modified data;
execute the updated query; and
transmit an output of the executed updated query to the user device.