ISO/IEC JTC 1/SC 32/WG 3 - Database language

This document defines data structures and basic operations on property graphs. It provides capabilities for creating, accessing, querying, maintaining, and controlling property graphs and the data they comprise. This document specifies the syntax and semantics of a data management language for specifying and modifying the structure of property graphs and collections thereof. This document provides a vehicle for portability of data definitions and manipulation among GQL-implementations. Implementations of this document can exist in environments that also support application programming languages, end-user query facilities, and various tools for database design, data administration, and performance optimization.

This document describes the definition and use of polymorphic table functions in SQL. The Report discusses the following features of the SQL Language: — The processing model of polymorphic table functions in the context of SQL. — The creation and maintenance of polymorphic table functions. — Issues related to methods of implementing polymorphic table functions. — How polymorphic table functions are invoked by application programs. — Issues concerning compilation, optimization, and execution of polymorphic table functions.

This document describes the definition and use of multidimensional arrays in SQL. Multidimensional arrays represent a core underlying structure of manifold science and engineering data. It is generally recognized today, therefore, that arrays have an essential role in Big Data and should become an integral part of the overall data type orchestration in information systems. This document discusses the syntax and semantics of operations on the MD-array data type defined in ISO/IEC 9075-15.

This document describes the support for the use of SQL within programs written in Java. This document discusses the following features of the SQL language: — The embedding of SQL expressions and statements in programs written in the Java programming language.

This document describes the support in SQL for time-related information. This document discusses the following features of the SQL language: — Time-related data types — Operations on time-related data — Time-related Predicates — Application-time period tables — System-versioned tables — Bi-temporal tables

This document provides a tutorial of SQL routines and types using the Java™ programming language. This document discusses the following features of the SQL Language: — The use of routines written in the Java programming language within SQL expressions and statements. — The use of user-defined types written in the Java programming language within SQL expressions and statements.

This document discusses the syntax and semantics for recognizing patterns in rows of a table, as defined in ISO/IEC 9075-2, commonly called “SQL/RPR”. SQL/RPR defines two features regarding row pattern recognition: — Feature R010, “Row pattern recognition: FROM clause” — Feature R020, “Row pattern recognition: WINDOW clause” These two features have considerable syntax and semantics in common, the principle difference being whether the syntax is placed in the FROM clause or in the WINDOW clause.

This document describes the support in SQL for JavaScript Object Notation. This document discusses the following features of the SQL language: — Storing JSON data. — Publishing JSON data. — Querying JSON data. — SQL/JSON data model and path language.

This document defines ways in which Database Language SQL can be used in conjunction with multidimensional arrays.

ISO/IEC 9075-3:2016 defines the structures and procedures that can be used to execute statements of the database language SQL from within an application written in a programming language in such a way that procedures used are independent of the SQL statements to be executed.

This Technical Report describes the support in SQL for time-related information. This Technical Report discusses the following features of the SQL language: — Time-related datatypes — Operations on time-related data — Time-related Predicates — Application-time period tables — System-versioned tables — Bitemporal tables

ISO/IEC 9075 defines Structured Query Language (SQL). The scope of SQL is the definition of data structure and the operations on data stored in that structure. ISO/IEC 9075-1, ISO/IEC 9075-2 and ISO/IEC 9075-11 encompass the minimum requirements of the language. Other parts define extensions. ISO/IEC 9075-1:2011 describes the conceptual framework used in other parts of ISO/IEC 9075 to specify the grammar of SQL and the result of processing statements in that language by an SQL-implementation.

ISO/IEC TR 19075-1:2011 describes the regular expression support in SQL adopted from the regular expression syntax of XQuery 1.0 and XPath 2.0 Functions and Operators (Second Edition), which is derived from Perl. It discusses five operators using this regular expression syntax: LIKE_REGEX predicate, to determine the existence of a match to a regular expression. OCCURRENCES_REGEX numeric function, to determine the number of matches to a regular expression. POSITION_REGEX function, to determine the position of a match. SUBSTRING_REGEX function, to extract a substring matching a regular expression. TRANSLATE_REGEX function, to perform replacements using a regular expression.

ISO/IEC 9075 defines the SQL language. The scope of the SQL language is the definition of data structure and the operations on data stored in that structure. ISO/IEC 9075-1:2008, ISO/IEC 9075-2:2008 and ISO/IEC 9075-11:2008 encompass the minimum requirements of the language. Other parts define extensions. ISO/IEC 9075-10:2008 defines extensions to the SQL language to support embedding of SQL statements into programs written in the Java programming language (Java is a registered trademark of Sun Microsystems, Inc.). In addition it specifies mechanisms to ensure binary portability of resulting applications.

