Patent ID: 7792783
Filing Date: 2010-09-07
Classification: G06Q,G16H

Abstract:
1. A method of determining aggregate values of health data items from heterogeneously coded databases containing heterogeneously coded medical data, wherein the heterogeneously coded medical data comprises data from multiple medical trials, said method comprising: querying the heterogeneously coded databases using a series of semantic layers using i) cascaded asymmetric association tables and ii) semantic search, wherein the heterogeneously coded databases are derived from multiple data sources that each utilize a different type of operating system and a different type of computer system; translating the heterogeneously coded medical data into conformal dimensions by utilizing a rule set that defines a semantic conceptual mapping between a source attribute of source data and a target attribute of a target domain, wherein the rule set is implemented using metadata associated with the source data, wherein the metadata stores the rule set, wherein the metadata stores a time that the source data was last accessed, wherein the metadata identifies the source data and the target domain, and wherein a semantic conceptual construct is instantiated as a semantic conceptual mapping tool based on the rule set; deriving denominator files of combinations of disease data, wherein said denominator files of combinations of disease data are aggregated based on a mapping of coded medical conditions and demographic conditions of persons described in the databases; querying the denominator files of combinations of disease data to aggregate contents of underlying heterogeneous data from the multiple data sources; said semantic conceptual mapping tool utilizing said metadata to automatically establish multiple extract, transform and load protocols used in an extract, transform and load process, wherein the extract, transform and load process extracts data from the source data, transforms extracted data into a format utilized by the target domain, and loads transformed extracted data into the target domain; storing the semantic conceptual mapping in a repository; preventing movement of the source data to the target domain until the semantic conceptual mapping using said metadata is completed; said extract, transform and load process automatically producing a mathematical mean, mode and standard deviation that describe data in the target domain; and maintaining appropriate privacy through usage of asymmetric associations between the source data and the target domain.