Part 4. Deploying and Managing the DW/BI System
Chapter 14: Designing and Implementing Security
Chapter 15: Metadata Plan
Chapter 16: Deployment
Chapter 17: Operations and Maintenance
Chapter 18: Present Imperatives and Future Outlook
The last part of the Lifecycle is the most exciting. Security! Deployment! Operations! As you can see in the diagram, we've placed these steps at the end of the Lifecycle. But don't wait too long to start thinking about these issues. The successful deployment and operations of your data warehouse must be built into the system from the outset.
As you're designing your plans for securing the data in the system, a good business sponsor can keep you on track. The costs of not securing the data are easily understood, but don't underestimate the costs associated with tightly securing information. The biggest cost of restrictive security is that it hinders the analyst's ability to combine data in unexpected ways, which can lead to valuable insights into your business.
A large part of deploying the fully developed and tested system is ensuring the user community is ready to use the new tools effectively. You should augment the metadata that underlies all the system components with business-oriented descriptions. These descriptions become part of the user-facing documentation and must be ready as soon as the system is launched. In production, you should rely on your operational procedures to load the DW/BI system with excellent data quality and system reliability. ...
Get The Microsoft® Data Warehouse Toolkit: With SQL Server 2008 R2 and the Microsoft® Business Intelligence Toolset, 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.
