Web Services at the OECD

1
Web Services at the OECD

• (Stephane Varin ITN/CBS)

2
Agenda

• Definition of web services.
• Web services in OECD.Stat
• Collaboration with IMF and World Bank
• A vision for the future.

3
Business A
Business B
Gerlish
German
English
?
Italish
Germanese
Esperanto
Business C
Business D
Japalian
Japanese
Italian
4
OECD
IMF
Windows
Windows
ad hoc
SQL
Oracle
ad hoc
Esperanto
ad hoc
Web Services
Worl Bank
Other
Unix
ad hoc

DB2
5
Web Services are standard based

• HTTP
• XML
• SOAP (Simple Object Access Protocol)
• WSDL (Web Services Description Language)
• UDDI (Universal Description Discovery
  integration)
• Others
• GXA (Global XML Web Services Architecture)
• WS-S (Security)
• WS-I (Interoperability)
• WS-T (Transaction)

6
OECD DotStat Datawarehouse
Production Databases
Internet Application
Datawarehouse
Web Services
DatasetBrowser
Excel Addin
SQL
Catalog
IMF Portal
Data Import
ltxmlgt lt/xmlgt
PCExpress
OECD Publications
Publication
Import Process
Data
Data
Fame
Data
Data
SQL Data
OLAP Cubes
7
DotStat Web Services

• http//stats.oecd.org/oecdstatws/datasetbrowser.as
  mx

8
Excel Addin using Web Service
9
Data extraction tool using Web Service
10
Online Data Browser using Web Service
11
Collaboration with IMF and World Bank

• Goals
• Better understand the strengths, weaknesses,
  opportunities and risks of Web Services
• Web Services Design
• UDDI
• Security Considerations
• Web Services Management Considerations
• Quality of Service
• Benefice
• Experience
• A prototype will be created based on a real
  business process.

12
IMF Web Portal
13
Proposal for future design of international Data
Exchange
Coordinator Web Service
2. Get web services queries that would return
annual data for GDP for France for 2002from any
international sources
3. There are two registry entries one form OECD
(data in ), and one from Eurostat (data in ).
Here are the queries
5. Query GDP, France, Annual, 2002,
4. Eurostat(Query GDP, France, Annual, 2002, )
5. Query GDP, France, Annual, 2002,
6. ltDATAgt 88888.88lt/DATAgt
6. ltDATAgt99999.99lt/DATAgt
7. ltDATAgt 88888.88lt/DATAgt
1. Query GDP, France, Annual, 2002,from any
international sources
8. ltDATA OECDgt99999.99lt/DATAgt ltDATA
EUROSTATgt88888.88lt/DATAgt
OECD
other orgs
14
Questions ?
15
Web Service usage scenario
UDDI Directory
SOAP Contract
WS Provider
Client App
16
Web Services in OECD.STAT
Web service consumer