The sdmx.io ecosystem includes a collection of open source SDMX software tools cooperating to solve official statistics use cases.
Fusion Metadata Registry (FMR) is primarily a structural metadata registry - a database designed specifically for storing SDMX artefacts including Concepts, Codelists and Data Structure definitions. A registry is useful in many cases where statistics are collected, produced and exchanged for externalising, centralising and controlling the structural metadata.
Benefits of using a registry for managing structural metadata include:
FMR provides several additional features in addition to its core registry role that help to support practical use cases:
FMR’s web user interface provides metadata managers and data modellers with a graphical way to explore the registry’s content, create new structures and maintain existing ones.
Many artefacts can also be exported to Excel, modified and reloaded - particularly useful for maintaining large Codelists and Constraints.
Datasets can be loaded and validated - checked that they comply with the Checking data quality helps to deliver effective data governance and improves the efficiency of data exchanges, avoiding the costly re-processing or re-transmission.
FMR applies nine standard validation rules:
Rule | Test Applied |
---|---|
Semantically compliant | The XML, JSON, CSV or Excel is well formed |
Duplicate observations | Uniqueness - there is only one observation value reported for each time period |
Mandatory attributes | All mandatory attributes are reported |
Obs status | OBS_STATUS is consistent with the observation value |
Time period format | E.g. FREQ=M means the TIME_PERIOD format must be YYYY-MM |
Valid calculations | Balance equalities defined used Validation Schemes |
Valid constraints | The data is within the universe defined by Data Constraints |
Valid representation | Each component complies with the representation defined in the DSD |
Valid structure | The dimensions and attributes are consistent with the DSD |
Datasets can be converted between most SDMX formats including:
Datasets can be mapped (transformed) to different DSDs using SDMX Structure Mapping.
Typical use cases include:
FusionXL is an Excel interface for FMR that complements and provides an alternative to the web user interface. The following functions are supported:
Fusion Transformer is a command line application for converting SDMX data between transmission formats. It provides an alternative to the FMR data conversion service finding application in scripts and data processing automation.
The .Stat Suite is a standard-based, componentised, open-source platform for the efficient production and dissemination of high-quality statistical data. It is: