Skip to content

A simple DBMS that supports basic schema creation, CRUD operations, Octree Indices and simple SQL Parsing implemented in Java

Notifications You must be signed in to change notification settings

mathewhany/dbms

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

25 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

DBMS

  • Supports 4 datatypes (strings, integers, doubles, dates) and uses the strategy design pattern to allow for adding more data types easily.
  • Stores pages and indicies in serialized object files, and uses strategy design pattern to make it easier to support other storage strategies.
  • Supports multi dimensional queries, range or partial queries using an Octree index.
  • Uses both the factory and strategy design patterns to allow supporting more indices easily.
  • Saves metadata about tables in a CSV format, and uses strategy pattern to easily support other formats in the futures.
  • The SQL parser supports SQL operations for: "CREATE TABLE", "CREATE INDEX", "INSERT", "UPDATE", "DELETE", "SELECT"

About

A simple DBMS that supports basic schema creation, CRUD operations, Octree Indices and simple SQL Parsing implemented in Java

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

 
 
 

Contributors