Methods for relating data in healthcare databases
View Patent ↗Methods, systems and computer program products for relating facts stored in healthcare databases are provided. At least two fact tables stored in a healthcare database including data meeting a criteria of interest are located. An identification key is assigned to the at least two fact tables including the located data meeting the criteria of interest. The identification key provides access to a dimension table including a list of subjects associated with the at least two fact tables including the located data meeting the criteria of interest so as to allow future identification of the subjects meeting the criteria of interest.
1. 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.
2. The method of claim 1 , wherein assigning said third identification key comprises automatically assigning a third identification key.
3. The method of claim 1 , wherein the located data is associated with a medical study, the method further comprising normalizing the data associated with the medical study so as to allow direct comparison of the data.
4. The method of claim 1 , wherein locating is preceded by generating a database including a plurality of fact tables and a plurality of associated dimension tables.
5. The method of claim 4 , wherein the plurality of fact tables are divided into a plurality of groups of fact tables and wherein each of the plurality of groups are associated with an entity, the method further comprising providing authorization codes to each entity, the authorization codes providing access to at least one of the groups of fact tables.
6. The method of claim 4 , wherein the plurality of fact tables include at least one identification key which identifies an associated dimension table, wherein the associated dimension table includes information that further describe facts provided in the fact table and wherein the plurality of fact tables are related through the plurality of dimension tables.