Imagine you are in this situation: as the senior data modeler in your organization, you review data models built by project teams to ensure they follow modeling best practices. There is a new reporting system currently being modeled called “Spam.” Spam will initially produce weekly spreadsheets for business users capturing spam email quantity by keyword on a given day of the week. Figure 1 is a subset of what might get produced, where the columns represent common spam words and the rows represent the days of the week.

The project team could not agree on one single model for this project, so they present you with three different physical data models (see Figure 2). Note that in option 3, a Spam Reporting Factor Type Name could be “Day of Week” and Spam Reporting Factor Value could be “Monday.” Instead of selecting the best model from these three, you decide to play it safe and list the situations where each model would be ideal.

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