O'Reilly logo

DATA WAREHOUSING FUNDAMENTALS: A Comprehensive Guide for IT Professionals by Paulraj Ponniah

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

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.

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