Methods and systems for mapping flattened structure to relationship preserving hierarchical structure

Abstract

A method and a system for mapping a flattened data structure into a relation preserving data structure is disclosed. The method includes receiving a flattened schema comprising a plurality of columns. The method includes receiving a plurality of user inputs from a user. The plurality of user inputs comprises a plurality of identifiers. The method includes defining a sample target hierarchical schema based on user inputs. The method includes preparing a nested hierarchical structure corresponding to the sample target hierarchical schema in a User Interface (UI) representation. The nested hierarchical structure comprises a plurality of nodes with corresponding identifiers and relationships of the plurality of nodes. The method includes performing an Artificial Intelligence (AI) based mapping of columns of the flattened schema to respective nodes of the plurality of nodes of the nested hierarchical structure. The method further includes generating a target hierarchical schema based on AI based mapping.