SimpleDB is a simple database. SimpleDB has the following primary feature:
- Support basic sql operations, like "select", "from", "where", "group by", "max", "min", "avg", "count", "rollback", "commit", "insert", "delete", "values", "into".
- Support multiple-table operations.
- Implement a simple query optimization schema
- Support transaction, ensure ACID properties.
More bottom details
- Slice data files into pages.
- Implement a buffer pool to manage the pages.
Usage sample
- (under terminal)
ant dist
java -jar dist/simpledb.jar parser data/dblp_data/dblp_simpledb.schema
load schema and data, get into database simulation terminalselect p.title from papers p where p.title like 'selectivity';
execucate normal sql statements.