Patent ID: 7580922

Claim:
A computer implemented method of relating facts stored in healthcare databases, comprising: locating data meeting a same, first criteria of interest in at least two fact tables stored in a healthcare database; assigning a same, first identification key to each one of the at least two fact tables including the located data meeting the first criteria of interest, the first identification key providing direct access to a unique, first dimension table associated with the first identification key and the first dimension table including a list of subjects associated with the at least two fact tables including the located data meeting the first criteria of interest to allow future identification of the subjects meeting the first criteria of interest through the unique, first dimension table; locating data meeting a second criteria of interest in at least two fact tables stored in the healthcare database; assigning a second identification key to the at least two fact tables including the located data meeting the second criteria of interest, the second identification key providing access to a second dimension table including a list of subjects associated with the at least two fact tables including the second criteria of interest so as to allow future identification of the subjects meeting the second criteria of interest; and assigning a third identification key to subjects meeting the first and second criterion of interest, the third identification key providing access to a third dimension table including a list of subjects meeting both the first and second criterion of interest so as to allow future identification of the subjects meeting the first and second criterion of interest.