-
Notifications
You must be signed in to change notification settings - Fork 1
/
toDo.txt
36 lines (25 loc) · 2.02 KB
/
toDo.txt
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
in M1 :
1 (Done) - when running program, catch any exception and re-throw it as DB exception
https://piazza.com/class/lel8rsvwc4e7j6/post/60
2 (Done) - I think that the vector<row> in page should be initialized with max no.rows allowed in one page as input to its constructor, to increase performance
https://piazza.com/class/lel8rsvwc4e7j6/post/45
3 (Done) - important : should write table info in metaData when creating table!
3 (Done)- throw exception in create table if the 3 hashTables don't have exactly the same keys
https://piazza.com/class/lel8rsvwc4e7j6/post/125
4 - important : Meta data file should be used to learn about TYPES of columns, as well check if inserted value is between column min and max in a table with every insert/delete/update,for example, in insert, it only checks for existance of table name in listOfCreatedTables,but doesn't check columns and compare their types with input parameters !
(Project grading schema)
5 (done I guess) - handle null values insertion/update/ delete
https://piazza.com/class/lel8rsvwc4e7j6/post/72
https://piazza.com/class/lel8rsvwc4e7j6/post/81
6 (done) - update method assumes that the clustering key is always integer, which is not neccessary
https://piazza.com/class/lel8rsvwc4e7j6/post/58
7 (done) - delete all pages if input hashTable is empty :
https://piazza.com/class/lel8rsvwc4e7j6/post/35
https://piazza.com/class/lel8rsvwc4e7j6/post/55
8 (done) - Duplicate value are not handeled correctly and both are added.
9 - I think we should binary search on rows when inserting value to find the location rather than using Collections.sort()
(because the .contains() in the Page class insertAnEntry() checks linearly & WITH REFERENCE NOT COMPARING THE PK
,thus outputting wrong results [in number 8] and allowing Dups).
in M2 :
1 - when creating an index on a column,throw exception if it contains null values
2 - when inserting a null value on a column that has an index built on, throw an exception