Metadata Driven Integrated INFORMATION SYSTEM of CSB of
Metadata Driven Integrated INFORMATION SYSTEM of CSB of LATVIA Version 2008. Central Statistical Bureau of Latvia April 5 – 9, 2008 / Luxembourg Presentation on UN ECE/Eurostat/OECD work session on MSIS
KEY INFORMATION of MD ISDMS usage • Successful implementation formed bases for the CSB regional restructuring ( 5 Data Centres(115) instead of 26 Regional Offices (180), completed in 2004 • • • System implemented in August year Surveys described in Metadata base from 2002 102 Surveys in active use in 2008 Surveys available for electronic submission Classifications for usage in metadata base Rate of electronically submitted data: o Maximal for supplied surveys up to o Average in 2007 2002 77 57 129 46% 23, 1% 2
ISDMS architecture - Versions 1 , 2 & 3 Integrated statistical data management system Corporative data Warehouse Macrodata base Registers base OLAP data base Microdata base Dissemination data base FIREALL Metadata base User administration data base FIREALL CSB Web Site Raw data base EE R R www SERVER ISDMS Business application Software Modules Core metadata base module related with DB: Registers module related with DB: Data aggregation module Data analysis module related with DB: USER ADMINISTRATION METADATA MICRODATA REGISTERS USER ADMINISTRATION Data WEB entry module Data mass entry module Missed data imputation module User administration module METADATA MICRODATA REGISTERS USER ADMINISTRATION METADATA MICRODATA REGISTERS DATA IMPUTATION SOFTWARE METADATA MICRODATA MACRODATA USER ADMINISTRATION METADATA REGISTERS USER ADMINISTRATION Data dissemination module related with DB: METADATA MACRODATA REGISTERS USER ADMINISTRATION Data entry and validation module related with DB: METADATA MICRODATA REGISTERS RAW DATABASE USER ADMINISTRATION related with DB: OLAP METADATA MACRODATA related with DB: Windows 2000 Server Advanced MS Internet Information Server SQL server 2000, PC-Axis related with DB: 3
Statistics Structuring in CSB based on the Process Oriented data processing 4
REENGINEERING - MAIN GOALS • Move from Microsoft SQL Server 2000 to version 2005 • System adaptation towards Social statistics data processing, analysis and dissemination, thus moving from MD ISDMS to MDIIS • Introduce transition of the data elder than three years from ISDMS micro and macro data bases to active archive storage • Improve e-Survey subsystem by introducing usage of different Internet browsing Software packages. • Implementation of SDMX standard requirements within data dissemination processes. 5
PROCESSES Covered by MD ISDMS + in Business & Social Statistics Domains 6
MDIIS as CSB Cooporative Data Warehouse 7
8
Thank you for attention ! • Karlis Zeila = • Karlis. Zeila@csb. gov. lv • http: //www. csb. lv 9
- Slides: 9