Skip to content

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.

Notifications You must be signed in to change notification settings

BoYuHuang1117/Mini-Database-design

Repository files navigation

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".

About

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.

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages