CS764 Project Home Page



WEB/SQL

WWW gateway to Paradise SQL database


BY: Zhongbin Yin & Wei Chen

ADVISOR: Prof. Jeffrey Naughton


Test Examples of our gateway:

1. SELECTION test
This example shows you to do SELECTION on an single relation
people(id:int, name:string, age:int, gendre:string).

2. JOINT test
This example shows you to do a JOINT on two relations:
people(id:int, name:string, age:int, gendre:string).
workstation(id:int, type:string, price:string)

3. Wisconsin Benchmark test1
This example shows you do selection on relation "aprime" of databse "wisc2" of Wisconsin Benchmark Data. (1,000 tuples in relation.)

4. Wisconsin Benchmark test2
This example shows you do selection on relation "ktup1" of databse "wisc2" of Wisconsin Benchmark Data. (10,000 tuples in relation.)