Building the Data Warehouse

Скачать в pdf «Building the Data Warehouse»


environment, 277 MIS (management


information systems), 4 monitoring data, 170 data warehouse


environment, 25-28 multidimensional DBMS, 17, 182-188 multiple-level data


warehouses, 232-235, 238


multiple profile records, 127 multiple storage media, 189 multiple technology interfaces, 170-171


N


naturally evolving architecture, 6 changing architecture, 15 inability to move from data to information, 12-14


lack of data credibility,


6-8


productivity problems, 9-11


near line storage, 269 nonvolatility, 33 normalization, 104-106


O


ODS (operational data store), 144, 300-301 OLTP (online transaction processing), 4 operational applications, ERP, 312-313 operational data, 16


data warehouse design, 82-83 level, 17 operational


development, 294 operational


environment, 128 operational reporting, 74 operational system changes, 287


operational window, 74-75 outages, design reviews, 333 overflow storage,


151-154, 306 ownership of data, 334


P


parallel storage/


management of data, 171


partitions, 55-58, 338 PCs, 4


physical data model, 99 physical data


organization, 329 physical model, 92 physical tables, 36-38, 98 planning process, determining granularity, 149


primary grouping of data, DIS, 95


primitive data, 15 process model, 88 processing


capacity requirements,


332


charges, 338 indexes only, 178 volume, 331 productivity problems, naturally evolving architecture, 9, 11 profile data, 303 profile records, 124, 127 public summary data, 334 purge criteria, 331 purging data, 72


Q


quick restore, 178


R


raw estimates, determining granularity, 148-149 recovery times, design reviews, 333


redundancy of data, global and local data warehouses, 214-215 redundant data, master files, 2


reengineering, 23-24 reference tables, 113-114, 335


referential integrity, 109 refreshing data


warehouses, 195-196 repetitive processing, 337 reports


costs, 66-68 DSS, 74 operational, 74 secondary, 274 resource estimates, 289 response time, DSS, 27 restructuring, design reviews, 329 Retail personalization system, 132-133 Retrieving data, EIS, 256-257 ROI (return on investment), 65 rolling summary data, 59

Скачать в pdf «Building the Data Warehouse»