Mapping Assistant English (en)

From SDMX and Metadata Standards

Revision as of 15:49, 10 August 2011 by Podolwo (Talk | contribs)

Jump to: navigation, search

The Mapping Assistant is meant to facilitate the mapping between the structural metadata provided by an SDMX-ML Data Structure Definition (DSD) and those that reside in a database of a dissemination environment.

Mapping Assistant maintains a Mapping Store for keeping the mappings between the SDMX and the local data storage scheme. In the SDMX Reference Infrastructure, the Mapping Assistant provides mapping information to the Data Retriever. The Data Retriever module connects to the Mapping Store database and accesses the appropriate mappings to translate the SDMX-ML queries to SQL for the dissemination database.

The mapping process with the Mapping Assistant tool can be described in four steps:

Step 1 – loading of the SDMX structures - CategoryScheme, DataFlow, Data Structure Definition – from SDMX-ML structure files

Step 2 – loading of the local non-SDMX database schema and the creation of the Dataset

Step 3 – mapping of local concepts to SDMX Concepts of the Data Structure Definition

Step 4 – trancoding of local codes to SDMX Codes of the Codelists referenced in the Data Structure Definition

The objective of the mapping process is to define the mappings for each of the mandatory SDMX Components to local data columns, residing in a local storage (Dissemination Database).

Personal tools