- ! -

!properties

- A -

About StreamLab

AbstractBaseUdx

Accessing Foreign Data

Adapter and SQL/MED parameters

Adapter for log4j

Converting Log Messages to Stream Data

Dynamic Logger Creation

Error Handling

Logging Levels

Modes of Operation

Adapters

Extensible Common Data Adapter

IconReading from Kafka
IconReading from IBM MQ
IconReading from Kinesis
IconWriting to Kafka
IconExtensible Common Data Adapter: Writing CSV files
IconExtensible Common Data Adapter: Writing XML Files

Parameters

Reading from IBM MQ

Reading from Kafka

Reading from Kinesis

Reading Kafka Input

Reading Kinesis Input

Writing CSV Files

IconWriting to Kafka
IconExtensible Common Data Adapter: Writing CSV files

Writing XML Files

IconWriting to Kafka
IconExtensible Common Data Adapter: Writing XML Files

Add Count

Adding a Guide

Adding a Line Source

Adding a Local Log File Source

IconAdding an RSS/Atom Source
IconAdding a Local Log File Source

Sampling Data from Source

Adding a Source

Adding a Stream Source

Adding a Table Source

Adding a View Source

Advanced Message Queuing Protocol

Agents

ECDA

IconReading Files in Remote Locations
IconUsing a Custom Filter with ECDA Agent
IconUsing a Custom Filter to Eliminate Invalid Rows
IconWriting Files to Remote Locations

Using a Custom Filter

IconUsing a Custom Filter with ECDA Agent
IconUsing a Custom Filter to Eliminate Invalid Rows

Aggregate Functions

AVG (Average)

COUNT

MAX

MIN

Population Standard Deviation

Statistical Variance and Deviation

IconStatistical Variance and Deviation Functions
IconSTDDEV_POP 

STD_DEV

STDDEV_SAMP

SUM

VAR_POP

VAR_SAMP

Aggregation

Aggregations

Amazon EC2

IconUsing the AWS Marketplace SQLstream Blaze AMI
IconInstalling the SQLstream AMI

Amazon Kinesis

Writing to from s-Server

Amazon Services

IconSQLstream s-Server Licensing
IconUsing the AWS Marketplace SQLstream Blaze AMI
IconInstalling the SQLstream AMI

AMI

IconSQLstream s-Server Licensing
IconUsing the AWS Marketplace SQLstream Blaze AMI
IconInstalling the SQLstream AMI

AMQP

Writing to from s-Server

AMQP Adapter

IconPlugins 
IconAMQP Adapter 

AMQP Writer

Analytic Functions

AVG (Average)

COUNT

MAX

MIN

Population Standard Deviation

Statistical Variance and Deviation

IconStatistical Variance and Deviation Functions
IconSTDDEV_POP 

STD_DEV

STDDEV_SAMP

SUM

VAR_POP

VAR_SAMP

Apache Kafka

Writing to from s-Server

Application

Promotion

Application Model

ApplicationTrace.log

Apply Rank

Archiving with Databases

Arranging Panels

aspen.config

aspen.custom.properties

IconConfiguring SQLstream 
IconNetwork Configuration for SQLstream 

aspen.properties

aspen.sdp.blocksize

aspen.sdp.linkTimeoutMs

aspen.sdp.mtu

aspen.sdp.pingTimerMs

aspen.sdp.port

aspen.sdp.rxblocksize

aspen.sdp.throwOnProtocolError

Atom feeds

Adding

Adding as Source

autoCommit

and the JDBC driver

Average

IconAggregate
IconAVG 
IconBucketize

Avro Data

Parsing

- B -

Backups

and Code Control

Bar Graph

Bars and Lines

Basic Building Blocks

Best Practices

Big Query Connector

BIGINT

BINARY

Blocking

and the JDBC driver

Bollinger Bands

Dashboard

Visualization Panel

BOOLEAN

Bouncing Bar Graph

Browser Interface

for webAgent

Browsing Object Definitions

IconUsing SQLstream s-Studio
IconUsing SQLstream s-Studio
IconUsing s-Studio

BSON Files

Writing with the ECDA

- C -

cachePagesInit

cachePageSize

cachePagesMax

cacheReservePercentage

calcVirtualMachine

Canceling Statements

and the JDBC driver

Cannot Connect to s-Server

CASE expression

IconExpressions and Literals 
IconSELECT clause

CASE Syntax Chart

IconSELECT statement 
IconSELECT clause

CAST

Catalog

IconGeneral Concepts 
IconRunning the Mochi Demo
IconThe Mochi Demo
IconThe Hamachi Demo
IconThe Mochi Demo

Catalog Navigator

Catalog Objects

Foreign Data Wrapper

Pump

Schema

Server

Catalogues

and Checkpoints

CDR (Call Data Records)

Cells

Selecting

Change Column Name

Changing Column Type

Changing tracing levels

CHAR (n)

And unicode support

Character (string) expressions

CHARACTER SETs

Checking Source Data

checkpointInterval

Choosing a Dashboard

class Driver

Client Application Threads

and the JDBC driver

Client Tools

IconInstalling SQLstream Client Tools
IconUninstalling Client Tools in a Standalone Installation

Contents

Datagen

File Writer Agent

Log File Agent

Network Socket Agent

Sqlline

Uninstalling

ClientTrace.properties

Closing SQLstream s-Studio

Code Control

Code Structure for Implementing Plugins

codeCacheMaxBytes

Color Coding

Column Color Coding

Columns

Converting Empty Cells to Null

Extracting

Splitting

command-line installation

Commands

Add Count

Aggregate

Analytics

IconAnalytics
IconAggregate
IconRunning Average
IconBucketize

