Statistical Information System March 2005 SIS Statistical Information

Statistical Information System March 2005 SIS - Statistical Information System - SCO Poland 1

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. March 2005 SIS - Statistical Information System - SCO Poland 2

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. March 2005 SIS - Statistical Information System - SCO Poland 3

Subject mater integration SMS – Statistical Metainformation System Classifications Positions Domains March 2005 Glossary of Terms SIS - Statistical Information System - SCO Poland Classifications Legal Acts 4

Physical Integration Demography Database SMS - Statistical Metainformation System Public Data Warehouse Product Database Source data March 2005 Statistical Data Warehouse Regional Data Bank SIS - Statistical Information System - SCO Poland TERYT system 5

Automatization of processes followed the surveys Classifications Forms Reporting periods Authors and Owners Positions Domains Survey Frame March 2005 Terms Survey Documentation System SIS - Statistical Information System - SCO Poland Classifications Legal Acts MData 6

Mode of works sequence of activities for subject meter integration Subject integration possibility Object integration of reporting from different Glossary of sources terms unique Statistical business register name and BJS unique subject description in all surveys for definitions of a given period of time terms statistical agricultural and forest classifications register SRGRi. L March 2005 SIS - Statistical Information System - SCO Poland coherence and grouping according to 7 standards

The goals of Data Warehouse creation To facilitate analysis and secondary surveys based on distributed data sources through dissemination of 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 from no authorized access. March 2005 SIS - Statistical Information System - SCO Poland 8

Mode of works sequence of activities for physical integration Data Warehouse: v National Census - NSP 2002 v Agricultural Census - PSR 2002 v Economic surveys: § DG-1 § F-01/I-01 § C-01 § Z-03 v Agricultural database v Architecture survey B-07 March 2005 Regional Data Bank (RDB): v Loading of RDB from Data Warehouse v Migration from existing RDB SIS - Statistical Information System - SCO Poland 9

Division of works during building of SIS Central Statistical Office Computing Centre statisticians informatics Concept Designing preparation Programming Designing Testing Organization of Administration works Coordination of Testing hardware and software Coordination with March 2005 SIS - Statistical Information 10 authors of surveys System - SCO Poland

General Data Warehouse schema March 2005 SIS - Statistical Information System - SCO Poland 11

Metabase and Data Warehouse Oracle Designer Repository System MB Statistical MB Terms Classifications Business Register Central Data Base Data mart SIS - Statistical Information System - SCO Poland MData MOLAP cube Operational Base March 2005 EUL Discoverer 12

Source data Paper (OCR) forms data Administrative data sources (SMA) Interviewers data SMS - Statistical Metainformation System Statistical Data Warehouse Internet forms data March 2005 SIS - Statistical Information System - SCO Poland P or tal Further works Documents Publ ic Data War ehou se 13