I. Environment
Windows XP
Java runtime environment 1.5.0.11


II. What would be tested

1. Correctness:
Requirement: The the data scale will not be large.
Content:
	Data type: int, float, char, datetime, boolean, timestamp, decimal
	Index
	Clauses: create/drop database, create/delete table(auto_increment), create/drop index
		 insert, delete, update 
		 select 
			 on multiple tables, may be nested
			 DISTINCT
	                 Alias of tables
	                 Subquery as Scalar Operand
			 aggregate function(with group by)
	                 [NOT] EXISTS
	                 ORDER BY more than one column as arguments
	(considering violation of constraints: primary key, not null)
	JDBC

2. Speed:
Requirement: While ensuring the correctness, run as fast as possible under large scale data.
Content: Storage, Index, Engine
Related clauses: create/drop database, create/delete table
		 no constraints on the column, except primary key
		 insert, delete, update
		 select
			 on multiple tables, may be nested
			 DISTINCT
	          	 on multiple tables, may be nested
	                 ORDER BY more than one column as arguments					 
Note: We may have several test data, covering all the aspects. You can
also provide test data on which you think your database may outperform
other teams'. 

3. Advanced:
During the presentation, you can implement the functions not mentioned
above, like GROUP BY, roll back. Prepare the scenario to prove them.


* Make buffer size adjustable
* The correctness and speed will be tested locally, that means you
should provide a local access program that uses a file containing
sql clauses as input and output the result into another file. 
* A GUI is required for presentation.


III. What should be submitted

1.Codes
2.Readme, telling me how to run your database.
3.Document containing what you have implemented and what you have
not, the design, each member's contribution.
4.Development diary(optional)

Lian, Xiaochen