/Mini-Database-design

This mini version of the database support multiple basic SQL-like commands and data is stored in a B+ tree style. Two metatables are included as "tablesTable" and "columnsTable". All the file is stored in .tbl file with reading and writing using RandomAccess. The programming language is Java.

Primary LanguageJava

Mini-Database-design

The mini version of the database support create, insert, update, delete, drop tables and where clause.

All of them are SQL-like commands and data is stored in a B+ tree style. All the file is contained using .tbl file with reading and writing using RandomAccessFile class.

This mini database automatically create a "data" repository and a "catalog" directory within it along with two meta-data named "tablesTable" and "columnsTable".

The page size of each .tbl file is 512 KB. It support datatype such as Byte, Short, Integer, Float, Double and String etc.

The detail Storage Definition Language (SDL) is in the "DavisBase Nano File Format Guide (SDL).pdf".