O'Reilly logo

Getting Started with Oracle Event Processing 11g by Lloyd Williams, Robin J. Smith, Alexandre Alves

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

SQL as a foundation

You have learned how to transform a stream into a relation by using WINDOW operators, and then how to convert a relation back to a stream by using the ISTREAM/DSTREAM/RSTREAM family of operators. But why do we convert to relations to begin with? By converting streams to relations, you can leverage the full power of SQL, as we are used to it in a database. After all, SQL works directly on top of relations.

CQL supports most of the SQL99 commands, which we explore in this section.

Joins

In CQL, you can join multiple sources, but all sources must be relations or streams that have been converted to relations using a window operator.

Joins are very useful as a mechanism for enriching events with contextual data that don't change often. ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required