Enter Your Email Address to Receive a
Copy of MedicExhange Member Demograhpics

Richard E. Biehl presents designing data warehouses--specifically, the star-schema dimensional warehouse plan at HIMSS 2010 , March 1 - 4, 2010 in Atlanta, GA.

Richard E. Biehl, PhD, a data warehouse architect and consultant for Data-Oriented Quality Solutions, used his expertise in designing data warehouses--specifically, the star-schema dimensional warehouse plan--in a presentation at HIMSS 10 called “Standardizing data dimensions of Healthcare Data Warehouses."

In the medical world, the center of the star can consist of lab test results, vital signs, text from nursing or radiology reports, or any other core facts, said Biehl, who noted that the dimensions are ways to “slice the data,” consisting of physical and logical, or sub-dimensions.  “The number of dimensions physically is a question of your database optimization. The number of dimensions, logically, is a characteristic of your clinical domain and will vary by institution and the scope of your data,” he explained.

During his presentation, Biehl gave a demonstration of how he would go about creating dimensions. Pulling out countries, states, cities and addresses, he created a geopolitical entity. Next, Biehl selected all nurses, physicians and transport people and created a caregiver dimension. He continued on and created several more dimensions, but noted that the process becomes more challenging as more complicated data is added to the system.

Source: HIMSS

You can discuss about HIMSS conference and related topic in our Radiology & Healthcare IT Conferences Group.