Basic

IconBasic
IconAdd Count
IconCast
IconDrop
IconExtract
IconMerge Columns
IconRename
IconRename Column
IconReplace Nulls
IconSplit
IconUse Null

Bucketize

CAST

CDR

DROP

Extract

Merge Columns

Parsers

IconParsers
IconRegex Split
IconParse W3C Log
IconParse CDR
IconParse Timestamp

Regex

Rename Columns

Rename List of Columns

Replace nulls

Running Average

Split Columns

Timestamp

Using Null

W3C

Compiling the UDX

Compound Identifiers

Concatenation

Configuring

Java Parameters

Repository Parameters

Configuring Data Sources

Configuring JDBC Driver Connections from Other Hosts

Conjunction (AND)

Connect to foreign data source

Connecting s-Server to a Web Server

IconUsing s-Server over the Internet
IconwebAgent
IconRunning webAgent
IconUsing s-Server over the Internet

webagentd

Connecting to a Generic Database

Connecting to a MySQL Database

Connecting to a Paracel Database

Connecting to a PostgreSQL Database

Connecting to a SQL Server Database

Connecting to a Terradata Database

Connecting to a Vectorwise Database

Connecting to an Oracle Database

Connecting to Data Sources Outside of s-Server

Connecting to Databases

Connection Pools

Limited Use in s-Server

Connection.getMetaData

Connection.setAutoCommit

console.log

Control Streams

Convert nulls to blank

Convert nulls to zero

Correctness Mode

Count

IconAggregate
IconBucketize

and GROUP BY

and WINDOW

COUNT(DISTINCT)

CPU

Icons-Server Requirements 
IconRequirements 

CREATE FUNCTION

Create new column by extracting old column

Create Server

Creating a New  StreamLab Project

Creating a New Dashboard

Creating a New StreamLab Project

Creating a stream out of a remote database table

Creating Multiple-Panel Dashboards

Creating Project

Creating SQL Objects

CSV (Comma Separated Values) Data

Parsing

CSV Files

Writing with the ECDA

IconWriting to Kafka
IconExtensible Common Data Adapter: Writing CSV files

Custom Dashboards

Bar Graph

Bars and Lines

Bollinger Bands

Bouncing Bar Graph

Map and Table

IconMap and Table Dashboard
IconGeographical Stream Panels

Parallel Coordinates

Scatter Matrix

Time Series

Customizing Data Parsing

Customizing Map Icons

- D -

Dashboards

Locking

Opening

Dashboards Home Page

IconUsing the Dashboards Home Page
IconUsing the Dashboards Home Page

Data and s-Dashboard

Data and wallclock time

data engine

Data processing

Troubleshooting

Data Sources

Foreign Streams

Data time

Data Types

Database

Restoring

databaseIncrementSize

databaseInitSize

databaseMaxSize

DatabaseMetaData.XXX

Databases

Connecting to

Inserting into

Selecting from

databaseShadowLogIncrementSize

databaseShadowLogInitSize

databaseTxnLogIncrementSize

databaseTxnLogInitSize

Datagen

IconGenerating Test Data with DataGen
IconGenerating Test Data with DataGen
IconList of Client Tools

Datagen XML files

IconGenerating Test Data with DataGen
IconGenerating Test Data with DataGen

DATE

Date / Time Expressions

Date and Time Patterns

DEC

DECIMAL

Declaring UDXs in s-Server

Default Server Hostname

Define a TableLookup UDX Control Stream

Delays

Demo Applications

Running

Demonstration Application

IconRunning the Mochi Demo
IconThe Mochi Demo
IconThe Hamachi Demo
IconThe Mochi Demo

Developing Panels

Development Environment

Development Pane

Development Practice

deviceSchedulerType

Dials

Differences from RDBMS tables

Directories

Discarded rows

Discovery

DISTINCT

Docker Container

DOUBLE

DOUBLE PRECISION

Downstream Operations

DriverManager.getConnection

DROP

- E -

EC2

IconSQLstream s-Server Licensing
IconUsing the AWS Marketplace SQLstream Blaze AMI
IconInstalling the SQLstream AMI

ECDA

Dynamically Configuring Properties

IconUsing the Options Query Property
IconUsing the Options Query Property

File Parsing Options

File Writing Options

Over HTTP

Over WebSockets

PARSE_ERROR

PARSE_LINE_NUMBER

PARSE_POSITION

Parsing Files

Reading from the File System

Using MAX_BYTES_PER_FILE

Using MAX_FILENAME_DELTA

Writing over Sockets

Writing to AMQP

Writing to Files

ECDA Agent

IconReading Files in Remote Locations
IconWriting Files to Remote Locations

Using a Custom Filter

Using a Custom Filter to Eliminate Invalid Rows

Eclipsed Rowtime Bounds

Edamame

IconRunning Demo Applications
IconThe Edamame Demo

Edamame Demo

Installing and Configuing Tomcat

Resetting

Restarting

Running

Eliminating Invalid Rows

with ECDA Agent

Enabling webAgent Application with webagentd

Enabling Writing to webAgent with webagentd

Enclosing a Frame within a Layout

Encrypting Communication for s-Server

Examples

IconRunning the Mochi Demo
IconThe Mochi Demo
IconThe Hamachi Demo
IconThe Edamame Demo
IconNotes on Installing and Configuring Tomcat
IconThe Mochi Demo

expectedConcurrentStatements

Exporting a Dashboard's URL

Expressions

CASE

Character

Date/Time

Interval

Numeric

Extensible Common Data Adapter

Dynamically Configuring Properties

IconUsing the Options Query Property
IconUsing the Options Query Property

