1 / 17

Statistical Metadata Model in Spain: Current Status and Future Applications

This presentation provides an overview of the current status and future use of the statistical metadata model developed in Spain. It covers the functional, management, and user points of view, as well as the role of metadata within INE (National Institute of Statistics). The presentation also includes information about current applications and the way forward.

edwardos
Download Presentation

Statistical Metadata Model in Spain: Current Status and Future Applications

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. STATISTICAL METADATA MODEL DEVELOPED IN SPAIN:CURRENT AND FUTURE USE AND APLLICATIONS Topic (ii): Metadata Concepts, Standards, Models and Registries Mar Blanco Frías GENEVA, 3-5 April 2006

  2. Objectives OBJECTIVES OF THE PRESENTATION • To explain the metadata model current status • Give a general view of the model: functional, management and user points of view • 2. To explain the metadata role inside INE • Information about current applications of the metadata project and the way forward

  3. INDEX 1 Metadata model description and status 1.1 Functional point of view 1.2 Management point of view 1.3 User point of view 2 Role of the metadata inside INE

  4. INDEX 1 Metadata model description and status 1.1 Functional point of view 1.2 Management point of view 1.3 User point of view 2 Role of the metadata inside INE

  5. 1.1 FUNCTIONAL POINT OF VIEW- FIRST PHASE • Fuctionally speaking the metadata project has been divided in two phases: • The first one concerning Statistical Operations • The second one concerning Regulations • The basic concepts used in the first phase are: • Statistical Operation:set of activities leading to obtain statistical results about a specific sector or issue from individually collected data • Variable:information about the unit being studied. In most cases, this variables use to correspond to a unique question in the questionnaire • Classification:set of classes or categories which fix the values that a variable can get. When talking about an international Regulation we talk about standard classifications

  6. System element Number Statistical Operations 102 Survey Questionnaires 253 Variables 8.187 Non-standardised classifications 1.434 1.1 FUNCTIONAL POINT OF VIEW- FIRST PHASE • The objective of the first phase is to have a repository including all surveys, in a relational Database supported by Oracle . Currently the Database contains the following information: • The information is classified in two ways: Horizontal Organization Vertical Organization Thematic Classification variables Thematic Classification classifications Statistical Operations Standard Questionnaires Variables Classifications No Standard

  7. Thematic classification of Variables Thematic Classification of Classifications # First level 28 17 # Second level 181 133 # Third level 445 535 1.1 FUNCTIONAL POINT OF VIEW- FIRST PHASE • Variables and classifications are classified using 3 levels of detail. The following number of themes are available at each level for variables and classifications: • In the case of variables, the thematic classification allows to compare how the different Units request similar information • In the case of classifications, the thematic classification allows to harmonize by eliminating superflous classifications To achieve a high degree of both internal and international harmonization that allows better comparisons FINAL OBJECTIVE

  8. 1.1 FUNCTIONAL POINT OF VIEW- SECOND PHASE • The second phase of the project is devoted to international Regulations and standardised concepts.The objective in this case is to bear a special attention to those variables included in a Regulation, among all variables. •  Using Regulations and CODED as a source of the concepts • To fulfill this objective a second relational Database has been constructed: PHASE 1 PHASE 2 VARIABLES IN STATISTICAL OPERATION VARIABLES IN REGULATION CONCEPTS FOR THIS VARIABLES CLASSIFICATIONS TRANSITION MATRIX • This database allows to ensure that all variables requested in the Regulation are indeed included in the Statistical Operation •  Also to identify the variables included in the Statistical Operations and not requested in the corresponding Regulation and understand why

  9. INDEX 1 Metadata model description and status 1.1 Functional point of view 1.2 Management point of view 1.3 User point of view 2 Role of the metadata inside INE

  10. 1.2 MANAGEMENT POINT OF VIEW • The maintenance of the System is carried out by means of a Metadata Management System • This prevents the operator from making mistakes when working directly in the tables • It allows to introduce and modify information in the Database in a easy and friendly way • Some Windows of the Management System:

  11. INDEX 1 Metadata model description and status 1.1 Functional point of view 1.2 Management point of view 1.3 User point of view 2 Role of the metadata inside INE

  12. 1.3 USER POINT OF VIEW • From a user point of view, it is not usefull to have greats amounts of information stored in tables if you are not able to exploit it as much as possible • The search Engine allows the user to efficiently find different types of information using different search criteria • Available in the Intranet • Different possibilities: • Thematic Searches: The user gets all the variables (or classifications) clasified in the selected theme • Allows to compare how the different Statistical Operations request information about the same theme • Allows to see relationships variableclasifications (1:n) and classifications variable(1:n) 2.Comparison of Statistical Operations:By means of a metodology to analyse similarity between variables and classifications in two Statistical Operations 3. Searches in regulations:It allows to generate a report connecting variables in a Statistical Opration with those in the corresponding Regulation 4. Global search: By litheral, theme, global character chain…

  13. 1.3 USER POINT OF VIEW • Some Search Engine windows (I): Global search Thematic search for Variables Concept definition Standard Classifications search

  14. 1.3 USER POINT OF VIEW • Some Search Engine windows (II): • Search by Regulation • Possibilities: • See the Regulation as it is stored in DB • See the variables in the Regulation with its attributes (internal codes, periodicity…) • See Variables in the Regulation which are requested in some SO • Search by Statistical Operation • Possibilities: • See the questionnaire as it is stored in the DB • See variables in the SO which are requested in the Regulation • See the associated Regulation

  15. INDEX 1 Metadata model description and status 1.1 Functional point of view 1.2 Management point of view 1.3 User point of view 2 Role of the metadata inside INE

  16. 2 ROLE OF METADATA INSIDE INE • Metadata has an important role in quality issues inside INE •  It is used as a quality indicator in surveys • Currently the metadata project is used in the Eurostat Task Force on Core Social Variables •  All information about social surveys is included in the metadata database => Metadata is a powerfull tool to compare how this surveys request the information and harmonize both internally and at European level • Metadata is a first step towards a complete documentation database • Usefull to help to define taxonomies in XBRL metainformation exchange project • FUTURE WORK: • Include not only Statistical operations under INE responsability but also those carried out by other Ministries and Government bodies • Link metadata to data it will help to reduce the load to informers in Economic Surveys.

  17. AND THAT’S ALL…. THANK YOU FOR YOUR ATTENTION!

More Related