Overview Work Package 3:
Building and implementation of the S-DWH: Architectural and technical aspects 3
1.Introduction 4
1Stovepipe model 5
2Augmented stovepipe model 6
6
3The Data Warehouse approach 6
3.1Integrated model 6
3.2Data Warehouse model 7
4The Generic Statistical Business Process Model (GSBPM) 9
5Generic Statistical Information Model (GSIM) version 1.0 10
2.Statistical Data Warehouse architecture 12
6Business Architecture 13
6.1Business processes, that constitute the core business and create the primary value stream 13
2.1.1.1Source Layer funtionalities 14
2.1.1.2Integration Layer funtionalities 16
2.1.1.3Interpretation and data analysis layer funtionalities 17
2.1.1.4Access Layer funtionalities 21
6.2Management processes, the processes that govern the operation of a system, 23
6.3Functional diagram for strategic over-arching processes 24
Functional diagram for operational over-arching processes 25
7Information Systems Architecture 28
7.1S-DWH is a metadata-driven system 29
7.2Layered approach of a full active S-DWH 31
2.1.1.5Source layer 32
2.1.1.6Integration layer 34
2.1.1.7Interpretation layer 36
2.1.1.8Access layer 40
7.3Workflow scenarios 42
Scenario 1: full linear end-to-end workflow 43
Scenario 2: Monitoring collection 45
Scenario 3: Evaluating new data source 45
Scenario 4: Re-using data for new standard output 46
Scenario 5: re-using data for complex custom query 46
Example of modularity 48
8Technology Architecture 50
8.1Access layer 50
8.2Interpretation and Data Analysis layer 53
8.3Integration layer 57
8.4Source Layer 59
8.5Towards a modular approach 63
Conclusions 65
The deliverables 3.1 and 3.3 are related to the Business Domain, which is used to align strategic objectives and tactical demands. This provides a common understanding of the organization described by:
Deliverable 3.2 is related to the Information Systems Domain, i.e. the conceptual organization of the effective S-DWH which is able to support tactical demands. This describes models, policies and rules that govern which data is collected, and how it is stored, arranged, integrated, and put to use in a S-DWH.