Fast Regex

File Parsing Options

File Reader

File Writing Options

Mail Server

MongoDB

OPTIONS_QUERY

IconUsing the Options Query Property
IconUsing the Options Query Property

PARSE_ERROR

PARSE_LINE_NUMBER

PARSE_POSITION

Parsing Avro Data

Parsing CSV (Comma Separated Values) Data

Parsing Files

Parsing Fixed Column Log Data

Parsing Google ProtoBuf Data

Parsing JSON Data

Parsing Key Pair Values

Parsing Variable Column Log Data

Parsing W3C Log Data

Parsing XML Data

Reading Avro Data

Reading CSV (Comma Separated Values) Data

Reading Fixed Column Log Data

Reading Google ProtoBuf Data

Reading JSON Data

Reading Key Pair Values

Reading Variable Column Log Data

Reading W3C Log Data

Reading XML Data

Socket Writer

Using MAX_BYTES_PER_FILE

Using MAX_FILENAME_DELTA

Using the Options Query

IconUsing the Options Query Property
IconUsing the Options Query Property

Writing BSON Files

Writing JSON Files

IconWriting to Kafka
IconExtensible Common Data Adapter: Writing JSON Files

Writing over the File System

Writing to

Writing to AMQP

Writing to Files

Writing to HTTP

Writing to IBM MQ

Writing to Kafka

Writing to Kinesis

Writing to MongoDB

Writing to Network Sockets

Writing to Snowflake

Writing to Web Sockets

Extensible Common Data Adapter Parsers

PARSE_ERROR

PARSE_LINE_NUMBER

PARSE_POSITION

Extensible Common Data Adapter(ECDA)

DIRECTORY

IconReading from the File System
IconECD Adapter and Agent: File System

ESCAPE_<column name>

IconReading from the File System
IconECD Adapter and Agent: File System

FILENAME_DATE_FORMAT

IconReading from the File System
IconECD Adapter and Agent: File System

FILENAME_PATTERN

IconReading from the File System
IconECD Adapter and Agent: File System

FILENAME_PREFIX

IconReading from the File System
IconECD Adapter and Agent: File System

FILENAME_SUFFIX

IconReading from the File System
IconECD Adapter and Agent: File System

MAX_BYTES_PER_FILE

IconReading from the File System
IconECD Adapter and Agent: File System

MAX_TIME_DELTA_PER_FILE

IconReading from the File System
IconECD Adapter and Agent: File System

ORIGINAL_FILENAME

Reading and Writing over the File System

Writing to AMQP

Writing to Sockets

Extensible Common Data Agent

File Writing Options

Using MAX_BYTES_PER_FILE

Using MAX_FILENAME_DELTA

Writing to Files

Extensible Common Data Framework

And Hadoop

Extension operators (UDF, UDX, Transform Plugins)

Extensions to SQL standard

OVER clause

ROWTIME system function, significance of

STREAM keyword

Windowed queries

External Databases

Looking Up

Extract

Extract string based on Regex

Extract string of length

Extract string using SQL regular expression

- F -

Failure scenarios

FAST_REGEX_LOG_PARSE

IconSystem-Defined Log-Parsing Functions
IconFAST_REGEX_LOG_PARSE

FAST_REGEX_LOG_PARSER

fennelDisabled

File System

Writing to from s-Server

File System, Sockets, AMQP, Kafka topics, HTTP, IBM MQ, Web Feed

File Writer Agent

FileWriter Adapter

FIleWriter Agent

Filtering

Find and replace string

Finding the Maximum Value

Finding the Minimum Value

Firewalls and s-Server

First SQLstream s-Server

First SQLstream s-Server Connection

Fixed Column Log Data

Parsing

FLOOR

FLUSH_CODE_CACHE

Foreign Data Wrappers

Creating

FOREIGN SERVER OPTIONS

Foreign Servers

and Adapters

Foreign Streams

and Adapters

Foreign Tables

Creating

FROM clause

Fulfillment Demo Application

Functions

Aggregate

Analytic

Scalar

- G -

GENERATE_DDL_FOR_JAR

GENERATE_DDL_FOR_SERVER

GENERATE_DDL_FOR_USER

Generating Test Data with Datagen

IconGenerating Test Data with DataGen
IconGenerating Test Data with DataGen

Geolocation example

GET_KEYWORDS

GET_OBJECT_DDL

Getting Data from External Databases

Getting Data from TCP or UDP

Getting Data into StreamLab

Getting Started

Sample Projects

Goals

Google ProtoBuf Data

Parsing

GoogleGeoCode UDF

Group Rank UDX

groupCommitInterval

Guide Commands

Guides

Adding

Commands

IconStreamLab Guides Overview
IconGuide Commands

Opening

Overview

Sample process

Switching sources

Throttling Sources

Using

Viewing SQL

Workflow

IconUsing a Guide Overvew
IconSample Guide Process

- H -

Hadoop

Writing to from s-Server

Hamachi

Hamachi demo

HAVING clause

in streaming queries

HDFS

HISTOGRAM_BARS_VIEW

HISTOGRAMS_VIEW

Hive

hostname -i

HTTP

IconUsing s-Server over the Internet
IconwebAgent
IconRunning webAgent
IconUsing s-Server over the Internet

Reading into s-Server

Writing to from s-Server

HTTP Writer

- I -

IBM MQ

Reading into s-Server

Writing to

Identifiers

Compound

Simple

Import and Export Queries and Results

Injecting Data into Streams

--input

IconReading Files in Remote Locations
IconWriting Files to Remote Locations

Input stream

Viewing

Inspecting Stream Contents

Install Logs

Installation Directories

Installer

Microsoft SQL Server JDBC Driver

Oracle JDBC Driver

Select Components

Server User

Service/Daemon

Installing

command-line

text mode

Installing as sudo vs. as Regular User

Installing as Sudo/Root vs. Installing as a Regular User

Installing Behind a Firewall

Installing Client Tools

Default Server Hostname

Directories

Select Components

Installing StreamLab

IconInstalling SQLstream StreamLab
IconInstalling Streamlab

Installing with a Trial License Behind a Firewall

INT

INTEGER

Integrating Dashboards into an Existing Web Page

Interpanel Communication

INTERVAL

Interval Expressions

Interval Operations

Intervals

--io

IconReading Files in Remote Locations
IconWriting Files to Remote Locations

IS DISTINCT FROM

IS NOT DISTINCT FROM

IS NOT NULL

IS NOT UNKNOWN

IS NULL

- J -

Java

Icons-Server Requirements 
IconRequirements 

Java Code and SSL

Java DataBase Connectivity

Java Naming Directory Interface

Java parameters

Configuring

IconConfiguring SQLstream 
IconJava Parameters

Overrriding

IconConfiguring SQLstream 
IconJava Parameters

Parameter substitution

IconConfiguring SQLstream 
IconJava Parameters

Substituting

Java Regular Expressions

and Parsing

Java UDFs

Calling from SQL UDFs

Java View

java.sql.PreparedStatement

java.sql.ResultSet

JAVA_HOME

JDBC

and Connection Pools

and Rowtime Bounds

JDBC and SSL

JDBC API

and UDXes

JDBC Driver

and Failure Scenarios

Configuring

SDP Requirements

JDBC INSERTs

and the Edamame Demo

JDBC URI

JDK

Icons-Server Requirements 
IconPreparing to Install 
IconRequirements 

JDK compatibility

JNDI

jniHandleTraceFile

JOIN clause of SELECT statement\

Join limitations

Joins

JSON Data

Parsing

JSON Files

Writing with the ECDA

IconWriting to Kafka
IconExtensible Common Data Adapter: Writing JSON Files

JVM

- K -

Kafka

Reading with the ECDA

Key Pair Values

Parsing

Keywords

KILL_SESSION

KILL_STATEMENT

KILL_STATEMENT_MATCH

Kinesis streams

Reading into s-Server

- L -

Late rows

Legacy Adapters

Legacy Agents

libuuid

Licensing

and Threads

and Throttle Mode

LIKE patterns

Line

Adding

Adding as Source

Linking Panel Data

Linux

Icons-Server Requirements 
IconRequirements 

Local data wrapper

Local Data Wrappers

Creating

Lock Icon

IconLocking Dashboards
IconLocking Dashboards

Locking Dashboards

IconUsing the Dashboards Home Page
IconLocking Dashboards
IconUsing the Dashboards Home Page
IconLocking Dashboards

Log File Adapter

and the Edamame Demo

CREATE FOREIGN DATA WRAPPER

Limitations

Relevant Commands

Schema Definitions

Log File Adapter Stream Options

Log File Agent

IconLog File Agent
IconList of Client Tools

Log Files

Adding

Adding as Source

Parsing

Parsing with FastRegex

Log4j

Configuring for sink streams and errors

Configuring for Source Streams

Fields

Receiving logs from a SocketReceiver

log4j Adapter

Configuration Parameters

Field parameters for columns in streams

Stream Options

LSB

Icons-Server Requirements 
IconRequirements 

- M -

Mail Adapter

and Header Fields

and Mapping Message Elements to Columns

and the Edamame Demo

Configuration Issues

Error Handling

Sending Mail

SQL Syntax

Managing aspen.custom.properties when installing a new version

Managing Memory Use

Managing Streaming Data in s-Server

Map and Table

IconMap and Table Dashboard
IconGeographical Stream Panels

Mapping Data

IconRunning the Mochi Demo
IconThe Mochi Demo
IconThe Mochi Demo

Memory

Icons-Server Requirements 
IconRequirements 

Merge Columns

MERGE statement

Merging Streams

and Rowtime Bounds

MESSAGE column

Microsoft SQL Server JDBC Driver

Mochi demo

IconRunning the Mochi Demo
IconThe Mochi Demo
IconThe Mochi Demo

mode text

Monitoring views

Moving Data Through s-Server

Multiple NIC cards

- N -

Naive Bayes

Named Streams

and Rowtime Bounds

Negation (NOT)

Network Socket Adapter

Network Socket Agent

Network Sockets

Writing to

New Project

Nodes

Normalizing source and destination IP addresses

NSAgent

Options

Parameters

Null values

Converting to

NUMERIC

Numeric expressions

- O -

Objects

DDL

Objects within a Schema

OBJECTS_IN_USE_VIEW

Online Documentation

Opening a Guide

Opening Dashboards

Opening SQLstream s-Studio

Oracle JDBC Driver

Organizing .sql files

--output

IconReading Files in Remote Locations
IconWriting Files to Remote Locations

Output rowtimes

Output to XML File

Output View

Outputting to File

OVER clause

Overriding Java parameters

- P -

PAGE_COUNTS_VIEW

Pan & Zoom Map visualization panel

Pan and Zoom

Panels

Development Process

Overview

Panels and Data

Panels Overview

Parallel Coordinates

Parsers

CDR

Parsing

Regex

W3C

Parsing Avro Data

Parsing CSV (Comma Separated Values) Data

Parsing Files

With ECDA (Extensible Common Data Adapter)

Parsing Fixed Column Log Data

Parsing Google ProtoBuf Data

Parsing JSON Data

