In the past several months, I introduced the concepts of the business dimensional model (BDM), which represents the business view of the data and how users will interact with it. This month, I will begin discussing how to move that business view forward on a project. If you are using a multidimensional database management system (MDBMS), then you already have what you need. You will need to enter your BDM constructs into the MDBMS meta data. However, if you are implementing your dimensional model in a relational database engine, you have more design work to do.

You need to translate the BDM into logical table structures. This is a relatively straightforward process. In its simplest form, each business dimension translates to a single dimension table, and each fact group translates to a fact table. This month we will look at translating the dimensions. These are the basics, so keep in mind that reality is rarely this simple.

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