|
|
Hjemmeside for kurset Datalagring og formater, E2009
The main part of the course deals with relational databases, including theory and practice for modeling and quering a database. The course also considers storage and manipulation of data in XML format. Look up the course description for a description of the teaching goals.
Admin
Textbook
|
|
Database Systems: An Application-Oriented Approach, 2nd edition by M.Kifer, A.Bernstein and P.Lewis.
Before you start reading, take a look at my take on how to read the book.
|
Course Plan
| 24/8 |
Introduction, Context, Relational Model, Integrity Constraints |
1, 2, 3.1, 3.2 |
3.2, 3.7, 3.14 |
|
| 31/8 |
SQL DDL, Rel. Algebra |
3.3, 5.1 |
3.8, 5.1, 5.3*, 5.6*,
5.10* (i), 5.12* |
Lab1 |
| 7/9 |
ER Modelling, UML, Normalization |
4, 6 |
4.7 (UML)*, 4.9 (b),
6.22, 6.29 (a,b)* |
Lab2 |
| 14/9 |
XML, DTD, XML Schema |
15.1, 15.2, 15.3 (17.1-3 green book) |
15.1*, 15.13* |
|
| 21/9 |
SQL, repetitions |
5.2 |
5.17*, 5.19* |
Lab3 |
| 28/9 |
SQL + Host Language |
8.1-8.5 |
Lab4* |
Lab4 |
| 5/10 |
XML Query Languages |
15.4.1, 15.4.3 (17.1 green book) |
Lab3* |
Lab5 |
| 12/10 |
|
|
|
|
| 19/10 |
Transactions: ACID properties, model, triggers |
18, 19.1, 7 (13.1, 13.2 green book) |
18.8*, 18.10*, 18.11* (pdf) |
Lab6 |
| 26/10 |
Concurrency control and recovery |
20.1-20.5, 22.1-2 |
Lab6* |
|
| 2/11 |
Indexes, repetitions |
9, 12.2.1 |
|
|
| 9/11 |
Parallel Databases, Map Reduce, Data Integration |
|
|
|
| 16/11 |
External lecture, spørgetime |
|
|
|
Note that only the exercises marked with a * are obligatory.
Exercises
The following exercises (and their correction), will help you prepare for the exam:
Here is the white exam distributed in class on 16/11, and its correction.
Assignment
There is one mandatory assignment. This is an individual assignment. The assignment will be available on October 5th and due back on November 16th.
Exam
Please fill out the following evaluation form before/after you read up the exam correction.
|
|
