Patent Issued for Relational database retrieval procedures for cohort-wise data comparisons (USPTO 11789979): Optum Health Solutions (UK) Limited

2023 NOV 07 (NewsRx) -- By a News Reporter-Staff News Editor at Insurance Daily News -- Optum Health Solutions (UK) Limited (London, United Kingdom) has been issued patent number 11789979, according to news reporting originating out of Alexandria, Virginia, by NewsRx editors.

The patent’s inventor is Siddiq, Imran (Leicestershire, GB).

This patent was filed on June 6, 2022 and was published online on October 17, 2023.

From the background information supplied by the inventors, news correspondents obtained the following quote: “Embodiments of the present disclosure generally relate to processing large datasets in an efficient manner to facilitate performing statistical comparison analysis between members of a cohort.”

Supplementing the background information on this patent, NewsRx reporters also obtained the inventor’s summary information for this patent: “In general, embodiments of the present disclosure provide methods, apparatus, systems, computing devices, computing entities, and/or the like 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. In accordance with one aspect of the present disclosure, 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 is provided. In various embodiments, the method comprises: importing the population dataset into a database environment; executing at least one structured query language (SQL) procedure within the 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 the at least one SQL procedure within the 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 the at least one SQL procedure within the 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 the at least one SQL procedure within the 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 the at least one SQL procedure within the 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 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.

“In accordance with another aspect of the present disclosure, an apparatus is provided. In various embodiments, the apparatus comprises at least one processor and at least one memory comprising computer program code. The at least memory and the program code are configured to, with the at least one processor, cause the apparatus to: import the population dataset into a database environment; execute at least one structured query language (SQL) procedure within the 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 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 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 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 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.”

There is additional summary information. Please visit full patent to read further.

The claims supplied by the inventors are:

“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.

“2. The method of claim 1, wherein: (i) the at least one SQL procedure is configured to generate the standardized data value for the attribute 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 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 identity the cohort by selecting the cohort from at least one cohort reference table hosted within the 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, for the attribute data item, executing the at least one SQL procedure within the database environment to generate a significance data value for the attribute of interest, wherein: the significance data value for the attribute of interest identifies an estimated magnitude of difference between the standardized data value and the statistical data value, and the user interface is configured to display a user interface element for the attribute of interest 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, for the attribute data item, executing the at least one SQL procedure within the database environment to generate a ranking for the attribute of interest, 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 is configured to display the ranking for the attribute of interest for the attribute data item in response to receiving a selection of the attribute data item identifier for the attribute data item by a user via the user interface.

“7. The method of claim 6, further comprising, for the attribute data item, executing the at least one SQL procedure within the database environment to generate a population ranking for the attribute of interest with respect to the attribute data item, wherein: the population ranking for the 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 is configured to display the population ranking for the attribute of interest for the attribute data item in response to receiving the selection of the attribute data item identifier for the attribute data item by the user via the user interface, and the user interface is configured to display one or more peer primary data groups associated with the cohort in the population ranking for the attribute of interest.

“8. The method of claim 7, wherein the user interface comprises (i) the comparison data value for the attribute of interest, (ii) the ranking for the attribute of interest for the attribute data item, and (iii) the population ranking for the attribute of interest for the attribute data item on non-overlapping portions of the user interface.

“9. The method of claim 1, wherein the user interface (i) comprises each standardized data value as a selectable user interface element for the attribute of interest and (ii) is configured to display the aggregate data value for the attribute of interest for the 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 groups describes a clinical commissioning group, each aggregate data group of the plurality of aggregate data groups describes a group of medical conditions, the attribute data item 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.”

There are additional claims. Please visit full patent to read further.

For the URL and additional information on this patent, see: Siddiq, Imran. Relational database retrieval procedures for cohort-wise data comparisons. U.S. Patent Number 11789979, filed June 6, 2022, and published online on October 17, 2023. Patent URL (for desktop use only): https://ppubs.uspto.gov/pubwebapp/external.html?q=(11789979)&db=USPAT&type=ids

(Our reports deliver fact-based news of research and discoveries from around the world.)