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.

Abstract: A method and system for facilitating user access to enterprise related data are provided. A catalog of data and metadata is generated from enterprise related data stored in a plurality of data stores. A user interface (UI) is displayed on an electronic device associated with a user. The UI is configured to provide a plurality of query options to query the catalog of data and metadata. At least one query option is configured to enable the user to provision a query to a virtual assistant associated with the UI. The query provided by the user using a query option is received, and a processing of the query is facilitated. A display of a response is caused on the UI based on the processing of the query. The response is selected from among a plurality of response options.

Abstract: A method and system for retrieving information from a plurality of data stores associated with the enterprise data universe are provided. The method includes causing display of a user interface (UI) on an electronic device associated with a user. A natural language query provided by the user using the UI is received and parsed to generate a plurality of query elements. A grammar-based analysis of the plurality of query elements is performed and an expression is generated based on the grammar-based analysis of the plurality of query elements. At least one answer to the query is retrieved from a knowledge base using the expression. The retrieved answer is provisioned to the user on the UI.

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.

Abstract: A method and system for generating structured data from semi-structured data are provided. The method includes reading a plurality of records from a data file including semi-structured data. Further, the method includes obtaining aligned delimiters in a list for every record that has been read. The method also includes selecting a most occurring delimiter from the list. The method then includes constructing a regular expression using the selected delimiter to split the records into different fields. The method also includes reconstructing the records for the regular expression to fit and split into fields. In addition, the method includes displaying the records split into the fields.

Abstract: A method and system for retrieving information from a plurality of data stores associated with the enterprise data universe are provided. The method includes causing display of a user interface (UI) on an electronic device associated with a user. A natural language query provided by the user using the UI is received and parsed to generate a plurality of query elements. A grammar-based analysis of the plurality of query elements is performed and an expression is generated based on the grammar-based analysis of the plurality of query elements. At least one answer to the query is retrieved from a knowledge base using the expression. The retrieved answer is provisioned to the user on the UI.

Abstract: A method and system for facilitating user access to enterprise related data are provided. A catalog of data and metadata is generated from enterprise related data stored in a plurality of data stores. A user interface (UI) is displayed on an electronic device associated with a user. The UI is configured to provide a plurality of query options to query the catalog of data and metadata. At least one query option is configured to enable the user to provision a query to a virtual assistant associated with the UI. The query provided by the user using a query option is received, and a processing of the query is facilitated. A display of a response is caused on the UI based on the processing of the query. The response is selected from among a plurality of response options.

Abstract: A method and system for generating structured data from semi-structured data are provided. The method includes reading a plurality of records from a data file including semi-structured data. Further, the method includes obtaining aligned delimiters in a list for every record that has been read. The method also includes selecting a most occurring delimiter from the list. The method then includes constructing a regular expression using the selected delimiter to split the records into different fields. The method also includes reconstructing the records for the regular expression to fit and split into fields. In addition, the method includes displaying the records split into the fields.