- ! -

!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
IconReading CSV
IconReading XML
IconReading JSON
IconReading Variable Column Files
IconReading Fixed Column Files
IconParsing W3C Data
IconECD Adapter and Agent: File System
IconWriting to Sockets
IconWriting to AMQP
IconWriting to Kafka
IconWriting to Kinesis
IconExtensible Common Data Adapter: Writing CSV files
IconExtensible Common Data Adapter: Writing XML Files
IconExtensible Common Data Adapter: Writing JSON Files
Iconall_file_formats_snippet

Parameters

Parsing CSV files

IconReading CSV
Iconall_file_formats_snippet

Parsing Fixed Column Log Files

IconReading Fixed Column Files
Iconall_file_formats_snippet

Parsing JSON Files

IconReading JSON
Iconall_file_formats_snippet

Parsing Variable Column Log Files

IconReading Variable Column Files
Iconall_file_formats_snippet

Parsing W3C Files

IconParsing W3C Data
Iconall_file_formats_snippet

Parsing XML Files

IconReading XML
Iconall_file_formats_snippet

Reading from IBM MQ

Reading from Kafka

Reading from Kinesis

Reading JSON Files

IconReading JSON
Iconall_file_formats_snippet

Reading Kafka Input

Reading Kinesis Input

Reading XML Files

IconReading XML
Iconall_file_formats_snippet

Writing CSV Files

IconECD Adapter and Agent: File System
IconWriting to Sockets
IconWriting to AMQP
IconWriting to Kafka
IconWriting to Kinesis
IconExtensible Common Data Adapter: Writing CSV files

Writing JSON Files

IconECD Adapter and Agent: File System
IconWriting to Sockets
IconWriting to AMQP
IconWriting to Kafka
IconWriting to Kinesis
IconExtensible Common Data Adapter: Writing JSON Files

Writing XML Files

IconECD Adapter and Agent: File System
IconWriting to Sockets
IconWriting to AMQP
IconWriting to Kafka
IconWriting to Kinesis
IconExtensible Common Data Adapter: Writing XML Files

Add Count

Adding a CSV Source

Adding a Guide

Adding a JSON Source

Adding a Line Source

Adding a Local Log File Source

IconAdding a Local Log File Source
IconAdding a Web Feed Source

Sampling Data from Source

Adding a Source

Adding a Stream Source

Adding a Table Source

Adding a XML 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

COUNT

MAX

MIN

SUM

Aggregation

Aggregations

Amazon EC2

IconUsing the AWS Marketplace SQLstream Blaze AMI
IconInstalling the SQLstream Blaze Trial AMI

Amazon Kinesis

Writing to from s-Server

Amazon Services

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

AMI

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

AMQP

CSV

JSON

Line

Writing to from s-Server

XML

AMQP Adapter

IconPlugins 
IconAMQP Adapter 

AMQP Writer

Analytic Functions

AVG

COUNT

MAX

MIN

SUM

Apache Kafka

Writing to from s-Server

Application

Promotion

Application Model

ApplicationTrace.log

Apply Rank

Archiving with Databases

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

autoCommit

and the JDBC driver

Average

IconBucketize
IconAVG 

- 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 Web Agent

Browsing Object Definitions

- C -

cachePagesInit

cachePageSize

cachePagesMax

cacheReservePercentage

calcVirtualMachine

Canceling Statements

and the JDBC driver

Cannot Connect to s-Server

CASE Syntax Chart

CAST

Catalog

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

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 SETs

Checking Source Data

checkpointInterval

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

IconCode Structure for Implementing Plugins
IconCode Structure for Implementing the Extensible Common Data Adapter

codeCacheMaxBytes

Color Coding

Column Color Coding

Columns

Converting Empty Cells to Null

Extracting

Splitting

command-line installation

Commands

Add Count

Analytics

IconAnalytics
IconBucketize
IconRunning Average

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 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
IconWeb Agent
IconRunning Web Agent
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 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

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 Dashboard

Creating a New StreamLab Project

Creating a stream out of a remote database table

Creating Project

Creating SQL Objects

CSV

Adding

Adding as Source

CSV Files

Writing with the ECDA

IconECD Adapter and Agent: File System
IconWriting to Sockets
IconWriting to AMQP
IconWriting to Kafka
IconWriting to Kinesis
IconExtensible Common Data Adapter: Writing CSV files

Custom Dashboards

Bar Graph

Bars and Lines

Bollinger Bands

Bouncing Bar Graph

Map and Table

Parallel Coordinates

Scatter Matrix

Time Series

