Overview

<< Click to Display Table of Contents >>

Navigation:  »No topics above this level«

Overview

Return to chapter overviewNext page

To get started using SQLstream Blaze, install SQLstream s-Server following the steps in the Installation Guide. s-Server installs with everything you need to view data visualizations, including s-Dashboard and the s-Server WebAgent. The installation guide also describes using the Mochi demo, which uses both of these tools to visualize an alert system for bank login failures. Once you have viewed the Mochi demo, you can install SQLstream StreamLab to start creating your own visualizations based on the Mochi data.

s-Server version 5.2 adds features for reading from and writing data to other systems, transforming data in s-Server, querying data, managing streams, and adding passwords to users. See Summary of 5.2 Features below.

SQLstream Blaze Documentation PDFs

Overviews

SQLstream Blaze Concepts

This guide offers an overview of SQLstream s-Server concepts including streams, the system architecture, application models. It also compares streaming SQL with RDMS SQL.


Tutorials

Installing SQLstream Blaze

This guide provides instructions on how to install SQLstream s-Server, SQLstream s-Studio, SQLstream client tools, and SQLstream StreamLab.

Building a Pipeline

This guide provides instructions for building a pipeline in s-Server.


Guides

Reading Data into s-Server

This guide describes how to read data into s-Server from the file system, network sockets, Apache Kafka topics, AMQP messages, Amazon Kinesis streams, RDBMS systems, and other sources.

Writing Data Out of s-Server

This guide describes how to write data from s-Server into the file system, network sockets, Apache Kafka topics, AMQP messages, Amazon Kinesis streams, RDBMS systems, and other locations

Transforming Data in s-Server

This guide describes how to transform data in s-Server, using SQL, User Defined Transforms and User Defined Functions.


Tools

Using StreamLab

This guide describes how to use StreamLab to parse, analyze, and display s-Server data graphically.

Using s-Studio

This document explains how to use SQLstream's integrated development environment, s-Studio, to parse, analyze, and output s-Server data.

Using s-Dashboard

This document describes how to use s-Dashboard to display s-Server data graphically.

Using SQLLine

This document explains how to use a customized version of a console based utility to execute SQL in s-Server.


Manuals

Streaming SQL Reference Guide

This guide offers comprehensive documentation of SQLstream s-Server streaming SQL, including the particular implementation of CREATE, ALTER, SELECT, and DROP statements.

Administrator Guide

This guide explains how to configure, maintain, and monitor s-Server once you have installed it.

Glossary

Defines key terms used for SQLstream s-Server.

New in 5.2

s-Server version 5.2 adds features for reading from and writing data to other systems, transforming data in s-Server, querying data, managing streams, and adding passwords to users.

Reading and Writing Data

You can now write from s-Server to Snowflake warehouses. See the topic Writing to Snowflake Warehouses.

You can now write from s-Server to MongoDB collections. See the topic Writing to MongoDB Collections.

You can now use s-Server to read and write data over HTTP.

You can also read and write data in and out of s-Server over WebSockets.

You can now parse Apache Avro files into s-Server. The Discover Parser will also identify Apache Avro files. See Using the Discovery Parser with Apache Avro in the Integration Guide.

You can now format files as BSON.

Transforming Data in s-Server

s-Server now incorporates machine learning systems such as SystemML and DataRobot. See Using s-Server for Machine Learning with Integrated Apache SystemML and Building a UDX with DataRobot.

You can now use run Kalman filters on streams of sensor data. A Kalman filter is a technique for sharpening the measurements produced by blurry sensors. See Using the Kalman Filter UDX.

Two new UDXes allow you to reconstruct missing rows from data streams. See Using the Linear Interpolation UDX and Using the Quadratic Interpolation UDX.

Matched Filter UDX. Allows you to evaluate a template against a signal, giving a correlation coefficient for how close the match was at any point within the signal.

A new built-in function, TSDIFF, lets you determine the difference between two timestamp expressions in miliseconds.

Querying Data in s-Server

s-Server now features offset and hopping windows.

Managing s-Server Objects

ALTER STREAM. ALTER STREAM lets you control data flowing through native streams, allowing you to pause streams temporarily or reset their stream clock. You can pause streams individually, or pause all streams in a schema, using any expression that refers to one or more streams.

ALTER USER. ALTER USER lets you add a password to a user, including the system administrator.