Datenbanktheorie
VU 181.140 (2.0) Sommersemester 2013
Reinhard Pichler
|
|
General information
- Language. This lecture will most probably be held in English since it is part of the EMCL curriculum (European Master's Program in Computational Logic).
- Place. Classes will be held in the Seminarraum 188/2 (Favoritenstraße 9-11, 4th floor, stairs 3).
- Time. The course has a regular meeting time. Classes will be held Tuesdays, 9:00 sharp - 11:00. Depending on the number of students, additional classes will be needed for the students' presentations at the end of the semester. The first class meets on Tuesday, 5 March, 9:00 - 11:00.
- Prerequisites. This course is designed for master's students. It is highly recommended to attend this course after the course Formale Methoden der Informatik (185.291). Students are assumed to have a basic knowledge in mathematical logic and to be familiar with basic concepts of complexity theory (to the extent taught in the course "Formale Methoden der Informatik").
Registration
Registration in TISS is required for this course!!
(Attention: registration != subscription)
Course overview
In this course, some fundamental aspects of query languages will be touched on. The following topics will be covered (as time permits):- Relational Query Languages
- Introduction to Datalog
- Relational Algebra vs. First-Order Logic (Codd's Theorem)
- Undecidability Results (Trakhtenbrot's Theorem)
- Complexity of Query Evaluation
- (Acyclic) Conjunctive Queries
- Inexpressibility Results (Ehrenfeucht-Fraïssé Games, 0-1 Laws)
Schedule of lectures (preliminary plan)
| Lecture | Date/Place | Topic | Slides | Supplementary material | 1 | Tuesday, 05-March 9:00 - 11:00 Seminarraum 188/2 |
General Information Introduction: Relational Query Languages |
dbt00,
4x1 dbt01, 4x1 |
|
| 2 | Tuesday, 12-March 9:00 - 11:00 Seminarraum 188/2 |
Introduction to Datalog
|
dbt02, 4x1 |
|
| 3 | Tuesday, 19-March 9:00 - 11:00 Seminarraum 188/2 |
Codd's Theorem | dbt03, 4x1 | |
| 4 | Tuesday, 9-April 9:00 - 11:00 Seminarraum 188/2 |
Trakhtenbrot's Theorem
Information on the Report and Presentation |
dbt04,
4x1
report, 4x1 |
|
| 5 | Tuesday, 16-April 9:00 - 11:00 Seminarraum 188/2 |
Complexity of Query Evaluation
|
dbt05, 4x1 | |
| 6 | Tuesday, 23-April 9:00 - 11:00 Seminarraum 188/2 |
Conjunctive Queries | dbt06, 4x1 | |
| 7 | Tuesday, 30-April 9:00 - 11:00 Seminarraum 188/2 |
Conjunctive Queries (continued)
|
|
|
| 8 | Tuesday, 7-May 9:00 - 11:00 Seminarraum 188/2 |
Ehrenfeucht-Fraïssé Games | dbt07, 4x1 | |
| 9 | Tuesday, 14-May 9:00 - 11:00 Seminarraum 188/2 |
Ehrenfeucht-Fraïssé Games
(continued) |
|
|
| Tuesday, 21-May |
no class
|
|
|
|
| 10 | Tuesday, 28-May 9:00 - 11:00 Seminarraum 188/2 |
Beyond relational data | |
|
| 11 | Tuesday, 4-June 9:00 - 11:00 Seminarraum 188/2 |
students' presentations |
|
|
| 12 | Tuesday, 11-June 9:00 - 11:00 Seminarraum 188/2 |
students' presentations |
|
|
| 13 | Tuesday, 18-June 9:00 - 11:00 Seminarraum 188/2 |
students' presentations |
|
|
| 14 | Tuesday, 25-June 9:00 - 11:00 Seminarraum 188/2 |
students' presentations |
|
Assessment
Assessment will be based on students' presentations and an oral exam at the end of the term. Detailed information will be provided in the first class.Selection of References
S. Abiteboul, R. Hull, and V. Vianu: Foundations
of Databases, Addison-Wesley, 1995.
G. Gottlob, N. Leone, and
F. Scarcello: The
Complexity of Acyclic Conjunctive Queries, J. ACM 48(3): 431-498 (2001)
(acm digital library).
G. Kolaitis: On
the Expressive Power of Logics on Finite
Models
(pdf).
| Last modified 19 February, 2013 |