O'Reilly logo

Microsoft® SQL Server™ 2000 DBA Survival Guide, Second Edition by Mark Spenik, Orryn Sledge

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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, ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required