Welcome Introduction to SDMX ESTP Workshop on SDMX

  • Slides: 15
Download presentation
Welcome Introduction to SDMX ESTP Workshop on SDMX in National Accounts Luxembourg, 16 -18

Welcome Introduction to SDMX ESTP Workshop on SDMX in National Accounts Luxembourg, 16 -18 March 2016 Eurostat

THE SDMX COMPONENTS SDMX Information Model Content Oriented Guidelines . . . not just

THE SDMX COMPONENTS SDMX Information Model Content Oriented Guidelines . . . not just a transmission format ! IT Infrastructure for exchange and sharing 2 2 Eurostat

The SDMX Components Describe statistics in a standard way Objects and their relationships §

The SDMX Components Describe statistics in a standard way Objects and their relationships § § Data Structure Definition (DSD), Concepts, Code List § Central management and standard access § SDMX Registry, SDMX Web Services § § § Cross Domain Concepts Cross Domain Code Lists Statistical Domains Metadata Common Vocabulary § Push § Provider generates and sends file to receiver Pull § § § Provider opens web service to data Receiver downloads regularly Hub § § Special case of pull: receiver downloads on end user request Eurostat 3

Describing the data exchange Who? When? Who? How? What? Where? Eurostat

Describing the data exchange Who? When? Who? How? What? Where? Eurostat

SDMX Implementation steps Data Provider Provision agreement Definition of flows Table 0101 Table 0102

SDMX Implementation steps Data Provider Provision agreement Definition of flows Table 0101 Table 0102 Table 0103 Dataflows Definition of table structures Data Structure 5 Eurostat

Exercice: Deriving a concept scheme from a table Eurostat

Exercice: Deriving a concept scheme from a table Eurostat

Proposed solution FREQ ACTIVITY TABLE_IDENTIFIER STO PRICES OBS_VALUE ADJUSTMENT REF_SECTOR TRANSFORMATION REF_AREA ACCOUNTING_ENTRY TIME_PERIOD

Proposed solution FREQ ACTIVITY TABLE_IDENTIFIER STO PRICES OBS_VALUE ADJUSTMENT REF_SECTOR TRANSFORMATION REF_AREA ACCOUNTING_ENTRY TIME_PERIOD UNIT_MEASURE REF_YEAR_PRICE Eurostat OBS_STATUS CONF_STATUS

Proposed solution Concept Scheme Eurostat

Proposed solution Concept Scheme Eurostat

Data Set Structure • Computers need to know the structure of data in terms

Data Set Structure • Computers need to know the structure of data in terms of: • • • Dimensionality Additional metadata Measures (Observation) Concepts Valid content Code Lists Non coded format (integer, date, text) Eurostat

Concepts play roles in a Data Structure • Comprises – Dimensions that identify the

Concepts play roles in a Data Structure • Comprises – Dimensions that identify the observation value – Attributes that additional information about the observation value (as a value or the context of the value) – Measures that are the observation values – Any of these may be • coded • text • date/time • number • etc. Eurostat

DERIVING A DATA STRUCTURE FROM A TABLE DIMENSIONS ATTRIBUTES MEASURES FREQ ACTIVITY TABLE_IDENTIFIER STO

DERIVING A DATA STRUCTURE FROM A TABLE DIMENSIONS ATTRIBUTES MEASURES FREQ ACTIVITY TABLE_IDENTIFIER STO PRICES OBS_VALUE ADJUSTMENT REF_SECTOR TRANSFORMATION REF_AREA ACCOUNTING_ENTRY Eurostat TIME_PERIOD UNIT_MEASURE REF_YEAR_PRICE OBS_STATUS CONF_STATUS

DERIVING A DATA STRUCTURE FROM A TABLE DIMENSIONS ATTRIBUTES MEASURES FREQ ACTIVITY TABLE_IDENTIFIER STO

DERIVING A DATA STRUCTURE FROM A TABLE DIMENSIONS ATTRIBUTES MEASURES FREQ ACTIVITY TABLE_IDENTIFIER STO PRICES OBS_VALUE ADJUSTMENT REF_SECTOR TRANSFORMATION REF_AREA ACCOUNTING_ENTRY Eurostat TIME_PERIOD UNIT_MEASURE REF_YEAR_PRICE OBS_STATUS CONF_STATUS

DATA STRUCTURE DEFINITION Eurostat

DATA STRUCTURE DEFINITION Eurostat

SDMX Information Model - Summary Reference Concept Scheme Reference DSD Reference Data Flow Constraint

SDMX Information Model - Summary Reference Concept Scheme Reference DSD Reference Data Flow Constraint Eurostat Reference Code lists

Welcome Introduction to SDMX ESTP Workshop on SDMX in National Accounts Luxembourg, 16 -18

Welcome Introduction to SDMX ESTP Workshop on SDMX in National Accounts Luxembourg, 16 -18 March 2016 Eurostat

SDMX Tools Interactive demonstrations ESTP Workshop on SDMXSDMX Tools Interactive demonstrations ESTP Workshop on SDMX
SDMX Converter SDMX SDMX Converter Software developed bySDMX Converter SDMX SDMX Converter Software developed by
The European Statistical Training Programme ESTP ESTP whatThe European Statistical Training Programme ESTP ESTP what
SDMX Tools Overview and architecture ESTP Workshop onSDMX Tools Overview and architecture ESTP Workshop on
SDMX tools and architecture Validation Services ESTP WorkshopSDMX tools and architecture Validation Services ESTP Workshop
Challenges at Statistics Netherlands ESTP WORKSHOP ON SDMXChallenges at Statistics Netherlands ESTP WORKSHOP ON SDMX
UK architecture for SDMX conversion ESTP WORKSHOP ONUK architecture for SDMX conversion ESTP WORKSHOP ON
Welcome SDMX in National Accounts Governance Maintenance ESTPWelcome SDMX in National Accounts Governance Maintenance ESTP
ESCWA SDMX Workshop Session SDMX Introduction Metadata TechnologyESCWA SDMX Workshop Session SDMX Introduction Metadata Technology
SDMX Tools Interactive demonstrations Structural Validation Service ESTPSDMX Tools Interactive demonstrations Structural Validation Service ESTP
ESCWA SDMX Workshop Session SDMX Information Model IntroducingESCWA SDMX Workshop Session SDMX Information Model Introducing
ESCWA SDMX Workshop Session SDMX Registry Registration ofESCWA SDMX Workshop Session SDMX Registry Registration of
SDMX TOOLS KNOWLEDGE SHARING WORKSHOP SDMX TOOLS DEVELOPEDSDMX TOOLS KNOWLEDGE SHARING WORKSHOP SDMX TOOLS DEVELOPED
ESCWA SDMX Workshop Session SDMX and Data SessionESCWA SDMX Workshop Session SDMX and Data Session