System and Method for Semantic Normalization of Healthcare Data to Support Derivation Conformed Dimensions to Support Static and Aggregate Valuation Across Heterogeneous Data Sources

A data processing system comprising:

• a processor;
• a bus connected to the processor;
• a computer usable medium connected to the bus, wherein the computer usable medium contains a set of instructions for determining aggregate values of health data items from heterogeneously coded databases containing heterogeneously coded medical data, by a method comprising:
• a) querying the databases using a series of semantic layers using i) cascaded asymmetric association tables and ii) semantic search;
• b) translating the heterogeneously coded medical data items into conformal dimensions;
• c) deriving denominator files of combinations of disease data;
• and
• d) querying the denominator files of combinations of disease data to aggregate contents of the underlying heterogeneous data based on a mapping of the coded medical and demographic conditions.

A computer program product comprising a computer readable medium having computer usable program code for determining aggregate values of health data items from heterogeneously coded databases containing heterogeneously coded medical data, the computer program product including computer usable program code for

• a) querying the databases using a series of semantic layers using i) cascaded asymmetric association tables and ii) semantic search;
• b) translating the heterogeneously coded medical data items into conformal dimensions;
• c) deriving denominator files of combinations of disease data;
• and
• d) querying the denominator files of combinations of disease data to aggregate contents of the underlying heterogeneous data. based on a mapping of the coded medical and demographic conditions.