Specifications

x Contents
PART II BUSINESS INTELLIGENCE DEVELOPMENT
CHAPTER 6 Scalable Data Warehousing 109
Parallel Data Warehouse Architecture . . . . . . . . . . . . . . . . . . . . . . . . . . . . .109
Data Warehouse Appliances 109
Processing Architecture 110
The Multi-Rack System 110
Hub-and-Spoke Architecture 115
Data Management . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .115
Shared Nothing Architecture 115
Data Types 120
Query Processing 121
Data Load Processing 121
Monitoring and Management . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .122
Business Intelligence Integration . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .123
Integration Services 123
Reporting Services 123
Analysis Services and PowerPivot 123
CHAPTER 7 Master Data Services 125
Master Data Management . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .125
Master Data Challenges 125
Key Features of Master Data Services 126
Master Data Services Components . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .127
Master Data Services Conguration Manager 128
The Master Data Services Database 128
Master Data Manager 128
Data Stewardship . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .129
Model Objects 129
Master Data Maintenance 131
Business Rules 132
Transaction Logging 134