UNSD OECD Joint Trade System

1
UNSD - OECD Joint Trade System

• A production application based on SDMX data
  exchange
• OECD Experts meeting, April 2006

2
UNSD-OECD Joint System

• Provide a coherent source of merchandise trade
  data
• Eliminate duplication in provision processing
  of data
• Develop common data processing standards/tools
• Share development costs
• OECD processes member country data
• UNSD processes all other data
• Content of complete databases in each
  Organisation is synchronised via the Data
  Exchange Suite (DES)
• DES web service synchronisation program
  (ComtradeTools)
• .. visit UN Comtrade site

3
DES - Data Exchange
Synchronisation
Disseminate
Disseminate
Working
Working
Working
Working
Database
Dissemination
Dissemination
Database
Database
Dissemination
Dissemination
Database
Database
Database
Database
Database
Process
Process
Common
Common
Common
Common
Processing
Processing
Processing
Processing
Module
Module
Module
Module
Data Access
Data capture
Data capture
4
Data Exchange/synchronisation

• Server Comtrade web services
• Internet-based, HTTP protocol, REST architecture
• Client
• Can access Comtrade web service via web browser
• and/or use ComtradeTools a command-line program
  for data transfer/conversion applications
• SDMX cross-sectional format, schemas specific to
  each classification - see UN site for more info
• Web service can compress data on the fly (70-80)
• Access security based on IP address

5
(No Transcript)
6
Access via the browser

• Data can be downloaded in SDMX format directly,
  e.g.
• Classification H2 Harmonized System 2002
• Reporter 36 Australia Partner 251 France
• Years 2003 and 2004 Commodity Total trade
• http//unstats.un.org/unsd/comtradedist/getSdmxV1.
  aspx?pxH2r36y2004,2003ccTOTALp251compfa
  lse
• Classification S2 SITC2
• Reporter 36 Australia Partner 0 World
• Year 2004 Commodity Total trade
• http//unstats.un.org/unsd/comtradedist/getSdmxV1.
  aspx?pxs2r36y2004ccTOTALp0compfalse

7
(No Transcript)
8
(No Transcript)
9
ComtradeTools

• Requires Win2000 or higher
• Standalone command-line program for Comtrade data
  download requires additional software to
  synchronise SQL database
• Downloads data in SDMX-ML format, can transform
  into CSV (or import into SQL Server)
• Available from http//unstats.un.org/unsd/comtrade
  dist/comtradeToolssetup.zip

10
ComtradeTools examples

• ComtradeTools /pxs2 /r36 /p0 /ccTOTAL /y2004
• ComtradeTools /pxH2 /r251 /cc10 /y2004
• ComtradeTools /pxH2 /r251 /cc10 /y2004
  /actionDownloadAndConvertToCSV
  /outputDirectoryc\temp\
• ComtradeTools /help
• ComtradeTools /year2003 /actionDownloadDataSetLi
  st
• ComtradeTools /r360 /y2003 /pxH1
  /sourceComtrade /formatSDMX /actionDownloadAndI
  mportToSQLDB

11
Conclusions

• A production application, based on SDMX data
  exchange format and web services
• SDMX cross-sectional format standardised V1.0
• Rapid - exchange can be compressed by web service
• Can convert to CSV format, and upload/synchronise
  with SQL database - no specialised SDMX knowledge
  necessary for end-users
• SDMX is becoming just a part of the plumbing
• Data collection via SDMX would need to be
  simple, via a generic format to avoid multiple
  schemas
• User-friendly interface for ComtradeTools

12
Thank you.. Questions?

• Douglas.Paterson_at_oecd.org
• Contacts
• Lynda.Hawe_at_oecd.org
• Markie Muryawan, UN markie_at_un.org
• Comtrade Technical guide http//unstats.un.org/uns
  d/comtradedist/comtradetools.aspx
• Comtrade Web Services http//unstats.un.org/unsd/c
  omtradedist/entry202.aspx