ISO/IEC 9075-10:2016/Cor 1:2022

Information technology - Database languages - SQL - Part 10: Object language bindings (SQL/OLB) - Technical Corrigendum 1

Technologies de l'information — Langages de base de données — SQL — Partie 10: Liaisons de langage objet (SQL/OLB) — Rectificatif technique 1

General Information

• Status: Published
• Publication Date: 23-Jun-2022
• ICS: 35.060 - Languages used in information technology
• Technical Committee: ISO/IEC JTC 1/SC 32 - Data management and interchange
• Drafting Committee: ISO/IEC JTC 1/SC 32 - Data management and interchange
• Current Stage: 9599 - Withdrawal of International Standard
• Start Date: 01-Jun-2023
• Completion Date: 30-Oct-2025

Relations

• Revised: ISO/IEC 9075-10:2023 - Information technology - Database languages SQL - Part 10: Object language bindings (SQL/OLB)
• Effective Date: 06-Jun-2022

Overview

ISO/IEC 9075-10:2016/Cor 1:2022 is a Technical Corrigendum to the international standard ISO/IEC 9075-10:2016, focusing on Object Language Bindings (SQL/OLB) within the SQL database language family. Published in June 2022 by the International Organization for Standardization (ISO) and International Electrotechnical Commission (IEC), this corrigendum addresses specific technical clarifications and corrections to improve the implementation and conformance of SQL/OLB standards.

This corrigendum plays an essential role in refining the relationship between SQL and object-oriented languages, ensuring consistency and interoperability in database language bindings used in various programming environments.

Key Topics

• Correction of DefinitionSchema Clause: The corrigendum removes an inappropriate rule by deleting the entire DefinitionSchema clause, enhancing clarity and compliance.
• Conformance Enhancements:
  • Adds missing conformance requirement text to clarify feature dependencies.
  • Specifies the concept of implied feature relationships in SQL/OLB, emphasizing that implementations claiming conformance to certain features must also claim conformance to related prerequisite features.
• Table 23: Implied Feature Relationships: Introduces a key reference table that outlines how specific SQL/OLB features depend on other SQL language features, enabling developers and vendors to understand conformance expectations more clearly.

Applications

ISO/IEC 9075-10:2016/Cor 1:2022 is crucial for professionals working with:

• Database API Development: Ensures object language bindings are implemented according to updated conformance rules, improving database accessibility and interaction from programming languages like Java, C++, and others.
• SQL Standards Compliance: Assists database vendors in auditing and certifying their SQL/OLB implementations for compliance with international standards, fostering interoperability across different systems.
• Cross-language Integration: Facilitates seamless integration of SQL with object-oriented programming languages, supporting complex applications requiring robust data management with minimal discrepancies.
• Quality Assurance and Testing: Provides precise conformance criteria needed for comprehensive testing of SQL/OLB features in modern database management systems.

Related Standards

• ISO/IEC 9075 series (SQL standards): This corrigendum complements the broader ISO/IEC 9075 family, which defines SQL syntax, semantics, and bindings.
• ISO/IEC JTC 1 SC 32: Covers data management and interchange standards, including other database language bindings and data representation formats.
• SQL/CLI (Call-Level Interface) and other language bindings standards that specify interaction between SQL and various programming languages.
• ISO/IEC 13249: Standards related to SQL multimedia and application packages, often interacting with SQL/OLB implementations for advanced data types and applications.

---

Keywords: ISO/IEC 9075-10:2016/Cor 1:2022, SQL/OLB, SQL Object Language Bindings, database language standards, SQL conformance, implied feature relationships, SQL implementation, database interoperability, object-oriented database interfaces, ISO SQL standards, technical corrigendum.

Standards Content (Sample)

INTERNATIONAL STANDARD ISO/IEC 9075-10:2016
TECHNICAL CORRIGENDUM 1
Published 2022-06
INTERNATIONAL ORGANIZATION FOR STANDARDIZATION • МЕЖДУНАРОДНАЯ ОРГАНИЗАЦИЯ ПО СТАНДАРТИЗАЦИИ • ORGANISATION INTERNATIONALE DE NORMALISATION
INTERNATIONAL ELECTROTECHNICAL COMMISSION • МЕЖДУНАРОДНАЯ ЭЛЕКТРОТЕХНИЧЕСКАЯ КОМИССИЯ • COMMISSION ÉLECTROTECHNIQUE INTERNATIONALE

Information technology — Database languages — SQL — Part 10:
Object Language Bindings (SQL/OLB)
TECHNICAL CORRIGENDUM 1
Technologies de l'information — Langages de base de données — SQL — Partie 10: Liaisons de
langage objet (SQL/OLB)
RECTIFICATIF TECHNIQUE 1
Technical Corrigendum 1 to ISO/IEC 9075-10:2016 was prepared by Joint Technical Committee
ISO/IEC JTC 1, Information technology, Subcommittee SC 32, Data management and interchange.

IC
...