Tutorial 1: Introduction to StreamLab

<< Click to Display Table of Contents >>

Navigation:  Building Streaming Applications >

Tutorial 1: Introduction to StreamLab

Previous pageReturn to chapter overviewNext page

This tutorial walks you through using SQLstream Blaze's SQL-generating, browser-based graphical tool, StreamLab.

StreamLab is a web application development environment that automatically generates streaming SQL. StreamLab lets you set up projects where you can parse incoming streaming data, generate real time analytics for it, visualize it, so that you can take action on it. You can gather streaming data from log files, sensors, message buses, network feeds, applications, databases, and other sources.

StreamLab does not require any knowledge of SQL programming to use it. But if you do know SQL, you can use StreamLab to generate blocks of SQL, and then modify these in another application.

The tutorial uses a set of data from buses in Sydney, Australia. Each bus sends out a row of data to a server, which continually writes this data to a text file known as a log file. Log files are used by most servers to output activity information for the server.

In this tutorial, you do the following:

1.Use StreamLab to access a log file and integrate its data

2.Format this data for processing: assign meaningful column names, extract useful information, and assign data types.

3.Perform a simple analytic on this data.

4.Create a visual representation of this data on a map using a dashboard.

5.Share the dashboard with other users.

Let's begin by connecting to the log file and testing access to it.