US 12,321,362 B1
Converting hierarchical data into relational data
Michael Roche, Springfield, MA (US); Andrew Sheridan, Springfield, MA (US); Ellie Nerney, Springfield, MA (US); and Daniel Oldham, Springfield, MA (US)
Assigned to Massachusetts Mutual Life Insurance Company, Springfield, MA (US)
Filed by Massachusetts Mutual Life Insurance Company, Springfield, MA (US)
Filed on Oct. 5, 2022, as Appl. No. 17/960,671.
Int. Cl. G06F 16/00 (2019.01); G06F 16/22 (2019.01); G06F 16/25 (2019.01); G06F 16/84 (2019.01)
CPC G06F 16/258 (2019.01) [G06F 16/2282 (2019.01); G06F 16/86 (2019.01)] 18 Claims
OG exemplary drawing
 
1. A method, implemented in a computer system comprising one or more processors coupled with memory, comprising:
receiving, by the one or more processors, via a network, a first file of a first format comprising hierarchical data including a set of data objects having a hierarchical relationship, each of set of data objects including at least one of a plurality of keys in accordance with the hierarchical relationship;
obtaining, by the one or more processors, a data object of the set of data objects in the hierarchical data, the data object including a key of the plurality of keys and a value;
determining, by the one or more processors, from a set of candidate anchor paths, an anchor path for the data object based on the hierarchical relationship of the key within the plurality of keys, each candidate anchor path of the set of candidate anchor paths associated with a respective table of a plurality of tables;
determining, by the one or more processors, from a set of candidate object paths, an object path for the data object based on the key and the anchor path, each candidate object path of the set of candidate object paths associated with a respective column of one or more columns in a table of the plurality of tables associated with the anchor path;
storing, by the one or more processors, on a cache memory, the value of the data object and an indication of a corresponding column associated with the object path;
determining, by the one or more processors, that a minimum number of values for the one or more columns for a row that are stored in the cache memory;
generating, by the one or more processors, responsive to determining that the minimum number of values are stored in the cache memory, the row of the table associated with the anchor path, wherein the row includes the value of the data object at the corresponding column associated with the object path;
clearing, by the one or more processors, at least a portion of the cache memory in response to generating the row of the table, including the value of the data object at the corresponding column;
storing, by the one or more processors, using a second file of a second format comprising relational data on a database, wherein the row includes the value of the data object at the corresponding column in the table of the plurality of tables; and
maintaining, by the one or more processors, the plurality of tables on the database using the second file of the second format to be searchable for querying via the network.