Relational database retrieval procedures for cohort-wise data comparisons

1. A method for generating a comparison data value for each attribute of interest for one or more attributes of interest associated with a population dataset comprising a plurality of records associated with a plurality of primary data groups, the method comprising:

importing, by one or more processors, the population dataset into a relational database environment;

executing, by the one or more processors, at least one structured query language (SQL) procedure within the relational database environment via a computing entity to aggregate the plurality of records into a plurality of attribute data items, wherein: (i) each attribute data item of the plurality of attribute data items (a) is associated with an attribute data item identifier, an associated aggregate data group of a plurality of aggregate data groups, and an associated primary data group of the plurality of primary data groups and (b) comprises an aggregate data value for each attribute of interest of the one or more attributes of interest, and (ii) each aggregate data value for a particular attribute of interest in a particular attribute data item is determined based at least in part on a subset of data values for the particular attribute of interest in the plurality of records of the population dataset that relate to the associated aggregate data group for the particular attribute data item and the associated primary data group for the particular attribute data item;

for each attribute data item of the plurality of attribute data items:

executing, by the one or more processors, the at least one SQL procedure within the relational database environment via the computing entity to generate a standardized data value for each attribute of interest of the one or more attributes of interest with respect to the attribute data item based at least in part on the aggregate data value for the attribute of interest;

executing, by the one or more processors, the at least one SQL procedure within the relational database environment via a computing entity to identify a cohort for the attribute data item based at least in part on the associated primary data group for the attribute data item, wherein the cohort comprises one or more peer primary data groups of the plurality of primary data groups for the attribute data item;

executing, by the one or more processors, the at least one SQL procedure within the relational database environment via the computing entity to generate a statistical data value for each attribute of interest of the one or more attributes of interest with respect to the cohort for the attribute data item, wherein at least one SQL procedure is configured to generate each statistical data value based at least in part on each standardized data value for one or more of the one or more peer primary data groups for the attribute data item; and

executing, by the one or more processors, the at least one SQL procedure within the relational database environment via the computing entity to generate the comparison data value for each attribute of interest of the one or more attributes of interest for with respect to the attribute data item, wherein the comparison data value represents a comparison between the standardized data value generated for the attribute of interest for the attribute data item and the statistical data value generated for the attribute of interest with respect to the cohort for the attribute data item; and

providing, by the one or more processors, a user interface for displaying via a user computing entity, wherein the user interface comprises, for each attribute data item of one or more of the plurality of attribute data items for an aggregate data group of the plurality of aggregate data groups, (i) the attribute data item identifier and (ii) the comparison data value for each attribute of interest of the one or more attributes of interest for each attribute data item.

2. The method of claim 1 , wherein: (i) the at least one SQL procedure is configured to generate the standardized data value for each attribute of interest of the one or more attributes of interest with respect to the attribute data item based at least in part on a selected primary group data value, and (ii) the selected primary group data value is selected from at least one standardized reference table hosted within the relational database environment based at least in part on the associated primary data group for the attribute data item.

3. The method of claim 1 , wherein: (i) the one or more peer primary data groups comprise a proper subset of the plurality of primary data groups that are deemed similar to the associated primary data group for the attribute data item, and (ii) the at least one SQL procedure is configured to identify the cohort by selecting the cohort from at least one cohort reference table hosted within the relational database environment based at least in part on the associated primary data group for the attribute data item.

4. The method of claim 1 further comprising, by the one or more processors and for each attribute data item of the plurality of attribute data items, executing the at least one SQL procedure within the relational database environment via the computing entity to generate a significance data value for each attribute of interest of the one or more attributes of interest, wherein:

the significance data value for an attribute of interest identifies an estimated magnitude of difference between the standardized data value generated for the attribute of interest for the attribute data item and the statistical data value generated for the attribute of interest for the attribute data item for the cohort, and

the user interface displays a user interface element for each attribute of interest of the one or more attributes of interest for each attribute data item of the plurality of attribute data items for the aggregate data group in which the significance data value comprises a certain data value.

5. The method of claim 4 , wherein the user interface element comprises at least one of a particular color for the attribute of interest indicating the significance data value or a graphical representation for the attribute of interest indicating the significant data value.

