HAPPY BOOKSGIVING
Use code BOOKSGIVING during checkout to save 40%-55% on books and eBooks. Shop now.
Register your product to gain access to bonus material or receive a coupon.
Data warehouses are the primary means by which businesses can gain competitive advantage through analyzing and using the information stored in their computerized systems. However, the data warehousing market is inundated with confusing, often contradictory, technical information from suppliers of hardware, databases and tools. Data Warehousing in the Real World provides comprehensive guidelines and techniques for the delivery of decision support solutions using open-systems data warehouses. Written by practitioners for practitioners, Data Warehousing in the Real World describes each stage of the implementation process in detail: from project planning and requirements analysis, through architecture and design to administrative issues such as user access, security, backup and recovery.
I INTRODUCTION:
1. Introduction
2. Delivery Process
II DATA WAREHOUSE ARCHITECTURE
3. System Processes
4. Process Architecture
III DESIGN:
5. Database Schema
6. Partitioning Strategy
7. Aggregations
8. Data Mining
9. Matadata
10. System and Data Warehouse Process Managers
IV HARDWARE AND OPERATIONAL DESIGN:
11. Hardware Architecture
12. Physical Layout
13. Security
14. Backup and Recovery
15. Service Level Agreement
16. Operating the Data Warehouse
V CAPACITY PLANNING, TUNING AND TESTING:
17. Capacity Planning
18. Tuning the Data Warehouse
19. Testing the Data Warehouse
VI FUTURES: 20 Data Warehouse Futures
Appendices