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