Method and system for managing associations between entity records

1. A method of managing associations between entity records, wherein the method comprises:

a) extracting data records from existing data sources stored in a relational database, wherein the data records comprise entity names and entity attributes associated with each of the entity names, wherein each of the entity names belong to different entity;

b) identifying the entity names, and entity attributes corresponding to each of the entity name in each of the extracted data records;

c) clustering the entity names and corresponding entity attributes to create a second plurality of entity records, wherein the clustering is performed based on similar entity attributes of the entity names;

d) comparing one or more geolocations between the second plurality of entity records and a first plurality of entity records stored in at least one curated database to determine at least one identical geolocation;

e) identifying associations between the second plurality of entity records and the first plurality of entity records based on the determination of the at least one identical geolocation between the second plurality of entity records and the first plurality of entity records; and

f) identifying associations between entity names in the second plurality of entity records based on the entity attributes and geolocations corresponding to each of the entity names in the second plurality of entity records.

2. The method of claim 1 , wherein the method comprises identifying a class of at least one entity attribute of the second plurality of entity records based on at least one curated database.

3. The method of claim 1 , wherein the method comprises analysing a geolocation of the entity names of the second plurality of entity records based on at least one curated database.

4. The method of claim 1 , wherein extracting data records from the existing data sources comprises cleaning and/or translating the data records.

5. A system for managing associations between entity records, wherein the system comprises:

a relational database configured to store at least one curated database and existing data sources;

a communication module configured to retrieve at least one curated database and existing data sources; wherein the communication module is operatively coupled to a processing module; and

the processing module configured to:

a) extract data records from existing data sources stored in the relational database, wherein the data records comprise entity names and entity attributes associated with each of the entity names, wherein each of the entity names belong to different entity;

b) identify the entity names and entity attributes corresponding to each of the entity names in each of the extracted data records;

c) cluster the entity names and corresponding entity attributes to create a second plurality of entity records, wherein the clustering is performed based on similar entity attributes of the entity names;

d) compare one or more geolocations between the second plurality of entity records and a first plurality of entity records stored in at least one curated database to determine at least one identical geolocation;

e) identify associations between the second plurality of entity records and the first plurality of entity records based on the determination of the at least one identical geolocation between the second plurality of entity records and the first plurality of entity records; and

f) identify associations between entity names in the second plurality of entity records based on the entity attributes and geolocations corresponding to each of the entity names in the second plurality of entity records.

6. The system of claim 5 , wherein the processing module identifies a class of at least one entity attribute of the second plurality of entity records based on at least one curated database.

7. The system of claim 5 , wherein the processing module analyses a geolocation of the entity names of the second plurality of entity records based on at least one curated database.

8. The system of claim 5 , wherein extracting data records from the existing data sources comprises cleaning and/or translating the data records.