The Data Warehouse Data Model: The Floor Plan for Your BI Environment

Home  >  Articles  > 







The Data Warehouse Data Model: The Floor Plan for Your BI Environment

by Vijay Sankaran

June 28, 2002


I've used the analogy between a home and a data warehouse before, and in what I've been seeing lately, I know that the analogy continues to hold true. Like a house, a data warehouse has many diverse components that need to be planned, architected and built properly in order for it to function optimally. In this column, I want to stress the importance of a robust data warehouse model as a part of the overall data warehouse architecture.

The data warehouse data model is like the floor plan of your house: Each entity is like a room and each attribute is like a characteristic of that room. If the analogy holds true, getting the model right seems pretty significant, doesn't it? Imagine drawing up a floor plan for your house and forgetting the sinks in the kitchen or the tub in the bathroom. Most people would be pretty ticked off. Data warehouse users are much the same. If they can't find the data that they need or the data they need exists in multiple places, they will look upon the system unfavorably. Getting the data model right and designing it to scale is key in building a successful data warehouse.

The key driver in building a sound data model is a solid understanding of the business requirements.



Please login/register to read the entire article.





sponsored announcements and special offers
You can do this!
Earn your master's degree in project management without putting your life on hold at GoUWP.com!
Apply today at GoUWP.com for 100% online courses, 45 PDUs each. No entrance exam. University of Wisconsin- Platteville’s MS in Project Management is globally accredited by PMI. Combine academics and real-world scenarios for a 360-degree education.
If you have a distributed team, what are you trying to achieve with Agile approaches? Isn't Agile more for co-located teams? There are eight key benefits to working in a distributed Agile environment. A new report from ProjectsAtWork looks at each of those benefits – and how you can achieve them.
Most business and IT executives agree that any company able to rapidly deliver software of high and predictable quality with minimum budgets enjoys a significant advantage. However, practical experience shows that the challenges associated with software quality remain largely unsolved. Download the white paper Uplift Quality with Requirements Driven Testing to learn fundamental principles of Requirements Driven Testing.



Wow! They've got the internet on computers now!
- Homer Simpson