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

No packages published

Contributors 4

  •  
  •  
  •  
  •