160 likes | 173 Views
Dissemination of Statistical Data, Publications and Metadata - Process Based on Common Structure of Statistical Information (CoSSI). Harri Lehtinen (harri.lehtinen@stat.fi). XML based dissemination - CoSSI. Modules: Document metadata Statistical metadata Processing metadata Publications
E N D
Dissemination of Statistical Data, Publications and Metadata - Process Based on Common Structure of Statistical Information (CoSSI) Harri Lehtinen(harri.lehtinen@stat.fi)
XML based dissemination - CoSSI • Modules: • Document metadata • Statistical metadata • Processing metadata • Publications • DATA: • Matrices (XDF) • Tables (CALS) • Sparse matrix (KEYS) CoSSI – www.stat.fi/cossi Harri Lehtinen
PC- Axis - tables PDF XLS / Dissemination process – today (Office97) .PX PX-Editmanual or batch processing - checking - edit metadata Automaticalpublishing -Timercontrolled Databaseservices .PX matrices matrices .PX PX-Web PX-Edit or PC-Axismanual or batch processing - exclusion- save as: Excel or txt Statisticalapplication FastWeb -Timercontrolled tables PX-Edit Publication production (Monthly & quarterly publ, publication tables...) SuperStar to PX HTML SAS to PX tables Publicationeditor XML-DBeXist Metadata: - statistical md- document md- classifications - processing md FastWeb:- Conversionto XHTML Conversionto PDF Word, Excel,... PX-templates Harri Lehtinen
PC- Axis - tables PDF / XML based dissemination process – XML and PC-Axis .PX PX-Editmanual or batch processing - checking - edit metadata Automaticalpublishing -Timercontrolled Päivitys-automaatio -Ajastus Tilasto-tietokanta-palvelut Databaseservices .PX .PX matrices matrices PX-Web PX-Web - Conversion to CoSSI-XML matrices Statisticalapplication tables PC-Axis Publication production (Monthly & quarterly publ, publication tables...) Automatical conversions &publishing:FastWeb-XML PX-Edit to PX&CoSSI SuperStar to PX&CoSSI tables SAS to PX&CoSSI Publicationeditor XML-DBeXist HTML Saxon- XSLT 2.0 HTML HTML XML-DBeXist Metadata: - statistical md- document md- classifications - processing md Disseminationdatabase- publications - matrices - tables XML-Editor Epic XEP- XSL-FO Statisticalmetadata Others RSS,txt... PX-templates Harri Lehtinen
PDF / XML based dissemination process – integration completed Databaseservices PC-Axis Publication production (Monthly & quarterly publ, publication tables...) Statisticalapplication PX-Web Automatical conversions &publishing:FastWeb-XML matrices PX-Edit to CoSSI SuperStar to CoSSI Publicationeditor XML-DBeXist tables SAS to CoSSI HTML Saxon- XSLT 2.0 HTML HTML Disseminationdatabase- publications - matrices - tables XML-Editor Epic XML-DBeXist Metadata: - statistical md- document md- classifications - processing md statistical metadata XEP- XSL-FO Others RSS,txt... PX-templates Harri Lehtinen
Metadata project (1/3) • Launched in spring 2006 • Project with the aims of creating a common display and updating environment for Statistics Finlands existing, separate metadata databases • to ascertain and define how the metadata in the relational databases can automatically be converted to an XML format (CoSSI) • to create a user interface for updating and maintaining the XML format metadata documents • to create a comprehensive system of identification codes Harri Lehtinen
Metadata project (2/3) • Metadata warehouse – eXist XML database • Metadata editor – Epic XML editor • Format of the data in the XML database – XML documents defined by the CoSSI model (www.stat.fi/cossi) Harri Lehtinen
Relational databases XML-DatabaseeXist Statistical metadataDocument metadataClassifications Quality declaration Processing md Statisticalconcepts database Metadata XML-EditorEpic Classification database Statisticsspecificmetadata databases Statisticsspecificmetadata databases Statisticsspecificmetadata databases Metadata project (3/3) XML database as metadata warehouse Harri Lehtinen
eXist XML database Harri Lehtinen
View of a statistical publication in the Epic editor View of the eXist XML database Metadata Publications Statistics produced by Statistics Finland Tables and matrices Harri Lehtinen
Publication in XML format Document metadata Statistical table Statistical metadata Harri Lehtinen
Statistical metadata for a variable in a table Statistical metadata for a variable ”Disposable income” Harri Lehtinen
HTML output of a statistical publication with statistical metadata Link to the statistical metadata Harri Lehtinen