Guavus SQLstream consists of six major components:
Client Tools contains sqlline, mtsql, datagen, jdbc, Log File Agent, and webAgent, as described below with links to further detail.
|SQLline||SQLLine is a command-line tool for communicating with the SQLstream s-Server or with other servers or databases, a generic & open-source database client that works with any jdbc database. More information about SQLLine can be found at: - http://sqlline.sourceforge.net/
SQLLine can be used interactively or to read a script. Its command language is SQL: it reads SQL statements and sends them to the server, gets the results, and prints the results.
|For the version in our client tools, the command line options are explained in the source file aspen/tools/sqlline. (See also the SQLline page in this manual.)
Note that a streaming query can take a long time to complete — maybe forever.
If SQLline executes a query, it prints all the rows in the result set.
|mtsql||The tool mtsql is like sqlline, but can run several SQL clients at the same time, in parallel, in separate threads of execution. You can use MTSQL to test and benchmark your applications by writing multi-threaded SQL scripts, synchronizing separate threads, and capturing output from each thread separately. Each thread executes a list of commands, in the mtsql language. The language is an extension of SQL which provides ways of coordinating the parallel clients.||The point of mtsql is that one script runs as several parallel, coordinated clients. The command line options are simple and described in comments in aspen/tools/mtsql.|
|datagen||Datagen generates test data for SQLstream applications, and pushes the data into SQLstream using the SQLstream JDBC Driver. The test data to be generated is described in XML files. DataGen processes DataSet and TupleRule XML definitions to generate streaming sample data for SQLstream.||See also the DataGen section of the Concepts Guide.|
|JDBC||JDBC (Java DataBase Connectivity) is a standard Java API for connecting to relational databases and other data sources that can produce relational data.||See also the JDBC Driver section of the Enterprise Interface Guide, for a discussion of JDBC in the SQLstream context, where it is used by applications to get data into or out of SQLstream.|
|webAgent||webAgent functions as a simple, miniature Web server. It accepts HTTP requests, sends these to s-Server, and returns JSON objects. See json.org for more details on JSON objects. SQLstream webAgent is delivered as part of the SQLstream Client Tools, in the shell script webAgent.sh.||webAgent is used by a number of SQLstream applications, including StreamLab and s-Dashboard. In order to use webAgent with web applications, users need one of the following browsers.
Microsoft Internet Explorer 11 (or later), Google Chrome 31 (or later), Mozilla Firefox 17 (or later), or Apple Safari 7 (or later).
The following table shows the directory structure and contents of the ClientTools.zip file, with links to further descriptions for DATAGEN, JDBC, and how the trace.properties file is used. For more information, see the topics DATAGEN, and JDBC Driver in the Integration Guide.
|Directory||Next-level Contents||Next-level Contents|