COHORT IDENTIFICATION SYSTEM

• US 20140122099A1
• Filed: 03/08/2013
• Published: 05/01/2014
• Est. Priority Date: 10/31/2012
• Status: Abandoned Application

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle International Corporation (Oracle Corporation)
• Inventors: TRIEBEL, William Andrew
• Application Number:
  US13/790,252
• Publication Number:
  US 20140122099A1
• Time in Patent Office: Days
• US Class Current: 705/2
• CPC Class Codes: G06F 16/245 Query processing
• CPC Class Codes: G06F 16/24573 using data annotations, e.g. user-defined metadata
• 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
• CPC Class Codes: G16H 50/70 for mining of medical data, e.g. analysing previous cases of other patients
• CPC Class Codes: G16H 70/40 relating to drugs, e.g. their side effects or intended usage

Abstract

A system is provided that identifies a cohort. The system retrieves metadata that includes information about one or more data fields of a data source. The system further creates a query for the data source based on the retrieved metadata. The system further compiles the query and executes the query on the data source. By executing the query on the data source, the system creates a case series. The system further generates a report based on the case series.

Claims

1. A computer-readable medium having instructions stored thereon that, when executed by a processor, cause the processor to identify a cohort, the identifying comprising:

retrieving metadata that comprises information about one or more data fields of a data source, wherein the information comprises a data type and structured query language information for each data field of the one or more data fields;

creating a query for the data source based on the retrieved metadata;

compiling the query based on one or more compiler rules;

executing the query on the data source, wherein the executing of the query creates a case series; and

generating a report based on the case series, wherein the report comprises a visualization of the case series.

2. The computer-readable medium of claim 1, the identifying further comprising storing the query in a query repository.

3. The computer-readable medium of claim 1, the identifying further comprising storing the case series in a case series repository.

4. The computer-readable medium of claim 3, the identifying further comprising retrieving the case series from the case series repository using a reporting case series application programming interface, wherein the reporting case series application programming interface defines a format of the case series for a reporting software application.

5. The computer-readable medium of claim 4, the identifying further comprising displaying the report within the reporting software application.

6. The computer-readable medium of claim 3, the identifying further comprising retrieving the case series from the case series repository using an interoperable case series application programming interface, wherein the interoperable case series application programming interface defines a format of the case series for a partner software application.

7. The computer-readable medium of claim 6, the identifying further comprising consuming the case series within the partner software application.

8. The computer-readable medium of claim 1, wherein the case series comprises one or more adverse event cases, and wherein each adverse event case comprises a data record that represents an adverse event.

9. The computer-readable medium of claim 1, wherein the data source comprises an adverse event report database.

10. The computer-readable medium of claim 1, wherein the case series comprises one or more reports or patient identifiers that are related to the safety of one or more drugs.

11. A computer-implemented method for identifying a cohort, the computer-implemented method comprising:

retrieving metadata that comprises information about one or more data fields of a data source, wherein the information comprises a data type and structured query language information for each data field of the one or more data fields;

creating a query for the data source based on the retrieved metadata;

compiling the query based on one or more compiler rules;

executing the query on the data source, wherein the executing of the query creates a case series; and

generating a report based on the case series, wherein the report comprises a visualization of the case series.

12. The computer-implemented method of claim 11, further comprising storing the query in a query repository.

13. The computer-implemented method of claim 11, further comprising storing the case series in a case series repository.

14. The computer-implemented method of claim 13 further comprising:

retrieving the case series from the case series repository using a reporting case series application programming interface, wherein the reporting case series application programming interface defines a format of the case series for a reporting software application; and

displaying the report within the reporting software application.

15. The computer-implemented method of claim 13, further comprising:

retrieving the case series from the case series repository using an interoperable case series application programming interface, wherein the interoperable case series application programming interface defines a format of the case series for a partner software application; and

consuming the case series within the partner software application.

16. A system for identifying a cohort, the system comprising:

a processor;

a memory configured to store one or more instructions;

a metadata retrieval module configured to retrieve metadata that comprises information about one or more data fields of a data source, wherein the information comprises a data type and structured query language information for each data field of the one or more data fields;

a query creation module configured to create a query for the data source based on the retrieved metadata;

a query compilation module configured to compile the query based on one or more compiler rules;

a query execution module configured to execute the query on the data source, wherein the executing of the query creates a case series; and

a report generation module configured to generate a report based on the case series, wherein the report comprises a visualization of the case series.

17. The system of claim 16, further comprising a query storage module configured to store the query in a query repository.

18. The system of claim 16, further comprising a case series storage module configured to store the case series in a case series repository.

19. The system of claim 18, further comprising:

a case series retrieval module configured to retrieve the case series from the case series repository using a reporting case series application programming interface, wherein the reporting case series application programming interface defines a format of the case series for a reporting software application; and

a display module configured to display the report within the reporting software application.

20. The system of claim 18, further comprising:

a case series retrieval module configured to retrieve the case series from the case series repository using an interoperable case series application programming interface, wherein the interoperable case series application programming interface defines a format of the case series for a partner software application; and

a consumption module configured to consume the case series within the partner software application.