# US 2008/0306984 A1 · System and method for semantic normalization of source for metadata integration with etl processing layer of complex data across multiple data sources particularly for clinical research and applicable to other domains

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

- Number: US 2008/0306984 A1
- Document ID: US20080306984A1
- Status: Published application
- Kind: A1
- Application number: 11/760,636
- Filed: 2007-06-08
- Published: 2008-12-11
- Earliest claimed: 2007-06-08
- Inventors: Robert R. Friedlander; Richard A. Hennessy; James R. Kraemer
- Web page: https://patentgrep.com/patent/US20080306984A1

## CPC

- G16H 10/60: for patient-specific data, e.g. for electronic patient records
- G06F 16/23: Updating
- G16H: HEALTHCARE INFORMATICS, i.e. INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR THE HANDLING OR PROCESSING OF MEDICAL OR HEALTHCARE DATA
- G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N)

## Abstract

A computer implemented method, apparatus, and computer usable program code for mapping data. A rule set is received. The rule set defines a semantic conceptual mapping between a source attribute of a source datum and a target attribute of a target domain. Furthermore, the rule set is implemented using first metadata associated with the source datum. A semantic conceptual construct is created based on the rule set. The semantic conceptual construct specifies the semantic conceptual mapping and is adapted to interact with a tool for performing an extract, transform, and load process. The source datum is mapped to the target domain using the tool. The tool performs the semantic conceptual mapping using the semantic conceptual construct. A conformed datum is created by the semantic conceptual mapping. The conformed datum is stored in a target data repository.

## Claims

### Claim 1

A computer implemented method comprising:
receiving 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;
creating 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;
storing the semantic conceptual construct in a format that supports interaction with a tool for performing an extract, transform, and load process;
mapping 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
storing the conformed datum in a target data repository.

### Claim 2 (depends on 1)

The computer implemented method of claim 1 wherein the metadata expresses a derived contextual understanding of the source datum.

### Claim 3 (depends on 1)

The computer implemented method of claim 1 wherein the rule set is defined by a user via a graphical user interface.

### Claim 4 (depends on 3)

The computer implemented method of claim 3 wherein the user has limited information technology knowledge.

### Claim 5 (depends on 1)

The computer implemented method of claim 1 wherein the tool is a currently available tool, and wherein the tool consumes a semantics definition stored in the semantic conceptual construct during a process of transforming and moving the source datum to the target domain.

### Claim 6 (depends on 1)

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

### Claim 7 (depends on 1)

The computer implemented method 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 a same concept to a user, and wherein the first clinical data and the second clinical data are in different formats.

### Claim 8 (depends on 1)

The computer implemented method of claim 1 further comprising:
preventing the semantic conceptual mapping until the semantic conceptual construct is created.

### Claim 9 (depends on 1)

The computer implemented method 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, a clinical term, a patient demographic, a phenotype data class, and a genotype data class.

### Claim 10 (depends on 1)

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

### Claim 11 (depends on 9)

The computer implemented method of claim 9 comprising:
creating an aggregation during extraction, transformation, and loading, even if the aggregation did not exist in the underlying data source.

### Claim 12 (depends on 1)

The computer implemented method 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 the same information to a user, and wherein the first clinical data and the second clinical data are in different formats.

### Claim 13

A computer implemented method comprising:
categorizing a plurality of target attributes into at least one domain, wherein the at least one domain has corresponding sets of domains;
associating a plurality of source attributes with the corresponding sets of domains, wherein associating creates a set of semantic conceptual definitions; and
storing the set of semantic conceptual definitions in a semantic conceptual mapping tool repository.

### Claim 14 (depends on 13)

The computer implemented method of claim 13 further comprising:
identifying a target data structure; and
loading the target data structure.

### Claim 15 (depends on 13)

The computer implemented method of claim 13 further comprising:
associating domain specifications associated with the sets of domains with the target data structure.

### Claim 16 (depends on 13)

The computer implemented method of claim 13 wherein the set of semantic conceptual definitions relate to at least one of a clinical study and health care claims records.

### Claim 17

A data processing system comprising:
a processor;
a bus connected to the processor;
a computer usable medium connected to the bus, wherein the computer usable medium contains a set of instructions for creating a set of definitions for use in mapping data, wherein the processor is adapted to carry out the set of instructions to:
categorize a plurality of target attributes into at least one domain, wherein the at least one domain has corresponding sets of domains;
associate a plurality of source attributes with the corresponding sets of domains, wherein associating creates a set of semantic conceptual definitions; and
store the set of semantic conceptual definitions in a metadata repository.

### Claim 18

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 receiving 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;
computer usable program code for creating 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;
computer usable program code for storing the semantic conceptual construct in a format that supports interaction with a tool for performing an extract, transform, and load process;
computer usable program code for mapping 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
computer usable program code for storing the conformed datum in a target data repository.

### Claim 19 (depends on 18)

The computer program product of claim 18 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 a same concept to a user, and wherein the first clinical data and the second clinical data are in different formats.

### Claim 20 (depends on 18)

The computer program product of claim 18 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, a clinical term, a patient demographic, a phenotype data class, and a genotype data class.
