Information technology — Database languages SQL — Part 15: Multidimensional arrays (SQL/ MDA)
Introduction: This document was developed in response to industry demand for the ability to store and manipulate data in the form of multidimensional arrays within databases managed using database language SQL. The organization of this document is as follows: 1) Clause 1, “Scope”, specifies the scope of this document. 2) Clause 2, “Normative references”, identifies additional standards that, through reference in this document, constitute provisions of this document. 3) Clause 3, “Terms and definitions”, defines the notations and conventions used in this document. 4) Clause 4, “Concepts”, presents concepts used in the definition of multidimensional arrays. 5) Clause 5, “Lexical elements”, defines a number of lexical elements used in the definition of multidi- mensional arrays. 6) Clause 6, “Scalar expressions”, defines a number of scalar expressions used in the definition of multidimensional arrays. 7) Clause 7, “Query expressions”, defines the elements of the language that produce rows and tables of data as used in multidimensional arrays. 8) Clause 8, “Predicates”, defines the predicates used in the definition of multidimensional arrays. 9) Clause 9, “Additional common rules”, specifies the rules for assignments that retrieve multidimen- sional array data from or store multidimensional array data into SQL-data, and formation rules for set operations. 10) Clause10,“Additionalcommonelements”,definesadditionalcommonelementsusedinthedefinition of multidimensional arrays. 11) Clause 11, “Schem
Scope: This document defines ways in which Database Language SQL can be used in conjunction with multidi- mensional arrays. © ISO/IEC 2023 – All rights reserved