General Concepts

<< Click to Display Table of Contents >>

Navigation:  Understanding Streaming SQL Concepts >

General Concepts

Previous pageReturn to chapter overviewNext page

Catalog -- A SQLstream catalog is the highest level repository object; it contains metadata and state information for the catalog objects (including streams, pumps and adapters) that comprise a SQLstream Repository.

See SQLstream Objects for the full set of object types.

Repository -- A persistent store for the SQLstream Catalog and native table data. By default, this is implemented with an embedded database, but it can be implemented with any relational database.

JDBC Driver -- The SQLstream JDBC driver, sometimes called the "client driver," enables external applications to connect to a SQLstream Control Node to establish a session for executing streaming SQL against a RAMP. Client applications can INSERT into streams or SELECT from streams or views. The driver uses SDP to communicate with the Control Node and RAMP.

Streaming Data Protocol -- Streaming Data Protocol (SDP) is a protocol for efficiently transmitting rows between nodes in an instance of a SQLstream s-Server. SDP is also used for transmission of data between client and server, for example as part of INSERT EXPEDITED.

s-Server -- The SQLstream runtime component that manages and executes SQLstream applications.

s-Studio -- SQLstream's user interface provides an Integrated Development Environment (IDE) for defining SQLstream objects and developing and testing streaming applications and queries (the Development tab) and an integrated console for monitoring the active sessions and statements within a running SQLstream s-Server (the Management tab).

s-Dashboard -- s-Dashboard is a browser-based interface for viewing s-Server schema objects: streams, views, or tables graphically. Dashboards are web pages that contain multiple panels, each of which can connect to a different stream, view, or table. Each panel contains a visualization.

StreamLab -- StreamLab is a web application development environment that automatically generates streaming SQL, which are known as "StreamApps." Using StreamLab's graphical interface, you can set up input streams for data, apply built-in analytics to this data, and create sinks for data for output to external locations.