Health Care Dimensional Modelling
Page 1 of 1
Health Care Dimensional Modelling
Hi,
I am working on Health care project to do data modeling to create either star or snow flake schema. Here is my table list
Dimensions Tables: Patient, Provider, Medication, vaccination, procedure, observation, diagnosis and lab results(These are just denormalised tables the dimensions are not yet populated for Medication to lab results only Patient and Provider dimensions are created)
Fact Table: Billing Table(with measures like length of stay and total amount and all keys from each Dim tables).
Now the problem is i could easily tie up the patient and provider dimension to the fact table with patient_id and provider_id and i dont know how to bring in or use rest of the dimension tables i.e,(Medication, vaccination, procedure, observation, diagnosis and lab results). I am new to dimensional modeling and i am not sure how to do tie up these tables do i need to use any bridge tables(if so for which tables we can have this bridge table). Moreover, whether a star schema is possible or we should have a snow flake.
please help me out.
Thanks
I am working on Health care project to do data modeling to create either star or snow flake schema. Here is my table list
Dimensions Tables: Patient, Provider, Medication, vaccination, procedure, observation, diagnosis and lab results(These are just denormalised tables the dimensions are not yet populated for Medication to lab results only Patient and Provider dimensions are created)
Fact Table: Billing Table(with measures like length of stay and total amount and all keys from each Dim tables).
Now the problem is i could easily tie up the patient and provider dimension to the fact table with patient_id and provider_id and i dont know how to bring in or use rest of the dimension tables i.e,(Medication, vaccination, procedure, observation, diagnosis and lab results). I am new to dimensional modeling and i am not sure how to do tie up these tables do i need to use any bridge tables(if so for which tables we can have this bridge table). Moreover, whether a star schema is possible or we should have a snow flake.
please help me out.
Thanks
mehnaz786786- Posts : 1
Join date : 2011-11-10
Similar topics
» newbie question on health care modeling
» Best practise in creating fact tables for health care
» Dimensional Modelling compared to Relational (3NF +) Modelling for DSS
» Dimensional Modelling
» Dimensional modelling
» Best practise in creating fact tables for health care
» Dimensional Modelling compared to Relational (3NF +) Modelling for DSS
» Dimensional Modelling
» Dimensional modelling
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum