leiwingqueen / entrydb

a simple db inspired of mit6.830

a simple db inspired of mit6.830

Usage

create data files with the following command:

java -jar dist/simpledb.jar convert work/log/data1.txt 2 "int,int"

start parser with the following command:

java -jar dist/simpledb.jar parser work/data/catalog1.txt

entrydb's Issues

wal(redo log and undo log) need to add log record buffer or implement aries algrithom.

wal(redo log and undo log) need to add log record buffer or implement aries algrithom.

replace zql to other sql lib

couse the zql lib is not maintain any more, we can try to use a more powerful sql tool lib to handle this job

use tuple level lock nor the page level lock

to improve the db performance. we need to implement page level lock

remove dirty page hash map in BtreeFile.java

As mention in lab5.md, we use dirty pages cache to mark if the page dirty.

BTreeFile.getPage() also adds pages to the dirtypages cache if they are fetched with read-write permission, since presumably they will soon be dirtied. One advantage of this approach is that it prevents loss of updates if the same pages are accessed multiple times during a single tuple insertion or deletion.

this solution will come up some problem. if we need to evict some page to get some page from disk, we can find some pages are not dirty but they actually in dirty page cache. because we will mark the page dirty later. for some case is more worse, as we find need to evict those error marked page, we will lost some update that we think the page is not dirty and just remove it from buffer pool.

i think dirty page is not necessary and remove the dirty page cache.

fix unit test and system test

fix unit test and system test

upgrade zql lib

crabbing protocol bugfix

replace system.out to logback

in this project, most of log use sysout, it's not convenient for use.

add user guide

add user guide to tell people how to use the project. you need to test the whole project at the first time