Is a physical data model different than an implementation data model?In other words, is the PDM a model of what the design should look like, and the IDM a model of how the design should be implemented (for instance, use of views and indexes)? Or are they really the same model?

For example, Figure 1 is a dimensional PDM, also known as a star schema. But is there another data model, the implementation data model, that comes after this to show this design will not be implemented in flattened tables but instead through database views on top of a data warehouse's more normalized set of tables? For this challenge, I asked the Design Challengers, "Does your organization recognize both a PDM and an IDM or just the PDM, and why?"

Register or login for access to this item and much more

All Information Management content is archived after seven days.

Community members receive:
  • All recent and archived articles
  • Conference offers and updates
  • A full menu of enewsletter options
  • Web seminars, white papers, ebooks

Don't have an account? Register for Free Unlimited Access