Transcript Statistical information management

Towards one consistent world trade database
: OECD and UNSD data sharing.
IT Issues
ITS Experts Meeting – September 2005
ITS Meeting Sept 2005
Trevor Fletcher ITN/CBS
The OECD/UNSD joint Trade System

Common application being jointly developed for
processing OECD and UNSD Trade data.

OECD to process member country data

UNSD to process all other data

Data to be exchanged between the organisations to
complete each organisations database content.
2
ITS Meeting Sept 2005
Backgound

Phasing out of current Oracle Software at OECD

UNSD migrating away from mainframe-based system

Decision taken to join forces in developing a single
application

Harmonisation of processing rules and technology
3
ITS Meeting Sept 2005
Application components – developed in partnership

SQL-based data model designed by UNSD and synchronised at both
sites.

Data processing procedures: being developed at OECD and parallel
tested at UNSD

Database browser client: designed and developed by UNSD – tested
and adapted by OECD.

Data exchange via XML (SDMX): schema designed by UNSD,
exchange mechanism being developed by OECD
4
ITS Meeting Sept 2005
OECD
Disseminate
Working
Database
Data Exchange &
Synchronisation
Dissemination
Database
UNSD
Disseminate
Working
Database
Dissemination
Database
Process
Process
Common
Processing
Module
Common
Processing
Module
Data Access
Data capture
Data capture
5
ITS Meeting Sept 2005
Opportunities

Extend XML Database Exchange mechanism to other
International Organisations (FAO, UNCTAD etc)

Use common exchange format for data capture from
National institutions providing raw data.

Reuse development for other Trade related data
(internally…): Monthly Trade Statistics, Trade In Services,
Bilateral Trade etc
6
ITS Meeting Sept 2005
Challenges

Managing joint development between different
organisations

Communications

Testing
7
ITS Meeting Sept 2005
Current Situation

Trade Data Processing suite 90% complete

Administrator Client – development completed

Web Browser Client - development completed

Data Exchange Mechanism – development completed

Database synchronisation - UNSD Historical data being loaded
OECD

Parallel testing of all components in progress at UNSD and OECD –
to continue to end 2005

Deployment at OECD and UNSD Jan 2006
8
ITS Meeting Sept 2005
Live Demo of Web Browser
Client
9
ITS Meeting Sept 2005
Thank you ...
[email protected]
questions & answers ...
10
ITS Meeting Sept 2005