ISO IEC TR 19583-21-2025 PDF

Full title and description

ISO/IEC TR 19583-21:2025 — Information technology — Concepts and usage of metadata — Part 21: 11179-3, -31, -32 Data model in SQL. This technical report gives a concrete SQL-based instantiation of the registry metamodels defined in the ISO/IEC 11179 series, using the SQL language defined in ISO/IEC 9075-2.

Abstract

This technical report describes a possible instantiation of the metadata-registry metamodels (ISO/IEC 11179-3, 11179-31 and 11179-32) as an implementable data model expressed in SQL (ISO/IEC 9075-2). It provides schema examples, mapping guidance and notes on how registry concepts map to SQL constructs.

General information

• Status: Published
• Publication date: March 7, 2025
• Publisher: ISO/IEC (joint technical report by ISO/IEC JTC 1/SC 32)
• ICS / categories: 35.040.50, 35.060
• Edition / version: Edition 2 (2025)
• Number of pages: 44

Key bibliographic and lifecycle details are recorded by ISO and the IEC webstores (publication 2025, 2nd edition, replacing the 2022 edition).

Scope

This report provides an implementation-oriented SQL data model that instantiates the registry metamodels from ISO/IEC 11179-3, ISO/IEC 11179-31 and ISO/IEC 11179-32. It is intended to show how registry concepts (registry items, identifications, designations, classifications, mappings and concept systems) can be represented and realized in SQL-compliant relational schemas and DDL as specified in ISO/IEC 9075-2. The document is an informative/implementation aid (technical report) rather than a normative specification for a single product.

Key topics and requirements

• SQL instantiation of the ISO/IEC 11179 registry metamodel (tables, keys, constraints, relationships).
• Mapping of registry concepts (items, identifiers, names, definitions, classifications, mappings) to SQL constructs.
• Examples of DDL and sample data for common registry structures.
• Guidance on normalization, referential integrity and use of SQL data types consistent with ISO/IEC 9075-2.
• Notes on interoperability, extensions and migration from earlier registry implementations.

The above topics follow the instantiation and guidance approach described in the technical report.

Typical use and users

Intended users include data architects, metadata registry implementers, database administrators, government and enterprise metadata managers, tool vendors and standards bodies implementing or interoperating with metadata registries based on ISO/IEC 11179. The report is used as an implementation reference to accelerate registry deployments and to improve consistency across SQL-based registry products.

Related standards

Directly related: ISO/IEC 11179-3 (Metamodel for registry common facilities), ISO/IEC 11179-31, ISO/IEC 11179-32 (concept system registration), and ISO/IEC 9075-2 (SQL/Foundation). The report is part of the ISO/IEC 19583 series (metadata concepts and usage) and replaces the earlier ISO/IEC TR 19583-21:2022 edition.

Keywords

metadata registry, ISO/IEC 11179, SQL, data model, registry metamodel, DDL, metadata management, registry instantiation, metadata interoperability

FAQ

Q: What is this standard?

A: ISO/IEC TR 19583-21:2025 is a technical report that presents an SQL-based instantiation of the metadata-registry metamodels from the ISO/IEC 11179 family, intended as implementation guidance for registry developers and users.

Q: What does it cover?

A: It covers mapping of registry concepts (identifiers, names, definitions, classifications, mappings, concept systems) to SQL schemas and DDL, with examples and guidance on integrity, data types and interoperability in the context of ISO/IEC 9075-2.

Q: Who typically uses it?

A: Data architects, metadata registry implementers, database administrators, standards practitioners, and tool vendors who need a practical SQL reference for implementing ISO/IEC 11179-based registries.

Q: Is it current or superseded?

A: Current — this is the 2nd edition published in March 2025; it supersedes the 2022 edition (ISO/IEC TR 19583-21:2022).

Q: Is it part of a series?

A: Yes. It is Part 21 of the ISO/IEC 19583 series (Concepts and usage of metadata) and is intended to be used alongside other parts of ISO/IEC 11179 and related metadata and data-management standards.

Q: What are the key keywords?

A: Metadata registry, ISO/IEC 11179, SQL/Foundation, DDL, registry metamodel, metadata interoperability.