EIS effort in the industry today is increasingly facing the challenge of providing a robust, yet flexible, enterprise architecture for data mart delivery to end users within a short period of time and with limited resources. This mart delivery architecture further needs to support a diverse set of end users ranging from power users having good knowledge of SQL to the true end users wanting to look at canned reports or perform OLAP queries. In addition, this architecture has to be flexible enough to support data delivery in ROLAP, DOLAP, Excel spreadsheets or simply flat file formats. This article proposes an enterprise architecture for delivering dependent data marts that will satisfy varying end-user DSS needs. One of the main features of the proposed architecture is its ability to allow the reuse of dimensions across the enterprise. The focus of this article is on the layer between a data warehouse and data marts. We call this layer the "Enterprise Mart Cooker."

FIGURE 1: Context-level view of proposed Enterprise Mart Cooker

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