6. The method of claim 1 , further comprising, by the one or more processors and for each attribute data item of the plurality of attribute data items, executing the at least one SQL procedure within the relational database environment via the computing entity to generate a ranking for each attribute of interest of the one or more attributes of interest with respect to the attribute data item, wherein:

the ranking comprises two or more peer primary data groups associated with the cohort listed in an order based at least in part on the standardized data value for the attribute of interest for the attribute data item for each of the two or more peer primary data groups associated with the cohort, and

the user interface displays the ranking for each attribute of interest of the one or more attributes of interest for a particular attribute data item of the plurality of attribute data items in response to receiving a selection of the attribute data item identifier for the particular attribute data item by a user via the user interface.

7. The method of claim 6 , further comprising, by the one or more processors and for each attribute data item of the plurality of attribute data items, executing the at least one SQL procedure within the relational database environment via the computing entity to generate a population ranking for each attribute of interest of the one or more attributes of interest with respect to the attribute data item, wherein:

the population ranking for an attribute of interest with respect to an attribute data item describes an ordering of each primary data group in the plurality of primary data groups that is determined based at least in part on the standardized data value for the attribute of interest for the attribute data item for each primary data group of the plurality of primary data groups, and

the user interface displays the population ranking for each attribute of interest of the one or more attributes of interest for the particular attribute data item in response to receiving the selection of the attribute data item identifier for the particular attribute data item by the user via the user interface, and

the user interface displays one or more peer primary data groups associated with the cohort in the population ranking for each attribute of interest.

8. The method of claim 7 , wherein the user interface comprises (i) the comparison data value for each attribute of interest of the one or more attributes of interest for each attribute data item of the plurality of attribute data items for the aggregate data group, (ii) the ranking for each attribute of interest of the one or more attributes of interest for the particular attribute data item, and (iii) the population ranking for each attribute of interest of the one or more attributes of interest for the particular attribute data item on non-overlapping portions of the user interface.

9. The method of claim 1 , wherein the user interface comprises (i) each standardized data value as a selectable user interface element for an attribute of interest of the one or more attributes of interest for each attribute data item of the plurality of attribute data items for the aggregate data group and (ii) displays the aggregate data value for a particular attribute of interest of the one or more attributes of interest for a particular attribute data item in response to receiving a selection of the selectable user interface element for the standardized data value for the particular attribute of interest by a user via the user interface.

10. The method of claim 1 , wherein:

each primary data group of the plurality of primary data group describes a clinical commissioning group,

each aggregate data group of the plurality of aggregate data groups describes a group of medical conditions,

each attribute data item of the plurality of attribute data items comprises an individual medical condition associated with the group of medical conditions described by the associated aggregate data group that is associated with the attribute data item, and

the one or more attributes of interest comprise: a cost associated with the individual medical condition that is described by the attribute data item with respect to the clinical commissioning group that is described by the associated primary data group that is associated with the attribute data item and a number of patient activities associated with the individual medical condition that is described by the attribute data item with respect to the clinical commissioning group that is described by the associated primary data group that is associated with the attribute data item.

11. An apparatus for generating a comparison data value for each attribute of interest for one or more attributes of interest associated with a population dataset comprising a plurality of records associated with a plurality of primary data groups, the apparatus comprising at least one processor and at least one memory including a computer program code, the at least one memory and the computer program code configured to, with the at least one processor, cause the apparatus to:

import the population dataset into a relational database environment;

execute at least one structured query language (SQL) procedure within the relational database environment to aggregate the plurality of records into a plurality of attribute data items, wherein: (i) each attribute data item of the plurality of attribute data items (a) is associated with an attribute data item identifier, an associated aggregate data group of a plurality of aggregate data groups, and an associated primary data group of the plurality of primary data groups and (b) comprises an aggregate data value for each attribute of interest of the one or more attributes of interest, and (ii) each aggregate data value for a particular attribute of interest in a particular attribute data item is determined based at least in part on a subset of data values for the particular attribute of interest in the plurality of records of the population dataset that relate to the associated aggregate data group for the particular attribute data item and the associated primary data group for the particular attribute data item;

