Скачать презентацию Exchange of data between OECD and Statistics Norway Скачать презентацию Exchange of data between OECD and Statistics Norway

0ebf4f014e1f51052e99aa208ee0bc50.ppt

  • Количество слайдов: 9

Exchange of data between OECD and Statistics Norway Marianne Vik Dysterud, Statistics Norway mvd@ssb. Exchange of data between OECD and Statistics Norway Marianne Vik Dysterud, Statistics Norway mvd@ssb. no Meeting of the OECD Expert Group on Statistical Data and Metadata Exchange, 10 -11 May 2007, Geneva, Switzerland OECD Expert Group on SDMX 2007, Geneva 10 – 11 May 2007, Marianne Vik Dysterud - mvd@ssb. no

SDMX approach in Statistics Norway topics • • • Experiences creating SDMX-ML files in SDMX approach in Statistics Norway topics • • • Experiences creating SDMX-ML files in SN Reporting methods considered Brief overview of the system architecture Experiences implementing SDMX-Registry Wishes and needs from an NSI OECD Expert Group on SDMX 2007, Geneva 10 – 11 May 2007, Marianne Vik Dysterud - mvd@ssb. no

SDMX approach in Statistics Norway Experiences creating SDMX-ML files • A challenge to find SDMX approach in Statistics Norway Experiences creating SDMX-ML files • A challenge to find readable data descriptions which is essential for creating metadata structure in our SQL DB (Statbank) • A DSD in XML format is not sufficient for this purpose • Example of what we ask for from Eurostat for PEII: D 1. 2. 3 Design and Implementation of SDMX Structural Definitions & D 5. 5. 3 MIG for the SDMX structure definition message (for PEEI Set 3) v. 1. 1 - this document describes the files (including code lists) we are supposed to report the document reminds of a GESMES key-family MIG OECD Expert Group on SDMX 2007, Geneva 10 – 11 May 2007, Marianne Vik Dysterud - mvd@ssb. no

SDMX approach in Statistics Norway Experiences creating SDMX-ML files • Loading data (incl. reporting SDMX approach in Statistics Norway Experiences creating SDMX-ML files • Loading data (incl. reporting date) into Statbank (SQL DB) in advance • When reporting date occurs: - SDMX-ML files are automatically produced by a PL/SQL routine in the Statbank system • The SDMX-ML files can be routed to different folders/catalogues OECD Expert Group on SDMX 2007, Geneva 10 – 11 May 2007, Marianne Vik Dysterud - mvd@ssb. no

SDMX approach in Statistics Norway 2 reporting methods considered: 1. RSS-feed including an URL SDMX approach in Statistics Norway 2 reporting methods considered: 1. RSS-feed including an URL to a specific SDMX-ML file – simple solution, but requires in-house development 2. Implementation of tools from SDMX. org 3. – test of ready-to-use software 4. OECD Expert Group on SDMX 2007, Geneva 10 – 11 May 2007, Marianne Vik Dysterud - mvd@ssb. no

Statbank export Norway DEDICATED PROTECTED ZONE DMZ SECURE ZONE WS Output WS RSS incl. Statbank export Norway DEDICATED PROTECTED ZONE DMZ SECURE ZONE WS Output WS RSS incl. URL to SDMX-ML files SDMX-Registry ? SDMX Internet SDMX-ML OECD Stat SDMX-ML Query Message OECD Expert Group on SDMX 2007, Geneva 10 – 11 May 2007, Marianne Vik Dysterud - mvd@ssb. no

SDMX approach in Statistics Norway Experiences implementing SDMX Registry • Where to find the SDMX approach in Statistics Norway Experiences implementing SDMX Registry • Where to find the right tools and the right version • SDMX. org includes 2 links – both point to the same page (www. metadatatechnology. com/tools. html) • Download site has 2 links – one for beta version – one for version 1. 0 – beta versions use to be newer, but … • We downloaded version 1. 0 of the tools (Keymaster, Data Provisioning, Data Set Registration and SDMX Registry) + instruction and user guides OECD Expert Group on SDMX 2007, Geneva 10 – 11 May 2007, Marianne Vik Dysterud - mvd@ssb. no

SDMX approach in Statistics Norway Experiences implementing SDMX Registry • different problems during first SDMX approach in Statistics Norway Experiences implementing SDMX Registry • different problems during first attempt of installation – SDMX Registry requires specific versions of third party applications • new try - looking for possible news – Link to the Registry installation was dead – One version of Install. Registry. tar. gz found under third party folder w Is this what we are looking for ? – Inconsistency in SDMX_tools_Installation_instructions-v-2_0. pdf Example: SDMXRegistry 2. war is the same as ftp: //www. metadatatechnology. com/pub/downloads/registry/installregistry. tar. gz ? OECD Expert Group on SDMX 2007, Geneva 10 – 11 May 2007, Marianne Vik Dysterud - mvd@ssb. no

SDMX approach in Statistics Norway Wishes and needs from an NSI • Readable Data SDMX approach in Statistics Norway Wishes and needs from an NSI • Readable Data Structure Definitions • Consistent installation and user guides • Windows installation • . NET environment OECD Expert Group on SDMX 2007, Geneva 10 – 11 May 2007, Marianne Vik Dysterud - mvd@ssb. no