240 likes | 255 Views
Implementation of Metainformation System in the Czech Statistical Office. International conference STATISTICS - Investment in the Future 2 Prague, 14 – 1 5 September 2009 Ebbo Petrikovits ebbo.petrikovits@czso.cz Petr Eli áš petr.elias@czso.cz
E N D
Implementation of Metainformation System in the Czech Statistical Office International conferenceSTATISTICS - Investment in the Future 2Prague, 14 –15 September 2009 Ebbo Petrikovitsebbo.petrikovits@czso.cz Petr Eliáš petr.elias@czso.cz Miroslava Brchaňová miroslava.brchanova@czso.cz 1
Background • SMS launched in February 2005 • SMS an integral part of the project Redesign of SIS • Redesign SIS the highest priority the CZSO • SMS the highest priority as well 2
Statistical Metainformation System(SMS) Methodology, Management Respondents Ministries of state statistical service Statistical Classifications (SMS-KLAS) S-MD, Methodology, IT Management, Info services, E-presentation End users, Respondents Users End users SMS Management, Info services, E-presentation Statistical Variables (SMS-UKAZ) Dissemination S-MD, Methodology End users End users, Respondents S-MD, Methodology, IT Data Fund End users Statistical Tasks (SMS-ULOHY) S-MD, Methodology, IT S-MD, Methodology, IT Time Series End users, Respondents End users S-MD, Methodology, IT Basic info on SIS End users, Respondents 3
SMS-KLAS SMS-UKAZ SMS-ULOHY DWH Development of the subsystems 1st external supplier TF 2006 project – 2nd supplier (under the TF 2006 Project) 4
TF2006 Project • Main goals • Develop and implement SMS-ULOHY using SMS-KLAS and SMS-UKAZ • Develop and implement DWH using SMS • SMS Portal 5
SMS Users • Internal users: • statisticians • methodologists • SMS administrators • developers of statistical applications • External users 6
SMS-KLAS) Main goals: • Operational running from July 2009 • What was done: • establishing catalogues • loading classifications including linkages between classification items ( ~ 1500 linear classifications [code- lists] and 20 hierarchical classifications) • removal of redundancies between code-lists • set up administration • Inspired by Neuchâtel Classification Model 7
SMS-UKAZ • Main goals: • standard model for definition of statistical variable (STAT-VAR) • model used for definition of STA-VAR in all phases of statistical business process 8
Basic Info • identifier • short name • full name SMS-UKAZModel of statistical variable • Elementary variables • concept • function • MU category • S-M breaks down • Texts • synonyms • definitions • generated name • comment STAT_VAR • Attributes • creator of STAT_VAR • methodologist • principal domain • data type • ……. 9
SMS-UKAZ • Who participates in descriptions: • statisticians describe STAT_VAR • methodologists ensure methodological consistency SMS-UKAZ already proved to be a highly efficient tool for statistical methodology 10
SMS-UKAZ • Process of initial loading • State of art • Annual Labour Statistics - cca 200 STAT_VARs • SBS and STS – cca 1900 input STAT_VARs • Population census 2011 and demography under preparation - cca 200 STAT_VARs • National account output STAT_VARs – initial steps • Time schedule for years 2010-2011 11
SMS-ULOHY • Main goals: • Tool for statisticians when specifying statistical tasks (in formalized and structural form) • history of changes • Increasing role of the methodology during the task specification process • SMS driven statistical production 12
SMS-ULOHY • What is described: • establishing the statistical task • needed STAT_VARs • questionnaires • response duty (sample specifications) • administrative data files • data validation rules • quality attributes • outputs (tables, reports) • time-tables • modules and production steps 13
SMS Portal(Introduction) • Main goals • internet presentation of the SMS • first version – only SMS-KLAS and SMS-UKAZ in Czech version • Next steps • SMS-ULOHY • English version • SMS Portal benefited from Norwegian experience 14
Main features of the SMS Portal • Accessibility • User friendliness • Uniformity • Up-to-date information • For all users 15
SMS Portal 1. Classifications and code lists (SMS-KLAS) 2. Statistical variables (SMS-UKAZ) 3. Future development 16
Catalogue of classifications Abbreviation ↓Name ↓Version ↓ Validity ↓ Family ↓Additional info ↓Download ↓ 17
Classifications • Available information about classifications • Structure • List of items • Additional information • Down load 18
Info about one item ← Level ←Code ←Name of an item ← Attributes ↓Linkages 19
Code lists – the same philosophy • Menu and options • Table format • Searches Slight differences: • Identification • History recording 21
STAT_VAR - search ← by Alphabet ← by Full-text ← by a Topic 22
Info about one STAT_VAR ← Full name ← Code ← Definition ← Synonyms ← Attributes 23
Next steps • SMS-KLAS and SMS-UKAZ • Downloads and prints • Advanced search • English version • SMS-ULOHY • Development • Czech and English version 24