CSEN 604 Data Bases II

Announcements

Mini-project 1 deadline

based on your request, extended to Friday, March 29th, 11:50PM. No further extensions will be given.

Mini-project 1 milestones

As per the project document, there are two milestones you have to submit: one without index and the second with an index. I am relaxing the requirement and you can submit one final deliverable with support for both using an index and not using an index. However, I must alert you that the project requires a significant development effort and by working on both features at the same time, you risk not handing in any submission that is working, and that in turn decreases our ability to give you partial marks. If you prefer to work on two separate submissions, you must submit as per specified date: March 4th, 2019, 11:50PM

DBII exam coverage

Exam is comprehensive covering all topics presented before/after midterm. Check sample exams. A previous announcement included a link to previous exams.

Quiz 2 for CSEN

Quiz 2 will be held on Monday April 1st, from 4-5PM in the following halls: H18 for (T7, T8, T9, and T10) H12 for (T11, T12, T13, T14, T15) H13 for (T16, T17, T18, T19, T20) Material included in Quiz 2 are those of lectures 6, 7 and 8 (physical plan + its estimation + undo logs). You are only allowed to attend in your designated hall.

Project 2 posted

in materials section

DBII Previous exams

have been placed here: https://drive.google.com/file/d/1yuaJP6nWrvZuGijKLqKjbr_g2mDcGRJq/view

PostgreSQL bitmap indices...

There is no explicit command you can issue to PostgreSQL that will result in creating a bitmap index. They are created on the fly while answering a query in PostgreSQL if the optimizer decides that it is the best strategy. You can force PostgreSQL optimizer to create bitmap indices by using one or more of the following: 1) you disable all other options 2) have the right data that bitmaps are best for, 3) do not create any index on the table.

Team member evaluation...

It has come to my attention that some team members are not working at all on the project which is causing problems for those who are more committed. A team member evaluation form has been posted in materials section. Submit the form to your TA after project deadline. If you end working alone and do not finish, that will be taken into consideration, and each team member will have a separate evaluation to reveal the actual contribution.

Midterm details...

Midterm is closed book. Bring your calculator. Midterm has 3 questions: Q1. Database Indices 20/60, Q2. Database Indices Usage 20/60 and Q3. Query Estimation 20/60.

Quiz 2 for BI

Quiz 2 will be held on Tuesday April 2nd, from 4-5PM in the following halls: H10 for (T16, T17) and H11 for (T18, T19) Material included in Quiz 2 are those of lectures 6, 7 and 8 (physical plan + its estimation + undo logs). You are only allowed to attend in your designated hall.

Project milestone II extended

to Wednesday March 27th - 11:59PM.

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
RenewSession