ISO/IEC 9075-9:2023/Cor 1:2026

Overview

ISO/IEC 9075-9:2023/Cor 1:2026 is a technical corrigendum to the international standard focused on Information technology - Database languages SQL - Part 9: Management of External Data (SQL/MED). This document, published by ISO/IEC, addresses modifications and clarifications to the 2023 edition of SQL/MED, which standardizes the management of external data sources via SQL. By refining the requirements and definitions, this corrigendum ensures greater consistency and correctness in the implementation of the SQL/MED standard by vendors and organizations worldwide.

This technical corrigendum is maintained by the ISO/IEC Joint Technical Committee JTC 1, Subcommittee SC 32, which specializes in data management and interchange standards.

Key Topics

• Clarification of Initial Table Population:
  The corrigendum provides clear guidance on how the SQL_SIZING base table in SQL/MED should be initially populated, supporting more accurate and predictable database setups.

  • It specifies inserting an additional row for 'MAXIMUM DATALINK LENGTH', enhancing the clarity and completeness of the sizing table.

• Conformance Adjustments:
  Incorrect conformance options and restrictive feature relationships have been updated or removed to better align with real-world implementations.

  • Removal of outdated or incorrect options for conformance claims.
  • Refined requirements for feature relationships, supporting a wider range of language and routine binding scenarios.

• Updated Implied Feature Relationships:
  The corrigendum revises Table 38 (Implied feature relationships of SQL/MED) to provide a more accurate mapping between features.

  • Expanded recognition of various programming language interfaces (Ada, C, COBOL, Fortran, MUMPS, Pascal, PL/I) for handling SQL/CLI routines, supporting broader compatibility and flexibility.

Applications

• Database Management Systems (DBMS):
  Vendors and developers use ISO/IEC 9075-9 and its corrigenda to ensure their DBMS products comply with globally recognized methods for managing external data using SQL.

• Data Integration Solutions:
  Organizations implementing data integration or federation solutions benefit from the clarified rules, ensuring that cross-platform data access and storage are robust and interoperable.

• Standards Compliance and Certification:
  Adhering to the latest corrigenda is essential for companies seeking certification for compliance with international SQL standards, particularly regarding the management and representation of external data sources.

• Interoperability Enhancements:
  By defining clearer relationships between SQL/MED features and external programming languages, the standard facilitates interoperability across heterogeneous system environments.

Related Standards

• ISO/IEC 9075 Series (SQL family):

  • Part 1: Framework
  • Part 2: Foundation (SQL/Foundation)
  • Part 9: Management of External Data (SQL/MED)

• ISO/IEC 13249:
  Provides extensions for SQL for various data types (including spatial, multimedia, and full-text).

• ISO/IEC 11179:
  Standards for metadata registries that can complement SQL/MED for external data description.

• ISO/IEC JTC 1/SC 32 Standards:
  Additional standards on data management and data interchange relevant for implementers and users of SQL/MED.

By addressing ambiguities and updating feature relationships, ISO/IEC 9075-9:2023/Cor 1:2026 strengthens the foundation for the management of external data with SQL, supporting greater interoperability, reliability, and standards compliance for enterprise and vendor solutions. For organizations seeking to maintain best practices and keep pace with evolving international database standards, referencing and implementing this corrigendum is essential.