1 / 9

Interactive session: Metadata

Interactive session: Metadata. Maia Ennok Head of Data Warehouse Service Statistics Estonia 24.05.2012. Schema. 05/24/12. Maia Ennok ESSNet Data Warehouse. Task. Put metadata subsets to schema (write examples) Same groups as previous ineractive session: SBS, STS, SBR, ET

merrill
Download Presentation

Interactive session: Metadata

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. Interactive session: Metadata Maia Ennok Head of Data Warehouse Service Statistics Estonia 24.05.2012

  2. Schema 05/24/12 Maia Ennok ESSNet Data Warehouse

  3. Task • Put metadata subsets to schema (write examples) • Same groups as previous ineractive session: SBS, STS, SBR, ET • GSBPM phases 1.-7. • SDWH layers, Extra Layer with description if we missed a layer, off SDWH • Metadata subsets in different colors (Statistical, Process, Technical, Quality, Authorisation), Extra metadata subset with description if we miss a subset • Presentations with metadata subsets, examples and answered fallowing questions • Questions: • What is in your opinion the key element of the S-DWH ? VARIABLE vs. DATASET • What is the absolute minimum set of metadata that must be defined for that element? • What should be the main function of the S-DWH (process support/driver,  output/dissemination)? • What is the function of the metadata layer? 05/24/12 Maia Ennok ESSNet Data Warehouse

  4. Generic Statistical Business Process Model (GSBPM) 05/24/12 Maia Ennok ESSNet Data Warehouse

  5. SDWH Layers • source layer, is the level in which we locate all the activities related to storing and managing internal (surveys) or external (archives) raw data sources. • integration layer, on this layer performs the typical Extraction, Transformation and Loading functions; which must be realized in automatic or semi-automatic ways • interpretation and data analysis layer is specialized to interactive and not structural activities. • access layer is addressed to a wide typology of users or informatics instruments for the final presentation of the information sought 05/24/12 Maia Ennok ESSNet Data Warehouse

  6. Metadata subsets Statistical metadataare data about statistical data This definition will obviously cover all kinds of documentation with some reference to any type of statistical data and is applicable to metadata that refer to data stored in a S-DWH as well as any other type of data store Examples: Variable definition; register description; code list. Process metadata are metadata that describe the expected or actual outcome of one or more processes using evaluable and operational metricsExamples: Operator’s manual (active, structured, reference); parameter list (active, structured, reference); log file (passive, structured, reference/structural) Technical metadata are metadata that describe or define the physical storage or location of data. Examples: Server, database, table and column names and/or identifiers; server, directory and file names and/or identifiers Quality metadata are any kind of metadata that contribute to the description or interpretation of the quality of data. Examples: Quality declarations for a survey or register (passive, free-form, reference); documentation of methods that were used during a survey (passive, free-form, reference); most log lists (passive, structured, reference/structural) Authorisation metadata are administrative data that are used by programmes, systems or subsystems to manage users’ access to data. Examples: User lists with privileges; cross references between resources and users 05/24/12 Maia Ennok ESSNet Data Warehouse

  7. Mapping the BPM-Notation on a SDWH layerd architecture 05/24/12 Maia Ennok ESSNet Data Warehouse

  8. Schema with metadata subsets Statistical Process Technical Quality Authorisation 05/24/12 Maia Ennok ESSNet Data Warehouse

  9. 3/28/12 Esitluse või esitleja nimi

More Related