US 11,934,402 B2
System and method for generating optimized data queries to improve hardware efficiency and utilization
Suki Ramasamy, Tamil Nadu (IN); Satish Reddy Andela, Telangana (IN); and Venkatarao Gorantla, Telangana (IN)
Assigned to BANK OF AMERICA CORPORATION, Charlotte, NC (US)
Filed by BANK OF AMERICA CORPORATION, Charlotte, NC (US)
Filed on Aug. 6, 2021, as Appl. No. 17/396,026.
Prior Publication US 2023/0037564 A1, Feb. 9, 2023
Int. Cl. G06F 16/2455 (2019.01); G06F 16/22 (2019.01)
CPC G06F 16/2455 (2019.01) [G06F 16/221 (2019.01)] 20 Claims
OG exemplary drawing
 
1. A system for searching a database, the system comprising:
at least one non-transitory storage device; and
at least one processing device coupled to the at least one non-transitory storage device, wherein the at least one processing device is configured to:
receive a search request to perform a search operation on one or more database columns of a database, wherein the search request is a SELECT query that includes one or more search value and indicates the one or more database columns of the database to be searched, wherein the search request comprises a request to exclude one or more NULL columns from the one or more database columns to be searched;
identify one or more search columns of the one or more database columns of the database based on at least one of the one or more search values, wherein the identification of the one or more search columns comprises comparing the at least one of the one or more search values with a reference matrix, wherein the reference matrix relates to contents of the database;
update the SELECT query of the search request based on the one or more search columns identified, wherein the updated search request has removed the one or more NULL columns from the one or more database columns to be searched by the search request, wherein the updated search request indicates the one or more search columns to be searched; and
cause a transmission of the updated search request for performance of the search operation, wherein the updated search request is the updated SELECT query that is capable of being performed on the database and indicates the one or more search columns to be searched, wherein the database includes each of the NULL columns after the search request is updated.