Table of Contents
- Title and Copyright Information
- Preface
- What's New in This Guide
-
1
Introduction
to Oracle CQL
-
1.1
Fundamentals of Oracle CQL
- 1.1.1 Streams and Relations
- 1.1.2 Relation-to-Relation Operators
- 1.1.3 Stream-to-Relation Operators (Windows)
- 1.1.4 Relation-to-Stream Operators
- 1.1.5 Stream-to-Stream Operators
- 1.1.6 Queries, Views, and Joins
- 1.1.7 Pattern Recognition
- 1.1.8 Event Sources and Event Sinks
- 1.1.9 Table Event Sources
- 1.1.10 Table Event Sink
- 1.1.11 Cache Event Sources
- 1.1.12 Functions
- 1.1.13 Time
- 1.2 Oracle CQL Statements
- 1.3 Oracle CQL and SQL Standards
- 1.4 Oracle Event Processing Server
-
1.1
Fundamentals of Oracle CQL
- 2 Basic Elements of Oracle CQL
-
3
Pseudocolumns
- 3.1 Introduction to Pseudocolumns
-
3.2
ELEMENT_TIME Pseudocolumn
- 3.2.1 Understanding the Value of the ELEMENT_TIME Pseudocolumn
- 3.2.2 Using the ELEMENT_TIME Pseudocolumn in Oracle CQL Queries
- 3.3 ORA_QUERY_ID Pseudocolumn
-
4
Operators
- 4.1 Introduction to Operators
- 4.2 Arithmetic Operators
- 4.3 Concatenation Operator
- 4.4 Alternation Operator
- 4.5 Range-Based Stream-to-Relation Window Operators
- 4.6 Tuple-Based Stream-to-Relation Window Operators
- 4.7 Partitioned Stream-to-Relation Window Operators
- 4.8 User-Defined Stream-to-Relation Window Operators
- 4.9 IStream Relation-to-Stream Operator
- 4.10 DStream Relation-to-Stream Operator
- 4.11 RStream Relation-to-Stream Operator
- 5 Expressions
- 6 Conditions
-
7
Common Oracle
CQL DDL Clauses
- 7.1 Introduction to Common Oracle CQL DDL Clauses
- 7.2 array_type
- 7.3 attr
- 7.4 attrspec
- 7.5 complex_type
- 7.6 const_bigint
- 7.7 const_int
- 7.8 const_string
- 7.9 const_value
- 7.10 identifier
- 7.11 l-value
- 7.12 methodname
- 7.13 non_mt_arg_list
- 7.14 non_mt_attr_list
- 7.15 non_mt_attrname_list
- 7.16 non_mt_attrspec_list
- 7.17 non_mt_cond_list
- 7.18 out_of_line_constraint
- 7.19 param_list
- 7.20 qualified_type_name
- 7.21 query_ref
- 7.22 time_spec
- 7.23 xml_attribute_list
- 7.24 xml_attr_list
- 7.25 xqryargs_list
- 8 Built-In Single-Row Functions
- 9 Built-In Aggregate Functions
-
10
Colt Single-Row
Functions
- 10.1 Introduction to Oracle CQLBuilt-In Single-Row Colt Functions
- 10.1 beta
- 10.2 beta1
- 10.3 betaComplemented
- 10.4 binomial
- 10.5 binomial1
- 10.6 binomial2
- 10.7 binomialComplemented
- 10.8 bitMaskWithBitsSetFromTo
- 10.9 ceil
- 10.10 chiSquare
- 10.11 chiSquareComplemented
- 10.12 errorFunction
- 10.13 errorFunctionComplemented
- 10.14 factorial
- 10.15 floor
- 10.16 gamma
- 10.17 gamma1
- 10.18 gammaComplemented
- 10.19 getSeedAtRowColumn
- 10.20 hash
- 10.21 hash1
- 10.22 hash2
- 10.23 hash3
- 10.24 i0
- 10.25 i0e
- 10.26 i1
- 10.27 i1e
- 10.28 incompleteBeta
- 10.29 incompleteGamma
- 10.30 incompleteGammaComplement
- 10.31 j0
- 10.32 j1
- 10.33 jn
- 10.34 k0
- 10.35 k0e
- 10.36 k1
- 10.37 k1e
- 10.38 kn
- 10.39 leastSignificantBit
- 10.40 log
- 10.41 log10
- 10.42 log2
- 10.43 logFactorial
- 10.44 logGamma
- 10.45 longFactorial
- 10.46 mostSignificantBit
- 10.47 negativeBinomial
- 10.48 negativeBinomialComplemented
- 10.49 normal
- 10.50 normal1
- 10.51 normalInverse
- 10.52 poisson
- 10.53 poissonComplemented
- 10.54 stirlingCorrection
- 10.55 studentT
- 10.56 studentTInverse
- 10.57 y0
- 10.58 y1
- 10.59 yn
-
11
Colt Aggregate
Functions
- 11.1 Introduction to Oracle CQL Built-In Aggregate Colt Functions
- 11.1 autoCorrelation
- 11.2 correlation
- 11.3 covariance
- 11.4 geometricMean
- 11.5 geometricMean1
- 11.6 harmonicMean
- 11.7 kurtosis
- 11.8 lag1
- 11.9 mean
- 11.10 meanDeviation
- 11.11 median
- 11.12 moment
- 11.13 pooledMean
- 11.14 pooledVariance
- 11.15 product
- 11.16 quantile
- 11.17 quantileInverse
- 11.18 rankInterpolated
- 11.19 rms
- 11.20 sampleKurtosis
- 11.21 sampleKurtosisStandardError
- 11.22 sampleSkew
- 11.23 sampleSkewStandardError
- 11.24 sampleVariance
- 11.25 skew
- 11.26 standardDeviation
- 11.27 standardError
- 11.28 sumOfInversions
- 11.29 sumOfLogarithms
- 11.30 sumOfPowerDeviations
- 11.31 sumOfPowers
- 11.32 sumOfSquaredDeviations
- 11.33 sumOfSquares
- 11.34 trimmedMean
- 11.35 variance
- 11.36 weightedMean
- 11.37 winsorizedMean
-
12
java.lang.Math
Functions
- 12.1 Introduction to Oracle CQL Built-In java.lang.Math Functions
- 12.1 abs
- 12.2 abs1
- 12.3 abs2
- 12.4 abs3
- 12.5 acos
- 12.6 asin
- 12.7 atan
- 12.8 atan2
- 12.9 cbrt
- 12.10 ceil1
- 12.11 cos
- 12.12 cosh
- 12.13 exp
- 12.14 expm1
- 12.15 floor1
- 12.16 hypot
- 12.17 IEEEremainder
- 12.18 log1
- 12.19 log101
- 12.20 log1p
- 12.21 pow
- 12.22 rint
- 12.23 round
- 12.24 round1
- 12.25 signum
- 12.26 signum1
- 12.27 sin
- 12.28 sinh
- 12.29 sqrt
- 12.30 tan
- 12.31 tanh
- 12.32 todegrees
- 12.33 toradians
- 12.34 ulp
- 12.35 ulp1
- 13 User-Defined Functions
-
14
Oracle CQL Queries,
Views, and Joins
- 14.1 Introduction to Oracle CQL Queries, Subqueries, Views, and Joins
-
14.2
Queries
- 14.2.1 Query Building Blocks
- 14.2.2 Simple Query
- 14.2.3 Built-In Window Query
- 14.2.4 User-Defined Window Query
- 14.2.5 MATCH_RECOGNIZE Query
- 14.2.6 Relational Database Table Query
- 14.2.7 XMLTABLE Query
- 14.2.8 Function TABLE Query
- 14.2.9 Cache Query
- 14.2.10 Sorting Query Results
- 14.2.11 Detecting Differences in Query Results
- 14.2.12 Parameterized Queries
- 14.2.13 Subqueries
- 14.3 Views
- 14.4 Joins
- 14.5 Oracle CQL Queries and the Oracle Event Processing Server Cache
- 14.6 Oracle CQL Queries and Relational Database Tables
- 14.7 Oracle CQL Queries and Oracle Data Cartridges
-
15
Pattern Recognition
With MATCH_RECOGNIZE
-
15.1
Understanding Pattern Recognition With MATCH_RECOGNIZE
- 15.1.1 MATCH_RECOGNIZE and the WHERE Clause
- 15.1.2 Referencing Singleton and Group Matches
-
15.1.3
Referencing Aggregates
- 15.1.3.1 Running Aggregates and Final Aggregates
- 15.1.3.2 Operating on the Same Correlation Variable
- 15.1.3.3 Referencing Variables That Have not Been Matched Yet
- 15.1.3.4 Referencing Attributes not Qualified by Correlation Variable
- 15.1.3.5 Using count With *, identifier.*, and identifier.attr
- 15.1.3.6 Using first and last
- 15.1.4 Using prev
- 15.2 MEASURES Clause
- 15.3 PATTERN Clause
- 15.4 DEFINE Clause
- 15.5 PARTITION BY Clause
- 15.6 ALL MATCHES Clause
- 15.7 WITHIN Clause
- 15.8 DURATION Clause
- 15.9 INCLUDE TIMER EVENTS Clause
- 15.10 SUBSET Clause
- 15.11 MATCH_RECOGNIZE Examples
-
15.1
Understanding Pattern Recognition With MATCH_RECOGNIZE
- 16 Oracle CQL Statements