IP Library Granted Patent US 8,768,967
Granted Patent B2
US 8,768,967 · App. 13/779,641 · Granted Jul 1, 2014

Data export/import from multiple data sources to a destination data repository using corresponding data exporters and an importer

View Patent ↗
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 8,768,967
App. No.
13/779,641
Granted
Jul 1, 2014
Kind
B2
Abstract

Embodiments of the present invention provide methods and systems for exporting data from a number of data sources using a number of corresponding data exporters, and importing the exported data into a destination data repository using a data importer. In various embodiments, the data exporters may be automatically generated using a data exporter generator adapted to generate the data exporters in view of data schemas of the data sources.

Claims (44)

1. A system, comprising:

at least one memory storing computer-executable instructions; and

at least one processor configured to access the at least one memory and execute the computer-executable instructions to:

generate, using a data exporter generator, a data exporter for exporting data stored in a data source, wherein the at least one processor is configured to generate the data exporter by executing the computer-executable instructions to:

determine, using the data exporter generator, a data schema associated with the data source that provides a description of the data,

configure, using the data exporter generator and based at least in part on the data schema, a read interface, wherein the read interface enables the data exporter to read the data from the data source, and

configure, using the data exporter generator and based at least in part on the data schema, a validation block, wherein the validation block enables the data exporter to validate the data;

export, using the data exporter, the data stored in the data source; and

communicate the data to a data importer for importing into a destination data repository.

2. The system of claim 1 , wherein the validation block enables the data exporter to validate the data in-line or by invoking one or more supplemental validation routines.

3. The system of claim 1 , wherein the at least one processor is further configured to execute the computer-executable instructions to:

configure, using the data exporter generator and based at least in part on the data schema, a transformation block and one or more associated transformation rules, wherein the transformation block enables the data exporter to transform the data in accordance with the one or more transformation rules to generate transformed data.

4. The system of claim 3 , wherein the transformation block enables the data exporter to transform the data from a first format associated with the data schema to a second format associated with the destination data repository.

5. The system of claim 3 , wherein the at least one processor is further configured to execute the computer-executable instructions to:

generate, using the data exporter generator, a write interface, wherein the write interface enables the data importer to write the transformed data into the destination data repository.

6. The system of claim 1 , wherein the at least one processor is further configured to execute the computer-executable instructions to:

generate, using the data exporter generator, a plurality of additional data exporters associated with a plurality of additional data sources, wherein each additional data exporter is configured to export respective data stored in a respective one of the plurality of additional data sources, and wherein a respective additional data schema describes the respective data stored in each of the plurality of additional data sources.

7. The system of claim 1 , wherein the data comprises a plurality of data fields comprising:

i) one or more single-value fields each comprising a respective value, and

ii) one or more variable length fields each comprising a respective plurality of values.

8. The system of claim 7 , wherein one or more first-level delimiters delineate each data field of the plurality of data fields from each other data field of the plurality of data fields.

9. The system of claim 8 , wherein one or more second-level delimiters delineate each value of the respective plurality of values of a respective at least one of the one or more variable length fields from each other value of the respective plurality of values.

10. The system of claim 7 , wherein the data comprises a plurality of variable length fields, wherein two or more of the plurality of variable length fields form at least part of a multiple field set, and wherein an identifier associated with the multiple field set indicates a same number of values associated with each of the two or more variable length fields.

11. The system of claim 7 , wherein the destination data repository accommodates the one or more single-value fields and the one or more variable length fields.

12. The system of claim 1 , wherein the data source is a medical service provider demographic data source associated with one or more medical service providers.

13. The system of claim 12 , wherein the data schema supports specification of medical service subprovider hierarchies.

14. A system, comprising:

at least one processor; and

at least one memory storing:

a data exporter generator for generating a data exporter for exporting data stored data source;

the data exporter; and

a data importer,

