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