100 likes | 113 Views
National Accounts World Wide Exchange. Lars Thygesen, OECD. OECD’s SDMX work. Promoting SDMX as the world standard Trying to generalise formats across domains away from stove-pipes Using SDMX in and out of OECD.Stat SDMX web service Joint External Debt Hub with BIS, IMF, WB NAWWE
E N D
National Accounts World Wide Exchange Lars Thygesen, OECD
OECD’s SDMX work • Promoting SDMX as the world standard • Trying to generalise formats across domains • away from stove-pipes • Using SDMX in and out of OECD.Stat • SDMX web service • Joint External Debt Hub with BIS, IMF, WB • NAWWE • ComTrade with UNSD • Data sharing with IMF (and other IOs) • Education with Eurostat, UNESCO • Country pilots: data collection
Rationale • The idea • web based mechanism • report internationally agreed set of data • allow any authorised user to access data • international organisations agree • Benefits to country's NSO • One format and one operation for reporting • Automated generation of data from source • Built-in validation • Benefits to international organisations • Timely reporting • Complete reporting • No code misinterpretations
<?xml version="1.0" encoding="UTF-8"?> <xs:schema xmlns:xs="http:..XML"...> <xs:element name="Code"> <xs:complexType/> </xs:element>……. <?xml version="1.0"?> <GenericData> <Value>STRUCTURE</Value> </Data> …… <?xml version="1.0"?> <GenericData> <Value>STRUCTURE</Value> </Data> …… Process Checks for Updated XML Files <?xml version="1.0"?> <Genericdata> <Value>AUSTRALIA</Value> </Data> …… <?xml version="1.0"?> <GenericData> <Value>CANADA</Value> </Data> …… Architecture: Data Flow OECD Web Server Web Application SDMX V 2.0 XML Schemas XML Files Validated By Schema XML Files Navigation Structural XML <?xml version="1.0"?> <GenericData> <Value>CANADA</Value> </Data> …… Transformed XML Upload to ANA Database or Output to Other Format Data and Metadata Structure Definitions <?xml version="1.0"?> <GenericData> <Value>AUSTRALIA</Value> </Data> …… Cached Data XML XML Files Copied to Server Content XML Files
Prototype V1: Web Interface • Data selection criteria is driven from the Structural XML • Data content is driven from the copied NSO XML data files • Dimension criteria and countries can be combined for output
Joint Eurostat/OECD questionnaire • Contains 48 tables • New version starting 2007 • To be used by OECD from 2007 • Yet to be formally adopted by EU
The NAWWE schema • http://stats.oecd.org/nawwe/ • SDMX-ML v/2 generic message • with 17 common dimensions + table no. • codelists based on international standards • Will accommodate yearly as well as quarterly national accounts • But limited now to annual accounts
Status spring 2007 • Countries: Australia, Canada, US, New Zealand, Mexico • Organisations: OECD, ECB, IMF • “Almost final” specification of questionnaire end 2006 • Data Structure Definitions for all tables • but only 11 of them specified as tables • Metadata Structure Definition • using SDMX Cross-Domain Concepts
Next steps • Four countries expected to report 2007 • BEA already shows many OECD tables on its web site www.bea.gov/bea/dn/sna/sna.htm • Process: • Adapt these tables to new questionnaire • Replace these tables by NAWWE tables
Tour Europe Comments and questions lars.thygesen@oecd.org The End