Most would agree that a high-quality design process is critical to a successful data warehouse (DW) project. The main deliverables of a good data warehouse design are: A) a dimensional model that meets the business' analytical needs, and B) a warehouse schema that achieves the desired performance requirements for the target physical environment. Given that this isn't a mean task--a good design requires careful analysis and much iteration-- a strong DW design tool would be a relief to the industry as a whole.

For several years, data warehouse architects have had a variety of general-purpose entity modeling tools available to assist in general database design. These tools allow us to construct logical models out of boxes and arrows, fill out entity and attribute information and, ultimately, generate a physical schema for a variety of target databases.

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