This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
teaching:infoh417 [2019/09/10 12:14] svsummer |
teaching:infoh417 [2020/09/10 08:46] (current) svsummer |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| ====== INFO-H-417 : Database Systems Architecture ====== | ====== INFO-H-417 : Database Systems Architecture ====== | ||
| - | <note important>If you are following this course, please fill in [[https://docs.google.com/forms/d/e/1FAIpQLSeNNsjBE-zrhNulpldr3-z-PB8W5hHPDMcVFdho-0PGqgmvPw/viewform|this form]] **before october 1**. This allows the course responsibles to contact you if needed, and get a better overview of the participant's background.</note> | + | <note important>This course has moved to the [[https://uv.ulb.ac.be/course/view.php?id=92219|Virtual University]]</note> |
| ===== GENERAL INFORMATION ===== | ===== GENERAL INFORMATION ===== | ||
| Line 25: | Line 25: | ||
| relational database management systems ensures recovery from errors | relational database management systems ensures recovery from errors | ||
| and controls concurrent access to the data. Topics studied in transaction processing include logging, serializability, concurrency control, and their combination. | and controls concurrent access to the data. Topics studied in transaction processing include logging, serializability, concurrency control, and their combination. | ||
| - | |||
| - | ==== Contacts ==== | ||
| - | |||
| - | * **Lecturer**: [[http://code.ulb.ac.be/code.people.php?id=992|Stijn Vansummeren]] (Campus Solbosh, Building U, 4th floor, room UB4.125) | ||
| - | |||
| - | |||
| - | ==== Organisation ==== | ||
| - | |||
| - | * The course is taught during the first semester | ||
| - | * The list of competences that will be taught during the course and interrogated during the exam is available in the {{:teaching:infoh417:course plan.pdf|course plan.}} | ||
| - | |||
| ==== Course Material ==== | ==== Course Material ==== | ||
| - | The course uses the book [[http://www.amazon.co.uk/gp/product/129202447X/ref=s9_simh_gw_p14_d0_i1?pf_rd_m=A3P5ROKL5A1OLE&pf_rd_s=center-2&pf_rd_r=05ETHX35GZHR16YA722M&pf_rd_t=101&pf_rd_p=455344027&pf_rd_i=468294|"Database Systems: The Complete Book (second, international edition)"]] by H. Garcia-Molina, J. D. Ullman, and J. Widom (ISBN-13: 978-0131354289), complemented by course notes made available on this website. | + | For the table of contents, course notes, slides, exercises and solutions, as well as recording of the lectures, see the [[https://uv.ulb.ac.be/course/view.php?id=92219|Virtual University]] page. |
| - | + | ||
| - | ==== Method of Evaluation ==== | + | |
| - | + | ||
| - | Students are evaluated on both a project to be developed during the semester, and a written exam. The project work contributes 6/20 points to the overall score, and the written exam contributes the remaining 14/20 points. Participation in both the project work and the written exam are mandatory requirements for passing the course. | + | |
| - | + | ||
| - | ===== COURSE TRAJECTORY ===== | + | |
| - | + | ||
| - | ==== Lecture 1: Course Introduction and Translation of SQL into the Relational Algebra ==== | + | |
| - | + | ||
| - | * During lecture 1 we refresh the basic background knowledge on relational database management systems (relations, relational algebra, SQL). To re-acquaint yourself with the relevant background knowledge, you are expected to read thoroughly chapter 1, chapter 2 (only sections 2.2 and 2.4), chapter 5 (only sections 5.1 and 5.2) and 6 from the handbook TCB. | + | |
| - | + | ||
| - | * During lecture 1 ({{:teaching:infoh417:slides-lect1.pdf|slides}}), we present an overview of the architecture of a query compiler (see chapter 16, sections 16.1, 16.3.1 and 16.3.2 in the book) and study the translation of SQL into the extended relational algebra (see {{:teaching:infoh417:sql2alg_eng.pdf|course notes}} for the full translation algorithm). | + | |
| - | + | ||
| - | * You are expected to solve exercise 1 of the {{:teaching:infoh417:01-sql2alg-ex.pdf|translation exercises (pdf)}} by the exercise session of friday 27 september. Exercise 2 gives extra exercise possibilities, but will not be corrected in class. | + | |
| - | + | ||