Toggle navigation
WebCMS3
Search Courses
Login
COMP9315
20T1
Home
Course Outline
Q and A
Exams
Course Work
Course Notes
Lectures
Prac Exercises
Theory Exercises
Assignments
PostgreSQL Doco
Readings
Activities
Forums
Timetable
Groups
Group Matchmaking
Toggle Menu
Resources
Lectures
Lectures
All Weeks
Course Introduction (video)
DBMS Revision (video)
Week 1
17/02/2020 - 23/02/2020
Mon 12-1 Lecture: Revision, PostgreSQL
Mon 1-2 Lecture: PostgreSQL, Catalogs
Tue 2-3 Lecture: Catalogs
Tue 3-4 Lecture: PostgreSQL Architecture
Week 2
24/02/2020 - 01/03/2020
There are no accessible resources under here.
Week 3
02/03/2020 - 08/03/2020
Mon 12-1 Lecture: Storage Manager, File Manager
Mon 1-2 Lecture: File Manager
Tue 2-3 Lecture: Buffer Pool
Tue 3-4 Lecture: Page Internals
Week 4
09/03/2020 - 15/03/2020
Mon 12-1 Lecture: Representing Tuples
Mon 1-2 Lecture: RelOps, Cost Models
Tue 2-3 Lecture: Scanning, Sorting
Tue 3-4 Lecture: Sorting, Projection
Week 5
16/03/2020 - 22/03/2020
Mon 12-1 Lecture: File Structures for Selection
Mon 1-2 Lectures: Sorted Files, Hashed Files
Tue 2-3 Lecture: Hashed Files
Tue 3-4: Linear Hashing
Week 6
23/03/2020 - 29/03/2020
Mon 12-1 Lecture: Indexing
Mon 1-2 Lecture: B-Trees
Tue 2-3 Lecture: Nd Selection
Lecture #4: Multi-attribute Hashing
Week 7
30/03/2020 - 05/04/2020
Lecture #1: Signature-based Indexing
Lecture #2: Assignment 2
Lecture #3: Multidimensional Tree Indexes
Lecture #4: Similarity-based Retrieval
Week 8
06/04/2020 - 12/04/2020
Lecture #0: Intro, DB Nerds
Lecture #1: Netsed-loop Join
Lecture #2: Sort-merge Join
Lecture #3: Hash Join
Lecture #4: Query Evaluation
Week 9
13/04/2020 - 19/04/2020
Lecture #0: Notices, DB Nerds
Lecture #1: Query Execution
Lecture #2: Query performance
Lecture #3: Transactions
Lecture #4: Concurrency Control
Week 10
20/04/2020 - 26/04/2020
Lecture #0: Notices, DB Nerds
Lecture #1: Atomicity, Durability
Lecture #2: Database Trends
Lecture #3: Parallel and Distributed DBMSs
Lecture #4: Course Review, Exam
Back to top
COMP9315 20T1 (DBMS Implementation)
is powered by
WebCMS3
CRICOS Provider No. 00098G
