School of Computing

Department of Computer Science

CS3223:   Database Systems Implementation

Semester 2, 2022/2023  

 

[Announcements]  [Instructor] [Course Objectives] [Lecture Schedule] [Reference Texts and Materials] [Assignments (Tutorials & Gradiance)] [Project] [Assessment]

Schedule

·       Day/Time: Fri 10:00-12:00

·       Venue: LT19

 

Week

Date

Topic

Textbook Chapter

1

Jan 13

Introduction, Storage

8,9

2

Jan 20

Tree-Structured Indexing

10

3

Jan 27

Hash-based Indexing

11

4

Feb 3

External Sorting

13

5

Feb 10

Evaluating Relational Operators I

12

6

Feb 17

Evaluating Relational Operators II
(Query Evaluation: Materialization and Iterators)

14

-

Feb 24

Recess Week

-

7

Mar 3

Query Optimizer (Make-up mid-term test)

15

8

Mar 10

Query Optimizer

-

9

Mar 17

Concurrency Control (B+-tree Concurrency Control)

16 & 17

10

Mar 24

Concurrency Control

17

11

Mar 31

Concurrency Control

-

12

Apr 7

Crash Recovery (Make-up for Good Friday holiday)

18

13

Apr 14

Crash Recovery & Review

-

14

Apr 21

Reading Week

-

15

Final Assessment (f2f)

-