Ontology mapper

A system for facilitating decision support by determining nomenclature linkages between variables in databases having different ontologies, comprising:

• one or more computer processors;
• and
• one or more computer storage media storing computer-useable instructions that, when executed by the one or more processors, implement a method comprising:
• accessing a first document from a first record system having a first ontology;
• accessing a second document from a second record system having a second ontology that is different than the first ontology;
• generating a provisional map linking a first-comparison variable to a second-comparison variable;
• determining categorical datatypes of one or more first document variables of the first document using the provisional map;
• determining categorical datatypes of one or more second document variables of the second document using the provisional map;
• based on the categorical datatypes of the one or more first document variables and the categorical datatypes of the one or more second document variables, generating a set of textmatrices;
• applying latent semantic analysis to the set of textmatrices to determine a latent semantic space associated with at least one first-document variable and at least one second document variable;
• specifying a threshold of similarity;
• and
• for the first comparison-variable from the at least one first-document variable associated with the latent semantic space:
• determining a measure of similarity to the second-comparison variable from at least one second-document variable associated with the latent semantic space:
• performing a comparison of the measure of similarity to the threshold;
• and
• based on the comparison, determining that the measure of similarity satisfies the threshold, associating the first comparison variable with the second comparison variable, and designating the association as a synonymy, wherein the threshold is satisfied if the measure of similarity is greater than the threshold.

A system for discovering and validating latent relationships in data, comprising:

• one or more processors;
• and
• one or more computer storage media storing computer-useable instructions that, when executed by the one or more processors, implement a method comprising:
• receiving a plurality of documents from two or more record-keeping systems, wherein the received plurality of documents comprises a set of documents;
• generating a provisional map linking a first-comparison variable to a second-comparison variable;
• determining categorical datatypes associated with each of the documents within the set of documents using the provisional map;
• based on the set of documents, generating a set of textmatricies;
• applying latent semantic analysis to the set of textmatrices to determine a latent semantic space;
• specifying a threshold of similarity;
• and
• for the first-document variable, from a first document, associated with the latent semantic space:
• determining a measure of similarity to the second-document variable, from a second document, associated with the latent semantic space;
• performing a comparison of the measure of similarity to the threshold;
• and
• based on the comparison, determining that the measure of similarity satisfies the threshold, associating the first-document variable with the second-document variable, and designating the association as a synonymy, wherein the threshold is satisfied if the measure of similarity is greater than the threshold.