数据仓库目录（Data warehouse directory）.doc

数据仓库目录（Data warehouse directory） Catalog Translator Preface A brief introduction to the translator Preface The first chapter is the development of DSS. 1 1.1 evolution 1 1.2 generation of direct access storage devices 2 1.3 personal computer / fourth generation programming language technology 3 1.4 into the decimation program 3 1.5 spider web 4 1.6 the problem of the natural evolution architecture 5 1.6.1 data lacks credibility 5 1.6.2 productivity issues 8 1.6.3 from data to information 10 Changes in the 1.6.4 method 11 1.7 architecture design environment 12 1.7.1 architecture design environment level 13 1.7.2 integration 14 1.8 who is the user 15 1.9 development lifecycle 15 1.10 hardware utilization mode 16 1.11 building a stage for redevelopment 16 1.12 monitor data warehouse environment 17 1.13 summary 19 The second chapter data warehouse environment 20 2.1 structure of data warehouse 22 2.2 subject oriented 23 2.3. First days to n days 26 2.4 granularity 28 An example of 2.4.1 granularity 29 2.4.2 granularity double level 31 2.5 segmentation problem 34 2.6 sample database 34 2.7 data segmentation 35 2.8 data organization in data warehouse 37 2.9 data warehouse standard manual 41 2.10 audit and data warehouse 41 2.11 cost rationality 41 2.12 clean warehouse data 42 2.13 report and architecture design environment 42 2.14, the opportunity to operate the window 43 2.15 summary 44 The third chapter design data warehouse 45 3.1 start with operational data 45 3.2 data / process model and architecture design environment 49 3.3 data warehouse and data model 50 3.3.1 Data Model 52 3.3.2 intermediate layer data model 54 3.3.3 physical data model 58 3.4 data model and repeated development 59 3.5 standardization / anti normalization 60 3.6 snapshot in data warehouse 65 3.7 metadata 66 3.8 management references in data warehouse 66 3.9 data cycle 67 3.10 complexity of conversion and integration 70 3.11 trigger data warehouse record 71 3.11.1 event 72 The composition of the