The Hamachi Demo

<< Click to Display Table of Contents >>

Navigation:  Analyzing Data in s-Server > Running Demo Applications >

The Hamachi Demo

Previous pageReturn to chapter overviewNext page

The Hamachi demo is designed to show how you can use SQLstream to analyze Web visitor traffic over 3, 7, 15 and 30 day windows. To do so, the demo makes extensive use of views.

The Hamachi demo is located in $SQLSTREAM_HOME/demo/hamachi. It consists of:

hamachi.sql. This file is read by sqllineClient to create the schema.
A datagen folder with scripts for generating input data: events.random.25k.set.xml and events.random.25k.set.xml, as well as datagen, an slink to datagen.
A perl folder with two debugging scripts:
owatchevents.pl — retrieves hamachi.events
owatchevents.sh — wrapper for watchevents.pl that sets CLASSPATH

Note: Perl integration with JDBC is supported using three CPAN modules: Inline, Inline::Java, and JDBC. You need to install these to get the Hamachi demo to work.

Running the Hamachi Demo

To run the Hamachi demo:

1.Open sqllineClient in $SQLSTREAM_HOME/bin

Note: $SQLSTREAM_HOME refers to the installation directory for s-Server, such as /opt/sqlstream/4.0.XXX/s-Server.

2.Enter !run ../demo/hamachi/hamachi.sql to create the Hamachi schema.
3.Navigate to demo/hamachi/datagen and enter $../../../../clienttools/datagen/datagen.sh events.random.25k.set.xml
4.Open s-Studio.
5.Select Schemas > Hamachi > Views
6.Right click on analytics_01x and choose Inspect.