ISO/IEC 9075 defines the SQL language. The scope of the SQL language is the definition of data structure and the operations on data stored in that structure. ISO/IEC 9075-1:2008, ISO/IEC 9075-2:2008 and ISO/IEC 9075-11:2008 encompass the minimum requirements of the language. Other parts define extensions. ISO/IEC 9075-13:2008 specifies the ability to invoke static methods written in the Java programming language as SQL-invoked routines and to use classes defined in the Java programming language as SQL structured user-defined types. (Java is a registered trademark of Sun Microsystems, Inc.)

ISO/IEC 9075 defines the SQL language. The scope of the SQL language is the definition of data structure and the operations on data stored in that structure. ISO/IEC 9075-1:2008, ISO/IEC 9075-2:2008 and ISO/IEC 9075-11:2008 encompass the minimum requirements of the language. Other parts define extensions. ISO/IEC 9075-9:2008 defines extensions to SQL to support management of external data through the use of foreign-data wrappers and datalink types.

ISO/IEC 9075 defines the SQL language. The scope of the SQL language is the definition of data structure and the operations on data stored in that structure. ISO/IEC 9075-1:2008, ISO/IEC 9075-2:2008 and ISO/IEC 9075-11:2008 encompass the minimum requirements of the language. Other parts define extensions. ISO/IEC 9075-2:2008 defines the data structures and basic operations on SQL-data. It provides functional capabilities for creating, accessing, maintaining, controlling, and protecting SQL-data. Both static and dynamic variants of the language are proved. In addition to direct invocation, bindings are provided for the programming languages Ada, C, COBOL, Fortran, M, Pascal, and PL/I.

ISO/IEC 9075 defines the SQL language. The scope of the SQL language is the definition of data structure and the operations on data stored in that structure. ISO/IEC 9075-1:2008, ISO/IEC 9075-2:2008 and ISO/IEC 9075-11:2008 encompass the minimum requirements of the language. Other parts define extensions. ISO/IEC 9075-3:2008 defines the structures and functions that can be used to execute statements of the database language SQL from within an application written in a standard programming language in such a way that the functions used are independent of the SQL statements to be executed.

ISO/IEC 9075 defines the SQL language. The scope of the SQL language is the definition of data structure and the operations on data stored in that structure. ISO/IEC 9075-1:2008, ISO/IEC 9075-2:2008 and ISO/IEC 9075-11:2008 encompass the minimum requirements of the language. Other parts define extensions. ISO/IEC 9075-4:2008 specifies the syntax and semantics of statements to add a procedural capability to the SQL language in functions and procedures. It includes statements to direct the flow of control, define variables, make assignments and handle exception conditions.

ISO/IEC 9075 defines the SQL language. The scope of the SQL language is the definition of data structure and the operations on data stored in that structure. ISO/IEC 9075-1:2008, ISO/IEC 9075-2:2008 and ISO/IEC 9075-11:2008 encompass the minimum requirements of the language. Other parts define extensions. ISO/IEC 9075-11:2008 specifies an Information Schema and a Definition Schema that describe: the structure and integrity constraints of SQL-data; the security and authorization specifications relating to SQL-data; the features, subfeatures, and packages of ISO/IEC 9075, and the support that each of these has in an SQL implementation; the SQL-implementation information and sizing items of ISO/IEC 9075 and the values supported by an SQL-implementation.

ISO/IEC 9075 defines the SQL language. The scope of the SQL language is the definition of data structure and the operations on data stored in that structure. ISO/IEC 9075-1:2008, ISO/IEC 9075-2:2008 and ISO/IEC 9075-11:2008 encompass the minimum requirements of the language. Other parts define extensions. ISO/IEC 9075-14:2008 defines ways in which Database Language SQL can be used in conjunction with XML.

ISO/IEC 9075 defines the SQL language. The scope of the SQL language is the definition of data structure and the operations on data stored in that structure. ISO/IEC 9075-1:2008, ISO/IEC 9075-2:2008 and ISO/IEC 9075-11:2008 encompass the minimum requirements of the language. Other parts define extensions. ISO/IEC 9075-1:2008 specifies the conceptual framework used in other parts of ISO/IEC 9075 to specify the grammar of SQL and the result of processing statements in that language by an SQL-implementation.

ISO/IEC 9075 defines the SQL database language. The scope of SQL is the definition of data structure and the operations on data stored in that structure. ISO/IEC 9075-1, -2 and -11 encompass the minimum requirements of the language. Other parts define extensions. ISO/IEC 9075-14:2006 defines ways in which SQL can be used in conjunction with XML. It defines ways of importing and storing XML data in an SQL database, manipulating it within the database and publishing both XML and conventional SQL-data in XML form. In addition, it provides facilities that permit applications to integrate into their SQL code the use of XQuery, the XML Query Language published by the World Wide Web Consortium (W3C), to concurrently access ordinary SQL-data and XML documents.