🔥🔥 Don’t Miss Out on Our End of Autumn Sale. If you have any questions, feel free to click the bottom right corner to contact our customer service..

Concat us[email protected]
Shopping Cart

No products in the cart.

🔍
BS ISO/IEC 19075-5:2021

BS ISO/IEC 19075-5:2021

$215.11

Information technology. Guidance for the use of database language SQL – Row pattern recognition

Published By Publication Date Number of Pages
BSI 2021 88
PDF Format Searchable Printable Preview Now
Guaranteed Safe Checkout
Category:

If you have any questions, feel free to reach out to our online customer service team by clicking on the bottom right corner. We’re here to assist you 24/7.
Email:[email protected]

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.

PDF Catalog

PDF Pages PDF Title
2 undefined
5 Contents
8 Tables
9 Foreword
11 Introduction
13 1 Scope
14 2 Normative references
15 3 Terms and definitions
16 4 Row pattern recognition: FROM clause
4.1 Context of row pattern recognition
4.2 Introduction to the FROM clause in row pattern recognition
4.3 Example of ONE ROW PER MATCH
19 4.4 Example of ALL ROWS PER MATCH
21 4.5 Summary of the syntax
22 4.6 The row pattern input table
4.6.1 Introduction to the row pattern input table
23 4.6.2 The row pattern input name
24 4.6.3 The row pattern input declared column list
25 4.7 MATCH_RECOGNIZE
4.8 PARTITION BY
4.9 ORDER BY
4.10 Row pattern variables
26 4.11 MEASURES
27 4.12 ONE ROW PER MATCH vs ALL ROWS PER MATCH
4.12.1 Introduction to use of ROWS PER MATCH
4.12.2 Handling empty matches
31 4.12.3 Handling unmatched rows
33 4.13 AFTER MATCH SKIP
34 4.14 PATTERN
4.14.1 Introduction to the PATTERN syntax
35 4.14.2 PERMUTE
36 4.14.3 Excluding portions of the pattern
37 4.15 SUBSET
38 4.16 DEFINE
39 4.17 The row pattern output table
4.17.1 Introduction to the row pattern output table
40 4.17.2 Row pattern output name
4.17.3 Row pattern output declared column list
41 4.18 Prohibited nesting
4.18.1 Introduction to prohibited nesting
42 4.18.2 Row pattern recognition nested within another row pattern recognition
4.18.3 Outer references within a row pattern recognition query
43 4.18.4 Conventional query nested within row pattern recognition query
44 4.18.5 Recursion
4.18.6 Concatenated row pattern recognition
45 5 Expressions in MEASURES and DEFINE
5.1 Introduction to the use of expressions in MEASURES and DEFINE
5.2 Row pattern column references
46 5.3 Running vs. final semantics
50 5.4 RUNNING vs.FINAL keywords
51 5.5 Aggregates
5.6 Row pattern navigation operations
5.6.1 The four operations
5.6.2 PREV and NEXT
53 5.6.3 FIRST and LAST
54 5.6.4 Nesting FIRST and LAST within PREV or NEXT
55 5.7 Ordinary row pattern column references reconsidered
56 5.8 MATCH_NUMBER function
5.9 CLASSIFIER function
60 6 Row pattern recognition: WINDOW clause
6.1 Introduction to the WINDOW clause
6.2 Example of row pattern recognition in a window
62 6.3 Summary of the syntax
6.3.1 Syntax components
63 6.3.2 Syntactic comparison to windows without row pattern recognition
64 6.3.3 Syntactic comparison to MATCH_RECOGNIZE
6.4 Row pattern input table
6.5 Row pattern variables and other range variables
66 6.6 Windows defined on windows
67 6.7 PARTITION BY
6.8 ORDER BY
6.9 MEASURES
6.10 Full window frame and reduced window frame
6.10.1 Introduction to window framing
68 6.10.2 ROWS BETWEEN CURRENT ROW AND
6.10.3 EXCLUDE NO OTHERS
6.11 AFTER MATCH SKIP
69 6.12 INITIAL vs SEEK
6.13 PATTERN
6.14 SUBSET
6.15 DEFINE
6.16 Empty matches and empty reduced window frames
71 6.17 Prohibited nesting
6.17.1 Restrictions on nesting
72 6.17.2 Row pattern recognition nested within another row pattern recognition
6.17.3 Outer references within a row pattern recognition query
73 6.17.4 Conventional query nested within row pattern recognition query
6.17.5 Recursion
6.17.6 Concatenated row pattern recognition
75 7 Pattern matching rules
7.1 Regular expression engines
76 7.2 Parenthesized language and preferment
7.2.1 Introduction to parenthesized language and preferment
77 7.2.2 Alternation
7.2.3 Concatenation
78 7.2.4 Quantification
79 7.2.5 Exclusion
80 7.2.6 Anchors
7.2.7 The empty pattern
7.2.8 Infinite repetitions of empty matches
82 7.3 Pattern matching in theory and practice

Related products

BS ISO/IEC 19075-5:2021
$215.11