Project goal
In this project, you will write a basic database management system called SimpleDB. First, you will implement the core modules required to access stored data on disk. You will then write a set of operators for SimpleDB to implement selections and joins. The end result is a database system that can perform simple queries over multiple tables. You will not be asked to add transactions, locking, and concurrent queries. However, we invite you to think how you can add such functionality into the system.
SimpleDB is written in Java. You have been provided with a set of mostly unimplemented classes and interfaces. You will need to write the code for these classes. Your code will be graded by running a set of system tests written using JUnit. You are also provided with a number of unit tests, which will not be used for grading but that you may find useful in verifying that your code works. Note that the provided unit tests are to help guide your implementation along, but they are not intended to be comprehensive or to establish correctness.
The remainder of this document describes the basic architecture of SimpleDB and gives some suggestions about how to start coding.
We strongly recommend that you start as early as possible on this project. It requires you to write a fair amount of code!
it's a learning experience for me as i'm quite curious to see how this particular application will work. In the past i have taken pretty complex piece of logic for my organization hence i'll be able to do this code changes. Let me know in case you have any more queries.