Metadata System ESSnet on Data Warehousing 4 th
- Slides: 20
Metadata System ESSnet on Data Warehousing 4 th Workshop Maia Ennok 20 th. of March 2013
The S-DWH 15. 09. 2020 Maia Ennok, Metadata System
Metadata layer n A metadata layer is a conceptual term that refers to all metadata in a data warehouse, regardless of logical or physical organisation. n A metadata system is a system for all metadata in the metadata layer. 15. 09. 2020 Maia Ennok, Metadata System
Goal of the Metadata System of SDWH n Facilitate and support the operation of the SDWH n 1. 4 delivery „Definition of the functionalities of a metadata system to facilitate and support the operation of the S‑DWH“ 15. 09. 2020 Maia Ennok, Metadata System
Statistical Metadata System of CMF Model for integrated management of SMS 15. 09. 2020 Maia Ennok, Metadata System
Functionalities of Metadata System Metadata management: n Metadata creation n Metadata usage n Metadata maintenance n Metadata evaluation …………. . functionality groups 15. 09. 2020 Maia Ennok, Metadata System
Metadata creation n Metadata creation is implementing metadata to the metadata system by creating or collecting metadata. n List of functionalities: n manual creation; n automated creation; n harvesting from other systems; n manual import from files; n creating links between metadata objects. 15. 09. 2020 Maia Ennok, Metadata System
Metadata usage n All the metadata must be deployed meaning metadata must be available to users (people, systems) in the right form and with the right tools. n List of functionalities: n search; n metadata export; n international use. 15. 09. 2020 Maia Ennok, Metadata System
Metadata maintenance n The role of metadata maintenance is to ensure that all metadata stored in the metadata repository are up-to-date for ongoing use. n List of functionalities: n maintenance of metadata history (versioning, update); n updating meta models in metadata repository; n updating links between metadata objects; n updating users and rights. 15. 09. 2020 Maia Ennok, Metadata System
Metadata evaluation n In metadata system there should be functionalities to evaluate the quality of metadata and to assure that metadata has high quality. n List of functionalities: n metadata validation (for example check links between metadata objects); n standards usage 15. 09. 2020 Maia Ennok, Metadata System
The S-DWH 15. 09. 2020 Maia Ennok, Metadata System
In which layers you have metadata functionalities(multiple mark)? A. B. C. D. E. Source Layer Integration Layer Interpretation and Analysis Layer Access Layer None of the above 15. 09. 2020 Maia Ennok, Metadata System
Metadata functionalities per layer Metadata Creation Metadata Usage Metadata Maintenance Metadata Evaluation Source Layer X X Integration Layer X X Interpretation and Analysis Layer X X Access Layer X X 15. 09. 2020 Maia Ennok, Metadata System
Metadata Subsets n Statistical metadata are data about statistical data n Process metadata are metadata that describe the expected or actual outcome of one or more processes using evaluable and operational metrics n Quality metadata are any kind of metadata that contribute to the description or interpretation of the quality of data. n Technical metadata are metadata that describe or define the physical storage or location of data n Authorisation metadata are administrative data that are used by programmes, systems or subsystems to manage users’ access to data 15. 09. 2020 Maia Ennok, Metadata System
Which metadata subsets you have in your metadata system (mark multiple)? A. B. C. D. E. F. Statistical metadata Process metadata Quality metadata Technical metadata Authorization metadata None of the above 15. 09. 2020 Maia Ennok, Metadata System
Integrated metadata system (IMETA) Statistics Estonia n MMX Metadata Repository n Metamodels in metadata repository n Statistical metadata(Neuchatel Terminology Model) n Technical metadata (Relational Database Metamodel) n Process metadata (XDTL Metamodel) n Authorization metadata (Role-Based Access Control Model) n … n Links between different kind of metadata 15. 09. 2020 Maia Ennok, Metadata System
Do you have links between different kind of metadata(multiple mark)? A. No links B. Links between objects of statistical metadata (ex. variable and classifier) C. Links between statistical metadata and technical metadata D. Links between statistical metadata and process metadata E. Links between all kind of metadata 15. 09. 2020 Maia Ennok, Metadata System
Links between columns and variables in i. META 15. 09. 2020 Maia Ennok, Metadata System
Functionalities in i. META n Metadata creation n manual or automated creation; import from files or from other systems; implementing metadata repository; creating links between metadata objects n Metadata usage n search; metadata export; international use n Metadata maintenance n maintenance of metadata history (versioning, update, etc); updating meta models in metadata repository; updating links between metadata objects; updating users and rights n Metadata evaluation n metadata validation (for example check links between metadata objects); n standards usage 15. 09. 2020 Maia Ennok, Metadata System
Thank you!
