SQL

<< Click to Display Table of Contents >>

Navigation:  Glossary >

SQL

Previous pageReturn to chapter overviewNext page

An abbreviation for Structured Query Language. SQLstream uses a slightly modified version of SQL called streaming SQL. The type of SQL that runs in s-Server is called streaming SQL. This SQL is based on the SQL:2008 ANSI standard, with some modifications. s-Server' streaming SQL is described in the Streaming SQL Reference Guide.

SQLstream’s main enhancement to the SQL standard concerns the STREAM object. The process of creating streams in streaming SQL is similar to the process of creating tables in a database system like PostGres or Oracle. Like database tables, streams have columns with column types. Once you create a stream, you can query it with a SELECT statement, or insert into it using an INSERT statement.