130 likes | 242 Views
XML and Web Services in OECD’s Statistical Information System. Lee Samuelson (EXD/ITN) and Lars Thygesen (STD). SIS : An Environment for:. Collection, processing and validation of statistical data and metadata Storage of validated data and metadata in a “warehouse”
E N D
XML and Web Services in OECD’s Statistical Information System Lee Samuelson (EXD/ITN) and Lars Thygesen (STD)
SIS : An Environment for: • Collection, processing and validation of statistical data and metadata • Storage of validated data and metadata in a “warehouse” • Creation and dissemination of statistical products
A Central Design Principle Preserve the decentralised nature of directorates’ statistical activities…… …… while making their data and metadata part of a coherent corporate system
A Modular Approach • OECD.Stat: “warehouse” for validated statistics and metadata • StatWorks: for data capture, processing, validation • MetaStore: for management of metadata • PubStat: for production of traditional publications • Browser: for online access
Key Design Goals • “Loose coupling” of modules XML is becoming global “lingua franca” for information exchange => XML a logical choice for information exchange within SIS • Standard method for retrieving data Web services are a widely-accepted means of integrating processes => Web services a logical choice for data retrieval
Data Production Environments (incl. StatWorks) OECD.Stat Corporate Data Warehouse Browser User Interfaces Cubes PubStat Publication Management Interface MetaStore XML XML Metadata Production Environment Published Outputs Web Services Architecture of the Statistical Information System Production Storage Dissemination
Examples : XML • OECD.Stat Entry Gate • Creating, adding, updating, deleting • XML inputs from multiple sources • Monitoring and controlling • Flexibility as modules evolve • Data Provider Interface
Examples : Web Services • Generating Statistical Outputs • DatasetBrowser Web service • Allows a “requester” Web service to determine what information is available in OECD.Stat, and how to retrieve it • OutputGenerator Web service • Extracts data from OECD.Stat via the DatasetBrowser, and converts resultant XML to one or more output forms; e.g. : • HTML • Excel XML • CSV text files • PC Axis files • SDMX (underway)
Statistical Publications • Changing the way we work • OECD.Stat as a single source of data • Use of XML and Web services
B a t c h c o m p o s i t i o n X S L T O n l i n e ( P D F a n d E x c e l ) C o m p u t e r T o P l a t e A Close Look ……. layout XML schema “Charte graphique” PubStat P u b l i c a t i o n s X M L F r a m e M a k e r E x c e l P D F Approved OECD.Stat
Numerous Benefits • Standards => modern, common “look and feel” for statistical publications • More automated processes => reduced “time to publish” • Less manual intervention => reduced possibility of error • User-friendly authoring tools => easier creation of new publications • XML-based content => easy re-purposing of information
XML and Web Services in Data Sharing • To be taken up at OECD Group of Experts Meeting • SDMX • Examples: • NAWWE • With IMF • With NSOs • UN/OECD World Trade Database
XML and Web Services in OECD’s Statistical Information System Lee Samuelson (EXD/ITN) and Lars Thygesen (STD)