Planning the Warehouse Design

The physical and operational requirements of warehousing solutions between traditional database efforts cause design and maintenance to be quite different. The architecture can be made up of several data marts feeding an enterprise storehouse or a warehouse supplying specialized aggregations for the smaller marts. In either solution, the basic considerations for planning the solution are as follows:

  • Gather the key players interested in the warehousing results.

  • Evaluate the scope, benefits, and costs of the warehousing effort.

  • Determine the intended business use and relationships of data to be loaded.

  • Evaluate the enterprise's key facts and subject-oriented dimensions.

  • Determine the frequency at which data is to be loaded, ...

Get Microsoft® SQL Server™ 2000 DBA Survival Guide, Second Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.