Corporate Data Model CDM Underlying principle 4 datastores

Corporate Data Model (CDM) Underlying principle: 4 datastores 1. 2. 3. 4. raw data cleaned data aggregated data published data INPUT CLEAN UNIT AGGREGATE DISSIMINATION - CDM was seen as ≈ active DWH

Corporate Data Model (CDM) Main characteristics: • • • All (statistical) processes must use the 4 datastores Processing systems interact on the data stores At some moments: snap shots, which build next data store It is possible to work further on the same (snap shotted) data store Simultanious updating of / on data is mainly organisational issue

Corporate Data Model CSO - Ireland INPUT DATA CLEANED DATASETS AGGREGATE DATASETS Surveys MANAGEMENT STORE 2 OPERATIONAL 3 IMPLEMENTATION S ADMINISTRATIVE DATA CENTRE Admin data DISSEMINATION

Data Management Store (DMS) • • • First implementation of CDM Mainly survey data Data tables are created and populated through the DMS applications. Metadata must be entered as the data tables are created. Metadata capturing = minimal bottleneck BR outside DMS (stand alone)

Corporate Data Model CSO - Ireland INPUT CLEANED DATASETS AGGREGATE DATASETS DISSEMINATION Mainly surveys APP – layer, incl. I/O interfaces SYS 1 SNAPSHOTS M S DATA COLLECTION ACTIVITIES D B SHARED INPUT SHARED CLEANED UNIT AGGREGATE STORE SYS 2 I SYS n DMS meta layer – Basic descriptions

Administrative Data Centre (ADC) • • • Developed for organisational reasons Only Admin data A catalyst to exploit administrative data for statistical purposes Interface with public authorities on admin data flows to CSO Clearing house inside CSO for admin data Data governance with respect to admin data

Administrative Data Centre (ADC) • • Has analysis layer R&D on available data To develop new datasets Without specific needs / demands from statistics

Corporate Data Model CSO - Ireland CLEANED DATASETS INPUT AGGREGATE DATASETS DISSEMINATION Only Admin Data ADC meta layer A D C DATA COLLECTION ACTIVITIES SYS 1 E SOURCES T L Data Products ADC B Front Door I SYS 2 SYS n LEAN INTERFACE

Corporate Data Model CSO - Ireland CLEANED DATASETS INPUT AGGREGATE DATASETS DISSEMINATION APP – layer, incl. I/O interfaces S A D C DATA COLLECTION ACTIVITIES M DATA COLLECTION ACTIVITIES D SNAPSHOTS SHARED INPUT SHARED CLEANED UNIT AGGREGATE STORE SYS 1 DMS meta layer – Basic descriptions B ADC meta layer I E SOURCES T L ADC Data Products SYS 2 SYS n Front Door LEAN INTERFACE