Requirement

• Linux or Window system
• JDK 1.5
• Sql4j, a SQL statement parser

Download

Qrw class library

• binary package: qrw.jar
• source package: Qrw-Src.tar.gz

QRW application

• binary package: QrwApp-dist.tar.gz
• source package: QrwApp-Src.tar.gz

Instruction

QRW class library

Classes and interfaces for query rewriting and translation.
Check API documentation for details.

 

QRW application

1. Make sure sql4j.jar and qrw.jar are in the CLASSPATH
2. Extract qrwapp.jar

   #jar xvf qrwapp.jar
   

3. Prepare query rewriting environment config file that points out the definition files of data base schemas, views and queries. Here are the samples: firstQrE.xml, schema.xml, views.xml, query1.sql. Note: one query file can only contain one SQL statement.
4. Usage of QrwApp command

   #java  	QrwApp	arg1  arg2
   arg1:
           rewriting task to do
   	TCM-Mini 	finding CE rewriting using TCM-MiniCon algorithm
   	MiniE 	finding CE rewriting  using MiniCon algorithm
   	MiniM	finding all contained rewriting using MiniCon algorithm
   arg2:
           The directory of rewriting evironment containing
           definition files of chema, views, queries. The directory
           must ends with / in unix system
   

5. Usage of QrwGui
   • For Linux:

     #./qrwgui
     

   • For Windows:

     >setup.bat
     >rungui.bat