System for linking diverse data systems

• US 9,953,081 B2
• Filed: 09/30/2015
• Issued: 04/24/2018
• Est. Priority Date: 02/26/2015
• Status: Active Grant

• Current Assignee: Accenture Global Services Limited (Accenture PLC)
• Original Assignee: Accenture Global Services Limited (Accenture PLC)
• Inventors: Gomadam, Karthik, Tung, Teresa Sheausan
• Primary Examiner(s): Somers, Marc S
• Application Number:
  US14/870,671
• Publication Number:
  US 20160253364A1
• Time in Patent Office: 937 Days
• CPC Class Codes: G06F 16/22 Indexing; Data structures therefor; Storage structures
• CPC Class Codes: G06F 16/256 in federated or virtual databases
• CPC Class Codes: G06F 16/26 Visual data mining; Browsing structured data
• CPC Class Codes: G06F 16/3344 using natural language analysis
• CPC Class Codes: G06F 16/353 into predefined classes
• CPC Class Codes: G06F 16/9024 Graphs; Linked lists G06F16/9027 takes precedence

Abstract

A system creates an abstraction layer surrounding a diverse data system including multiple different databases. Data is received from data sources and ingested into the various databases according to a core model. New instances of the core model are created and added to a larger linked data model (LDM) when new data sources are added to the system. The LDM captures the linkages between different linked data objects and links across different databases. Accordingly, applications are able to access or explore the linked data stored in different databases without prior knowledge of the linking relationships.

Claims

1. A method comprising:

receiving a dataset at a communication interface, the dataset including dataset context information comprising metadata for the dataset;

determining by a processor a core model correlating to the dataset based on the dataset context information, the core model comprising a first dataset type node, a first database node, and a first relationship edge existing between the first dataset type node and the first database node, the first relationship edge establishing a relationship property for storage of the first dataset type in the first database node, the first database node corresponding to a first database of a plurality of databases in a diverse data system;

determining by the processor that a first portion of the dataset correlates to the first dataset type node;

referencing, by the processor, the first relationship edge between the first dataset type node and the first database node to determine the first database is a destination for storage of the first portion of the dataset;

transmitting by the communication interface the first portion of the dataset to the first database for storage;

instantiating, by linked data model (LDM) control circuitry, a first LDM instance in an LDM, the first LDM instance comprising;

definitional structure that represents the core model;

a representation of the first portion of the dataset as an instance of the first dataset type node of the core model; and

a representation of the first database as an instance of the first database node of the core model;

receiving by the communication interface a query for at least the first portion of the dataset from a querying entity;

referencing, by the LDM control circuitry, the first LDM instance to determine the first database as the database in which the first portion of the dataset is stored;

transmitting by the communication interface the first portion of the dataset to the querying entity;

determining by the processor a semantic query response to the query by referencing, via the LDM control circuitry, a domain knowledge graph of the LDM, the domain knowledge graph including the first LDM instance as an LDM instance node related to a second LDM instance node in the domain knowledge graph; and

transmitting by the communication interface an identification of the second LDM instance node to the querying entity.

2. The method of claim 1 wherein the core model includes a second dataset type node, a second database node, and a second relationship edge existing between the second dataset type node and the second database node, the second relationship edge establishing a relationship property for storage of the second dataset type in the second database node, the second database node corresponding to a second database of the plurality of databases in the diverse data system, the method further comprising:

determining by the processor that a second portion of the dataset correlates to the second dataset type node;

referencing, by the processor, the second relationship edge between the second dataset type node and the second database node to determine the second database as a destination for storage of the second portion of the dataset;

transmitting by the communication interface the second portion of the dataset to the second database for storage; and

wherein instantiating, by the LDM control circuitry, the first LDM instance in the LDM further comprises including a representation of the second portion of the dataset as an instance of the second dataset type node and a representation of the second database as an instance of the second database node.

3. The method of claim 1 further comprising:

contacting by the processor via the communication interface, the first database to retrieve the first portion of the dataset; and

receiving by the communication interface the first portion of the dataset from the first database.

4. The method of claim 3 further comprising:

determining by the processor a semantic query response to the query by referencing, via the LDM control circuitry, the first LDM instance to determine a link between a second portion of the dataset and the first portion of the dataset within the first LDM instance; and

transmitting by the communication interface an identification of the second portion of the dataset to the querying entity.

5. The method of claim 1 further comprising:

receiving, at the communication interface, a second dataset, the second dataset including second dataset context information comprising metadata associated with the second dataset;

determining by the processor that the core model correlates to the second dataset based on the second dataset context information;

determining by the processor that a first portion of the second dataset correlates to the first dataset type node of the core model;

referencing by the processor the first relationship edge between the first dataset type node and the first database node to determine the first database is a destination for storage of the first portion of the second dataset;

transmitting by the communication interface the first portion of the second dataset to the first database for storage; and

instantiating, by the LDM control circuitry, a second LDM instance in the LDM, the second LDM instance having at least partially a same structure as the core model and including a representation of the first portion of the second dataset as an instance of the first dataset type node of the core model and a representation of the first database as an instance of the first database node of the core model.

6. The method of claim 5 further comprising:

