IP Library Patent Application 13607100
Patent Application
App. No. 13/607,100

Systems and Methods for Data Integration and Standardization

Loading inventors, assignments & file history…
Monitor This Case
Get email alerts when status or documents change.
Order Certified Copies
Most orders are placed with the USPTO same day — all within 24 business hours.
Order via The Patent Place →
Pre-filled with this patent's details
Quick Facts
Patent No.
US None
App. No.
13/607,100
Abstract

Systems and methods for data integration and standardization are disclosed. For example, one disclosed method comprises receiving first and second clinical trial data from first and second data stores, transforming the first clinical trial data and the second clinical trial data into operational data formats and storing the transformed data in a second operational data store; generating a first data entity stored in an integrated data format in an integrated data store; selecting a first data record from first clinical trial data in the first operational data format; identifying a second data record from the second clinical trial data in the second operational data format, wherein identifying the second data record is based at least in part on a determined association between the first data record and the second data record; and storing data from the first data record and the second data record in the first data entity.

Claims (50)

1 . A method comprising:

receiving first clinical trial data from a first data store, the first clinical trial data stored in a first format and comprising a plurality of data records;

receiving second clinical trial data from a second data store, the second data store different from the first data store, the second clinical trial data stored in a second format, the second format different from the first format and comprising a plurality of data records;

transforming the first clinical trial data from the first format to a first operational data format and storing the first clinical trial data in the first operational data format in a first operational data store;

transforming the second clinical trial data from the second format to a second operational data format and storing the second clinical trial data in the second operational data format in a second operational data store;

generating a first data entity stored in an integrated data format in an integrated data store;

selecting a first data record from first clinical trial data in the first operational data format;

identifying a second data record from the second clinical trial data in the second operational data format, wherein identifying the second data record is based at least in part on a determined association between the first data record and the second data record; and

storing data from the first data record and the second data record in the first data entity.

2 . The method of claim 1 , further comprising:

receiving the first remote clinical trial data from a first remote data store, the first remote clinical trial data stored in a first remote format;

receiving the second remote clinical trial data from a second remote data store, the second remote clinical trial data stored in a second remote format;

transforming the first remote clinical trial data from the first remote format to the first clinical trial data in the first format; and

transforming the second remote clinical trial data from the second remote format to the second clinical trial data in the second format.

3 . The method of claim 2 , wherein at least one of the first remote clinical trial data or the second remote clinical trial data is received in real-time.

4 . The method of claim 1 , wherein the receiving of the first and second clinical trial data occurs in real-time.

5 . The method of claim 4 , wherein the steps of transforming the first and second clinical trial data, generating the first data entity, selecting the first data record, identifying the second data record, and storing data occurs in real-time after receiving the first and second clinical trial data.

6 . The method of claim 1 , further comprising receiving a mapping specification, and wherein identifying the second data record is further based at least in part on the mapping specification.

7 . The method of claim 6 , wherein storing data from the first data record and the second data record in the first data entity comprises converting at least some of the data from the first data record and the second data record into the integrated data format based at least in part on the mapping specification.

8 . The method of claim 1 , wherein generating the first entity comprises identifying an existing entity in the integrated data store.

9 . A computer-readable medium comprising program code for causing a processor to execute a method, the program code comprising:

program code for receiving first clinical trial data from a first data store, the first clinical trial data stored in a first format and comprising a plurality of data records;

program code for receiving second clinical trial data from a second data store, the second data store different from the first data store, the second clinical trial data stored in a second format, the second format different from the first format and comprising a plurality of data records;

program code for transforming the first clinical trial data from the first format to a first operational data format and storing the first clinical trial data in the first operational data format in a first operational data store;

program code for transforming the second clinical trial data from the second format to a second operational data format and storing the second clinical trial data in the second operational data format in a second operational data store;

program code for generating a first data entity stored in an integrated data format in an integrated data store;

program code for selecting a first data record from first clinical trial data in the first operational data format;

