Managing a Data Warehouse or Data Mart
You must realize that the data warehouse will be an evolving project. After you decide to begin one, there will probably be no end in sight. The users will constantly need access to different types of information. Source systems will change, and these changes will disrupt the transformation processes. The success of any system tends to bring forth more users and more new requests, and thus put a larger load on system resources. You must be prepared to handle the following ongoing tasks:
Backup/Recovery— As with any database, a solution must be reached for how frequently backups will occur. The data in warehouses can be viewed as less volatile from day to day but not less important. Because the volume of ...
Get Microsoft® SQL Server™ 2000 DBA Survival Guide, 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.
