Exchange of data between OECD and Statistics Norway

1
Exchange of data between OECD and Statistics
Norway

• Marianne Vik Dysterud, Statistics Norway
• mvd_at_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

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

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

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

6
Statbank Norway
SECURE ZONE
WS Output
export
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
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

8
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 InstallRegistry.tar.gz found under
  third party folder
• Is this what we are looking for ?
• Inconsistency in SDMX_tools_Installation_instructi
  ons-v-2_0.pdf
• Example
• SDMXRegistry2.war is this the same as
• ftp//www.metadatatechnology.com/pub/downloads/reg
  istry/installregistry.tar.gz ?

9
SDMX approach in Statistics NorwayWishes and
needs from an NSI

• Readable Data Structure Definitions
• Consistent installation and user guides
• Windows installation
• .NET environment