# US 2019/0057137 A1 · Data migration from a source system to a data schema of a medical study on a target system

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

- Number: US 2019/0057137 A1
- Document ID: US20190057137A1
- Status: Published application
- Kind: A1
- Application number: 15/678,212
- Filed: 2017-08-16
- Published: 2019-02-21
- Earliest claimed: 2017-08-16
- Assignees: International Business Machines Corporation
- Applicants: International Business Machines Corporation
- Inventors: Walker Bradham; Anthony Castrati; Jordan S. Simpson
- Web page: https://patentgrep.com/patent/US20190057137A1

## CPC

- G06F 16/254: {Extract, transform and load [ETL] procedures, e.g. ETL data flows in data warehouses}
- G16H 10/20: for electronic clinical trials or questionnaires
- G06F 3/0482: Interaction with lists of selectable items, e.g. menus
- G06F 3/04847: Interaction techniques to control parameter settings, e.g. interaction with sliders or dials
- G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N)
- G16H: HEALTHCARE INFORMATICS, i.e. INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR THE HANDLING OR PROCESSING OF MEDICAL OR HEALTHCARE DATA

## Abstract

An embodiment of the present invention migrates data between source and target systems. Retrieved source data is mapped to corresponding data elements of a data design for a computer implemented scenario on a target system. One or more of the data elements of the data design are stored on the target system in a format different than a format of the retrieved data. Filters and transformations are generated based on the mapping and data design, and the retrieved data are converted to the format of the target system. One or more from a group of the mapping, filters, and transformations is adjusted in response to detecting at least one from a group of modifications to the data design and non-conforming data received from the one or more source systems. The converted data is stored for the corresponding data elements on the target system for use by the computer implemented scenario.

## Claims

### Claim 1

A method of migrating data between source and target systems comprising:
retrieving data from one or more source systems;
mapping the retrieved data from the source systems to corresponding data elements of a data design for a computer implemented scenario on the target system, wherein one or more of the data elements of the data design are stored on the target system in a format different than a format of the retrieved data;
generating filters and transformations based on the mapping and data design and converting the retrieved data of the source systems to the format for storing the corresponding data elements on the target system;
adjusting one or more from a group of the mapping, filters, and transformations in response to detecting at least one from a group of modifications to the data design and non-conforming data received from the one or more source systems; and
storing the converted data for the corresponding data elements on the target system for use by the computer implemented scenario.

### Claim 2 (depends on 1)

The method of claim 1, further comprising:
generating and executing test cases to verify the generated filters and transformations and determine an amount of the retrieved data correctly converted for the corresponding data elements of the data design in the target system.

### Claim 3 (depends on 1)

The method of claim 1, further comprising:
transforming the data elements of the data design in the target system to a standard format used by one or more external systems and exporting the transformed data to the one or more external systems for processing.

### Claim 4 (depends on 3)

The method of claim 3, wherein the standard format includes one or more from a group of Clinical Data Interchange Standards Consortium Operational Data Model (CDISC ODM) and Clinical Data Interchange Standards Consortium Study Data Tabulation Model (CDISC SDTM).

### Claim 5 (depends on 1)

The method of claim 1, wherein mapping the retrieved data comprises:
mapping the retrieved data from the source systems to the corresponding data elements of the data design for the computer implemented scenario via a user interface.

### Claim 6 (depends on 5)

The method of claim 5, wherein the mapping is independent of the formats of the retrieved data and for storing the corresponding data elements on the target system.

### Claim 7 (depends on 1)

The method of claim 1, wherein the computer implemented scenario includes a medical clinical trial.

### Claim 8 (depends on 1)

The method of claim 1, further comprising:
detecting the modifications to the data design and the non-conforming data received from the one or more source systems in real-time; and
providing notifications of errors due to the detected modifications and non-conforming data.

### Claim 9

