Overview
ISO/IEC TR 19583-21:2025 is a Technical Report that provides a concrete SQL instantiation of the metadata registry metamodel defined in ISO/IEC 11179-3, ISO/IEC 11179-31, and ISO/IEC 11179-32, using the SQL language family specified in ISO/IEC 9075. It complements the UML-based conceptual models by showing how UML class diagrams and metamodel constructs can be translated into SQL schema, constraints and example statements - enabling implementers to deploy a standards‑compliant Metadata Registry (MDR) in a relational database.
Key topics and technical requirements
- Metamodel-to-SQL translation: Principles and conventions for converting UML Class Diagrams into SQL tables, columns and constraints (e.g., classes → tables; attributes → columns; class‑typed attributes → foreign keys).
- Naming and style guidelines: Practical recommendations such as using UPPER CASE for SQL keywords and lower_case (snake_case) for object names to preserve clarity and traceability back to the UML metamodel.
- Handling complex constructs: Approaches for composite datatypes, specialization hierarchies, association classes, cross‑table constraints and datatype mappings that preserve the semantics of ISO/IEC 11179 metamodels.
- Traceability and documentation: Embedding comments and references in SQL to map SQL objects to UML artefacts and metamodel clauses.
- Examples and specimen SQL: Informative annexes with example SQL instantiations - Annex A for ISO/IEC 11179-3, Annex B for ISO/IEC 11179-32, Annex C for ISO/IEC 11179-31 - showing create table statements, keys, foreign keys and constraints.
Practical applications and users
Who benefits:
- Metadata architects and data stewards building a Metadata Registry or data catalog aligned to ISO/IEC 11179.
- Database designers and RDBMS implementers wanting a reference SQL schema for MDR implementation.
- Systems integrators and software vendors implementing interoperable metadata management solutions.
- Standards bodies and data governance teams adopting a standardized representation for data elements, value domains and concept systems.
Practical uses:
- Deploying a standards‑based MDR to support data discovery, reuse and semantic interoperability.
- Implementing registries for data element registration, concept systems/ontologies, value domains and permissible values.
- Translating UML metadata models into executable SQL for testing, prototyping and production deployments.
Related standards
- ISO/IEC 11179 series (parts 3, 30, 31, 32, 33, 34, 35) - metadata registry metamodels
- ISO/IEC 9075 - SQL (database language specification)
- ISO/IEC 19505 - UML standards (class diagram notation)
Keywords: ISO/IEC TR 19583-21:2025, metadata registry, ISO/IEC 11179, SQL data model, UML to SQL, metadata management, concept system registration, data specification registration.