Parsing Key Pair Values

Parsing Log File Records

FIXED_COLUMN_LOG_PARSE

SYS_LOG_PARSE

VARIABLE_COLUMN_LOG_PARSE

W3C_LOG_PARSE

Parsing Log Files

and Fast Regex

and Regex

Parsing URIs

Parsing Variable Column Log Data

Parsing W3C Log Data

Parsing XML

Parsing XML Data

Perl

and JDBC Driver

IconJDBC Driver and Perl
IconJDBC Driver and Perl

Pipe-Delimited Files

Pipelines

Troubleshooting

Plugins

IconPlugins
IconPlugins 

Port Adjustments

Preference Settings

SQLLine

PreparedStatement

Prevent Users from Modifying Layout

IconLocking Dashboards
IconLocking Dashboards

Procedures

Calling

Processing

Processing Pipelines

IconApplication Design Considerations 
IconUsing Pumps to Create Processing Pipelines

Project Settings

Scrutinizer

Projects

and StreamLab menu

Creating

Generating SQL

Overview

Sample

Saving

Switching

Promoting a SQLstream application

Promoting Data Time to ROWTIME

--props

IconReading Files in Remote Locations
IconWriting Files to Remote Locations

Protecting Dashboards

IconLocking Dashboards
IconLocking Dashboards

Publishing Dashboards

Integrating into an Existing Web Page

Pumps

IconApplication Design Considerations 
IconPumps, Streams, and Processing Pipelines

Overview

Starting

Stopping

- Q -

Queries

and Time

Troubleshooting

IconApplication Design Considerations 
IconPumps, Streams, and Processing Pipelines

Queries on Streams

Feeding with Pumps

Queries that Run Forever

query engine

Query Examples

Service Level Agreement

IconService Level Agreement 
IconService Level Agreement 

Query Patterns

IconQuery Patterns 
IconQuery Patterns 

Query that aggregates a stream

Query Time

and Correctness Mode

Querying Streams

Factors Causing Delay

IconTime and Streaming Data 
IconTime and Streaming Data 

- R -

RAM Management System (RAMMS)

and RDBMS

RDBMS Databases

Connecting with SQLLine

Reading Avro Data

Reading CSV (Comma Separated Values) Data

Reading Data

Input Formats

Reading External Databases

Reading Fixed Column Log Data

Reading from IBM MQ

Reading from Kafka

Reading from Other Sources

AMQP

File System

HTTP

IBM MQ

Sockets

Web Feeds

WebSockets

Reading Google ProtoBuf Data

Reading JSON Data

Reading Kafka Input

Reading Key Pair Values

Reading Kinesis Input

Reading Syntax Diagrams

Reading system parameters

Reading Variable Column Log Data

Reading W3C Log Data

Reading XML Data

REAL

Reduce Business Latency

REGEX

IconFAST_REGEX_LOG_PARSE
IconFAST_REGEX_LOG_PARSER

Using with find and replace function

Regex Parsing

IconRegex Split
IconParse W3C Log

REGEX_LOG_PARSE

IconSystem-Defined Log-Parsing Functions
IconREGEX_LOG_PARSE 

Relational Asynchronous Message Processor

Relational Asynchronous Messaging (RAM)

About

Relational Operators

and Rowtime Bounds

Remote database tables

Querying

Streaming

Tailing

Remove Column from View

Rename Column

Rename List of Columns

Repository

Configuring Parameters

Parameters

Repository Parameters

Configuring

REPOSITORY_INTEGRITY_VIOLATIONS()

REPOSITORY_PROPERTIES_VIEW

Reserved Words and Keywords

resourceDir

Rolling windows

Rotating Log Support

Row parse functions using views and tables

ROW_COUNTS_VIEW

Row-by-Row Operators

and Rowtime Bounds

Rows

Splitting Trains of

ROWTIME

and Relational Operators

Data Time

Explicit

Implicit

Queries

Troubleshooting

IconTime and Streaming Data 
IconTime and Streaming Data 

Rowtime  Bounds

and Merged Trains of Rows

and Merging

and Split Trains of Rows

Eclipsed

Semantics of

Setting Explicitly

rowtime bound

Rowtime Bounds

IconRowtime Bounds
IconWhat are Rowtime Bounds? 
IconRowtime Bounds API 
IconIntroducing SQLstream 

and JDBC

and Relational Operators

Rowtime bounds and UDXes

ROWTIME operator

ROWTIME system function, significance of

Rowtimes

--rowType

IconReading Files in Remote Locations
IconWriting Files to Remote Locations

RSS feeds

Adding

Adding as Source

Running Average

Running Count

Adding

Running Multiple Instances of s-Server on the Same System

IconAppendix: Running Multiple Instances of s-Server
IconRunning Multiple Instances of s-Server

Running SQLstream Blaze as a Virtual Hard Disk

s-Dashboard

StreamLab

The Mochi Demo

Running SQLstream Blaze as a Virtual Machine Appliance

s-Dashboard

StreamLab

The Mochi Demo

Running s-Server as a Service

IconInstalling s-Server
IconAppendix: Managing s-Server as a Service
IconManaging s-Server as a Service

- S -

Sample 5 Rows from Source

Sample Guide Process

Sampling Data from Source

Saving

Saving Projects

Saving ROWTIME to "normal" column

Scatter Matrix

Schema Objects

Foreign Stream

Foreign Table

Functional Objects

Stream

Table

User Defined Transform

User-Defined Function

User-Defined Routine

View

--schemaName

IconReading Files in Remote Locations
IconWriting Files to Remote Locations

Schemas

Creating

Dropping

Scripts

and Views

Scrutinizer

