ISO/IEC TR 19075-5-2016 PDF

ISO/IEC TR 19075-5-2016 PDF

Information technology - Database languages - SQL Technical Reports - Part 5: Row Pattern Recognition in SQL

$60.00 $120.00 -50%
Product Code: ISO/IEC TR 19075-5
Stock In Stock
Edition: 1ST
Published: 12/15/2016
Number of Pages: 90
File Size: 1 file, 1 Byte

Available Options

Product Description

Information technology - Database languages - SQL Technical Reports - Part 5: Row Pattern Recognition in SQL

Introduction: This Technical Report discusses the syntax and semantics for recognizing patterns in rows of a table, as defined in [ISO9075-2]. [ISO9075-2] 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. The organization of this Technical Report is as follows: 1) Clause 1, “Scope”, specifies the scope of this Technical Report. 2) Clause 2, “Normative references”, identifies standards that are referenced by this Technical Report. 3) Clause 3, “Row pattern recognition: FROM clause”, discusses Feature R010, “Row pattern recognition: FROM clause”. 4) Clause 4, “Expressions in MEASURES and DEFINE”, discusses scalar expression syntax in row pattern matching. 5) Clause 5, “Row pattern recognition: WINDOW clause”, discusses Feature R020, “Row pattern recognition: WINDOW clause”. Clause 5, “Row pattern recognition: WINDOW clause”, does not duplicate material already presented in Clause 3, “Row pattern recognition: FROM clause” and Clause 4, “Expressions in MEASURES and DEFINE”, which should be read even if the reader is only interested in Feature R020, “Row pattern recognition: WINDOW clause”. 6) Clause 6, “Pattern matching rules”, discusses the formal rules of pattern matching. viii Row Pattern Recognition in SQL ©

Scope: This Technical Report discusses the syntax and semantics for recognizing patterns in rows of a table, as defined in [ISO9075-2]. ©ISO/IEC 2016 – All rights reserved Scope 1

Be the first to write a review for this product.

Write a review

Note: HTML is not translated!
Bad           Good
ISO/IEC TR 19075-5-2016 PDF

ISO/IEC TR 19075-5-2016 PDF

$60.00 $120.00