US 12,469,074 B2
Systems and methods for processing inter-dependent data for risk modelling and analysis
Yangming Chris Cai, Toronto (CA); and Sriram Rajaram, Toronto (CA)
Assigned to Bank of Montreal, Toronto (CA)
Filed by Bank of Montreal, Toronto (CA)
Filed on Aug. 18, 2022, as Appl. No. 17/890,897.
Claims priority of provisional application 63/237,881, filed on Aug. 27, 2021.
Prior Publication US 2023/0068947 A1, Mar. 2, 2023
Int. Cl. G06F 16/20 (2019.01); G06F 16/22 (2019.01); G06F 16/28 (2019.01); G06Q 40/03 (2023.01)
CPC G06Q 40/03 (2023.01) [G06F 16/2282 (2019.01); G06F 16/285 (2019.01)] 18 Claims
OG exemplary drawing
 
1. A method of processing data items in one or more memories configured in a first logical table including a plurality of logical rows and a plurality of logical columns, wherein a value of a data item in a first logical column in each logical row is determined based on a dependency of the first logical column on a second logical column in another logical row, the method comprising:
configuring, by one or more processors, at least the first and second logical columns of the first logical table into a first logical array of data items;
determining, by the one or more processors executing a first execution node, values of the data items in the first logical array using the dependency; and
responsive to determining, by the one or more processors, an allocation of the values of the data items in the first logical array to a first execution node of a plurality of execution nodes and values of the data items in a second logical array to a second execution node of the plurality of execution nodes according to the dependency,
converting, by the one or more processors executing the first execution node of the allocation, the first logical array with the determined values of the data items into the second logical array of the second execution node of the allocation to improve performance of processing the first logical array and the second logical array, the second logical array comprises a second logical table that includes a plurality of logical rows and a plurality of logical columns using a function configured to:
convert the first logical array with the determined values into a plurality of key-value pairs; and
convert the plurality of key-value pairs into the plurality of columns and the plurality of rows in the second logical table by mapping the key-value pairs to the plurality of logical rows and the plurality of logical columns of the first logical table.