wherein the data exporter generator comprises computer-executable instructions that, responsive to execution by the at least one processor, cause operations to be performed for generating the data exporter, the operations comprising:

determining a data schema associated with the data source that provides a description of the data,

generating a read interface based at least in part on the data schema, wherein the read interface enables the data to be read from the data source, and

generating a validation block based at least in part on the data schema, wherein the validation block enables validation of the data read from the data source,

wherein the data exporter comprises computer-executable instructions that, responsive to execution by the at least one processor, cause operations to be performed comprising:

exporting the data from the data source based at leas in part on the read interface, and

validating the read data based at least in part on the validation block, and

wherein the data importer comprises computer-executable instructions that, responsive to execution by the at least one processor, cause the data exported by the data exporter to be imported into a destination data repository.

15. The system of claim 14 , wherein the data exporter generator further comprises computer-executable instructions that, responsive to execution by the at least one processor, cause:

a transformation block and one or more associated transformation rules to be generated based at least in part on the data schema, wherein the transformation block enables transformation of the data in accordance with the one or more transformation rules to generate transformed data responsive to execution by the at least one processor of the computer-executable instructions of the data exporter.

16. The system of claim 15 , wherein the data exporter generator further comprises computer-executable instructions that, responsive to execution by the at least one processor, cause:

a write interface to be generated, wherein the write interface enables the transformed data to be written into the destination data repository responsive to execution by the at least one processor of the computer-executable instructions of the data importer.

Assignments (7)
RELEASE OF SECURITY INTEREST Recorded Oct 5, 2022
From: BANK OF AMERICA, N.A.
To: CHANGE HEALTHCARE RESOURCES, LLC (FORMERLY KNOWN AS ALTEGRA HEALTH OPERATING COMPANY LLC); CHANGE HEALTHCARE SOLUTIONS, LLC; CHANGE HEALTHCARE PERFORMANCE, INC. (FORMERLY KNOWN AS CHANGE HEALTHCARE, INC.); CHANGE HEALTHCARE OPERATIONS, LLC; CHANGE HEALTHCARE HOLDINGS, INC.; CHANGE HEALTHCARE TECHNOLOGIES, LLC (FORMERLY KNOWN AS MCKESSON TECHNOLOGIES LLC); CHANGE HEALTHCARE HOLDINGS, LLC
Reel/Frame 061620/0054 →
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Apr 23, 2018
From: CHANGE HEALTHCARE TECHNOLOGIES, LLC
To: CHANGE HEALTHCARE HOLDINGS, LLC
Reel/Frame 045613/0731 →
CHANGE OF NAME Recorded Apr 2, 2018
From: MCKESSON TECHNOLOGIES LLC
To: CHANGE HEALTHCARE TECHNOLOGIES, LLC
Reel/Frame 045766/0181 →
CHANGE OF NAME Recorded Mar 15, 2017
From: MCKESSON TECHNOLOGIES INC.
To: MCKESSON TECHNOLOGIES LLC
Reel/Frame 042020/0726 →
SECURITY AGREEMENT Recorded Mar 2, 2017
From: CHANGE HEALTHCARE HOLDINGS, LLC; CHANGE HEALTHCARE, INC.; CHANGE HEALTHCARE HOLDINGS, INC.; CHANGE HEALTHCARE OPERATIONS, LLC; CHANGE HEALTHCARE SOLUTIONS, LLC; ALTEGRA HEALTH OPERATING COMPANY LLC; MCKESSON TECHNOLOGIES LLC
To: BANK OF AMERICA, N.A., AS COLLATERAL AGENT
Reel/Frame 041858/0482 →
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Apr 14, 2014
From: ANANTHA, VIK S.
To: MCKESSON HEALTH SOLUTIONS LLC
Reel/Frame 032665/0753 →
MERGER Recorded Apr 9, 2014
From: MCKESSON HEALTH SOLUTIONS LLC
To: MCKESSON TECHNOLOGIES INC.
Reel/Frame 032635/0172 →