Information exchange between heterogeneous databases through automated identification of concept equivalence

• US 20050154708A1
• Filed: 01/29/2003
• Published: 07/14/2005
• Est. Priority Date: 01/29/2002
• Status: Abandoned Application

• Current Assignee: Children's Hospital Boston
• Original Assignee: Children's Hospital Boston
• Inventors: Sun, Yao
• Application Number:
  US10/502,876
• Publication Number:
  US 20050154708A1
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 16/27 Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
• CPC Class Codes: G06F 16/275 Synchronous replication

Abstract

Described are a system and methods for exchanging information between heterogeneous databases (28,28′). A constructor (54) produces a first semantic network (58) representation of a first database (28). A concept matcher (52) identifies semantic concept equivalencies (64) between the semantic network (58) representation of the first database (28) and a second semantic network (58′) representation of the second database (28′). A query processor (66) uses one of the identified semantic concept equivalencies (64,64′) to generate a request to access data from the second database (28).

Claims

1. A system for exchanging information between a first database and a second database, the system comprising:

a constructor for producing a first semantic network representation of the first database;

a concept matcher for identifying semantic concept equivalencies between the semantic network representation of the first database and a semantic network representation of the second database; and

a query processor using one of the identified semantic concept equivalencies to generate a request to access data from the second database.

2. The system of claim 1, wherein the semantic network representation of the database includes a plurality of nodes, each node representing a concept, at least one of the nodes having a link to the first database for use in formulating a query.

3. The system of claim 2, wherein each node represents a medical concept.

4. The system of claim 1, wherein the semantic network representation of the database includes a plurality of nodes, each node representing a concept, at least one of the nodes having a link to a vocabulary.

5. The system of claim 4, wherein the vocabulary is the Unified Medical Language System Metathesaurus.

6. The system of claim 1, wherein the semantic network representation of the database includes a plurality of nodes, each node representing a concept, at least one node having a first link to the first database for use in formulating a query and a second link to a vocabulary.

7. The system of claim 6, wherein the at least one node has a definition associated therewith.

8. The system of claim 1, further comprising a table storing the semantic concept equivalencies.

9. The system of claim 1, further comprising a transmitter for sending the request generated by the query processor over a network to a database system comprising the second database.

10. The system of claim 9, wherein the transmitter sends the first semantic network representation to the database system comprising the second database.

11. The system of claim 1, wherein the query processor uses the first semantic network representation to formulate a query that accesses data in the first database in response to a request received over a network.

12. The system of claim 1, further comprising a receiver for receiving the second semantic network representation over a network from a database system comprising the second database.

13. The system of claim 1, further comprising a receiver for receiving data over a network transmitted from a database system comprising the second database in response to the request.

14. The system of claim 1, wherein the network constructor allows reconstruction of the first semantic network representation if the first database changes.

15. The system of claim 1, wherein the concept matcher establishes a context for at least one node in the first semantic network representation and identifies a matching concept in the second semantic network representation for the at least one node using the established context.

16. The system of claim 1, wherein the concept matcher dynamically re-identifies semantic concept equivalencies between the semantic network representation of the first database and the semantic network representation of the second database if one of the semantic network representations changes.

17. A method for exchanging data between databases, the method comprising:

generating a first semantic network representation of a first database;

receiving a second semantic network representation of a second database;

identifying semantic concept equivalencies between the first and second semantic network representations; and

producing a request to retrieve information from the second database using at least one of the identified semantic concept equivalencies.

18. The method of claim 17, further comprising linking at least one node in the first semantic network representation to a vocabulary list.

19. The method of claim 18, wherein identifying semantic concept equivalencies includes comparing each term in the vocabulary list linked to the at least one node in the first semantic network representation with each term in a vocabulary list linked to at least one node in the second semantic network representation.

20. The method of claim 17, wherein identifying semantic concept equivalencies includes establishing a context for at least one node in the first semantic network representation, and identifying a matching concept in the second semantic network representation for the at least one node using the established context.

21. The method of claim 20, wherein the context includes at least one sibling node of the at least one node in the first semantic network representation.

22. The method of claim 20, wherein the context includes at least one neighboring node of the at least one node in the first semantic network representation.

23. The method of claim 20, wherein the context includes at least one leaf node depending from the at least one node in the first semantic network representation.

24. The method of claim 17, wherein identifying semantic concept equivalencies includes matching a concept represented by at least one node in the first semantic network representation with at least one concept represented by at least one node in the second semantic network representation.

25. The method of claim 24, further comprising assigning a score to each matched concept.

26. The method of claim 25, further comprising selecting one matched concept for the at least node in the first semantic network representation based bn the score for that one matched concept.

27. The method of claim 24, further comprising setting a threshold for a number of matched concepts found by a particular matching algorithm, and rejecting each matched concept found by that particular matching algorithm if the number exceeds the threshold.

28. The method of claim 17, wherein identifying semantic concept equivalencies includes generalizing at least one node of the first semantic network representation to find a concept in the second semantic network representation that encompasses a concept represented by the at least one node of the first semantic network representation.

29. The method of claim 17, wherein identifying semantic concept equivalencies includes decomposing at least one node of the first semantic network representation into constituent concepts and find a match for at least one of the constituent concepts in the second semantic network representation.

30. The method of claim 17, further comprising transmitting the request over a network to retrieve information from the second database.

31. The method of claim 17, further comprising storing the identified semantic concept equivalencies in the first database.

32. The method of claim 17, further comprising using a stored semantic concept equivalency to identify another semantic concept equivalency.

33. The method of claim 17, further comprising reconstructing the first semantic network representation if the first database changes.

34. The method of claim 17, further comprising dynamically re-identifying semantic concept equivalencies between the first semantic network representation and the second semantic network representation if one of the semantic network representations changes

35. A method of exchanging data between databases, the method comprising:

generating a semantic network representation of a first database; and

receiving a request from a remote database system to retrieve information from the first database, the request identifying a node of the semantic network representation; and

retrieving information from the first database using a query formulated from information associated with the node of the semantic network representation.

36. The method of claim 35, further comprising identifying semantic concept equivalencies between the semantic network representation of the first database and a second semantic network representation of a second database.

37. The method of claim 36, wherein identifying semantic concept equivalencies occurs in response to receiving the request from the remote database system.

38. The method of claim 36, further comprising receiving the second semantic network representation from the remote database system.

39. The method of claim 36, generating the semantic network representation of the first database occurs in response to receiving the request from the remote database system.

40. The method of claim 35, further comprising communicating the semantic network representation to the remote database system.

41. The method of claim 35, further comprising communicating the retrieved information to the remote database system over a network.

42. The method of claim 35, further comprising regenerating the first semantic network representation if the first database changes.