for each attribute data item of the plurality of attribute data items:

execute the at least one SQL procedure within the relational database environment to generate a standardized data value for each attribute of interest of the one or more attributes of interest with respect to the attribute data item based at least in part on the aggregate data value for the attribute of interest;

execute the at least one SQL procedure within the relational database environment to identify a cohort for the attribute data item based at least in part on the associated primary data group for the attribute data item, wherein the cohort comprises one or more peer primary data groups of the plurality of primary data groups for the attribute data item;

execute the at least one SQL procedure within the relational database environment to generate a statistical data value for each attribute of interest of the one or more attributes of interest with respect to the cohort for the attribute data item, wherein at least one SQL procedure is configured to generate each statistical data value based at least in part on each standardized data value for one or more of the one or more peer primary data groups for the attribute data item; and

execute the at least one SQL procedure within the relational database environment to generate the comparison data value for each attribute of interest of the one or more attributes of interest for with respect to the attribute data item, wherein the comparison data value represents a comparison between the standardized data value generated for the attribute of interest for the attribute data item and the statistical data value generated for the attribute of interest with respect to the cohort for the attribute data item; and

provide a user interface for displaying via a user computing entity, wherein the user interface comprises, for each attribute data item of one or more of the plurality of attribute data items for an aggregate data group of the plurality of aggregate data groups, (i) the attribute data item identifier and (ii) the comparison data value for each attribute of interest of the one or more attributes of interest for each attribute data item.

12. The apparatus of claim 11 , wherein: (i) the at least one SQL procedure is configured to generate the standardized data value for each attribute of interest of the one or more attributes of interest with respect to the attribute data item based at least in part on a selected primary group data value, and (ii) the selected primary group data value is selected from at least one standardized reference table hosted within the relational database environment based at least in part on the associated primary data group for the attribute data item.

13. The apparatus of claim 11 , wherein: (i) the one or more peer primary data groups comprise a proper subset of the plurality of primary data groups that are deemed similar to the associated primary data group for the attribute data item, and (ii) the at least one SQL procedure is configured to identify the cohort by selecting the cohort from at least one cohort reference table hosted within the relational database environment based at least in part on the associated primary data group for the attribute data item.

14. The apparatus of claim 11 , wherein, for each attribute data item of the plurality of attribute data items, the at least one memory and the computer program code are configured to, with the at least one processor, cause the apparatus to execute the at least one SQL procedure within the relational database environment to generate a significance data value for each attribute of interest of the one or more attributes of interest, in which:

the significance data value for an attribute of interest identifies an estimated magnitude of difference between the standardized data value generated for the attribute of interest for the attribute data item and the statistical data value generated for the attribute of interest for the attribute data item for the cohort, and

the user interface displays a user interface element for each attribute of interest of the one or more attributes of interest for each attribute data item of the plurality of attribute data items for the aggregate data group in which the significance data value comprises a certain data value.

15. The apparatus of claim 11 , wherein, for each attribute data item of the plurality of attribute data items, the at least one memory and the computer program code are configured to, with the at least one processor, cause the apparatus to execute the at least one SQL procedure within the relational database environment to generate a ranking for each attribute of interest of the one or more attributes of interest with respect to the attribute data item, in which:

the ranking comprises two or more peer primary data groups associated with the cohort listed in an order based at least in part on the standardized data value for the attribute of interest for the attribute data item for each of the two or more peer primary data groups associated with the cohort, and

the user interface displays the ranking for each attribute of interest of the one or more attributes of interest for a particular attribute data item of the plurality of attribute data items in response to receiving a selection of the attribute data item identifier for the particular attribute data item by a user via the user interface.

16. A non-transitory computer storage medium comprising instructions for generating a comparison data value for each attribute of interest for one or more attributes of interest associated with a population dataset comprising a plurality of records associated with a plurality of primary data groups, the instructions being configured to cause one or more processors to at least perform operations configured to:

import the population dataset into a relational database environment;

