Building the Data Warehouse

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


warehouse, 81, 281 field transformation, 83 format of legacy data, 83


limiting operational data scans, 85 loading


archival data, 84 current data, 85 ongoing data changes, 85


operational data,


82-83, 86


detail levels, 239, 242 detailed data, EIS, 261 developing distributed data warehouses, 225-227 development, 222-224 development life cycle, 21 direct data access, 129 DIS (Data Item Set), 92-94 connectors, 96 physical tables, 98 primary grouping of data, 95


secondary grouping of data, 96


type-of data, 96-97 distributed data


warehouses, 201-202 corporate data model, 228, 231


developing, 225-227 meta data, 232 dormancy rates, design reviews, 339 drill down analysis, EIS, 251-253


DSS (decision support system), 2 analysts, 19 monitoring system, 28


reports, 74 response time, 27 dual levels of granularity, 49


E


ebusiness, 307 efficient index usage, 175 EIS (executive information systems), 19, 247 analysis example, 248-250


atomic data, 254 detailed data, 261 drill down analysis, 251-253


event mapping, 258-260 retrieving data, 256-257 summary data, 262 typical uses, 248 encoding data, 33 end user requirements, design reviews, 325 ERD (Entity Relationship Diagram), 92-93 ERP (Enterprise Resource Planning), 311-312 building data


warehouses, 314-315 corporate data


warehouse, 318-319 operational


applications, 312-313 ETL (extract/transform/ load), 122 events


mapping, EIS, 258-260 triggering snapshots, 122 exploration, 53 exploration


warehouses, 339 extent of development, design reviews, 325 external contextual data, 194


external data, 265-267 archiving, 275 comparing to internal data, 275 components, 272 data models, 273 frequency of


availability, 268 meta data, 269-270 storage, 271


extract processing, design reviews, 327 extract program, 5


F


fast restore, 178 feedback loops, 156, 286 field transformation, data warehouse design, 83 flowback, 337 format of legacy data, data warehouse design, 83


frequency of availability, external data, 268 functionality of data movement, 118-121


G


global data, intersection with local data, 211-213 global data warehouses, 202-209

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