Customizing Data Parsing

- D -

Dashboards Home Page

Data and wallclock time

data engine

Data processing

Troubleshooting

Data sources

Data time

IconTroubleshooting Processing Delays
IconTroubleshooting Processing Delays

Data Types

Database

Restoring

databaseIncrementSize

databaseInitSize

databaseMaxSize

DatabaseMetaData.XXX

Databases

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 and Time Patterns

DEC

DECIMAL

Declaring UDXs in s-Server

Default Server Hostname

Define a TableLookup UDX Control Stream

Delays

IconTroubleshooting Processing Delays
IconTroubleshooting Processing Delays

Demo Applications

Running

Demonstration Application

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

deviceSchedulerType

Differences from RDBMS tables

Directories

Discarded rows

DISTINCT

DOUBLE

DOUBLE PRECISION

Downstream Operations

DriverManager.getConnection

DROP

- E -

EC2

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

ECDA

Dynamically Configuring Properties

IconUsing the Options Query Property
IconUsing the Options Query Property

File Parsing Options

File Writing Options

Over HTTP

Over Web Sockets

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 Web Agent Application with webagentd

Enabling Writing to Web Agent with webagentd

Enclosing a Frame within a Layout

Encrypting Communication for s-Server

Engine Driver

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

Extensible Common Data Adapter

AMQP Reader

AMQP Writer

Dynamically Configuring Properties

IconUsing the Options Query Property
IconUsing the Options Query Property

Fast Regex

IconParsing Files with FastRegex
Iconall_file_formats_snippet

File Parsing Options

File Reader

IconParsing Files with FastRegex
Iconall_file_formats_snippet

File Writing Options

Mail Server

OPTIONS_QUERY

IconUsing the Options Query Property
IconUsing the Options Query Property

PARSE_ERROR

PARSE_LINE_NUMBER

PARSE_POSITION

Parsing Files

Socket Reader

Socket Writer

IconReading from Sockets
IconExtensible Common Data Adapter: Reading from and Writing to Sockets

Using MAX_BYTES_PER_FILE

Using MAX_FILENAME_DELTA

Using the Options Query

IconUsing the Options Query Property
IconUsing the Options Query Property

Writing over the File System

Writing to AMQP

Writing to Files

Writing to IBM MQ

Writing to Kafka

Writing to Kinesis

Writing to 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

- F -

Failure scenarios

FAST_REGEX_LOG_PARSE

IconSystem-Defined Log-Parsing Functions
IconFAST_REGEX_LOG_PARSE

FAST_REGEX_LOG_PARSER

fennelDisabled

File System

CSV

JSON

Line

Writing to from s-Server

XML

File Writer Agent

FileWriter Adapter

FIleWriter Agent

Filtering

Finding the Maximum Value

Finding the Minimum Value

Firewalls and s-Server

Fixed Column Log Files

Parsing with the ECDA

IconReading Fixed Column Files
Iconall_file_formats_snippet

FLOOR

FLUSH_CODE_CACHE

FOREIGN SERVER OPTIONS

Foreign Servers

and Adapters

Foreign Streams

and Adapters

FROM clause

Fulfillment Demo Application

- 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

Goals

Google Protocol Buffers

IconReading ProtoBuf
Iconall_file_formats_snippet

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
IconWeb Agent
IconRunning Web Agent
IconUsing s-Server over the Internet

Reading into s-Server

- I -

IBM MQ

Reading into s-Server

Writing to

Identifiers

Compound

Simple

Injecting Data into Streams

--input

IconReading Files in Remote Locations
IconWriting Files to Remote Locations

Input stream

Viewing

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

INTERVAL

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.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

jdbc:sqlstream:engine

JDK

Icons-Server Requirements 
IconPreparing to Install 
IconRequirements 

JDK compatibility

JNDI

jniHandleTraceFile

JOIN clause of SELECT statement\

Join limitations

Joins

JSON

Adding

Adding as Source

JSON Files

Writing with the ECDA

IconECD Adapter and Agent: File System
IconWriting to Sockets
IconWriting to AMQP
IconWriting to Kafka
IconWriting to Kinesis
IconExtensible Common Data Adapter: Writing JSON Files

JVM

- K -

Kafka

CSV

JSON

Line

Reading with the ECDA

XML

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

Linux

Icons-Server Requirements 
IconRequirements 

Local data wrapper

Lock Icon

IconLocking Dashboards
IconLocking Dashboards

Locking Dashboards

IconUsing the Dashboards Home Page
IconLocking Dashboards
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

Fixed Column