updating, by the LDM control circuitry, a domain knowledge graph of the LDM to include the second LDM instance as an LDM instance node in relation to at least one other LDM instance node in the domain knowledge graph.

7. The method of claim 1 further comprising:

receiving an update to the core model, the update including a third database node and a relationship edge establishing a relationship property for storage of the first dataset type in the third database node, the third database node corresponding to a third database of the plurality of databases in the diverse data system; and

updating, by the LDM control circuitry, the first LDM instance to link the first portion of the dataset to the third database.

8. The method of claim 7 further comprising:

updating, by the LDM control circuitry, a plurality of LDM instances to link the first portion of the dataset to the third database, the plurality of LDM instances being instances of the core model.

9. A system comprising:

a communication interface configured to receive a dataset including dataset context information comprising metadata associated with the dataset;

a first core model including a first dataset type node, a first database node, and a first relationship edge existing between the first dataset type node and the first database node, the first relationship edge establishing a relationship property for storage of the first dataset type in the first database node, the first database node corresponding to a first database of a plurality of databases in a diverse data system;

data ingestion circuitry in communication with the communication interface and configured to;

determine the core model as correlating to the dataset based on the dataset context information;

determine that a first portion of the dataset correlates to the first dataset type node; and

reference the relationship edge between the first dataset node and the first database node in the core model to determine the first database is a destination for storage of the first portion of the dataset;

the communication interface further configured to transmit the first portion of the dataset to the first database for storage;

linked data model (LDM) maintenance circuitry in communication with the data ingestion circuitry and configured to;

instantiate a first LDM instance in an LDM, the first LDM instance having, at least partially, a same structure as the core model and including a representation of the first portion of the dataset as an instance of the first dataset type node of the core model and a representation of the first database as an instance of the first database node of the core model; and

maintain a domain knowledge graph of the LDM including a domain knowledge graph including a first node corresponding to the first LDM instance; and

data exploration circuitry in communication with the communication interface and the LDM maintenance circuitry, the data exploration circuitry configured to;

receive, from a user, a selection of the first node corresponding to the first LDM instance;

communicate with the LDM maintenance circuitry to reference the first LDM instance to determine the first portion of the data set, the first database, and a second portion of the data set as associated with the first node; and

provide to the user, the first portion of the dataset and a semantic response comprising an indication of an availability of a second portion of the dataset.

10. The system of claim 9 wherein:

the first core model further includes a second dataset type node, a second database node, and a second relationship edge existing between the second dataset type node and the second database node, the second relationship edge establishing a relationship property for storage of the second dataset type in the second database node, the second database node corresponding to a second database of the plurality of databases in the diverse data system;

the data ingestion circuitry is further configured to;

determine that a second portion of the dataset correlates to the second dataset type node; and

reference the second relationship edge between the second dataset type node and the second database node to determine the second database as a destination for storage of the second portion of the dataset;

the communication interface is further configured to transmit the second portion of the dataset to the second database for storage;

and

the LDM maintenance circuitry is further configured to;

instantiate the first LDM instance by including a representation of the second portion of the dataset as an instance of the second dataset type node and a representation of the second database as an instance of the second database node.

11. The system of claim 10 further comprising:

data consumption circuitry in communication with the communication interface and the LDM maintenance circuitry, the data consumption circuitry configured to;

receive a query via the communication interface for at least the first portion of the dataset from a querying entity;

communicate with the LDM maintenance circuitry to reference the first LDM instance to determine the first database as the database in which the first portion of the dataset is stored; and

contact, via the communication interface, the first database to retrieve the first portion of the dataset;

determine a semantic query response to the query by communicating with the LDM maintenance circuitry to reference the first LDM instance to determine a link between the second portion of the dataset and the first portion of the dataset within the first LDM instance; and

effect transmission via the communication interface of the first portion of the dataset and an identification of the second portion of the dataset to the querying entity.

12. The system of claim 10 wherein

the data exploration circuitry is further configured to:

provide a data explorer tool to a user;

receive, via the data explorer tool, from a user, the selection of the first node corresponding to the first LDM instance;

contact, via the communication interface, the first database to retrieve the first portion of the dataset; and

provide to the user, via the data exploration tool, the first portion of the dataset and the indication of the availability of the second portion of the dataset.

13. The system of claim 10 wherein:

the domain knowledge graph further includes;

a second node corresponding to a second LDM instance of the core model, and

a relationship edge coupling the first node to the second node;

the data exploration circuitry is further configured to;

communicate with the LDM maintenance circuitry to reference the domain knowledge graph to determine the second node as associated with the first node based on the relationship edge coupling the first node to the second node; and

provide to the user, via the data exploration tool, a representation of the indication of the second node.

14. The system of claim 13 wherein the second LDM instance indicates a second dataset is linked to the first database, wherein the data exploration circuitry is further configured to:

receive from the user, via the data explorer tool, a selection of the second node;

communicate with the LDM maintenance circuitry to reference the second LDM instance to determine the second dataset and the first database as associated with the second node;

contact, via the communication interface, the first database to retrieve the second dataset; and

provide to the user, via the data exploration tool, the second dataset.

15. The system of claim 12 wherein the data explorer tool comprises a graphical user interface (GUI).