ISO/IEC TR 19075-4:2015 情報技術 — データベース言語 — SQLテクニカルレポート — Part 4: JavaTMプログラミング言語を使用したルーチンとタイプのSQL | ページ 2

Foreword

ISO (the International Organization for Standardization) and IEC (the International Electrotechnical Commission) form the specialized system for worldwide standardization. National bodies that are members of ISO or IEC participate in the development of International Standards through technical committees established by the respective organization to deal with particular fields of technical activity. ISO and IEC technical committees collaborate in fields of mutual interest. Other international organizations, governmental and non-governmental, in liaison with ISO and IEC, also take part in the work. In the field of information technology, ISO and IEC have established a joint technical committee, ISO/IEC JTC 1.

International Standards are drafted in accordance with the rules given in the ISO/IEC Directives, 2.

The main task of the joint technical committee is to prepare International Standards. Draft International Standards adopted by the joint technical committee are circulated to national bodies for voting. Publication as an International Standard requires approval by at least 75 % of the national bodies casting a vote.

In exceptional circumstances, when the joint technical committee has collected data of a different kind from that which is normally published as an International Standard (“state of the art”, for example), it may decide to publish a Technical Report. A Technical Report is entirely informative in nature and shall be subject to review every five years in the same manner as an International Standard.

Attention is drawn to the possibility that some of the elements of this document may be the subject of patent rights. ISO and IEC shall not be held responsible for identifying any or all such patent rights.

ISO/IEC TR 19075-4 was prepared by Joint Technical Committee ISO/IEC JTC 1, Information technology, Subcommittee SC 32, Data management and interchange.

ISO/IEC TR 19075 consists of the following parts, under the general title Information technology - Database languages - SQL Technical Reports:

• Part 1: XQuery Regular Expression Support in SQL
• Part 2: SQL Support for Time-Related Information
• Part 3: SQL Embedded in Programs Using the Java™ Programming Language
• Part 4: SQL with Routines and Types Using the Java™ Programming Language
• Part 5: Row Pattern Recognition in SQL

Introduction

The organization of this part of ISO/IEC 19075 is as follows:

• 1) Clause 1, “Scope”, specifies the scope of this part of ISO/IEC 19075.
• 2) Clause 2, “Normative references”, identifies additional standards that, through reference in this part of ISO/IEC 19075, constitute provisions of this part of ISO/IEC 19075.
• 3) Clause 3, “Routines tutorial”, provides a tutorial on the use of routines written in the Java programming language within SQL expressions and statements.
• 4) Clause 4, “Types tutorial”, provides a tutorial on the use of user-defined types written in the Java programming language within SQL expressions and statements.

1 Scope

This Technical Report provides a tutorial of SQL Routines and Types Using the Java™ Programming Language.

The Report 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.

2 Normative references

The following referenced documents are indispensable for the application of this document. For dated references, only the edition cited applies. For undated references, the latest edition of the referenced document (including any amendments) applies.

2.1 ISO and IEC standards

2.2 Other international standards

[Java] The Java™ Language Specification, Third Edition, James Gosling, Bill Joy, Guy Steele, and Gilad Bracha, Prentice Hall, June 14, 2005, ISBN 0-321-24678-0.

[JVM] The Java™VirtualMachine Specification, SecondEdition, Tim Lindholm and FrankYellin, Addison-Wesley, 1999, ISBN 0-201-43294-3, as amended by Clarifications and Amendments to the Java Virtual Machine Specification, http://java.sun.com/docs/books/jvms/second_edition/jvmsclarify.html .

[J2SE] Java™ Platform Standard Edition 6API Specification, http://java.sun.com/javase/6/docs/api/index.html .

[Serialization] Java™ObjectSerialization Specification, version 6.0 http://java.sun.com/javase/6/docs/platform/serialization/spec/serialTOC.html .

[JDBC] JDBC™ 4.0 Specification, Final v1.0, Lance Andersen, Sun Microsystems, Inc., November 7, 2006.