ISO/IEC INTERNATIONAL STANDARD 9075-14 Sixth edition 2023-06 Information technology Database languages SQL - Part 14: XML-Related Specifications (SQL/ XML) Technologies de I'information - Langages de base de données SQL - Partie 14: Spécifications relatives au XML (SQL/XML) Reference number IEC IS0/IEC 9075-14:2023(E) OS1 @ IS0/IEC 2023 IS0/IEC 9075-14:2023(E) COPYRIGHT PROTECTED DOCUMENT @IS0/IEC2023 All rights reserved. Unless otherwise specified, or required in the context of its implementation, no part of this publication may be reproduced or utilized otherwise in any form or by any means, electronic or mechanical, including photocopying, or posting on or ISo's member body in the country of the requester. ISO copyright office CP 401 · Ch. de Blandonnet 8 CH-1214 Vernier, Geneva Phone: +41 22 749 01 11 Email: [email protected] Website: www.iso.org Published in Switzerland i @ IS0/IEC 2023 - All rights reserved IS0/IEC 9075-14:20(E) Contents Page Foreword.. .ix Introduction. xi 1 Scope.. 2 Normative references.. 3 Terms and definitions. 4 Concepts. 14 4.1 Notations and conventions. 14 4.1.1 Notations.... 14 4.1.2 XML-related notations. 4.2 Data types... 4.2.1 Naming of predefined types. 4.2.2 Data type terminology. 4.3 XML. 4.3.1 Introduction 4.3.2 XML types. 4.3.3 Characteristics of XML values. 17 4.3.4 XML comparison and assignment. 18 4.3.5 Operations involving XML values. 18 4.3.6 Registered XML schemas. 20 4.4 Data conversions. 21 4.5 Data analysis operations. . 22 4.5.1 Aggregate functions. 22 4.6 SQL-invoked routines. 22 4.6.1 Routine descriptors 4.7 SQL-statements. 23 4.7.1 SQL-statements classified by function. 23 4.7.1.1 SQL-session statements. 23 4.8 Basic security model. 4.8.1 Privileges. . 4.9 SQL-sessions.. 4.9.1 SQL-session properties.. ...23 4.10 XML namespaces. ...24 4.11 Overview of mappings. ...24 4.11.1 Introduction to mappings. 4.11.2 Mapping SQL character sets to Unicode. . 4.11.3 Mapping Unicode to SQL character sets. . ..25 4.11.4 Mapping SQL <identifier>s to XML. . ..25 4.11.5 Mapping XML names to SQL. @ IS0/IEC 2023 - All rights reserved ili IS0/IEC 9075-14:2023(E) 4.11.6 Mapping SQL data types to XML. .26 4.11.7 Mapping values of SQL data types to XML. 27 4.11.8 Mapping XQuery atomic values to SQL values. 4.11.9 Visibility of columns, tables, and schemas in mappings from SQL to XML 4.11.10 Mapping an SQL table to XML. . . . 4.11.11 Mapping an SQL schema to XML. . . . 4.11.12 Mapping an SQL catalog to XML. . . - 5 Lexical elements.. ....32 5.1 <token> and <separator>. 5.2 <literal>.. 5.3 Names and identifiers. .35 6 Scalar expressions. .36 6.1 <data type>.. .36 6.2 <field definition>. . .39 6.3 <value expressionprimary>. 40 6.4 <value specification> and <target specification>, .41 6.5 <case expression>. 42 6.6 <cast specification>. 6.7 <XML cast specification>. . 6.8 <value expression>. . 6.9 <string value function>.. . 6.10 <XML value expression>. . - 6.11 <XML value function>. ..61 6.12 <XML comment>. 6.13 <XML concatenation> 6.14 <XML document>. ..66 6.15 <XML element>. ..68 6.16 <XML forest> .72 6.17 <XML parse>, 6.18 <XML PI> 77 6.19 <XML query> .80 6.20 <XML text>. .86 6.21 <XML validate> .88 7 Query expressions. .93 7.1 <table reference> 93 7.2 <query expression> 8 Predicates.... 8.1 <predicate>. 8.2 <XML content predicate>. 8.3 <XML document predicate>. .100 8.4 <XML exists predicate>. .102 8.5 <XML valid predicate>. .103 9 Mappings... .108 9.1 Mapping SQL <identifier>s to XML names. . . .108 9.2 Mapping a multi-part SQL name to an XML name. . .111 9.3 Mapping XML names to SQL <identifier>s. . 113 iv @ IS0/IEC 2023 - All rights reserved IS0/IEC 9075-14:2023(E) 9.4 Mapping an SQL data type to an XML name. . .115 9.5 Mapping SQL data types to XML schema data types. .120 9.6 Mapping an SQL data type to a named XML schema data type. . : . 9.7 Mapping a collection of SQL data types to XML schema data types. . 9.8 Mapping values of sQL data types to values of XML schema data types. .