Skip to content

An implementation of a database system for the database system management class

Notifications You must be signed in to change notification settings

shervinee/simpleDatabaseSystem-

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

2 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

SimpleDB

This simpleDatabaseSystem which is known as SimpleDB that was originally wirtten by Rex Ren and his colleage at UC Berekley's Database class CS186. The original repository

This repository consists of an edited version of the original system which has designed for multiple programming assignment in order to familiarize the trainees with the fundumental of Database Systems and their low level implementations. It gives the oppurtunity for one to have an appreciation of the complex computations the known systems such as Oracle and SQL Server goes through such as buffering, joining, paging and etc.

Extracted from the original repository the archtecure of system breaks down into 6 main category:

  1. Classes that represent fields, tuples, and tuple schemas;
  2. Classes that apply predicates and conditions to tuples;
  3. One or more access methods (e.g., heap files) that store relations on disk and provide a way to iterate through tuples of those relations;
  4. A collection of operator classes (e.g., select, join, insert, delete, etc.) that process tuples;
  5. A buffer pool that caches active tuples and pages in memory and handles concurrency control and transactions (neither of which you need to worry about for this project); and,
  6. A catalog that stores information about available tables and their schemas.

The system has been written in Java and contains multiple Junit test for each assignment (Unit and System testing).

The main purpose of repository is to show an attempt for solving some of the assignment questions.

About

An implementation of a database system for the database system management class

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages