View

A reusable definition of a query, created using the CREATE VIEW command. In streaming SQL, views are similar to database views, but are compiled once and continue to process incoming data rows in real time. (Database views are compiled each time the query is executed.(media/condensed_create_view.png" align=“right) ) As with a database view, you can SELECT from a view. Because the view continues to process data, the results of SELECT from a view are the same as if the original query were run. A view is a schema object.

Usefulness of Views

Streaming views are like “macros” and are extremely useful for expanding a complex query in streaming SQL, more useful than they are in an RDBMS context.

While views are used in RDBMS systems, to implement joins or simplify access to a large table, they are used in more specific ways in= streaming SQL.

Because SQLstream s-Server is effective at listening to data at different points in a series of processing steps, chained views allow you to “listen” (SELECT) to data from one or more streams, foreign streams or views. Each view can perform filters, transformations, or analysis, and can produce results for “downstream” listeners.

Each named view is then available for other listeners–internal pipelines or external clients–to SELECT. This allows you to break down a complex business pipeline into easily understood chunks, which can be selected at any time.