Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision Both sides next revision
teaching:infoh417 [2019/11/18 15:30]
svsummer
teaching:infoh417 [2019/11/21 09:12]
svsummer [COURSE TRAJECTORY]
Line 97: Line 97:
   * You are expected to solve exercise 2 of the {{:​teaching:​infoh417:​04-costbasedsel-ex.pdf|cost-based plan selection exercises}} ​ by the exercises session of **November 15**.   The solutions {{:​teaching:​infoh417:​04-costbasedsel-sol-slides.pdf|are online}}.   * You are expected to solve exercise 2 of the {{:​teaching:​infoh417:​04-costbasedsel-ex.pdf|cost-based plan selection exercises}} ​ by the exercises session of **November 15**.   The solutions {{:​teaching:​infoh417:​04-costbasedsel-sol-slides.pdf|are online}}.
  
-==== Lecture ​8: Coping with System Failures ​ ====+==== Lecture ​7: Coping with System Failures ​ ====
  
-  * During lecture ​{{:​teaching:​infoh417:​slides-lect8-part1.pdf|slides part 1}} {{:​teaching:​infoh417:​slides-lect8-part2.pdf|slides part 2}} we gave a short introduction to transaction processing in general, and dove into coping with systems failures in particular. The details may be found in chapter 17 of the book.+  * During lecture ​{{:​teaching:​infoh417:​slides-lect8-part1.pdf|slides part 1}} {{:​teaching:​infoh417:​slides-lect8-part2.pdf|slides part 2}} we gave a short introduction to transaction processing in general, and dove into coping with systems failures in particular. The details may be found in chapter 17 of the book.
  
   * You are expected to solve the integrated exercise 8.2 of the {{:​teaching:​infoh417:​02-logicalopt-ex.pdf|optimization exercises}},​ and 3.5 of the {{:​teaching:​infoh417:​04-costbasedsel-ex.pdf|cost-based plan selection exercises}} by the exercise session of **Friday, November 22**. **It is strongly suggested that you try doing these exercises, as they are typical exam questions.**  ​   * You are expected to solve the integrated exercise 8.2 of the {{:​teaching:​infoh417:​02-logicalopt-ex.pdf|optimization exercises}},​ and 3.5 of the {{:​teaching:​infoh417:​04-costbasedsel-ex.pdf|cost-based plan selection exercises}} by the exercise session of **Friday, November 22**. **It is strongly suggested that you try doing these exercises, as they are typical exam questions.**  ​
  
   * You are expected to solve exercises 17.2.2, 17.2.4, 17.2.5, 17.2.7, 17.3.2, 17.3.3, 17.3.4, 17.3.5, 17.4.2, 17.4.3, 17.4.4, and 17.4.5 in the book by exercise session of **Friday, November 29**.   * You are expected to solve exercises 17.2.2, 17.2.4, 17.2.5, 17.2.7, 17.3.2, 17.3.3, 17.3.4, 17.3.5, 17.4.2, 17.4.3, 17.4.4, and 17.4.5 in the book by exercise session of **Friday, November 29**.
 +
 +==== Lecture 8: Integrated exercises ​ ====
 +
 +  * During lecture 8 we focused on solving integrated exercises 8.2 of the {{:​teaching:​infoh417:​02-logicalopt-ex.pdf|optimization exercises}},​ and 3.5 of the {{:​teaching:​infoh417:​04-costbasedsel-ex.pdf|cost-based plan selection exercises}}.
 +
 +==== Lecture 9: Concurrency control ====
 +
 +  * During lecture 9 ({{:​teaching:​infoh417:​slides-lect9.pdf|slides}}),​ we studied the problems that can occur when a database runs many transactions concurrently and the different kinds of scheduling algorithms that can prevent these problems. The details can be found Chapter 18 (sections 18.5, 18.6. 18.7 is excluded).
 +
 +  * You are expected to solve exercises ​ 18.2.4(b,​d,​e),​ 18.8.1(b,​d),​ 18.8.2 (a,c), and 18.9.1 (c,f)  by the response lecture of **Friday, December 6**.  ​
 +
 +==== Revision session ====
 +
 +Durig the lecture & exercise session ​ of **Friday, december 6** you have the opportunity to  ask questions on the theory and exercises. In particular, if you would like to have a certain part of a lecture re-explained,​ or an exercise re-corrected,​ then this is possible **provided that you let prof. Vansummeren know your question by monday, december 2 at the latest**. ​
 + 
 
teaching/infoh417.txt · Last modified: 2020/09/10 08:46 by svsummer