18.7. CHAPTER SUMMARY

  • Physical design takes the data warehouse implementation closer to the hardware. Physical design activities may be grouped into seven distinct steps.

  • The importance of standards can not be overemphasized. Adopt sound standards during the physical design process.

  • Optimizing storage allocation ranks high in the physical design activities. Make use of RAID technology.

  • Data warehouse performance is heavily dependent on proper indexing strategy. B-Tree indexes and bitmapped indexes are suitable.

  • Other performance improvement schemes that are part of the physical design include the following: data partitioning, data clustering, parallel processing, creation of summaries, adjusting referential integrity checks, proper setting of DBMS initialization parameters, and use of data arrays.

Get DATA WAREHOUSING FUNDAMENTALS: A Comprehensive Guide for IT Professionals 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.

Start your free trial