US 12,242,480 B1
Automatic querying through selection of registered data sets
Matthew James Martinez, San Antonio, TX (US); Joseph James Albert Campbell, New Braunfels, TX (US); Quentin L. Holness, San Antonio, TX (US); Ryan Matthew West, Helotes, TX (US); Rachel Michelle Ballew, San Antonio, TX (US); and Mitchell Wade Palermo, San Antonio, TX (US)
Assigned to United Services Automobile Association (USAA), San Antonio, TX (US)
Filed by UIPCO, LLC, San Antonio, TX (US)
Filed on Jul. 29, 2022, as Appl. No. 17/877,784.
Claims priority of provisional application 63/227,524, filed on Jul. 30, 2021.
Int. Cl. G06F 16/242 (2019.01); G06F 16/2453 (2019.01)
CPC G06F 16/24544 (2019.01) [G06F 16/2423 (2019.01); G06F 16/2428 (2019.01)] 20 Claims
OG exemplary drawing
 
1. A method for automatically building and executing a join query, the method comprising:
providing a user interface (UI) with a flow for table selections and column selections, wherein the UI is based on registered programming data objects corresponding to one or more database elements;
wherein each of the programming data objects defines the one or more database elements, each for a table or column within the table, and
wherein each of the one or more database elements has corresponding meta-data defining what is displayed in the UI for the table selections or the column selections;
receiving, from the UI, two or more table selections and one or more column selections for the join query;
computing a number of connections between each of the selected tables, wherein the number of connections is a number of columns the selected tables have in common;
selecting a root table for the join query as the table with a highest number of connections;
resolving code snippets, from the programming data objects corresponding to the selected two or more tables and the selected one or more columns, into search string snippets;
generating the join query by:
inserting, into a root table slot in a query template, the search string snippet for the root table;
inserting, into a join table slot in the query template, one or more search string snippets for the one or more selected tables that are not the root table; and
inserting, into a column select slot in the query template, the one or more search string snippets for the one or more selected columns; and
executing the join query and providing results.