Q:  

We've built a 350GB data warehouse to house personnel records. We are currently having performance trouble. I believe it to be because the data warehouse was designed in a relational schema instead of dimensional schema (i.e. Star). What magnitude of performance improvement could we expect to see if we were to redesign the data warehouse using a dimensional schema model such as a star schema?

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