EPL446: Advanced Database Systems
by Demetris Zeinalipour
Department of Computer Science
University of Cyprus

Quick Links

WebMail
CS Courses

EPL446: Laboratory


Week

Description
  Material
2

 Introduction to the Minibase System

3

 

Exercises: Storage and Indexing Overview

Official Announcement of Topics for the Semester Presentation

4

Exercises: Tree-based Indexing (B+ Tree Delete Algorithm)

5

Indroduction to Postgress Indexes

6 Exercises: External Sorting & Evaluation of Relational Operators (Projections)
7 Exercises: Evaluation of Relational Operators (Joins)
8

Explanation of AS2/3 & Exercises: Query Optimization Problems


9


Setting up SSH public/private keys & Exercises: Characterizing Schedules on Serializability and Recoverability
10
Introduction to Postgress transactions

11

Exercises: Concurrency Control with Locking
12 Exercises: Concurrency Control with Timestamps

13

Exercises: Database Recovery Techniques


 

Copyright Department of Computer Science, University of Cyprus