Data warehouse for hospital patient information

Is there a direct relationship between diagnosis and treatment, and if so what are the facts of interest in this intersection? What is in the fact table of the star that has diagnosis and treatment as dimensions? Maybe the dimensions you are after are the "types" of treatment, where treatments can be categorized or characterized by some meaningful criterion. Likewise for the diagnosis. Surely there must be a huge number of possible derivatives for a diagnosis or a treatment. Maybe you could consider aggregating the number of treatments for a particular type of treatment and the number of diagnosis for a type of diagnosis. Still, I wonder what correlation between diagnosis and treatment you are trying to discover? Is it the average duration of treatment given certain types of treatments for certain types of diagnosis? Is it the tally of treatments that were considered completely successful, moderately successful, etc.?

For More Information

• What do you think about this answer? E-mail us at editor@searchDatabase.com with your feedback.
• The Best Data Warehousing and Business Intelligence Web Links: tips, tutorials, scripts, and more.
• Have an DW tip to offer your fellow administrators and developers? The best tips submitted will receive a cool prize. Submit your tip today!
• Ask your technical data warehousing questions -- or help out your peers by answering them -- in our live discussion forums.
• Ask the Experts yourself: Our SQL, database design, Oracle, SQL Server, DB2, metadata, object-oriented and data warehousing gurus are waiting to answer your toughest questions.