Database Engine including bitmap indices implemented in Java. All the entries of the database are serialzied and then saved on disk, also the indices are serialized and saved.
- Clone the repo and open it in a Java IDE
- in the project directory, create the following empty folders:
- data
- docs/bitmaps
- docs/pages
- tableName
- clusteringKey
- map<colName,type>
You cannot create 2 tables with the same name, if you want to delete a table, you can delete its related info the data/metadata.csv and docs/pages files.
All the entries in the table will be sorted according to the clustering key.
- tableName
- map<colName,value>
The Clustering key must be part of the inserted elements.
- tableName
- map<colName,value>
This function deletes all rows that match colName=value.
- tableName
- colName
This function creates a bitmap index of the column you choose.
- tableName
this functions prints in the console all pages of a table.
- tableName
- colName
this functions prints the bitmap indices created for a table using the column specified, you should have called DBApp.createBitmapIndex(tableName,colName) before using this function.
- Check the file Main.java and comment/uncomment the calls to insert, delete, create and adjust the parameters in these functions.
- Be careful not to create the same table/bitmap index twice
This project was created in May 2019 as a part of an undergraduate Databases Course.