1 / 5

National Accounts World Wide Exchange

National Accounts World Wide Exchange. Progress Update – Russell Penlington (STD). October 2003. Rationale:. Capitalise on Standards. National Account standards exist already:. SNA93 defines a standard for national account statistical data.

burt
Download Presentation

National Accounts World Wide Exchange

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. National Accounts World Wide Exchange Progress Update – Russell Penlington (STD) October 2003

  2. Rationale: Capitalise on Standards National Account standards exist already: • SNA93 defines a standard for national account statistical data • NSOs submit Excel tables in a standard coding and format Data Dissemination standards exist already: • XML is an non-proprietary standard for transmitting data between applications and organizations • SDMX is an XML standard for defining, transmitting, validating, and interpreting statistical data between organizations NAWWE attempts to capitalise on these standards to: • Enhance national account data collection at the OECD • Provide other international organizations the same benefits • Facilitate data sharing and dissemination processes for NSOs

  3. <?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"?> <OECD.STAT xmlns:xsd=...> <Value>STRUCTURE</Value> </Data> …… Process Checks for Updated XML Files Excel Tables <?xml version="1.0"?> <OECD.STAT xmlns:xsd=...> <Value>AUSTRALIA</Value> </Data> …… <?xml version="1.0"?> <OECD.STAT xmlns:xsd=...> <Value>CANADA</Value> </Data> …… Architecture: Data Flow OECD Web Server Web Application SDMX Based XML Schemas XML Files Validated By Schema XML Data Files Navigation Structural XML <?xml version="1.0"?> <OECD.STAT xmlns:xsd=...> <Value>CANADA</Value> </Data> …… Upload to SNA Database or Output to Other Format Defines Dimensions and Data Structure Excel VBA Macro provided by OECD <?xml version="1.0"?> <OECD.STAT xmlns:xsd=...> <Value>AUSTRALIA</Value> </Data> …… Copied XML Files XML Files Copied to Server XML Data Files Potential to reduce the number of steps for validating and loading of NSO data into OECD systems Content

  4. Prototype: 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

  5. Progress Update: Project Status XML Schema and File Structures: • Structural and Data XML schemas based on SDMX standards • New Excel macros distributed to pilot countries Web Application Interface: • Automatic checking of remote server Data XML file updates • Utilization of Structural XML for navigation & metadata display Next Steps: • Modify and refine XML schema as SDMX version 1.0 eventuates • Enable notification of XML file import status (NSOs & STD staff) • Provide XML output functionalities (Excel and database upload) • Integration of user functions (validation, output, upload) OECD Development Team: Valerie Thielemans, Eric Dery, and Russell Penlington

More Related