درباره ما
ANSI INCITS 500
Information Technology – Database Language SQL – Row Pattern Recognition (SQL/RPR)
Organization:
ANSI - American National Standards Institute
Year: 2012
Abstract: INCITS 500-2012 specifies the syntax and semantics of database language facilities that support row pattern matching using regular expressions.
The database language facilities that support row pattern recognition include:
- A subset of regular expression syntax.
- Row pattern variables that span subsequences of rows, defined using conditions on individual rows and on aggregates of rows.
- A major new syntax element, the MATCH_RECOGNIZE clause, that can be applied to table expressions and can be used in definitions of windows.
The database language facilities that support row pattern recognition include:
- A subset of regular expression syntax.
- Row pattern variables that span subsequences of rows, defined using conditions on individual rows and on aggregates of rows.
- A major new syntax element, the MATCH_RECOGNIZE clause, that can be applied to table expressions and can be used in definitions of windows.
Collections
:
-
Statistics
ANSI INCITS 500
Show full item record
| contributor author | ANSI - American National Standards Institute | |
| date accessioned | 2017-09-04T18:15:54Z | |
| date available | 2017-09-04T18:15:54Z | |
| date copyright | 2012.10.16 | |
| date issued | 2012 | |
| identifier other | HLMXAFAAAAAAAAAA.pdf | |
| identifier uri | http://yse.yabesh.ir/std;query=autho470393FD081D544/handle/yse/198810 | |
| description abstract | INCITS 500-2012 specifies the syntax and semantics of database language facilities that support row pattern matching using regular expressions. The database language facilities that support row pattern recognition include: - A subset of regular expression syntax. - Row pattern variables that span subsequences of rows, defined using conditions on individual rows and on aggregates of rows. - A major new syntax element, the MATCH_RECOGNIZE clause, that can be applied to table expressions and can be used in definitions of windows. | |
| language | English | |
| title | ANSI INCITS 500 | num |
| title | Information Technology – Database Language SQL – Row Pattern Recognition (SQL/RPR) | en |
| type | standard | |
| page | 111 | |
| status | Active | |
| tree | ANSI - American National Standards Institute:;2012 | |
| contenttype | fulltext |