program code for identifying a second data record from the second clinical trial data in the second operational data format, wherein identifying the second data record is based at least in part on a determined association between the first data record and the second data record; and

program code for storing data from the first data record and the second data record in the first data entity.

10 . The computer-readable medium of claim 9 , further comprising:

program code for receiving the first remote clinical trial data from a first remote data store, the first remote clinical trial data stored in a first remote format;

program code for receiving the second remote clinical trial data from a second remote data store, the second remote clinical trial data stored in a second remote format;

program code for transforming the first remote clinical trial data from the first remote format to the first clinical trial data in the first format; and

program code for transforming the second remote clinical trial data from the second remote format to the second clinical trial data in the second format.

11 . The computer-readable medium of claim 10 , wherein at least one of the first remote clinical trial data or the second remote clinical trial data is received in real-time.

12 . The computer-readable medium of claim 9 , wherein the receiving of the first and second clinical trial data occurs in real-time.

13 . The computer-readable medium of claim 12 , wherein the steps of transforming the first and second clinical trial data, generating the first data entity, selecting the first data record, identifying the second data record, and storing data occurs in real-time after receiving the first and second clinical trial data.

14 . The computer-readable medium of claim 9 , further comprising program code for receiving a mapping specification, and wherein the program code for identifying the second data record is further based at least in part on the mapping specification.

15 . The computer-readable medium of claim 14 , further comprising a mapping tool, the mapping tool configured to generate the mapping specification.

16 . The computer-readable medium of claim 14 , wherein the program code for storing data from the first data record and the second data record in the first data entity comprises program code for converting at least some of the data from the first data record and the second data record into the integrated data format based at least in part on the mapping specification.

17 . The computer-readable medium of claim 9 , wherein the program code for generating the first entity comprises program code for identifying an existing entity in the integrated data store.

18 . A system comprising:

a system interface comprising at least one processor in communication with a computer readable medium, the system interface configured to receive data from one or more source systems;

at least one staging database, the staging database comprising a computer readable medium configured to store one or more data records according to data formats of the one or more source systems;

a data processing layer comprising at least one processor in communication with a computer readable medium, the data processing layer configured to receive the one or more data records from the at least one staging database and to transform the one or more data records into one or more operational data formats;

at least one operational database, the staging database comprising a computer readable medium configured to store one or more data records according to the one or more operational data formats;

a data integration layer comprising at least one processor in communication with a computer readable medium, the data integration layer configured to receive the one or more data records from the at least one operational database and to generate or update one or more data entities based on the one or more data records from the at least one operational database; and

an integrated data store, the integrated data store configured to receive and store the one or more data entities from the data integration layer.

19 . The system of claim 18 , wherein the data integration layer is further configured to receive at least one mapping schema, and to generate the one or more data entities based at least in part on the at least one mapping schema.

20 . The system of claim 18 , wherein the integrated data store is further configured to receive and store at least one mapping schema.

Assignments (3)
RELEASE OF SECURITY INTEREST Recorded May 13, 2015
From: JPMORGAN CHASE BANK, N.A.
To: QUINTILES TRANSNATIONAL CORP.; TARGETED MOLECULAR DIAGNOSTICS, LLC; QUINTILES, INC.; OUTCOME SCIENCES, INC.; EXPRESSION ANALYSIS, INC.; ENCORE HEALTH RESOURCES, LLC
Reel/Frame 035655/0392 →
SECURITY AGREEMENT Recorded Feb 20, 2013
From: QUINTILES TRANSNATIONAL CORP.; EXPRESSION ANALYSIS, INC.; OUTCOME SCIENCES, INC.; TARGETED MOLECULAR DIAGNOSTICS, LLC
To: JPMORGAN CHASE BANK, N.A., AS ADMINISTRATIVE AGENT
Reel/Frame 029839/0054 →
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Dec 4, 2012
From: CLAYTON, TIMOTHY B.; GORTON, MARK; GRUNDSTROM, THOMAS; JAIN, ANKUR
To: QUINTILES TRANSNATIONAL CORPORATION
Reel/Frame 029400/0657 →