US 11,789,979 B2
Relational database retrieval procedures for cohort-wise data comparisons
Imran Siddiq, Leicestershire (GB)
Assigned to Optum Health Solutions (UK) Limited, London (GB)
Filed by Optum Health Solutions (UK) Limited, London (GB)
Filed on Jun. 6, 2022, as Appl. No. 17/805,501.
Application 17/805,501 is a continuation of application No. 17/072,546, filed on Oct. 16, 2020, granted, now 11,372,892.
Claims priority of provisional application 62/916,299, filed on Oct. 17, 2019.
Prior Publication US 2022/0300535 A1, Sep. 22, 2022
This patent is subject to a terminal disclaimer.
Int. Cl. G06F 16/28 (2019.01); G06F 16/242 (2019.01); G06F 16/2457 (2019.01); G06F 16/22 (2019.01); G06F 16/2455 (2019.01)
CPC G06F 16/284 (2019.01) [G06F 16/2282 (2019.01); G06F 16/244 (2019.01); G06F 16/24553 (2019.01); G06F 16/24578 (2019.01)] 20 Claims
OG exemplary drawing
 
1. A computer-implemented method comprising:
executing, by one or more processors, at least one structured query language (SQL) procedure within a database environment to aggregate a plurality of records associated with a plurality of primary data groups into a plurality of attribute data items, wherein: (i) an attribute data item of the plurality of attribute data items (a) is associated with at least one of an attribute data item identifier, an associated aggregate data group of a plurality of aggregate data groups, or an associated primary data group of the plurality of primary data groups and (b) comprises an aggregate data value for an attribute of interest of one or more attributes of interest, and (ii) the aggregate data value for the attribute of interest in the attribute data item is determined based at least in part on a subset of data values for the attribute of interest in the plurality of records of a population dataset that relate to the associated aggregate data group for the attribute data item and the associated primary data group for the attribute data item;
for the attribute data item:
executing, by the one or more processors, the at least one SQL procedure within the database environment to generate a standardized data value for the attribute 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 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;
executing, by the one or more processors, the at least one SQL procedure within the database environment to generate a statistical data value for the attribute of interest with respect to the cohort for the attribute data item, wherein the at least one SQL procedure is configured to generate the statistical data value based at least in part on the 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 database environment to generate a comparison data value for the attribute of interest 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 configured for display via a user computing entity, wherein the user interface comprises, for the attribute data item, (i) the attribute data item identifier and (ii) the comparison data value for the attribute of interest.