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 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 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 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 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. 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 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 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 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
Скачать презентацию Exchange of data between OECD and Statistics Norway
0ebf4f014e1f51052e99aa208ee0bc50.ppt