130 likes | 282 Views
Statistical Information System. Integration. The main goal of the integration of statistical data bases was to assure, that services offered by official statistics will be continuo u sly available through improving access to the information already gathered in many distributed data bases.
E N D
Statistical Information System SIS - Statistical Information System - SCO Poland
Integration • The main goal of the integration of statistical data bases was to assure, that services offered by official statistics will be continuously available through improving access to the information already gathered in many distributed data bases. SIS - Statistical Information System - SCO Poland
Concept of integration of survey results At the concept level the following main activities were assumed: • Integration of survey results • Subject mater – through unique definition of terms and classifications used for documentation of statistical surveys, • Physical – through putting maximum set of results in one integrated system, • Automatization of processes followed the surveys – developed gradually, in optimal way for a given time. SIS - Statistical Information System - SCO Poland
Classifications Classifications Positions Legal Acts Glossary of Terms Domains Subject mater integration SMS – Statistical Metainformation System SIS - Statistical Information System - SCO Poland
Physical Integration SMS - Statistical Metainformation System Demography Database Public Data Warehouse Product Database Statistical Data Warehouse Source data RegionalDataBank TERYT system SIS - Statistical Information System - SCO Poland
Automatization of processes followed the surveys Classifications Forms AuthorsandOwners Positions Classifications Reporting periods Legal Acts Domains Terms Survey Frame Survey Documentation System MData SIS - Statistical Information System - SCO Poland
Subject integration possibility of reporting from different sources Statistical business register BJS unique subject description in all surveys for a given period of time statistical agricultural and forestregister SRGRiL Object integration Glossary of terms unique name and definitions of terms classifications coherence and grouping according to standards Mode of workssequence of activities for subject meter integration SIS - Statistical Information System - SCO Poland
The goals of Data Warehouse creation • To facilitate analysis and secondary surveys based on distributed data sources through disseminationof the results of different reports from one place, • To create foundation for commonly accessible data bases as natural extension of data bases accessible for statisticians, • To disseminate data efficiently for permanent users including EUROSTAT, OECD and other international organizations, • To elaborate efficient methods to secure data – as well from damaging as fromno authorized access. SIS - Statistical Information System - SCO Poland
Data Warehouse: National Census - NSP 2002 Agricultural Census - PSR 2002 Economic surveys: DG-1 F-01/I-01 C-01 Z-03 Agricultural database Architecture survey B-07 Mode of workssequence of activities for physical integration Regional Data Bank (RDB): • Loading of RDB from Data Warehouse • Migration from existing RDB SIS - Statistical Information System - SCO Poland
Central Statistical Office - statisticians Concept preparation Designing Organization of works Testing Coordination with authors of surveys and CSCC Central Statistical Computing Centre - informatics Designing Programming Testing Administration Coordination of hardware and software Division of works during building of SIS SIS - Statistical Information System - SCO Poland
General Data Warehouse schema SIS - Statistical Information System - SCO Poland
Metabase and Data Warehouse Oracle Designer Repository EUL Discoverer System MB Business Register MData Terms Classifications Statistical MB Operational Base Central Data Base Data mart MOLAP cube Data mart SIS - Statistical Information System - SCO Poland
Further works Source data SMS - Statistical Metainformation System Portal Paper (OCR) forms data Administrative data sources (SMA) Statistical Data Warehouse Documents Public Data Warehouse Interviewers data Internet forms data SIS - Statistical Information System - SCO Poland