INCITS 500-2012 Information technology - Database Language SQL - Row Pattern Recognition (SQL/RPR)

standard by InterNational Committee for Information Technology Standards (formerly NCITS), 10/16/2012

Full Description

This standard specifies SQL language syntax and semantics that permit applications to identify row pattern matches by using extended regular expressions applied to rows of base and derived tables. A key component of this standard is the use of row pattern variables that span subsequences of rows, defined using conditions on individual rows and on aggregates of rows. The primary syntax element defined in this standard is the MATCH_RECOGNIZE clause, which is applied to table expressions.

Product Details

Published: 10/16/2012 ANSI: ANSI Approved Number of Pages: 111 File Size: 1 file , 630 KB