Apparatus, system and method for rapid cohort analysis
An apparatus, system, and method for rapid cohort analysis. In one embodiment, the apparatus includes an interface and a processor. The interface may receive an identifier of a first index attribute. The processor may search the database for a first group of records associated with the first index attribute, search the database for a second group of records, each record in the second group of records sharing a common second index attribute with a record in the first group of records, but not associated with the first index attribute, and calculate a statistic in response to information associated with the first group of records and the second group of records.
1. An apparatus, comprising:
an interface configured to receive an identifier of a first index attribute and a second index attribute; and
a processor in data communication with the interface, the processor configured to:
search the database for a first group of healthcare records associated with the first index attribute;
assign a first distinguishing identifier to each healthcare record in a subset of the first group of healthcare records in response to a determination that the subset of healthcare records have a common value of a second index attribute;
search the database for a second group of cohort healthcare records, wherein each cohort healthcare record in the second group of cohort healthcare records shares a common second index attribute with a healthcare record in the first group of healthcare records, but not associated with the first index attribute;
assign a second distinguishing identifier to each cohort record in the second group of cohort healthcare records that corresponds to the first distinguishing identifier assigned to a healthcare record in the subset of the first group of healthcare records; and
calculate a statistic in response to healthcare information associated with the first group of healthcare records and the second group of cohort healthcare records based on the assigned first and second identifiers, wherein the statistic comprises a probability of an attribute shared between a diagnosis for a person represented by a healthcare record in the second group and a diagnosis for a person represented by a healthcare record in the first group.
2. A system, comprising:
a data storage device configured to store a healthcare database comprising one or more healthcare records, each healthcare record having one or more attributes; and
a server in data communication with the data storage device, configured to:
receive an identifier of a first index attribute and a second index attribute;
search the database for a first group of healthcare records associated with the first index attribute;
assign a first distinguishing identifier to each healthcare record in a subset of the first group of healthcare records in response to a determination that the subset of healthcare records have a common value of a second index attribute;
search the database for a second group of cohort healthcare records, wherein each cohort healthcare record in the second group of cohort healthcare records shares a common second index attribute with a healthcare record in the first group of healthcare records, but not associated with the first index attribute; and
calculate a statistic in response to healthcare information associated with the first group of healthcare records and the second group of cohort healthcare records based on the assigned first and second identifiers, wherein the statistic comprises a probability of an attribute shared between a diagnosis for a person represented by a healthcare record in the second group and a diagnosis for a person represented by a healthcare record in the first group.
3. The system of claim 2 , where the server is further configured to narrow the first group of healthcare records according to a limiting criterion.
4. The system of claim 2 , where the server is further configured to count distinct healthcare records in the first group of healthcare records and the second group of healthcare records.
5. The system of claim 2 , where the server is further configured to aggregate healthcare records from the first group and from the second group according to a selected attribute.
6. The system of claim 5 , where the server is further configured to compute a probability in response to a ratio of a number of healthcare records in the first group having the selected attribute and a number of healthcare records in the second group having the selected attribute.
7. A computer program product, comprising a non-transitory computer readable medium having computer usable program code executable to perform operations comprising:
receiving an identifier of a first index attribute and a second index attribute;
searching a database for a first group of healthcare records associated with the first index attribute;
assigning a first distinguishing identifier to each healthcare record in a subset of the first group of healthcare records in response to a determination that the subset of healthcare records have a common value of a second index attribute;
searching the database for a second group of cohort healthcare records, wherein each cohort healthcare record in the second group of cohort healthcare records shares a common second index attribute with a healthcare record in the first group of healthcare records, but not associated with the first index attribute;
assigning a second distinguishing identifier to each cohort record in the second group of cohort healthcare records that corresponds to the first distinguishing identifier assigned to a healthcare record in the subset of the first group of healthcare records; and
calculating a statistic in response to healthcare information associated with the first group of healthcare records and the second group of healthcare records based on the assigned first and second identifiers, wherein the step of calculating the statistic comprises calculating a probability of an attribute shared between a diagnosis for a person represented by a healthcare record in the second group and a diagnosis for a person represented by a healthcare record in the first group.
8. The computer program product of claim 7 , wherein the code also performs the operation of narrowing the first group of healthcare records according to a limiting criterion.
9. The computer program product of claim 7 , wherein calculating the statistic further comprises counting distinct healthcare records in the first group of healthcare records and the second group of healthcare records.
10. The computer program product of claim 7 , wherein calculating the statistic further comprises aggregating healthcare records from the first group and from the second group according to a selected attribute.
11. The computer program product of claim 10 , wherein calculating the statistic further comprises computing a probability in response to a ratio of a number of healthcare records in the first group having the selected attribute and a number of healthcare records in the second group having the selected attribute.
12. A method, comprising:
receiving an identifier of a first index attribute and a second index attribute;
searching a database for a first group of healthcare records associated with the first index attribute;
assigning a first distinguishing identifier to each healthcare record in a subset of the first group of healthcare records in response to a determination that the subset of healthcare records have a common value of a second index attribute;
searching the database for a second group of cohort healthcare records, wherein each cohort healthcare record in the second group of cohort healthcare records shares a common second index attribute with a healthcare record in the first group of healthcare records, but not associated with the first index attribute;
assigning a second distinguishing identifier to each cohort record in the second group of cohort healthcare records that corresponds to the first distinguishing identifier assigned to a healthcare record in the subset of the first group of healthcare records; and
calculating a statistic in response to healthcare information associated with the first group of healthcare records and the second group of cohort healthcare records based on the assigned first and second identifiers, wherein calculating a statistic comprises a probability of an attribute shared between a diagnosis for a person represented by a healthcare record in the second group and a diagnosis for a person represented by a healthcare record in the first group.
13. The method of claim 12 , further comprising narrowing the first group of healthcare records according to a limiting criterion.
14. The method of claim 12 , wherein calculating the statistic further comprises counting distinct healthcare records in the first group of healthcare records and the second group of healthcare records.
15. The method of claim 12 , wherein calculating the statistic further comprises aggregating healthcare records from the first group and from the second group according to a selected attribute.
16. The method of claim 15 , wherein calculating the statistic further comprises computing a probability in response to a ratio of a number of healthcare records in the first group having the selected attribute and a number of healthcare records in the second group having the selected attribute.