IconReading Fixed Column Files
Iconall_file_formats_snippet

Parsing

Parsing with FastRegex

IconParsing Files with FastRegex
Iconall_file_formats_snippet

Variable Column

IconReading Variable Column Files
Iconall_file_formats_snippet

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

loopback tables

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

Map and Table

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

MINUS

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 -

Named Streams

and Rowtime Bounds

Negation (NOT)

Network Socket Adapter

Network Socket Agent

Network Sockets

CSV

JSON

Line

Writing to from s-Server

XML

New Project

Nodes

Normalizing source and destination IP addresses

NSAgent

Options

Parameters

Null values

Converting to

NUMERIC

- O -

Objects

DDL

Objects within a Schema

OBJECTS_IN_USE_VIEW

Online Documentation

Opening a Guide

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

Parallel Coordinates

Parsers

CDR

Parsing

Regex

W3C

Parsing CSV files

IconReading CSV
Iconall_file_formats_snippet

Parsing Files

With ECDA (Extensible Common Data Adapter)

Parsing Fixed Column Log Files

IconReading Fixed Column Files
Iconall_file_formats_snippet

Parsing JSON Files

IconReading JSON
Iconall_file_formats_snippet

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 Files

IconReading Variable Column Files
Iconall_file_formats_snippet

Parsing W3C Files

IconParsing W3C Data
Iconall_file_formats_snippet

Parsing XML

Parsing XML Files

IconReading XML
Iconall_file_formats_snippet

Perl

and JDBC Driver

IconJDBC Driver and Perl
IconJDBC Driver and Perl

Pipe-Delimited Files

Pipelines

Troubleshooting

Plugin

Plugins

IconPlugins
IconPlugins 

Port Adjustments

Preference Settings

SQLLine

PreparedStatement

Prevent Users from Modifying Layout

IconLocking Dashboards
IconLocking Dashboards

Processing

Processing Pipelines

IconApplication Design Considerations 
IconUsing Pumps to Create Processing Pipelines

Projects

and StreamLab menu

Creating

Generating SQL

Overview

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

Pumps

IconApplication Design Considerations 
IconPumps, Streams, and Processing Pipelines

Overview

- 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 CSV files

IconReading CSV
Iconall_file_formats_snippet

Reading Data

Input Formats

Reading External Databases

Reading Fixed Column Files

IconReading Fixed Column Files
Iconall_file_formats_snippet

Reading from IBM MQ

Reading from Kafka

Reading from Other Sources

AMQP

File System

HTTP

IBM MQ

Sockets

Web Feeds

Web Sockets

Reading JSON Files

IconReading JSON
Iconall_file_formats_snippet

Reading Kafka Input

Reading Kinesis Input

Reading ProtoBuf Files

IconReading ProtoBuf
Iconall_file_formats_snippet

Reading Syntax Diagrams

Reading system parameters

Reading Variable Column Files

IconReading Variable Column Files
Iconall_file_formats_snippet

Reading XML Files

IconReading XML
Iconall_file_formats_snippet

REAL

Reduce Business Latency

Regex

IconFAST_REGEX_LOG_PARSE
IconFAST_REGEX_LOG_PARSER

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 system function, significance of

Rowtimes

--rowType

IconReading Files in Remote Locations
IconWriting Files to Remote Locations

RSS feeds

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

Dropping

Scripts

and Views

Scrutinizer

Toggling

Turning off

s-Dashboard

IconUsing the AWS Marketplace SQLstream Blaze AMI
IconInstalling the SQLstream Blaze Trial 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

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

Shutting down s-Server

and Backups

SIMILAR TO patterns

SIMILAR TO Table

Simple Identifiers

Sinks

Sliding Window (or Rolling Window)

Slowing Source Flow

Slowing Sources

SMALLINT

SMTP Mail Stream Column Options

Sources

IconStreamLab Input Overview
IconConfiguring File System as File Source

Adding

AMQP 0.9

AMQP 1.0

And streams

Kafka 0.9

Kafka 1.0

Over TCP

Over UDP

Overview

Switching within guide

Throttling

Using Network Sockets

Splitting columns

SQL

Viewing

Viewing for Guides

SQL comments

DESCRIPTION

SQL definitions

SQL Files

Organizing

SQL JOIN

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

Querying s-Server Tables

SQL/MED Plugin for JDBC

Microsoft SQL Server

MySQL

Oracle

PostgreSQL

Teradata

SQL:2008

Extensions

SQL:2008 Standard

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 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

SqlStreamVJdbcEngineDriver

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 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 engine driver

