IBM Context-Oriented Information Retrieval

Overview

Requirements

Download

FAQs

Forum

Reviews

Platform requirements

Operating systems: Windows® XP, 2000, Server 2003

Software:

• Java™ 1.4 or above
• IBM® DB2® 8.2
• Apache Tomcat 5.5.17 (optional)

Installation instructions

Running in Tomcat:

1. Download and unzip the file Score.zip.
2. Copy the Score folder to the <TOMCAT_BASE>\webapps folder.
3. Copy the DB2 driver (db2java.jar and db2jcc.jar) to the <TOMCAT_BASE>\webapps\Score\WEB-INF\lib folder. These JAR files are generally found in <DB2_INSTALL_BASE>\java (C:\Program Files\IBM\SQLLIB\java). If the folder does not have db2java.jar but has db2java.zip, then copy the db2java.zip file to the required folder and rename it to db2java.jar.
4. Open the file <TOMCAT_BASE>\webapps\Score\database\CRM\SetupDatabase.ddl. Change the term <schema-name> to the name under which you are currently logged on to the machine. The user name must be in upper case.
5. Start a DB2 command prompt as follows: Go to Start > Run, type db2cmd, and click on Enter.
6. Change directory as follows:

   cd "<TOMCAT_BASE>\webapps\Score\database\CRM\"

7. At the DB2 command prompt, give the following command (you should have created rights in DB2 for executing this command):

   db2 -tf SetupDatabase.ddl

8. Change the configuration file as follows (this file is located at <TOMCAT_BASE>\webapps\Score\WEB-INF\classes\config.properties):
   1. If the installation path of Internet Explorer on your machine is different than the path given in the configuration file, please change the path in the configuration file.
   2. If the TOMCAT port is not 8080, then change the setting to the correct value for the parameter HTTP_PORT.
   3. Change the values of the INSTALLED_HOST_NAME to the name of the machine on which the software is installed. The default is localhost; if the software is being run on the same machine on which it is installed, then localhost will be fine.
   4. If you have changed the SetupDatabase.ddl and installed the data in a database whose name is not CRM, then set the value of the DBNAME (database name) to the correct database name.
   5. Set the USERNAME and PASSWORD fields to the values with which you have installed the software. This is generally the user name and passwords of the person who has logged on the machine while installing the software.
   6. Change the value of the SCHEMA parameter to the user name with which you have logged on to the machine while creating the database (Step 7). The schema name is generally in upper case and is case-sensitive.

9. Start TOMCAT (<TOMCAT_BASE>\bin\startup.bat).
10. If you are working on the same machine on which Tomcat is installed, navigate to http://localhost:8080/Score. If Tomcat is on a remote machine, navigate to: http://<tomcat-machine-ip>:8080/Score.

For an overview and walk-through of the demonstration, please see the included documentation.

Running as a command line interface (CLI):

1. Download the coir.jar file.
2. Make sure that you have the coir.jar and the DB2 drivers in the class path when you invoke the CLI. Execute this code from command line as follows:

   java TestCOIR <userName> <password> <databaseName> <schemaName> <SQLquery>

   The CLI prints the context keywords that it finds from the SQL query result.
3. Make sure that the CRM database is installed (instructions are given in the installation steps for the Tomcat demo). If you wish to execute the CLI on the CRM database provided with the installation, please use the following command:

   java -classpath %CLASSPATH%;coir.jar TestCOIR <user-name> <password> CRM <schema-name> "select * from transactions where transactions.acctid=1 and transactions.month=1"

   Please note that the <schema-name> is actually the user name (of the person who installed the database) and must be in upper case. You can also execute the CLI on your own database.
4. The code for TestCOIR.java is also provided. This code shows how to access IBM Context-Oriented Information Retrieval as an API.

Uninstallation instructions:

1. Stop Tomcat (<TOMCAT_BASE>\bin\shutdown.bat).
2. Start a DB2 command prompt as follows: Go to Start > Run, type db2cmd, and click on Enter.
3. Change directory as follows:

   cd "<TOMCAT_BASE>\webapps\Score\database\CRM\"

4. Execute the following command:

   db2 -tf UninstallDatabase.ddl

5. Remove the folder named Score from <TOMCAT_BASE>\webapps\.