Overview
ISO/IEC 9075-16:2023/Cor 1:2026 is a technical corrigendum to ISO/IEC 9075-16:2023, the international standard for SQL's Property Graph Queries (SQL/PGQ). Maintained by ISO/IEC JTC 1/SC 32, this document corrects and clarifies language, rules, and syntax related to querying and managing property graphs in SQL-compliant database systems. By refining definitions and conformance statements, this corrigendum ensures that the implementation of SQL/PGQ remains accurate, interoperable, and aligned with industry best practices in information technology and database management.
Key Topics
-
Property Graph Concepts: The corrigendum clarifies terms and rules for representing pure property graphs, including how labels, directed and undirected edges, and vertex label sets are defined and managed.
-
Syntax and Semantic Corrections: Updates are provided to syntax rules for property graph definitions, scalar expressions (such as ``), and path pattern matching, ensuring precise language usage and predictable behavior.
-
Equality Operations: The document introduces stricter requirements for equality operations, specifying how columns in edge and vertex tables should be comparable and how data types should be checked for equality.
-
Graph Pattern Matching: Several clarifications address the correct use of pattern matching syntax, the handling of infinite sets in path queries, and how specific modes-such as "different edges match"-affect the results and performance of graph queries.
-
Label Expressions and Predicates: Rules for processing label expressions, especially in various SQL/PGQ clauses, are enhanced to ensure conformance and clarity in how graph labels are referenced based on context.
-
Conformance and Feature Relationships: The corrigendum augments the table of implied feature relationships in SQL/PGQ, further specifying dependencies among advanced path modes, explicit keywords, and graph table features.
Applications
Implementing ISO/IEC 9075-16:2023/Cor 1:2026 is relevant for:
- Database Engine Developers: Ensuring compliance and interoperability in SQL systems that offer property graph querying capabilities.
- Data Architects: Designing property graph data models and queries that conform with the latest international standards.
- Software Integrators: Building analytics and data integration solutions that rely on standardized graph query features in SQL.
- Compliance and QA Teams: Verifying that SQL-based graph features meet the corrected conformance and syntax requirements outlined by ISO.
Typical use cases include social network analysis, recommendation systems, fraud detection, and network topology mapping, where accurate and efficient property graph queries are essential.
Related Standards
Organizations implementing this corrigendum should consider the following related standards for comprehensive SQL and property graph management:
- ISO/IEC 9075-1 – Information technology - Database languages SQL - Part 1: Framework (SQL/Framework)
- ISO/IEC 9075-2 – Information technology - Database languages SQL - Part 2: Foundation (SQL/Foundation), which provides the core language elements referenced in the corrigendum.
- ISO/IEC 9075-16:2023 – Property Graph Queries (SQL/PGQ), the primary specification corrected by this document.
- ISO/IEC JTC 1/SC 32 – Standards related to data management and interchange.
By adhering to this technical corrigendum in conjunction with the above standards, organizations support robust, interoperable, and internationally recognized SQL property graph query implementations.
For further details and access to the official publication, visit the ISO website.