CENTRALIZED DATA MAPPING FOR SITE-SPECIFIC DATA EXTRACTION

• US 20110047176A1
• Filed: 08/20/2010
• Published: 02/24/2011
• Est. Priority Date: 08/21/2009
• Status: Abandoned Application

• Current Assignee: Cerner Innovation, Inc. (Oracle Corporation)
• Original Assignee: Cerner Innovation, Inc. (Oracle Corporation)
• Inventors: HOFFMAN, MARK A.
• Application Number:
  US12/860,646
• Publication Number:
  US 20110047176A1
• Time in Patent Office: Days
• US Class Current: 707/769
• CPC Class Codes: G06F 16/24556 Aggregation; Duplicate elimination
• CPC Class Codes: G06F 16/24573 using data annotations, e.g. user-defined metadata
• CPC Class Codes: G16H 40/67 for remote operation
• CPC Class Codes: G16H 50/20 for computer-aided diagnosis, e.g. based on medical expert systems
• CPC Class Codes: G16H 50/80 for detecting, monitoring or modelling epidemics or pandemics, e.g. flu
• CPC Class Codes: Y02A 90/10 Information and communication technologies [ICT] supporting adaptation to climate change, e.g. for weather forecasting or climate simulation

Abstract

Methods, systems, and computer storage media are provided for tuning extraction scripts to extract particular summary data from site systems. Categories of summary data are determined based on the summary data desired to be retrieved. Site-specific codes that correspond to the categories are received and are mapped to standard codes to provide a common nomenclature. Extraction scripts are tuned and are executed by a site system to query for summary data. The extraction scripts identify the site-specific codes associated with the summary data to be retrieved. Summary data is received in response to the execution of the extraction scripts, and the data is formatted for presentation.

Claims

1. One or more computer storage media storing computer-useable instructions that, when used by one or more computing devices, cause the one or more computing devices to perform a method comprising:

determining one or more categories of summary data associated with the summary data that is to be retrieved;

receiving site-specific codes that correspond to the one or more categories of summary data;

mapping the site-specific codes to a set of standard codes;

receiving the summary data from a site system in response to execution of a set of one or more extraction scripts on the site system, wherein the set of one or more extraction scripts identifies the site-specific codes that correspond to the one or more categories of the summary data; and

utilizing the mapping to format the summary data for presentation.

2. The media of claim 1, further comprising:

receiving a request from the site system for the site-specific codes that are to be identified in the set of one or more extraction scripts; and

communicating the site-specific codes that are to be identified in the set of one or more extraction scripts.

3. The media of claim 1, further comprising:

determining that additional summary data is to be retrieved; and

communicating additional site-specific codes associated with the additional summary data to the site system.

4. The media of claim 1, wherein mapping the site-specific codes to the set of standard codes further comprises:

associating each of the site-specific codes with the standard code, wherein both the site-specific code and the associated standard code represent a similar category of the summary data; and

storing the association of the site-specific codes and the standard codes in a database.

5. The media of claim 1, wherein the summary data, once formatted, is accessible to various sites that have provided the summary data and to other third parties.

6. The media of claim 5, wherein a particular site from which the summary data is received is provided access to the summary data received from other sites.

7. The media of claim 1, wherein a site identifier is received with the summary data so that the site system from which the summary data has been communicated can be identified.

8. The media of claim 1, wherein the received summary data is communicated in association with the respective site-specific codes.

9. One or more computer storage media storing computer-useable instructions that, when used by one or more computing devices, cause the one or more computing devices to perform a method comprising:

receiving a request for site-specific codes that correspond to one or more categories of summary data;

providing the site-specific codes, wherein the site-specific codes are provided to a central system that maps the site-specific codes to standard codes;

querying a central system to determine a subset of the site-specific codes to be identified in a set of one or more extraction scripts, wherein when executed, the set of one or more extraction scripts extracts the summary data associated with the identified site-specific codes;

receiving an indication of subset of the site-specific codes to be identified in the set of one or more extraction scripts; and

based on the received site-specific codes, tuning the set of one or more extraction scripts to identify the subset of the site-specific codes;

executing the set of one or more extraction scripts to extract the summary data; and

communicating the extracted summary data.

10. The media of claim 9, further comprising receiving additional site-specific codes associated with additional categories of summary data.

11. The media of claim 10, further comprising incorporating the additional site-specific codes into the set of one or more extraction scripts such that when executed, the set of one or more extraction scripts will extract the summary data associated with the additional categories.

12. The media of claim 9, further comprising encrypting the extracted summary data prior to its communication to a central system.

13. The media of claim 9, wherein the set of one or more extraction scripts is executed by a site system and is stored in a site database.

14. The media of claim 13, wherein the extracted summary data comprises a portion of a total amount of the summary data stored in the site database.

15. The media of claim 9, wherein the summary data is extracted from electronic medical records.

16. The media of claim 9, further comprising receiving the set of one or more extraction scripts.

17. A system for extracting summary data, the system comprising:

a web service that receives requests from site systems and in response to the requests provides the site systems with one or more site-specific codes that correspond to categories of the summary data to be extracted from the site systems,

wherein upon receiving the one or more site-specific codes, the site systems tune a set of one or more extraction scripts prior to its execution so that the extraction scripts identify the one or more site-specific codes that correspond to the categories of the summary data that to be retrieved, and

wherein the web service further maps each of the one or more site-specific codes to a standard code;

an aggregator that receives the summary data extracted from the site systems and that assembles and formats the summary data for presentation; and

a central database that stores the summary data received from the site.

18. The system of claim 17, wherein mapping each of the one or more site-specific codes to the standard code further comprises:

associating each of the one or more site-specific codes with the standard code, wherein both the site-specific code and the associated standard code represent a similar category of the summary data; and

storing the association of the site-specific codes and the standard codes in the central database.

19. The system of claim 17, wherein the categories of summary data correspond to one or more of a healthcare order, a clinical event, or a diagnosis.

20. The system of claim 18, wherein the aggregator, upon receiving the summary data, utilizes the mapping of the site-specific codes and the standard codes to determine the category to which the summary data corresponds.