Star schema for a data warehouse
2 posters
Page 1 of 1
Star schema for a data warehouse
A health centre is characterised by the following processes:
Patients go to doctors. Patients have a home address (city, country).
Likewise doctors have a work address. Patients have either a private or
public insurance. Furthermore, patients have an age.
Doctors keep records for all their patients. These records keep information
of the disease that a patient has and the data and type of treatment.
Furthermore, the patient record keeps information on whether each
application of the treatment is effective (score from 1 to 6; 6 is good) and
whether there were any side effects (score from 1 to 6; 6 = no side
effects).
A treatment can either be a certain medication (e.g. Aspirin, Placebo,…)
or surgery (e.g. heart surgery, arthroscopy,…). Each treatment has a cost
for private patients and for public patients. For example, heart surgery
costs £50000 for private patients and £20000 for public patients.
question is...
State which tables are fact tables; which tables are dimension tables?
What are the measures of the fact tables?
Patients go to doctors. Patients have a home address (city, country).
Likewise doctors have a work address. Patients have either a private or
public insurance. Furthermore, patients have an age.
Doctors keep records for all their patients. These records keep information
of the disease that a patient has and the data and type of treatment.
Furthermore, the patient record keeps information on whether each
application of the treatment is effective (score from 1 to 6; 6 is good) and
whether there were any side effects (score from 1 to 6; 6 = no side
effects).
A treatment can either be a certain medication (e.g. Aspirin, Placebo,…)
or surgery (e.g. heart surgery, arthroscopy,…). Each treatment has a cost
for private patients and for public patients. For example, heart surgery
costs £50000 for private patients and £20000 for public patients.
question is...
State which tables are fact tables; which tables are dimension tables?
What are the measures of the fact tables?
remo- Posts : 2
Join date : 2012-09-21
Re: Star schema for a data warehouse
Main confused is, \ is possible to come more than one face table in star schema?
remo- Posts : 2
Join date : 2012-09-21
Re: Star schema for a data warehouse
Hi,
a star schama is one fact table, surrounded by multiple dimension tables. You can have scenarios where a dimension will be shared by more than one fact table eg. like Time dimension, Country dimension ...
thanks
a star schama is one fact table, surrounded by multiple dimension tables. You can have scenarios where a dimension will be shared by more than one fact table eg. like Time dimension, Country dimension ...
thanks
hkandpal- Posts : 113
Join date : 2010-08-16
Similar topics
» How to Handle Updates to Dimension Attributes (SCD 1) that have a Cardinality > 1 (Context is Data Warehouse Star Schema)
» Star Schema put to test!
» Only way to pull data from star/snowflake schema is by using facts?
» Data Modeling Question (Bridge Tables?) for Star Schema for Proposals/Awards for university
» star schema designing
» Star Schema put to test!
» Only way to pull data from star/snowflake schema is by using facts?
» Data Modeling Question (Bridge Tables?) for Star Schema for Proposals/Awards for university
» star schema designing
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum
|
|