execute at least one structured query language (SQL) procedure within the relational database environment to aggregate the plurality of records into a plurality of attribute data items, wherein: (i) each attribute data item of the plurality of attribute data items (a) is associated with an attribute data item identifier, an associated aggregate data group of a plurality of aggregate data groups, and an associated primary data group of the plurality of primary data groups and (b) comprises an aggregate data value for each attribute of interest of the one or more attributes of interest, and (ii) each aggregate data value for a particular attribute of interest in a particular attribute data item is determined based at least in part on a subset of data values for the particular attribute of interest in the plurality of records of the population dataset that relate to the associated aggregate data group for the particular attribute data item and the associated primary data group for the particular attribute data item;

for each attribute data item of the plurality of attribute data items:

execute the at least one SQL procedure within the relational database environment to generate a standardized data value for each attribute of interest of the one or more attributes of interest with respect to the attribute data item based at least in part on the aggregate data value for the attribute of interest;

execute the at least one SQL procedure within the relational database environment to identify a cohort for the attribute data item based at least in part on the associated primary data group for the attribute data item, wherein the cohort comprises one or more peer primary data groups of the plurality of primary data groups for the attribute data item;

execute the at least one SQL procedure within the relational database environment to generate a statistical data value for each attribute of interest of the one or more attributes of interest with respect to the cohort for the attribute data item, wherein at least one SQL procedure is configured to generate each statistical data value based at least in part on each standardized data value for one or more of the one or more peer primary data groups for the attribute data item; and

execute the at least one SQL procedure within the relational database environment to generate the comparison data value for each attribute of interest of the one or more attributes of interest for with respect to the attribute data item, wherein the comparison data value represents a comparison between the standardized data value generated for the attribute of interest for the attribute data item and the statistical data value generated for the attribute of interest with respect to the cohort for the attribute data item; and

provide a user interface for displaying via a user computing entity, wherein the user interface comprises, for each attribute data item of one or more of the plurality of attribute data items for an aggregate data group of the plurality of aggregate data groups, (i) the attribute data item identifier and (ii) the comparison data value for each attribute of interest of the one or more attributes of interest for each attribute data item.

17. The non-transitory computer storage medium of claim 16 , wherein:

(i) the at least one SQL procedure is configured to generate the standardized data value for each attribute of interest of the one or more attributes of interest with respect to the attribute data item based at least in part on a selected primary group data value, and (ii) the selected primary group data value is selected from at least one standardized reference table hosted within the relational database environment based at least in part on the associated primary data group for the attribute data item.

18. The non-transitory computer storage medium of claim 16 , wherein: (i) the one or more peer primary data groups comprise a proper subset of the plurality of primary data groups that are deemed similar to the associated primary data group for the attribute data item, and (ii) the at least one SQL procedure is configured to identify the cohort by selecting the cohort from at least one cohort reference table hosted within the relational database environment based at least in part on the associated primary data group for the attribute data item.

19. The non-transitory computer storage medium of claim 16 , wherein, for each attribute data item of the plurality of attribute data items, the instructions are configured to cause the one or more processors to at least perform operations configured to execute the at least one SQL procedure within the relational database environment to generate a significance data value for each attribute of interest of the one or more attributes of interest, in which:

the significance data value for an attribute of interest identifies an estimated magnitude of difference between the standardized data value generated for the attribute of interest for the attribute data item and the statistical data value generated for the attribute of interest for the attribute data item for the cohort, and

the user interface displays a user interface element for each attribute of interest of the one or more attributes of interest for each attribute data item of the plurality of attribute data items for the aggregate data group in which the significance data value comprises a certain data value.

20. The non-transitory computer storage medium of claim 16 , wherein, for each attribute data item of the plurality of attribute data items, the instructions are configured to cause the one or more processors to at least perform operations configured to execute the at least one SQL procedure within the relational database environment to generate a ranking for each attribute of interest of the one or more attributes of interest with respect to the attribute data item, in which:

the ranking comprises two or more peer primary data groups associated with the cohort listed in an order based at least in part on the standardized data value for the attribute of interest for the attribute data item for each of the two or more peer primary data groups associated with the cohort, and

the user interface displays the ranking for each attribute of interest of the one or more attributes of interest for a particular attribute data item of the plurality of attribute data items in response to receiving a selection of the attribute data item identifier for the particular attribute data item by a user via the user interface.