Chapter 2: Database Setup for Risk Analytics Platform

Loading the IQ sample data

Risk Analytics Platform provides sample data as a set of .csv files, which you can load on both UNIX and Windows systems.

To run the data load script files, you must have the Sybase IQ 12.6 client tools on your system. You can run the .bat and .tst files (discussed in the following sections) on your client system. Note that the client and server can be on the same machine.

All of the files needed to complete the IQ database setup and load the sample data are located in subfolders of the \Data and \Scripts folders.

Some of the .csv files are contained in WinZip .zip files. You must unzip these files, then copy all of the .csv files to the server machine. If you are creating the IQ database on a UNIX server, copy the \Data\RAP_Output folder and its contents to the UNIX directory where you start the IQ server. You can FTP these files from Windows to the UNIX machine.

Note The .csv files, which contain the sample data, must be transferred in an ASCII format to the UNIX server machine.

The .csv files must be in the same location (folder or directory) as the Sybase IQ database files and the directory from which the Sybase IQ server is started.

You use four types of files to complete the database setup, load the sample data, and create the IQ indexes.

The first file type is .bat. These scripts are used to start the database setup and data loading processes. The .bat files are in the \Data\RAP_Load and \Scripts\RAP Setup folders.
The second file type is .tst. This script is called by a .bat file and performs the loading process of the .csv files. The .tst file is in the \Data\RAP_ Load folder.
The third file type is .csv. These files are simply comma-delimited data files containing all of the necessary data for the sample database. The .csv files are in the \Data\RAP_Output folder.
The fourth file type is .sql. These files contain the commands to complete the database setup and to create the Sybase IQ indexes on the tables in the sample database. The .sql files are in the \Data\RAP_Index and the \Scripts\RAP Setup folders.

Before you can run any of the scripts, you must edit both the .bat and .tst files to correspond to the sample database you created.

View this book as PDF