100 likes | 121 Views
Publishing Metadata with Data - XML based dissemination process of statistical information (CoSSI). Harri Lehtinen (harri.lehtinen@stat.fi). Metadata project (1/3). Launched in spring 2006
E N D
Publishing Metadata with Data - XML based dissemination process of statistical information (CoSSI) Harri Lehtinen(harri.lehtinen@stat.fi)
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) • XML based metadata base in statistical tabulations • SAS • SuperStar • PC-Axis 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
Statisticalapplication PC-Axis PX-Web Publication production (Monthly, quarterly, yearly publ, publication tables...) PC-Axis figures Publicationeditor XML-DBeXist PC-Axis PX-Edit Conversions &Publishing SuperStar Disseminationdatabase - publications - matrices - tables XML-EditorEpic SAS tables HTML ... Saxon- XSLT 2.0 HTML HTML XEP- XSL-FO PDF XML-DBeXist Metadata: - statistical md- document md- classifications - quality declaration - processing md Others RSS,txt... matrices SDMXXBRL XML-based dissemination process Harri Lehtinen
Metadata in the CoSSI model • Example of the metadata and the tools used Harri Lehtinen
View of a statistical publication in the Epic editor View of the eXist XML database Statistics produced by Statistics Finland Metadata Publications 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