System, method, and computer program for normalizing a JSON structure

A method, comprising:

• at a computer system:
• receiving user input defining a structured format for a target data structure, the structured format including:
• at least one entity type capable of being stored in the target data structure, and
• a data configuration for each entity type of the at least one entity type,
• wherein each entity type requires entities of the entity type to be defined in the target data structure using a relative path;
• identifying a source JSON structure having a semi-structured format, wherein the source JSON structure includes a plurality of nodes;
• and
• normalizing the source JSON structure into the target data structure by:
• traversing the plurality of nodes of the source JSON structure to extract metadata from the source JSON structure, the metadata including:
• nodes values stored in the source JSON structure, a foreign key map listing nodes attributes capable of being used as a foreign key for entities of the target data structure, and a parent entity map listing entities having a common relative path between an object node being traversed and its parent node in the source JSON structure, and
• using the metadata to map values in the source JSON structure to corresponding entities of the target data structure based on the particular structured format defined for the target data structure,
• wherein each entity of the target data structure is defined using the relative path between two of the nodes of the source JSON structure.

A system, comprising:

• a non-transitory memory storing instructions;
• and
• one or more processors in communication with the non-transitory memory that execute the instructions to:
• receive user input defining a structured format for a target data structure, the structured format including:
• at least one entity type capable of being stored in the target data structure, and
• a data configuration for each entity type of the at least one entity type,
• wherein each entity type requires entities of the entity type to be defined in the target data structure using a relative path;
• identify a source JSON structure having a semi-structured format, wherein the source JSON structure includes a plurality of nodes;
• and
• normalize the source JSON structure into the target data structure by:
• traversing the plurality of nodes of the source JSON structure to extract metadata from the source JSON structure, the metadata including:
• nodes values stored in the source JSON structure, a foreign key map listing nodes attributes capable of being used as a foreign key for entities of the target data structure, and a parent entity map listing entities having a common relative path between an object node being traversed and its parent node in the source JSON structure, and
• using the metadata to map values in the source JSON structure to corresponding entities of the target data structure based on the particular structured format defined for the target data structure,
• wherein each entity of the target data structure is defined using the relative path between two of the nodes of the source JSON structure.