Other Settings

Toggling

IconManaging the Scrutinizer
IconTurning off the Scrutinizer

Turning off

IconManaging the Scrutinizer
IconTurning off the Scrutinizer

s-Dashboard

IconUsing the AWS Marketplace SQLstream Blaze AMI
IconInstalling the SQLstream AMI

Demo Applications

IconRunning the Mochi Demo
IconThe Mochi Demo
IconThe Mochi Demo

SDK

Writing UDF

Writing UDXs

SDP, Streaming Protocol

sdpListenerPort

Seeing Mail as Stream Data

SELECT

Join clause

Select Components

IconInstalling s-Server
IconInstalling SQLstream Client Tools

SELECT statement

FROM clause

Send a Link to a Dashboard

SEQUENCES_VIEW

Server and Host Issues for Development and Test Machines

Server Certificates and s-Server

Server Type

Server User

Servers

Creating

Service/Daemon

Session Management

Administrative Commands

Client Commands

Transactional Commands

SESSION_PARAMETERS_VIEW

SESSIONS_VIEW

SET CATALOG

SET PATH

SET SCHEMA

setRowtimeBound

Setting and Getting Rowtime Bounds

and the JDBC driver

Sharing a Dashboard with Another User

Sharing Dashboards

Integrating into an Existing Web Page

Shutting down s-Server

and Backups

SIMILAR TO patterns

SIMILAR TO Table

Simple Identifiers

Sinks

External Data Stream

Slowing Source Flow

Slowing Sources

SMALLINT

SMTP Mail Stream Column Options

Snowflake

Writing to

Sources

Adding

And streams

Overview

Switching within guide

Throttling

Splitting columns

SQL

Viewing

Viewing for Guides

SQL comments

DESCRIPTION

SQL definitions

SQL Files

Organizing

SQL JOIN

SQL View

SQL WHERE

SQL/MED

and Adapters

Creating a Foreign Stream

JDBC drivers

JDBC Foreign Data Wrapper

JDBC Foreign Server Definition

JDBC Foreign Table Definition

JDBC Metadata Import

Parameters

Querying JDBC Foreign Tables

Tailing a Remote Database Table

SQL/MED Plugin for JDBC

Microsoft SQL Server

MySQL

Oracle

PostgreSQL

Teradata

SQL:2008

Extensions

Sqlline

Command Set

Commands

Configuing

Configuration Preference Settings

Scripts

Starting

Using to Connect to Databases

SQLLine Commands

SQLLINECLIENT

sqllineRemote

and JDBC

IconUsing sqlLineRemote to Connect to a Database
IconUsing sqlLineRemote to Connect to a Database

SQLstream Blaze

Running in Docker

SQLstream Blaze AMI

SQLstream Blaze Components

Client Tools

s-Dashboard

s-Server

s-Studio

StreamLab

WebAgent

SQLstream Blaze Trial AMI

SQLstream Blaze Trial VHD Appliance

SQLstream Blaze Trial VM Appliance

SQLstream Data Types

SQLstream JDBC driver

IconSQLstream JDBC Driver
IconExtensions to JDBC API

SQLstream repository

SQLstream Software Development Kit

SQLstream s-Server

and Failure

SQLstream s-Server Licensing

SQLstream s-Server terminal window

Stopping the SQLstream s-Server

SQLstream s-Studio

s-Server

and Licensing

and RDBMS

IconApplicationModel 
IconIntroducing SQLstream 

and Rowtime Bounds

and Shutting Down

Application Model

Comparable Systems

Conceptual Analogies

Configuration Properties

Configuring

Confirm running

Connecting

Examples

IconRunning the Mochi Demo
IconRunning Demo Applications
IconThe Mochi Demo
IconThe Hamachi Demo
IconThe Edamame Demo
IconThe Mochi Demo

General Concepts

installing

Maintenance

Managing and Monitoring

Managing Service

IconAppendix: Managing s-Server as a Service
IconManaging s-Server as a Service

Network Configuration

Objects

Overview

Requirements

Icons-Server Requirements 
IconRequirements 

Restoring Database

Running in Docker

Running Multiple Instances

IconAppendix: Running Multiple Instances of s-Server
IconRunning Multiple Instances of s-Server

Setting Checkpoints

Starting

Stopping

System Architecture

Uninstalling

Upgrading

vs RDBMS

s-Server Cannot Resolve Host Name

s-Server Network Configuration

Troubleshooting

s-Serverd

IconAppendix: Managing s-Server as a Service
IconManaging s-Server as a Service

SSL

s-Studio

Closing

Development Environment

Opening

Preparation

Requirements

Uninstalling

s-Studio Development pane

Stack dump

Recommended way to get

Standard Deviation

Starter Projects

Using

Starting the SQLstream s-Server

STAT_SET_COLUMN_HISTOGRAM

STAT_SET_PAGE_COUNT

STAT_SET_ROW_COUNT

STATEMENTS_VIEW

Statistical Variance and Deviation

Population Variance

Sample Variance

VAR_SAMP

IconVAR_SAMP 
IconVAR_POP 

STD_DEV

STDDEV_SAMP

Stopping the SQLstream s-Server

!kill

!quit

Stream

Troubleshooting

Stream Clock

Stream Data Processing

About

STREAM keyword

Stream Processing

Stream-graphs

Streaming Aggregation

and Rowtime Bounds

Streaming Correlation

Streaming Data

About

Streaming Data from One Guide to Another

Streaming Data in CSV format

Streaming Data in JSON format

Streaming Data in XML format

Streaming Data to an Exernal Source

Streaming JOINs

IconStreaming Joins
IconCreating Streaming JOINs
IconJOIN clause

