CSEN 604 Data Bases II


Exam content.

Six questions on 15 pages including an aid sheet about spatial databases. Questions are: Database Indices 25/100, Query Estimation and Plans 22/100, Logs & Recovery 9/100, Transactions & Concurrency 24/100, Spatial Databases 10/100, SQL/NoSQL Databases 10/100

Project - bitmap index

I am relaxing the requirement for a bitmap index constructed on the column that is not used to sort the table. You can do it without a dense copy of the values provided that you keep the values sorted in the bitmap index. This way, you can do range queries as well as aggregate functions using the bitmap index. You do not need to implement a dense-like intermediate layer and a bitmap suffices.

Quiz 3 content

Lecture 7, 8 and 9.

Latest Material

Course Staff

Teaching assistant

Course Meetings

Office Hours

  • On Tuesday 5th slot , for Amal Yassien in C6.209