# US 2008/0307430 A1 · System and method for a multiple disciplinary normalization of source for metadata integration with etl processing layer of complex data across multiple claim engine sources in support of the creation of universal/enterprise healthcare claims record

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

- Number: US 2008/0307430 A1
- Document ID: US20080307430A1
- Status: Published application
- Kind: A1
- Application number: 11/760,652
- Filed: 2007-06-08
- Published: 2008-12-11
- Earliest claimed: 2007-06-08
- Assignees: International Business Machines Corporation
- Inventors: Robert R. Friedlander; Richard A. Hennessy; James R. Kraemer
- Web page: https://patentgrep.com/patent/US20080307430A1

## CPC

- G16H 10/60: for patient-specific data, e.g. for electronic patient records
- G06Q 40/08: Insurance
- G16H 10/20: for electronic clinical trials or questionnaires
- G16H: HEALTHCARE INFORMATICS, i.e. INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR THE HANDLING OR PROCESSING OF MEDICAL OR HEALTHCARE DATA
- G06Q: INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR

## Abstract

Exemplary illustrative embodiments provide for a computer implemented method, apparatus, and computer usable program code for mapping data. The mapping is defined by a user and maps a source datum to a target datum having a target attribute. The mapping is defined using metadata. Source specific information is omitted from the mapping and stored in a target data repository.

## Claims

### Claim 1

A data processing system comprising:
at least one processor;
a bus coupled to the at least one processor;
a computer usable medium connected to the bus, wherein the computer usable medium contains a set of instructions for mapping data, wherein the at least one processor is adapted to carry out the set of instructions to:
receive a rule set, wherein the rule set defines a semantic conceptual mapping between a source attribute of a source datum and a target attribute of a target domain, and wherein the rule set is implemented using first metadata associated with the source datum;
create a semantic conceptual construct based on the rule set, wherein the semantic conceptual construct describes the semantic conceptual mapping and defines a semantic normalization rule;
store the semantic conceptual construct in a format that supports interaction with a tool for performing an extract, transform, and load process;
map the source datum to the target domain using the tool, wherein the tool performs the step of mapping using the semantic conceptual construct, and wherein a conformed datum is created by the step of mapping; and
store the conformed datum in a target data repository.

### Claim 2 (depends on 1)

The data processing system of claim 1 wherein the semantic conceptual construct comprises data that defines a semantic conceptual mapping between the metadata associated with the source datum and second metadata associated with the target domain attribute.

### Claim 3 (depends on 1)

The data processing system of claim 1 wherein the source datum comprises first clinical data related to a clinical study and the conformed datum comprises second clinical data related to the clinical study, wherein the first clinical data and the second clinical data convey the same information to a user, and wherein the first clinical data and the second clinical data are in different formats.

### Claim 4 (depends on 1)

The data processing system of claim 1 wherein the rule set is created by a user who has limited information technology knowledge.

### Claim 5 (depends on 1)

The data processing system of claim 1 wherein the at least one processor is further adapted to carry out the set of instructions to:
prevent the semantic conceptual mapping until the semantic conceptual construct is created.

### Claim 6 (depends on 1)

The data processing system of claim 1 wherein the source datum comprises one of a name, a healthcare code, a language, a numerical value, a unit of measurement, a format, a date, a drug name, an industry classification, and a clinical term.

### Claim 7 (depends on 1)

The data processing system of claim 1 wherein the conformed datum is stored at an atomic level.

### Claim 8 (depends on 7)

The data processing system of claim 7 wherein the conformed datum is semantically equivalent to the source datum.

### Claim 9 (depends on 7)

The data processing system of claim 7 wherein the target data repository is a database and wherein all levels of granularity of the database are conformed based on dimensions of the database.

### Claim 10 (depends on 9)

The data processing system of claim 9 wherein the at least one processor is adapted to carry out the set of instructions to:
create an aggregation during extraction, transformation, and loading even if the aggregation did not exist in the underlying data source.

### Claim 11 (depends on 1)

The data processing system of claim 1 wherein the source datum comprises first healthcare claims record data related to a healthcare claims record and the conformed datum comprises second clinical data related to the clinical study, wherein the first clinical data and the second clinical data convey a same information to a user, and wherein the first clinical data and the second clinical data are in different formats.

### Claim 12

A computer implemented method comprising:
creating a semantic conceptual mapping definition;
loading a target definition;
populating the target definition;
selecting a target domain;
selecting a domain attribute of the target domain;
determining a semantic conceptual mapping type;
selecting a source variable;
mapping the source variable to the target domain attribute using the semantic conceptual mapping definition, wherein mapping produces a conformed datum; and
storing the conformed datum to a storage device.

### Claim 13 (depends on 12)

The computer implemented method of claim 12 wherein via the step of mapping a semantic conceptual mapping is formed, and wherein the method further comprises:
validating the semantic conceptual mapping.

### Claim 14 (depends on 12)

The computer implemented method of claim 12 further comprising:
generating a mapping report.

### Claim 15

A computer implemented method comprising:
defining a semantic conceptual mapping, wherein the semantic conceptual mapping is defined by a user, wherein the semantic conceptual mapping maps a source datum to a target datum having a target attribute, wherein the semantic conceptual mapping is defined using metadata, and wherein source specific information is omitted from the semantic conceptual mapping; and
storing the semantic conceptual mapping in a data repository as a semantic conceptual construct.

### Claim 16 (depends on 15)

The computer implemented method of claim 15 further comprising:
validating the semantic conceptual mapping.

### Claim 17 (depends on 16)

The computer implemented method of claim 16 wherein the target datum is stored at an atomic level.

### Claim 18 (depends on 17)

The computer implemented method of claim 17 wherein the target data repository is a database and wherein all levels of granularity of the database are conformed based on dimensions of the database.

### Claim 19

A computer program product comprising:
a computer usable medium having computer usable program code for mapping data, the computer program product including:
computer usable program code for defining a semantic conceptual mapping, wherein the semantic conceptual mapping is defined by a user, wherein the semantic conceptual mapping maps a source datum to a target datum having a target attribute, wherein the semantic conceptual mapping is defined using metadata, and wherein source specific information is omitted from the semantic conceptual mapping; and
computer usable program code for storing the semantic conceptual mapping in a data repository as a semantic conceptual construct.

### Claim 20 (depends on 19)

The computer program product of claim 19 wherein the target datum is stored at an atomic level, wherein the target data repository is a database, and wherein all levels of granularity of the database are conformed based on dimensions of the database.