and Rowtime Bounds

Examples of

Streaming Queries

About

Streaming Sources

AMQP

File System

Kafka

Kinesis

Socket

Streaming SQL

Troubleshooting

IconTime and Streaming Data 
IconTime and Streaming Data 

Streaming SQL Operators

Arithmetic Operators

EXISTS operator

IN operator

Operator types

Precedence

Scalar Operators

Subquery Operators

Streaming SQL Queries

Streaming StreamLab Data to an External Database

Generic

MySQL

Oracle

Paracel

PostgreSQL

SQL Server

Terradata

Vectorwise

StreamingPreparedStatement

IconExtensions to JDBC API
IconPlugins 

StreamLab

IconUsing the AWS Marketplace SQLstream Blaze AMI
IconInstalling the SQLstream AMI

and SQL

and s-Server

and WebAgent

Installing

IconInstalling SQLstream StreamLab
IconInstalling Streamlab

Running

StreamLab and Error Logs

StreamLab Dashboards

Cloning a Layout Frame

Exporting a Dashboard's URL

Layouts

Organizing

Swapping Panels

Types of Layouts

IconTypes of Layouts
IconEnclosing a Frame within a Layout

StreamLab Dashboards Overview

StreamLab data

StreamLab Galleries

StreamLab Guides Overview

StreamLab Input

StreamLab menu

StreamLab Overview

StreamLab Projects

Overview

StreamLab Projects Home Page

IconUsing the StreamLab Projects Home Page
IconUsing the StreamLab Projects Home Page

StreamLab requirements

StreamLab sources

StreamLab Workflow

Streams

IconApplication Design Considerations 
IconPumps, Streams, and Processing Pipelines

Adding as Source

and Rowtime Bounds

and Time

Creating

Infinite

Tables, Difference From

Troubleshooting

Troubleshooting with Trace Files

Views

Streams and Time

Stream-stream joins

Stream-table joins

IconCreating Streaming JOINs
IconJOIN clause

Stream-table joins vs. Table Lookup UDX

String Operators

sudo

Suggestions

Overview

Using

Sum

IconAggregate
IconBucketize

Summary View

Supported Databases

Switching between projects and dashboards

SYS_BOOT.MGMT

Using

SYS_FTRS

SYS_LOG_PARSE

System Architecture

System delay

System Logs

System Panels

System parameter configuration

System Parameters

Altering

cachePagesInit

IconConfiguring SQLstream 
IconSystem Parameters

cachePageSize

IconConfiguring SQLstream 
IconSystem Parameters

cachePagesMax

IconConfiguring SQLstream 
IconSystem Parameters

cacheReservePercentage

IconConfiguring SQLstream 
IconSystem Parameters

calcVirtualMachine

IconConfiguring SQLstream 
IconSystem Parameters

checkpointInterval

IconConfiguring SQLstream 
IconSystem Parameters

codeCacheMaxBytes

IconConfiguring SQLstream 
IconSystem Parameters

Configuring

IconConfiguring SQLstream 
IconSystem Parameters

databaseIncrementSize

IconConfiguring SQLstream 
IconSystem Parameters

databaseInitSize

IconConfiguring SQLstream 
IconSystem Parameters

databaseMaxSize

IconConfiguring SQLstream 
IconSystem Parameters

databaseShadowLogIncrementSize

IconConfiguring SQLstream 
IconSystem Parameters

databaseShadowLogInitSize

IconConfiguring SQLstream 
IconSystem Parameters

databaseTxnLogIncrementSize

IconConfiguring SQLstream 
IconSystem Parameters

databaseTxnLogInitSize

IconConfiguring SQLstream 
IconSystem Parameters

deviceSchedulerType

IconConfiguring SQLstream 
IconSystem Parameters

expectedConcurrentStatements

IconConfiguring SQLstream 
IconSystem Parameters

fennelDisabled

IconConfiguring SQLstream 
IconSystem Parameters

groupCommitInterval

IconConfiguring SQLstream 
IconSystem Parameters

jniHandleTraceFile

IconConfiguring SQLstream 
IconSystem Parameters

resourceDir

IconConfiguring SQLstream 
IconSystem Parameters

sdpListenerPort

IconConfiguring SQLstream 
IconSystem Parameters

tempIncrementSize

IconConfiguring SQLstream 
IconSystem Parameters

tempInitSize

IconConfiguring SQLstream 
IconSystem Parameters

System Procedures

FLUSH_CODE_CACHE

KILL_SESSION

KILL_STATEMENT

KILL_STATEMENT_MATCH

STAT_SET_COLUMN_HISTOGRAM

STAT_SET_PAGE_COUNT

STAT_SET_ROW_COUNT

System Views

HISTOGRAM_BARS_VIEW

HISTOGRAMS_VIEW

Monitoring

OBJECTS_IN_USE_VIEW

PAGE_COUNTS_VIEW

REPOSITORY_PROPERTIES_VIEW

ROW_COUNTS_VIEW

SEQUENCES_VIEW

SESSION_PARAMETERS_VIEW

SESSIONS_VIEW

STATEMENTS_VIEW

Using Scripts With

System-Defined Log-Parsing Functions

- T -

Tab-Delimited Files

Table Lookup UDX

Table Reader Adapter

Configuring Control Stream

Configuring Foreign Server with JNDIparams

Configuring State Table

Creating a Control Stream

Creating a Foreign Stream

Defining a Server Using ConnParams

Defining the Server

Example: Code Using Jndiparams

Example: Connection Parameters and Options defined in Server definition

Registering the Plugin (Foreign Data Wrapper)

SKIPVALIDATION and run-time errors

