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

Project Activity

See All Activity >

Follow Simple Java Database

Simple Java Database Web Site

Other Useful Business Software
Grafana: The open and composable observability platform Icon
Grafana: The open and composable observability platform

Faster answers, predictable costs, and no lock-in built by the team helping to make observability accessible to anyone.

Grafana is the open source analytics & monitoring solution for every database.
Learn More
Rate This Project
Login To Rate This Project

User Reviews

Be the first to post a review of Simple Java Database!

Additional Project Details

Registered

2014-03-12
Report inappropriate content