A computer program product for migrating data between source and target systems, the computer program product comprising a computer readable storage medium having program instructions embodied therewith, the program instructions executable by a processor to cause the processor to:
retrieve data from one or more source systems;
map the retrieved data from the source systems to corresponding data elements of a data design for a computer implemented scenario on the target system, wherein one or more of the data elements of the data design are stored on the target system in a format different than a format of the retrieved data;
generate filters and transformations based on the mapping and data design and convert the retrieved data of the source systems to the format for storing the corresponding data elements on the target system;
adjust one or more from a group of the mapping, filters, and transformations in response to detecting at least one from a group of modifications to the data design and non-conforming data received from the one or more source systems; and
store the converted data for the corresponding data elements on the target system for use by the computer implemented scenario.

### Claim 10 (depends on 9)

The computer program product of claim 9, wherein the program instructions are further configured to cause the processor to:
generate and execute test cases to verify the generated filters and transformations and determine an amount of the retrieved data correctly converted for the corresponding data elements of the data design in the target system.

### Claim 11 (depends on 9)

The computer program product of claim 9, wherein the program instructions are further configured to cause the processor to:
transform the data elements of the data design in the target system to a standard format used by one or more external systems and export the transformed data to the one or more external systems for processing.

### Claim 12 (depends on 11)

The computer program product of claim 11, wherein the standard format includes one or more from a group of Clinical Data Interchange Standards Consortium Operational Data Model (CDISC ODM) and Clinical Data Interchange Standards Consortium Study Data Tabulation Model (CDISC SDTM).

### Claim 13 (depends on 9)

The computer program product of claim 9, wherein mapping the retrieved data comprises:
mapping the retrieved data from the source systems to the corresponding data elements of the data design for the computer implemented scenario via a user interface.

### Claim 14 (depends on 13)

The computer program product of claim 13, wherein the mapping is independent of the formats of the retrieved data and for storing the corresponding data elements on the target system.

### Claim 15 (depends on 9)

The computer program product of claim 9, wherein the computer implemented scenario includes a medical clinical trial.

### Claim 16 (depends on 9)

The computer program product of claim 9, wherein the program instructions are further configured to cause the processor to:
detect the modifications to the data design and the non-conforming data received from the one or more source systems in real-time; and
provide notifications of errors due to the detected modifications and non-conforming data.

### Claim 17

A system for migrating data between source and target systems comprising:
at least one processor configured to:
retrieve data from one or more source systems;
map the retrieved data from the source systems to corresponding data elements of a data design for a computer implemented scenario on the target system, wherein one or more of the data elements of the data design are stored on the target system in a format different than a format of the retrieved data;
generate filters and transformations based on the mapping and data design and convert the retrieved data of the source systems to the format for storing the corresponding data elements on the target system;
adjust one or more from a group of the mapping, filters, and transformations in response to detecting at least one from a group of modifications to the data design and non-conforming data received from the one or more source systems; and
store the converted data for the corresponding data elements on the target system for use by the computer implemented scenario.

### Claim 18 (depends on 17)

The system of claim 17, wherein the at least one processor is further configured to:
generate and execute test cases to verify the generated filters and transformations and determine an amount of the retrieved data correctly converted for the corresponding data elements of the data design in the target system.

### Claim 19 (depends on 17)

The system of claim 17, wherein the computer implemented scenario includes a medical clinical trial, and the at least one processor is further configured to:
transform the data elements of the data design in the target system to a standard format used by one or more external systems and export the transformed data to the one or more external systems for processing, wherein the standard format includes one or more from a group of Clinical Data Interchange Standards Consortium Operational Data Model (CDISC ODM) and Clinical Data Interchange Standards Consortium Study Data Tabulation Model (CDISC SDTM).

### Claim 20 (depends on 17)

The system of claim 17, wherein the at least one processor is further configured to:
detect the modifications to the data design and the non-conforming data received from the one or more source systems in real-time; and
provide notifications of errors due to the detected modifications and non-conforming data.