sqlDialect options

Using a State Table

Table Update Adapter

Creating a Foreign Data Wrapper

Defining the Foreign Stream

Defining the Server

TableLookup UDX

Installing

--tableName

IconReading Files in Remote Locations
IconWriting Files to Remote Locations

Tables

Adding as Source

MERGE

TableUpdate Adapter

tail logfile_name

Tailing an External Database table

TCP

tempIncrementSize

tempInitSize

Temporal Predicates

The Mochi Demo

IconUsing the AWS Marketplace SQLstream Blaze AMI
IconInstalling the SQLstream AMI

THREAD_STACK_ENTRIES

Threads

and Licensing

THREADS (UDX)

Throttle button

Throttling Data Flow

TIME

Time Series

Time WINDOWs

and the Edamame Demo

Time zones

TIMESTAMP

Timestamps

Parsing

TINYINT

Tomcat

Configuring

Installing

Trace Files

About

Changing tracing levels

Configuring

Trace.log

Trace.properties

Tracing Levels

About

Changing

Tracking late rows

Transparency

Troubleshooting

Delays in Receiving Data

Network Configuration

Trace Files

Troubleshooting performance

Troubleshooting Streaming SQL

IconTime and Streaming Data 
IconTime and Streaming Data 

Troubleshooting StreamLab

- U -

UDF, User Designed Function, Custom Function

UDFs

Google GeoCode

Writing

UDP

UDX SYSTEM_INFO

UDX THREAD_STACK_ENTRIES

UDXes

IconTransforming Data in s-Server
IconPlugins 

UDXs

and Rowtime Bounds

Compiling

Writing

Unicode support

Uninstaller

IconUninstalling SQLstream 
IconUninstalling s-Studio in a Standalone Installation
IconUninstalling Client Tools in a Standalone Installation

Uninstalling

Client Tools

s-Server

s-Studio

UNION ALL

and Rowtime Bounds

Updating JDBC Foreign Tables

URI Parse UDX

User

IconCREATE USER
IconUser 

User Defined Function

Creating in Java

User Defined Functions

Creating in SQL

User Defined Transforms

IconTransforming Data in s-Server
IconUsing UDXs and UDFs for Analysis

Session Identification Exam

Using

User-Defined Functinos

Google GeoCode

User-Defined Procedure

User-defined Routines

and Prepared Statement

User-initiated Checkpoints

Using  MongoDB as a Data Sink

Using Blackboard

Using color coding to identify possible SQL type conflicts

Using Google Maps and  OpenStreetMaps Tiles with StreamLab

Using Network Sockets as a Data Sink

Using Panel Layouts

Using Snowflake as a Data Sink

Using sqlLineRemote to Connect to a Database

IconUsing sqlLineRemote to Connect to a Database
IconUsing sqlLineRemote to Connect to a Database

Using SSL with JDBC

Using SSL with s-Server

Using TableLookup UDX to Prefetch a Partitioned Portion of a Database

Using the Log File Adapter

Schema Definitions

Using the Pan and Zoom Map

Customizing Icons

Using Trace Files to Troubleshoot Streams

Using Web Sockets as a Data Sink

- V -

Validating, Executing and Formatting SQL

VARBINARY

VARCHAR

And unicode support

Variable Column Log Data

Parsing

Verifying that Source has Data

VHD

Viewing Column Details and Suggestions

Viewing Input stream

Viewing List of  StreamLab Projects

IconUsing the StreamLab Projects Home Page
IconUsing the StreamLab Projects Home Page

Viewing List of Dashboards

Viewing One Row at a Time

Viewing SQL

Views

Adding as Source

Virtual Hard Disk

Virtual Machine Image

VMI

- W -

W3C Log Data

Parsing

W3C_LOG_PARSE

Wallclock time

Waypoint.java

Web Feeds

Reading into s-Server

Web Sockets

Writing to

webAgent

IconUsing s-Server over the Internet
IconwebAgent
IconRunning webAgent
IconUsing s-Server over the Internet

Interface

Service

Test tool

WEBAGENT_ENABLE_WEBAPP

WEBAGENT_ENABLE_WRITE

webagentd

WebFeed Adapter

WebSockets

Reading into s-Server

Welcome pane

Why are my rows discarded?

Windowed Aggregation

and Rowtime Bounds

Windowed queries

Windows

Working with External Databases

Wrapper

Writing BSON Files

Writing CSV Files

IconWriting to Kafka
IconExtensible Common Data Adapter: Writing CSV files

Writing Data

AMQP

AWS Kinesis

CSV

File System

JSON

Kafka

Network Socket

XML

Writing JSON Files

IconWriting to Kafka
IconExtensible Common Data Adapter: Writing JSON Files

Writing to  MongoDB

Writing to AMQP

Writing to Files with the Extensible Common Data Adapter

Writing to Hadoop

Writing to HTTP

Writing to IBM MQ

Writing to Kafka

Writing to Kinesis

Writing to Mail Servers

Writing to Network Sockets

Writing to Other Destinations

AMQP

File System

Hadoop

HTTP

IBM MQ

Kafka

Kinesis

Mail Server

MongoDB

Network Sockets

Snowflake

Web Sockets

Writing to Snowflake

Writing to the File System

Writing to Web Sockets

Writing UDFs

Writing UDXs

Writing XML Files

IconWriting to Kafka
IconExtensible Common Data Adapter: Writing XML Files

- X -

XML Data

Parsing

XML Files

IconFileWriter Adapter
IconFileWriter_Agent

Writing with the ECDA

IconWriting to Kafka
IconExtensible Common Data Adapter: Writing XML Files

XMLParser UDX