Q:

What are top- down and bottom-up models and how do they differ?

A:

Doug Hackney’s Answer: In a classic, top-down, monolithic DW, the data marts are subsets of the data warehouse. In top-down and hybrid approaches, they are the building blocks of the DW system. Both models are valid, and both work, given the appropriate political and cultural setting. Top-down models require long-term, unwavering support of the very top of the business organization. Bottom-up models are more appropriate where that commitment and support may be lacking.

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