Statistical join methods for data management
AssigneeBank of America Corporation
InventorAntoan Izmirliev
Life of this patent
Estimating the term…
Abstract
Aspects of the disclosure relate to joining data tables. A computing platform may input two or more tables into a statistical join function, which may initiate execution of the statistical join function, and where executing the statistical join function comprises applying one or more of: an end condition function, a partition tables function, or an outer join function to generate a new table that includes information from the two or more tables. The computing platform may send, to a user device, the new table and one or more commands directing the user device to display the new table, which may cause the user device to display the new table.
Claims20
A computing platform comprising:
- at least one processor;
- a communication interface communicatively coupled to the at least one processor;
- and
- memory storing computer-readable instructions that, when executed by the at least one processor, cause the computing platform to:
- initiate execution of a statistical join function on two or more tables, wherein executing the statistical join function comprises:
- a) if any of the two or more tables comprise a single row, executing an end condition function and repeating step b), wherein executing the end condition function joins at least two of the two or more tables comprising the single row and causes the at least two of the two or more tables comprising the single row to no longer comprise the single row;
- b) if none of the two or more tables comprise a single row, executing a partition tables function;
- c) if the two or more tables are both empty, executing a statistical join function to create a new table of the two or more tables, and returning to step b);
- d) if the two or more tables are not both empty, executing a merge tables function;
- e) if at least one of the two or more tables are empty, executing an apply outer join function, wherein executing the apply outer join function creates a new table of the two or more tables, and returning to step b);
- f) if none of the two or more tables are empty, identifying whether a vector R is empty, wherein the vector R is indicative of a merged version of the two or more tables;
- g) if R is empty, executing the apply outer join function, wherein executing the apply outer join function creates a new table of the two or more tables and returning to step a);
- and
- h) if R is not empty, generate a new table that includes information from the two or more tables in a single table;
- and
- send, to a user device, the new table and one or more commands directing the user device to display the new table, wherein sending the one or more commands directing the user device to display the new table causes the user device to display the new table.
A method comprising:
- at a computing platform comprising at least one processor, a communication interface, and memory:
- initiating execution of a statistical join function on two or more tables, wherein executing the statistical join function comprises:
- a) if any of the two or more tables comprise a single row, executing an end condition function and repeating step b), wherein executing the end condition function joins at least two of the two or more tables comprising the single row and causes the at least two of the two or more tables comprising the single row to no longer comprise the single row;
- b) if none of the two or more tables comprise a single row, executing a partition tables function;
- c) if the two or more tables are both empty, executing a statistical join function to create a new table of the two or more tables, and returning to step b);
- d) if the two or more tables are not both empty, executing a merge tables function;
- e) if at least one of the two or more tables are empty, executing an apply outer join function, wherein executing the apply outer join function creates a new table of the two or more tables, and returning to step b);
- f) if none of the two or more tables are empty, identifying whether a vector R is empty, wherein the vector R is indicative of a merged version of the two or more tables;
- g) if R is empty, executing the apply outer join function, wherein executing the apply outer join function creates a new table of the two or more tables and returning to step a);
- and
- h) if R is not empty, generate a new table that includes information from the two or more tables in a single table;
- and
- sending, to a user device, the new table and one or more commands directing the user device to display the new table, wherein sending the one or more commands directing the user device to display the new table causes the user device to display the new table.
One or more non-transitory computer-readable media storing instructions that, when executed by a computing platform comprising at least one processor, a communication interface, and memory, cause the computing platform to:
- initiate execution of a statistical join function on two or more tables, wherein executing the statistical join function comprises:
- a) if any of the two or more tables comprise a single row, executing an end condition function and repeating step b), wherein executing the end condition function joins at least two of the two or more tables comprising the single row and causes the at least two of the two or more tables comprising the single row to no longer comprise the single row;
- b) if none of the two or more tables comprise a single row, executing a partition tables function;
- c) if the two or more tables are both empty, executing a statistical join function to create a new table of the two or more tables, and returning to step b);
- d) if the two or more tables are not both empty, executing a merge tables function;
- e) if at least one of the two or more tables are empty, executing an apply outer join function, wherein executing the apply outer join function creates a new table of the two or more tables, and returning to step b);
- f) if none of the two or more tables are empty, identifying whether a vector R is empty, wherein the vector R is indicative of a merged version of the two or more tables;
- g) if R is empty, executing the apply outer join function, wherein executing the apply outer join function creates a new table of the two or more tables and returning to step a);
- and
- h) if R is not empty, generate a new table that includes information from the two or more tables in a single table;
- and
- send, to a user device, the new table and one or more commands directing the user device to display the new table, wherein sending the one or more commands directing the user device to display the new table causes the user device to display the new table.
Dependencies are inferred from the claim text.