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

19.6. CHAPTER SUMMARY

  • Deployment of the first version of the data warehouse follows the construction phase.

  • Major activities in the deployment phase relate to user acceptance, initial loads, desktop readiness, initial training, and initial user support.

  • Pilot systems are appropriate in several sets of circumstances. Common types of pilots are proof-of-concept, proof-of-technology, comprehensive test, user tool appreciation, broad business, and expandable seed.

  • Although data security in a data warehouse environment is similar to security in OLTP systems, providing access privileges is more involved because of the nature of data access inthe warehouse.

  • Why back up the data warehouse? Even though there are hardly any direct data updates in the data warehouse, there are several reasons for backing up. Scheduling backups is more difficult and recovery procedures are also more difficult because of the data volume in the warehouse.

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