SDMX Structural Metadata Management Solutions
for Official Statistics
SDMX Structural Metadata Management using Fusion Registry 9
Metadata Technology’s SDMX Structural Metadata Management solutions are designed for Central Banks, International Organisations and National Statistics Offices who need a robust and controlled source of structural metadata to drive the official statistics data lifecycle.
SDMX Structural Metadata Registry
Fusion Registry 9 provides all of the functions required of a metadata registry for SDMX structures including a controlled environment for creating and maintaining structures, a metadata repository for storage and SDMX-standard interfaces for exchanging the metadata with people and systems.
Fusion Registry 9 supports SDMX versions 1.0, 2.0 and 2.1, plus legacy EDI formats.
All SDMX structures are supported, including:
- Data Providers
- Data Consumers
- Category Schemes
- Concept Schemes
- Codelists (flat and hierarchical)
- Data Structure Definitions
- Provision Agreements
- Reporting Constraints
- Pre-defined queries
- Metadata Structure Definitions
- Data Structure Maps
- Dataflow Maps
- Codelist Maps
- Concept Schemes
- Category Schemes
- Concept Scheme Maps
Authoring and Maintaining Metadata
Fusion Registry 9's web user interface provides a comprehensive set of tools for authorised users to author and maintain the structurl metadata. Wizards are provided to guide and simplfy many maintenance tasks including the creation and modification of Codelists and Data Structure Definitions.
Fusion Registry 9 is a web application, so multiple people can log in to manage the structural metadata concurrently. Users require just a standard web browser - no Adobe Flash or any other special plugins are required which makes it simple to access, simple to deploy and simple to secure.
Structures can only be created and changed by authorised users. Fusion Registry 9 can use either Microsoft Active Directory, or Fusion Security as its directory server. Fusion Security is Metadata Technology's proprietary directory server and comes included as part of the package. For simpler use cases, a Fusion Registry 9 server can also be configured to operate in stand-alone security mode where a single 'root' superuser account takes charge of all maintenance and administration tasks.
You can try out the web user interface on the Enterprise Edition live demo server or by downloading the free-to-use Fusion Registry 9 Community Edition. The live demo server is public, so you won't be able to add or change structures without a login.
Metadata Technology's FusionXL addin for Excel establishes an online connection to a Fusion Registry 9 server allowing users to explore the catalogue of registered SDMX structures, and to view, author and change the structures using spreadsheets.
FusionXL is part of the SDMX Community Tools, so it's free to use and works with both Fusion Registry 9 Community and Enterprise editions for the purpose of managing structural metadata.
When used with the Enterprise Edition, FusionXL also supports viewing, authoring and editing of observation data held in Fusion Registry managed data repositories. There's more about using FusionXL for data authoring under the Data Reporting section, and the Data Dissemination section for viewing data.
Importing and Exporting Structural Metadata
Structural metadata can be imported and exported in a variety of formats including:
- SDMX-ML (XML)
Most structure types can also be exported to and imported from Excel spreadsheets which provide a useful way to author and edit offline. Codelists can also be imported and exported as CSV.
What does an Excel structure look like? Download an example that uses the SDMX REST API to retrieve a World Bank Data Structure Defintion from the Fusion Registry 9 live demo server.
Structures can be imported and exported interactively using the web user interface, and programatically through the REST API. The user interface Export Structures function allows individual structures, all structures of a particular type, or the entire contents of the Registry to be downloaded to file.
Authorised users can load structure files through the user interface, specifying whether to 'Append' the contents to existing structures, 'Replace' structures that have the same ID, or perform a 'Full Replace'.
A Full Replace effectively deletes all of the structural metadata of the target Registry and replaces it with that being loaded. Exporting the entir contents of a Registry and loading it into another using Full Replace is therefore an effective way of cloning or moving structural metadata between environments.
Structures can be loaded from any source, provided they are in an SDMX compliant format (principally SDMX-ML, SDMX-JSON or EDI).
All structures being loaded are checked for compliance with the SDMX standard and for referential integrity. Like conventional databases, imports are managed as an 'atomic transaction' such that the import is guaranteed to be applied in its entirety, or not at all which ensures the target Registry is always maintained in a consistent state.
SDMX REST API
Fusion Registry 9's SDMX compliant REST API provides methods for:
- Submitting structural metadata to the Registry
- Querying for structures
- Deleting structures
- Querying for schemas for Data Structures, Data Flows or Provision Agreements
All structures can be submitted and retrieved as any of the SDMX versions and formats, with Excel also supported for most structures.
The formal SDMX REST specification is published by the SDMX Technical Working Group.
There's more details on the Fusion Registry 9 SDMX REST API implmentation and how to use it in the Web Services Guide.
The Fusion Registry 9 web interface includes an interactive tool for building REST web service queries.