US Patent 11372892 Relational database retrieval procedures for cohort-wise data comparisons

Embodiments of the present disclosure provide methods, apparatus, systems, computing devices, and computing entities for generating a comparison data value for each attribute of interest for one or more attributes of interest associated with a dataset. In one embodiment, a method is provided comprising: importing the dataset into a database environment; executing a SQL procedure to aggregate records in the dataset into attribute data items, wherein each item comprises an aggregate data value for each attribute of interest; and for each item: executing the SQL procedure to (1) generate a standardized data value for each attribute of interest based on the aggregate data value; (2) identify a cohort; (3) generate a statistical data value for each attribute of interest with respect to the cohort; and (4) generate the comparison data value for each attribute of interest based on a comparison between the standardized data value and the statistical data value.