Browse Code
A simple database with commands similar to those of SQL. It is to be run from the command line.
(java -jar DatabaseJAR.jar)
The application allows users to create tables, add data to the tables, view data from tables using various filters, back-up and restore the database, read commands from a text file, perform various set operations (such as union and intersection) on tables, and define indices on tables to allow faster manipulation. (To simplify the binary tree structure, the define index command assumes there is no duplicate data in the table column on which the index is defined).
The tables' metadata are stored in .xml files, and the row data is stored in .bin files. Test cases and code are provided.
This project uses JUnit 4 (only for test cases) and SAXReader (for parsing .xml).
A description of the available commands is provided in "commandSyntax.txt".
Features
- Java 7
- Java-docs provided
- Executable .jar provided
- Files uploaded in an Eclipse project format
- Allows basic database manipulation
- Accepts commands spanning multiple lines
- Stores table information locally
- Robust error handling