Claims:WE CLAIMS
1. A method for creating a dynamic canonical data model, the method comprising:
creating, by a data model creating device, staging tables to analyze regulatory data collected from a plurality of heterogeneous sources;
creating, by the data model creating device, a dynamic canonical ontology based on the staging tables representing the regulatory data, wherein the dynamic canonical ontology determines a plurality of attributes associated with the regulatory data and relationships amongst the plurality of attributes;
identifying automatically, by the data model creating device, at least one modification associated with at least one of the plurality of attributes by applying machine learning techniques on the staging tables; and
updating, by the data model creating device, the dynamic canonical ontology by adding the at least one modification to create the dynamic canonical data model.
2. The method of claim 1 further comprising collecting the regulatory data from the plurality of heterogeneous data sources.
3. The method of claim 2 further comprising converting the regulatory data into a standardized format for the dynamic canonical model.
4. The method of claim 1, wherein the regulatory data is analyzed to determine a data lineage and at least one quality matrix associated with the regulatory data.
5. The method of claim 1, wherein the dynamic canonical ontology defines lexical and semantical variations in the regulatory data.
6. The method of claim 1 further comprising:
identifying at least one redundant attribute from the plurality of attributes by applying the machine learning techniques on the staging tables; and
identifying at least one redundant relationship from the relationships amongst the plurality of attributes by applying the machine learning techniques on the staging tables.
7. The method of claim 6, wherein updating the dynamic canonical ontology comprises removing the at least one redundant attribute and the at least one redundant relationship from the dynamic canonical ontology.
8. The method of claim 1, wherein the at least one modification comprises at least one of a new attribute, a change in an existing attribute, or a new combination of attributes.
9. The method of claim 1 further comprising performing analytics on the dynamic canonical data model to identify patterns and relationships amongst attributes within the dynamic canonical ontology after being updated.
10. The method of claim 9 further comprising determining compliance of a plurality of regulations extracted from the regulatory data by the dynamic canonical data model based on a result of the analytics performed on the dynamic canonical data model.
11. A system for creating a dynamic canonical data model, the system comprising:
a processor; and
a memory communicatively coupled to the processor, wherein the memory stores processor instructions, which, on execution, causes the processor to:
create staging tables to analyze regulatory data collected from a plurality of heterogeneous sources;
create a dynamic canonical ontology based on the staging tables representing the regulatory data, wherein the dynamic canonical ontology determines a plurality of attributes associated with the regulatory data and relationships amongst the plurality of attributes;
identify automatically at least one modification associated with at least one of the plurality of attributes by applying machine learning techniques on the staging tables; and
update the dynamic canonical ontology by adding the at least one modification to create the dynamic canonical data model.
12. The system of claim 11, wherein the processor instructions further cause the processor to collect the regulatory data from the plurality of heterogeneous data sources.
13. The system of claim 11, wherein the regulatory data is analyzed to determine a data lineage and at least one quality matrix associated with the regulatory data.
14. The system of claim 11, wherein the processor instructions further cause the processor to:
identify at least one redundant attribute from the plurality of attributes by applying the machine learning techniques on the staging tables; and
identify at least one redundant relationship from the relationships amongst the plurality of attributes by applying the machine learning techniques on the staging tables.
15. The system of claim 14, wherein to update the dynamic canonical ontology the processor instructions further cause the processor to remove the at least one redundant attribute and the at least one redundant relationship from the dynamic canonical ontology.
16. The system of claim 11, wherein the at least one modification comprises at least one of a new attribute, a change in an existing attribute, or a new combination of attributes.
17. The system of claim 11, wherein the processor instructions further cause the processor to perform analytics on the dynamic canonical data model to identify patterns and relationships amongst attributes within the dynamic canonical ontology after being updated.
18. The system of claim 17, wherein the processor instructions further cause the processor to determine compliance of a plurality of regulations extracted from the regulatory data by the dynamic canonical data model based on a result of the analytics performed on the dynamic canonical data model.

Dated this 03rd day of March, 2017
Swetha SN
Of K&S Partners
Agent for the Applicant
, Description:TECHNICAL FIELD
This disclosure relates generally to managing operational tasks in an enterprise network and more particularly to method and system for creating dynamic canonical data model to unify data from heterogeneous sources.