xSQL Financial Samples

As explained in the samples/xsql/scripts/financial/readme.txt file, the SQL sample files *.sql in this directory are designed to demonstrate the use of various SQL analytics functions on sequences (time-series) using xSQL. They can be run by starting xSQL with the following commands:

 
    cd eXtremeDB/samples/xsql/scripts/financial
            
 
    ..\..\..\..\target\bin\xsql -i
     

Command files

To facilitate running the sample scripts, the following command files are provided:

xslq.bat (xsql.sh)

This command file launches xSQL with an argument list. It is provided to avoid the necessity to typing the long command line above. For example the following command line launches xSQL in interactive mode, creating a database of size 100Mb and running the scirpt file quote.sql:

 
    xsql -i -size 100m -f quote.sql
     

x.bat (x.sh)

This command file is provided to run query examples in script files x1.sql thru x15.sql that demonstrate practical queries using sequences:

 
    x 15
     

f.bat (f.sh)

This command file is provided to run simple statistical queries in script files f1.sql thru f5.sql:

 
    f 5
     

g.bat (g.sh)

This command file is provided to run simple statistical queries in script files g6.sql thru g11.sql:

 
    g 11