Transcript Publishing Metadata with Data

Publishing Metadata with Data - XML based
dissemination process of
statistical information (CoSSI)
Harri Lehtinen
([email protected])
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
14.9.2006
2
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
14.9.2006
3
Metadata project (3/3)
Relational
databases
Statistical
concepts
database
XML-Database
eXist
Metadata
Statistical metadata
Document metadata
Classification
database
Classifications
XML-Editor
Epic
Quality declaration
Statistics
Statistics
Statistics
specific
specific
specific
metadata
metadata
metadata
databases
databases
databases
Processing md
XML database as metadata warehouse
Harri Lehtinen
14.9.2006
4
XML-based dissemination process
Statistical
application
PC-Axis
Publication production
PX-Web
(Monthly, quarterly, yearly publ, publication tables...)
PC-Axis
PX-Edit
SuperStar
figures
SAS
Publication
editor
XML-DB
XML-Editor
Dissemination
database
eXist
...
tables
Epic
- publications
- matrices
- tables
Metadata:
matrices
- statistical md
- document md
- classifications
- quality declaration
- processing md
PC-Axis
Conversions &
Publishing
Saxon
- XSLT 2.0
HTML
HTML
HTML
XEP
- XSL-FO
PDF
Others
RSS,
txt...
SDMX
XBRL
XML-DB
eXist
Harri Lehtinen
14.9.2006
5
Metadata in the CoSSI model

Example of the metadata and the tools used
Harri Lehtinen
14.9.2006
6
Statistics produced by
Statistics Finland
View of the eXist XML
database
View of a statistical
publication in the Epic editor
Metadata
Publications
Tables and matrices
Harri Lehtinen
14.9.2006
7
Statistical table
Document metadata
Publication in XML format
Statistical metadata
Harri Lehtinen
14.9.2006
8
Statistical metadata for a variable in a table
Statistical metadata for a
variable ”Disposable income”
Harri Lehtinen
14.9.2006
9
HTML output of a statistical publication with statistical metadata
Link to the statistical
metadata
Harri Lehtinen
14.9.2006
10