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

• US 7,788,213 B2
• Filed: 06/08/2007
• Issued: 08/31/2010
• Est. Priority Date: 06/08/2007
• Status: Expired due to Fees

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Hennessy, Richard A., Kraemer, James R., Friedlander, Robert R.
• Primary Examiner(s): Ali; Mohammad
• Assistant Examiner(s): BUI, THUY T
• Application Number:
  US11/760,652
• Publication Number:
  US 20080307430A1
• Time in Patent Office: 1,180 Days
• Field of Search: 707/101, 707/102, 707/600, 707/601, 707/602, 707/809
• US Class Current: 707/600
• CPC Class Codes: G06Q 40/08 Insurance
• CPC Class Codes: G16H 10/20 for electronic clinical trials or questionnaires
• CPC Class Codes: G16H 10/60 for patient-specific data, e.g. for electronic patient records

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

1. A data processing system comprising:

at least one processor;

a bus coupled to the at least one processor;

memory elements connected to the bus, wherein the memory elements contain a set of computer executable instructions for mapping data, wherein the at least one processor is adapted to carry out the set of computer executable instructions to;

receive a rule set, wherein the rule set defines a semantic conceptual mapping definition between a source attribute of a source datum and a target attribute of a target domain, wherein source specific information is omitted from the semantic conceptual mapping definition and wherein the rule set is implemented using first metadata associated with the source datum;

receive reference information from a reference source, wherein the reference source includes data dictionaries, online resources, custom vocabularies, lookup tables, code lists and semantic rules;

load a target definition;

populate the target definition organized according to the target domain, wherein the target definition is a data structure that defines how data is stored and a format of data in a conformed data target;

select the target domain for creation of a metadata based semantic conceptual mapping;

select a target domain attribute of the target domain;

determine a semantic conceptual mapping type;

select a source domain attribute;

deduce a data type of the source domain attribute;

create a semantic conceptual mapping from the source domain attribute to the target domain attribute using the reference information and the semantic conceptual mapping definition, wherein creating the semantic conceptual mapping further comprises validating the semantic conceptual mapping;

store the semantic conceptual mapping as a semantic conceptual construct wherein the semantic conceptual construct uses the semantic conceptual mapping type and the data type of the source domain attribute;

map the source domain attribute to the target domain attribute responsive to the semantic conceptual mapping being valid, using the semantic conceptual construct in accordance with the semantic conceptual mapping type and the data type of the source domain attribute, wherein a conformed datum is created and is integrated by capture of semantic equivalence via metadata; and

store the conformed datum in a target data repository.

2. 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.

3. 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.

4. The data processing system of claim 3 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.

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

6. 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.

7. 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.

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

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

10. The data processing system of claim 8 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.

11. The data processing system of claim 10 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.

12. A computer implemented method comprising:

receiving a rule set, wherein the rule set defines a semantic conceptual mapping definition between a source attribute of a source datum and a target attribute of a target domain, wherein source specific information is omitted from the semantic conceptual mapping definition and wherein the rule set is implemented using first metadata associated with the source datum;

receiving reference information from a reference source, wherein the reference source includes data dictionaries, online resources, custom vocabularies, lookup tables, code lists and semantic rules;

loading a target definition;

populating the target definition organized according to a target domain, wherein the target definition is a data structure that defines how data is stored and a format of data in a conformed data target;

selecting the target domain for creation of a metadata based semantic conceptual mapping;

selecting a target domain attribute of the target domain;

determining a semantic conceptual mapping type;

selecting a source domain attribute;

deducing a data type of the source domain attribute;

creating a semantic conceptual mapping from the source domain attribute to the target domain attribute using the reference information and the semantic conceptual mapping definition, wherein creating the semantic conceptual mapping further comprises validating the semantic conceptual mapping;

storing the semantic conceptual mapping as a semantic conceptual construct wherein the semantic conceptual construct uses the semantic conceptual mapping type and the data type of the source domain attribute;

mapping the source domain attribute to the target domain attribute responsive to the semantic conceptual mapping being valid, using the semantic conceptual construct in accordance with the semantic conceptual mapping type and the data type of the source domain attribute, wherein a conformed datum is created and is integrated by capture of semantic equivalence via metadata; and

storing the conformed datum in a target data repository.

13. The computer implemented method of claim 12 wherein validating the semantic conceptual mapping further comprises:

validating attribute mapping in the semantic conceptual mapping.

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

15. The computer implemented method of claim 14 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.

16. A computer program product comprising:

memory elements having computer executable program code stored therein for mapping data, the computer executable program code including;

computer executable program code for receiving a semantic conceptual mapping definition, 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 definition and wherein a rule set is implemented using first metadata associated with a source datum;

computer executable program code for receiving reference information from a reference source;

computer executable program code for loading a target definition;

computer executable program code for populating the target definition organized according to a target domain, wherein the target definition is a data structure that defines how data is stored and a format of data in a conformed data target;

computer executable program code for selecting the target domain for creation of a metadata based semantic conceptual mapping;

computer executable program code for selecting a target domain attribute of the target domain;

computer executable program code for determining a semantic conceptual mapping type;

computer executable program code for selecting a source domain attribute;

computer executable program code for deducing a data type of the source domain attribute;

computer executable program code for creating a semantic conceptual mapping from the source domain attribute to the target domain attribute using the reference information and the semantic conceptual mapping definition, wherein creating the semantic conceptual mapping further comprises validating the semantic conceptual mapping;

computer executable program code for determining whether the semantic conceptual mapping is valid; and

computer executable program code responsive to a determination that the semantic conceptual mapping is valid for storing the semantic conceptual mapping in a data repository as a semantic conceptual construct, wherein the semantic conceptual construct is responsive to the semantic conceptual mapping type and the data type of the source domain attribute.

17. The computer program product of claim 16 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.