ISO/IEC 9075-14:2023

Information technology — Database languages SQL — Part 14: XML-Related Specifications (SQL/XML)

Technologies de l'information — Langages de base de données SQL — Partie 14: Spécifications relatives au XML (SQL/XML)

General Information

• Status: Published
• Publication Date: 31-May-2023
• 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/WG 3 - Database language
• Current Stage: 9092 - International Standard to be revised
• Start Date: 22-Jun-2025
• Completion Date: 28-Jun-2025

Relations

• Revises: ISO/IEC 9075-14:2016/Cor 2:2022 - Information technology — Database languages — SQL — Part 14: XML-Related Specifications (SQL/XML) — Technical Corrigendum 2
• Effective Date: 11-Feb-2023

Standards Content (Sample)

INTERNATIONAL ISO/IEC
STANDARD 9075-14
Sixth edition
2023-06
Information technology — Database
languages SQL —
Part 14:
XML-Related Specifications (SQL/
XML)
Technologies de l'information — Langages de base de données SQL —
Partie 14: Spécifications relatives au XML (SQL/XML)
Reference number
© ISO/IEC 2023
© ISO/IEC 2023
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
the internet or an intranet, without prior written permission. Permission can be requested from either ISO at the address below
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: [phone]
Email: [e-mail]
Website: www.iso.org
Published in Switzerland
ii
© ISO/IEC 2023 – All rights reserved

ISO/IEC9075-14:2023(E)
Contents Page
Foreword.ix
Introduction.xi
1 Scope.1
2 Normativereferences.2
3 Termsanddefinitions.4
4 Concepts.14
4.1 Notationsandconventions.14
4.1.1 Notations.14
4.1.2 XML-related notations.14
4.2 Data types.15
4.2.1 Namingofpredefinedtypes.15
4.2.2 Datatypeterminology.16
4.3 XML.16
4.3.1 Introduction.16
4.3.2 XML types.16
4.3.3 CharacteristicsofXMLvalues.17
4.3.4 XMLcomparisonandassignment.18
4.3.5 OperationsinvolvingXMLvalues.18
4.3.6 RegisteredXMLschemas.20
4.4 Dataconversions.21
4.5 Dataanalysisoperations.22
4.5.1 Aggregate functions.22
4.6 SQL-invokedroutines.22
4.6.1 Routine descriptors.22
4.7 SQL-statements.23
4.7.1 SQL-statementsclassifiedbyfunction.23
4.7.1.1 SQL-sessionstatements.23
4.8 Basicsecuritymodel.23
4.8.1 Privileges.23
4.9 SQL-sessions.23
4.9.1 SQL-sessionproperties.23
4.10 XMLnamespaces.24
4.11 Overviewofmappings.24
4.11.1 Introductiontomappings.24
4.11.2 MappingSQLcharactersetstoUnicode.25
4.11.3 MappingUnicodetoSQLcharactersets.25
4.11.4 MappingSQLstoXML.25
4.11.5 MappingXMLnamestoSQL.25
©ISO/IEC2023–Allrightsreserved iii

ISO/IEC9075-14:2023(E)
4.11.6 MappingSQLdatatypestoXML.26
4.11.7 MappingvaluesofSQLdatatypestoXML.27
4.11.8 MappingXQueryatomicvaluestoSQLvalues.28
4.11.9 Visibilityofcolumns,tables,andschemasinmappingsfromSQLtoXML.29
4.11.10 MappinganSQLtabletoXML.29
4.11.11 MappinganSQLschematoXML.30
4.11.12 MappinganSQLcatalogtoXML.30
5 Lexicalelements.32
5.1 and.32
5.2 .34
5.3 Namesandidentifiers.35
6 Scalarexpressions.36
6.1 .36
6.2 .39
6.3 .40
6.4 and.41
6.5 .42
6.6 .43
6.7 .46
6.8 .54
6.9 .55
6.10 .60
6.11 .61
6.12 .62
6.13 .64
6.14 .66
6.15 .68
6.16 .72
6.17 .75
6.18 .77
6.19 .80
6.20 .86
6.21 .88
7 Queryexpressions.93
7.1 .93
7.2 .97
8 Predicates.98
8.1 .98
8.2 .99
8.3 .100
8.4 .102
8.5 .103
9 Mappings.108
9.1 MappingSQLstoXMLnames.108
9.2 Mappingamulti-partSQLnametoanXMLname.111
9.3 MappingXMLnamestoSQLs.113
iv ©ISO/IEC2023–Allrightsreserved

ISO/IEC9075-14:2023(E)
9.4 MappinganSQLdatatypetoanXMLname.115
9.5 MappingSQLdatatypestoXMLschemadatatypes.120
9.6 MappinganSQLdatatypetoanamedXMLschemadatatype.139
9.7 MappingacollectionofSQLdatatypestoXMLschemadatatypes.142
9.8 MappingvaluesofSQLdatatypestovaluesofXMLschemadatatypes.144
9.9 MappinganSQLtabletoXMLschemadatatypes.150
9.10 MappinganSQLtabletoanXMLelementorasequenceofXMLelements.154
9.11 MappinganSQLtabletoXMLandanXMLschemadocument.158
9.12 MappinganSQLschematoXMLschemadatatypes.163
9.13 MappinganSQLschematoanXMLelement.166
9.14 MappinganSQLschematoanXMLdocumentandanXMLschemadocument.169
9.15 MappinganSQLcatalogtoXMLschemadatatypes.174
9.16 MappinganSQLcatalogtoanXMLelement.176
9.17 MappinganSQLcatalogtoanXMLdocumentandanXMLschemadocument.179
10 Additionalcommonrules.184
10.1 Retrieval assignment.184
10.2 Store assignment.186
10.3 Resultofdatatypecombinations.188
10.4 Typeprecedencelistdetermination.190
10.5 Typenamedetermination.191
10.6 Determinationofidenticalvalues.192
10.7 DeterminationofequivalentXMLvalues.193
10.8 Equality operations.196
10.9 Groupingoperations.197
10.10 Multisetelementgroupingoperations.198
10.11 Orderingoperations.199
10.12 Potentialsourcesofnon-determinism.200
10.13 InvokinganSQL-invokedroutine.202
10.14 DeterminationofnamespaceURI.205
10.15 ConstructionofanXMLelement.207
10.16 ConcatenationoftwoXMLvalues.210
10.17 SerializationofanXMLvalue.211
10.18 ParsingastringasanXMLvalue.216
10.19 RemovingXQuerydocumentnodesfromanXQuerysequence.220
10.20 ConstructingacopyofanXMLvalue.222
10.21 ConstructinganunvalidatedXQuerydocumentnode.223
10.22 CreationofanXQueryexpressioncontext.224
10.23 DeterminationofanXQueryformaltypenotation.227
10.24 ValidatinganXQuerydocumentorelementnode.230
11 Additionalcommonelements.232
11.1 .232
11.2 .235
11.3 .237
11.4 .238
11.5 .239
12 Schemadefinitionandmanipulation.242
©ISO/IEC2023–Allrightsreserved v

ISO/IEC9075-14:2023(E)
12.1 .242
12.2 .244
12.3 .245
12.4 .246
12.5 .248
12.6 .249
12.7 .250
12.8 .251
12.9 .255
13 SQL-clientmodules.256
13.1 .256
13.2 .258
13.3 Datatypecorrespondences.259
14 Data manipulation.261
14.1 .261
14.2 ...