# US 2012/0254205 A1 · Ontology guided reference data discovery

> Agents: this data is available as JSON from the patentgrep API and MCP server — see https://patentgrep.com/llms.txt

- Number: US 2012/0254205 A1
- Document ID: US20120254205A1
- Status: Published application
- Kind: A1
- Application number: 13/493,369
- Filed: 2012-06-11
- Published: 2012-10-04
- Earliest claimed: 2010-05-27
- Assignees: International Business Machines Corporation
- Inventors: Dmitriy Fot; Dan J. Mandelstein; Ivan M. Milman; Martin A. Oberhofer; Sushain Pandit
- Web page: https://patentgrep.com/patent/US20120254205A1

## CPC

- G06F 16/217: {Database tuning (G06F16/2282 takes precedence; database performance monitoring G06F11/3409)}
- G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N)

## Abstract

Mapping and translating reference data from multiple databases using an enterprise ontology. This is achieved by various means, including mapping values of a first database to corresponding fields within the ontology, mapping values of a second database to corresponding fields within the ontology, and determining relationships between the values of the first database and the values of the second database based on their respective mappings to common fields within the ontology.

## Claims

### Claim 1

A method of mapping reference data, comprising:
mapping a first reference value from a first set of reference data to a first ontology value in an ontology, wherein the first reference value characterizes one or more data values in a first database;
mapping a second reference value from a second set of reference data to a second ontology value in the ontology, wherein the second reference value characterizes one or more data values in a second database;
determining a first association between the first ontology value and the second ontology value; and
based on the determined first association, and by use of one or more computer processors, determining a second association between the first value from the first set of reference data and the second value from the second set of reference data.

### Claim 2 (depends on 1)

The method of claim 1, further comprising:
generating a translation table, based on the determined second association between the first reference value and the second reference value, for translating the first set of reference data to use a reference schema of the second set of reference data.

### Claim 3 (depends on 2)

The method of claim 2, further comprising:
creating, based on the translation table, a translated set of reference data, wherein the translated set of reference data contains data of the first set of reference data, and uses the reference schema of the second set of reference data.

### Claim 4 (depends on 1)

The method of claim 1, wherein mapping the first reference value from the first set of reference data to the first ontology value in the ontology, further comprises:
for each ontology value in the ontology, determining a value partition between the ontology value and the reference value;
determining a maximal value partition between a particular ontology value and the reference value; and
mapping the reference value to the particular ontology value.

### Claim 5 (depends on 1)

The method of claim 1, wherein mapping the first reference value from the first set of reference data to the first ontology value in the ontology, further comprises:
identifying a first domain of the ontology corresponding to the one or more reference values from the first set of reference data; and
mapping the one or more reference values from the first set of reference data to an ontology value in the first domain of the ontology.

### Claim 6 (depends on 1)

The method of claim 1, wherein the first ontology value and the second ontology value are a same value within the ontology.

### Claim 7

A computer-readable storage medium containing a program which, when executed, performs an operation, comprising:
mapping a first reference value from a first set of reference data to a first ontology value in an ontology, wherein the first reference value characterizes one or more data values in a first database;
mapping a second reference value from a second set of reference data to a second ontology value in the ontology, wherein the second reference value characterizes one or more data values in a second database;
determining a first association between the first ontology value and the second ontology value; and
based on the determined first association, and by use of one or more computer processors, determining a second association between the first value from the first set of reference data and the second value from the second set of reference data.

### Claim 8 (depends on 7)

The computer-readable storage medium of claim 7, the operation further comprising:
generating a translation table, based on the determined second association between the first reference value and the second reference value, for translating the first set of reference data to use a reference schema of the second set of reference data.

### Claim 9 (depends on 8)

The computer-readable storage medium of claim 8, the operation further comprising:
creating, based on the translation table, a translated set of reference data, wherein the translated set of reference data contains data of the first set of reference data, and uses the reference schema of the second set of reference data.

### Claim 10 (depends on 7)

The computer-readable storage medium of claim 7, the operation further comprising:
identifying the first set of reference data, containing a first plurality of reference values, comprising:
for each table in a first database:
determining a size of the table;
determining whether the table is a reference table based on the determined size for the table; and
if the table is determined to be a reference data table, adding the table to the first set of reference data.

### Claim 11 (depends on 7)

The computer-readable storage medium of claim 7, wherein mapping the first reference value from the first set of reference data to the first ontology value in the ontology, further comprises:
identifying a first domain of the ontology corresponding to the one or more reference values from the first set of reference data; and
mapping the one or more reference values from the first set of reference data to an ontology value in the first domain of the ontology.

### Claim 12 (depends on 7)

The computer-readable storage medium of claim 7, wherein the first ontology value and the second ontology value are a same value within the ontology.

### Claim 13

A system, comprising:
a computer processor; and
a memory containing a program that, when executed on the computer processor, performs an operation for mapping reference data, comprising:
mapping a first reference value from a first set of reference data to a first ontology value in an ontology, wherein the first reference value characterizes one or more data values in a first database;
mapping a second reference value from a second set of reference data to a second ontology value in the ontology, wherein the second reference value characterizes one or more data values in a second database;
determining a first association between the first ontology value and the second ontology value; and
based on the determined first association, and by use of one or more computer processors, determining a second association between the first value from the first set of reference data and the second value from the second set of reference data.

### Claim 14 (depends on 13)

The system of claim 13, wherein the program, when executed, further performs the steps comprising:
generating a translation table, based on the determined second association between the first reference value and the second reference value, for translating the first set of reference data to use a reference schema of the second set of reference data.

### Claim 15 (depends on 14)

The system of claim 14, wherein the program, when executed, further performs the steps comprising:
creating, based on the translation table, a translated set of reference data, wherein the translated set of reference data contains data of the first set of reference data, and uses the reference schema of the second set of reference data.

### Claim 17 (depends on 13)

The system of claim 13, wherein mapping the first reference value from the first set of reference data to the first ontology value in the ontology, further comprises:
for each ontology value in the ontology, determining a value partition between the ontology value and the reference value;
determining a maximal value partition between a particular ontology value and the reference value; and
mapping the reference value to the particular ontology value.

### Claim 18 (depends on 13)

The system of claim 13, wherein mapping the first reference value from the first set of reference data to the first ontology value in the ontology, further comprises:
identifying a first domain of the ontology corresponding to the one or more reference values from the first set of reference data; and
mapping the one or more reference values from the first set of reference data to an ontology value in the first domain of the ontology.

### Claim 19 (depends on 13)

The system of claim 13, wherein the first ontology value and the second ontology value are a same value within the ontology.