s-Server Network Configuration

Troubleshooting

s-Serverd

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

SSL

s-Studio

Closing

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

STD_DEV

STDDEV_POP

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 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 Blaze Trial 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 Guides Overview

StreamLab Input

StreamLab menu

StreamLab Overview

StreamLab Projects

Overview

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

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

Summary View

Supported Databases

Switching between projects and dashboards

SYS_BOOT.MGMT

Using

SYS_FTRS

SYS_LOG_PARSE

System Architecture

System delay

IconTroubleshooting Processing Delays
IconTroubleshooting Processing Delays

System Logs

System parameter configuration

System Parameters

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

IconTable Update Adapter
IconConfiguring Foreign Server and Foreign Stream
IconConfiguring Foreign Server and Foreign Stream

Configuring Control Stream

Configuring Foreign Server

IconConfiguring Foreign Server and Foreign Stream
IconConfiguring Foreign Server and Foreign Stream

Configuring Foreign Server with JNDIparams

Configuring Foreign Stream

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

The Mochi Demo

IconUsing the AWS Marketplace SQLstream Blaze AMI
IconInstalling the SQLstream Blaze Trial 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

IconTroubleshooting Processing Delays
IconTroubleshooting Processing Delays

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

IconTroubleshooting Processing Delays
IconTroubleshooting Processing Delays

Network Configuration

Trace Files

Troubleshooting performance

Troubleshooting Streaming SQL

IconTime and Streaming Data 
IconTime and Streaming Data 

Troubleshooting StreamLab

Tumbling Window

- 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 color coding to identify possible SQL type conflicts

Using Google Maps and  OpenStreetMaps Tiles with StreamLab

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 Trace Files to Troubleshoot Streams

- V -

VARBINARY

VARCHAR

And unicode support

Variable Column Log Files

Parsing with the ECDA

IconReading Variable Column Files
Iconall_file_formats_snippet

Verifying that Source has Data

VHD

Viewing Column Details and Suggestions

Viewing Input stream

Viewing List of  StreamLab Projects

Viewing List of Dashboards

Viewing SQL

Views

Virtual Hard Disk

Virtual Machine Image

VMI

- W -

W3C Files

Parsing with the ECDA

IconParsing W3C Data
Iconall_file_formats_snippet

W3C_LOG_PARSE

Wallclock time

IconTroubleshooting Processing Delays
IconTroubleshooting Processing Delays

Waypoint.java

Web Agent

IconUsing s-Server over the Internet
IconWeb Agent
IconRunning Web Agent
IconUsing s-Server over the Internet

Interface

Service

Test tool

Web Feed

Adding

Adding as Source

Web Feeds

Reading into s-Server

Web Sockets

Reading into s-Server

WEBAGENT_ENABLE_WEBAPP

WEBAGENT_ENABLE_WRITE

webagentd

WebFeed Adapter

Welcome pane

Why are my rows discarded?

Windowed Aggregation

and Rowtime Bounds

Windowed queries

Windows

Working with External Databases

Wrapper

Writing CSV Files

IconECD Adapter and Agent: File System
IconWriting to Sockets
IconWriting to AMQP
IconWriting to Kafka
IconWriting to Kinesis
IconExtensible Common Data Adapter: Writing CSV files

Writing JSON Files

IconECD Adapter and Agent: File System
IconWriting to Sockets
IconWriting to AMQP
IconWriting to Kafka
IconWriting to Kinesis
IconExtensible Common Data Adapter: Writing JSON Files

Writing to AMQP

Writing to Files with the Extensible Common Data Adapter

Writing to Hadoop

Writing to IBM MQ

Writing to Kafka

Writing to Kinesis

Writing to Mail Servers

Writing to Other Destinations

AMQP

File System

Hadoop

IBM MQ

Kafka

Kinesis

Mail Server

Sockets

Writing to Sockets

Writing to the File System

Writing UDFs

Writing UDXs

Writing XML Files

IconECD Adapter and Agent: File System
IconWriting to Sockets
IconWriting to AMQP
IconWriting to Kafka
IconWriting to Kinesis
IconExtensible Common Data Adapter: Writing XML Files

- X -

XML

Adding

Adding as Source

XML Files

IconFileWriter Adapter
IconFileWriter_Agent

Writing with the ECDA

IconECD Adapter and Agent: File System
IconWriting to Sockets
IconWriting to AMQP
IconWriting to Kafka
IconWriting to Kinesis
IconExtensible Common Data Adapter: Writing XML Files

XML Metadata Interchange (XMI)

XMLParser UDX