1 / 9

Exchange of data between OECD and Statistics Norway

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. SDMX approach in Statistics Norway topics.

milek
Download Presentation

Exchange of data between OECD and Statistics Norway

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. 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

  2. SDMX approach in Statistics Norwaytopics • 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

  3. 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: - D1.2.3 Design and Implementation of SDMX Structural Definitions & D5.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

  4. 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

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

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

  7. 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

  8. SDMX approach in Statistics NorwayExperiences 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 InstallRegistry.tar.gz found under third party folder • Is this what we are looking for ? • Inconsistency in SDMX_tools_Installation_instructions-v-2_0.pdf Example: SDMXRegistry2.war is this 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

  9. SDMX approach in Statistics NorwayWishes 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

More Related