Building the Data Warehouse

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


C


CDC (changed data capture), 196-197 class IV ODS, design reviews, 339 CLDS, 21


clickstream data, 298-299 collectiive view of data, 47 compaction, 47, 175, 335 completely unrelated warehouses, 224-225 complex contextual data, 194 complexity of


transformation, 118 components


external data, 272 snapshots, 123 unstructured data, 272 compound keys, 176 connectors, DIS, 96 contextual data, 192-194 continuous files, 61 coordinating development among distributed locations, 227 corporate data model, 89


distributed data


warehouses, 228, 231 migration plans, 278-279 corporate information factory, 17


cost justification, 65-66 cost of reports, 66-68 creative indexes, 108 creative profiles, 108 credit scoring, 133 cross media storage managers, design reviews, 341


cumulative structures, 59 cyclicity of data, 115


D


DASD (direct access storage device), 4, 39 data


archival, 74 compaction, 175 contextual, 192-193 corrections, design reviews, 334 direct access, 129 heterogeneity, 69 homogeneity, 69 indirect access, 130 integration, architected environment, 19 managing large


amounts, 167-169 monitoring, 170 parallel storage/ management, 171 profiles, 26


data (Continued) purges, 72


relationships, design reviews, 332 replication, 196 storage, design reviews, 341


variable length, 176 data-driven development methodologies, 291, 293 data levels, architected environment, 17 data mart level, 17 data marts, star joins, 138-139, 142 data mining, 53 data models, 88-89, 92, 102 design reviews, 326 external data, 273 unstructured data, 273 data to information problems, naturally evolving architecture, 12-14


data warehouse design, 81, 281


data model, 89, 92 design models, 87 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 stability analysis, 90 data warehouse level, 17 data warehouses archival data, 74 auditing, 64 building costs, 68-69 collective view of data, 47 compaction, 47 complexity of


transformation, 118 continuous files, 61 cost justification, 65-66 cost of reports, 66-68 cumulative


structures, 59 cyclicity of data, 115 data mining, 53 day 1-day n

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