One of the primary reasons for the failure of a data warehousing project is lack of an appropriate architecture. This article talks about a new architectural framework for data flow from the source systems all the way through the presentation layer and outlines the questions one must ask before selecting a particular component within the architecture framework.

Figure 1 shows an outline of the 5x5 architectural framework for an enterprise data warehouse in a medium to large organization. This framework contains five stages of data movement and storage combined with five sets of processes to move data from one logical stage to the next. Of course, the number of components and the size of each component will vary from one project to another based on a number of factors, including, but not limited to:

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