Freie Universität
Berlin
Fachbereich Mathematik und
Informatik
Institut für Informatik
AG Datenbanken / Informationssysteme
Slides | Subject | Assignments | ||
12.4. |
info (6) info(2) intro (6) intro(2) |
General
information. Introduction: files and databases, global architectures, data models. |
||
14.4 |
concept-1-2.pdf concept1-6.pdf |
Conceptual
Modeling (1): ER-Modelling Conceptual Modeling (2): constraints |
Übungszettel 1 personen.txt Musterlösung 1 |
|
19.4. |
concept-2-2.pdf concept-2-6.pdf |
Conceptual Modeling
(2): cardinaltity constraints, n-ary relations,
generalization/specialization |
||
21.4. |
RelDM-1-2.pdf RelDM-2-6.pdf |
Mapping a
conceptual model to relations |
Übungszettel
2 Musterlösung 2 |
|
26.4. |
SQL/DDL-1-2.pdf SQL/DDL-1-6.pdf SQL/DDL-2-2.pdf SQL/DDL-2-6.pdf |
Schema
definition in SQL (1) |
Übungszettel 3 Musterlösung 3 TempDatentypen |
|
28.4. |
FuncDep1-2.pdf FuncDep1-6.pdf |
Schema
definition SQL/DDL (2); Schema definition: design quality Functional dependencies and Normal forms (1) |
||
3.5. |
FuncDep2-2.pdf FuncDep2-6.pdf |
Normal
forms |
Übungszettel 4 Musterlösung 4 |
|
10.5. |
Normalization
algorithms |
Übungszettel 5 Musterlösung 5-1 Musterlösung 5-2 |
||
12.5. |
RelAlgebra-2.pdf RelAlgebra-6.pdf |
Relational
Algebra |
||
17.5. |
TupelCalc-2.pdf TupelCalc-6.pdf SQL-Einf-2.pdf SQL-Einf-6.pdf |
SQL/DML
(1) |
||
19.5. |
AdvancedSQL-2.pdf AdvancedSQL-6.pdf |
SQL/DML
(2) |
Übungszettel 6 Musterlösung 6 |
|
24.5. |
" Advanced
SQL, |
|||
26.5. |
Views-2.pdf Views-6.pdf |
Views
, Security and Right |
Übungszettel 7 Terra DB Schema Musterlösung 7 |
|
31.5. |
Extensions-2.pdf Extensions-6.pdf |
SQL
extensions(1) (user defined types etc.) |
||
2.6. |
DBsecurity-2.pdf DBsecurity-6.pdf |
PL/SQL
etx, (SQL
rights) |
Übungszettel 8 VideoDB-Create VideoDB-Insert |
|
7.6. |
Embedded-1-2.pdf Embedded-1-6.pdf |
Rights;
Embedded
SQL / C |
||
9.6 |
Embedded-2-2.pdf Embedded-2-6.pdf |
Embedded
SQL, Java , |
Dateien für das Projekt: Erste Schritte (pdf) Einfaches Bsp (zip) MVC Konzept MVC Bsp (zip) Sequenzdiagramm |
|
14.6 |
JDBC , SQLJ , OR mapping, EJB performance | |||
16.6. |
DWH-2.pdf DWH-6.pdf |
Data
Warehouse in a Nutshell |
Test 3 | |
21.6. |
Phys-2.pdf Phys-6.pdf |
Physical
Aspects of Data Management: RAID, physical storage, Indexing (1) |
||
23.6. |
First
paper on R-trees by Goodman |
Indexing
, Multidimensional Indexing: R-trees |
Übungszettel 9 Musterlösung 9 |
|
separate course for bio-informatics
starts june 28. |
||||
28.6.
14-16 |
TA-2.pdf TA-6.pdf |
Transactions:
model, conflict-serializability, serialization theorem |
||
28.6.
8-10 |
Intro-2.pdf Intro.6.pdf |
Introduction
to management of molecular biological DB (MDB) |
Übung B1 Übersichtsartikel zu MDB |
|
30.6.
14-16 |
CC-2.pdf (1+2) CC-6.pdf (1+2) updated: RO-TA and MVCC |
Concurrency
Control (1) |
Übungszettel 10 Musterlösung 10 |
|
30.6.
8-10 |
IR-2.pdf IR-6.pdf |
Language
processing and Information Retrieval in MDB |
Artikel:
Med. Abbrev. 3D VectorspaceRetrieval Indexing GenomicDB |
|
5.7.14-16 |
see
30.6., |
Concurrency
Control (2) |
||
5.7.
8-10 |
XML-1-2.pdf XML-1-6.pdf |
IR
/ XML(1) Sample DTD:Int.Nucleotide Sequence Database (INSD) Sample XML schema: EMBL common |
Sequenceformate: EMBl FASTA INDXML |
|
7.7.
14-16 |
Recov-1-2.pdf Recov-1-6.pdf |
Again
CC (optimistic, Timestamps, Escrow-locks) Logging
and recovery (1) |
Übungszettel 11 Musterlösung 11 Test 1 Test 2 |
|
7.7.8-10 |
XML-2-2.pdf XML-2-6.pdf Vortrag zu EMBL |
XML(2) |
Artikel zu EMBL ÜbungB2.pdf Datei kraus.xml zur Übung |
|
12.7. 14-16 | Recov-2.2.pdf Recov-2-6.pdf |
Logging
and recovery (2), |
||
12.7.8-10 | Datamining-2.pdf Datamining-6.pdf Genexpr.-DB-2-pdf (J.Russ) |
Datamining
in a Nutshell (1) - Intro, Decision trees |
XML/DB für
Microarraydaten (Bachelor-Theses, Uni Göttingen) |
|
14.7. 14-16 | Logging and recovery (2) | |||
14.7.8-10 | Swissprot-2.pdf (S. Stiller) |
Datamining
in a Nutshell (2) - Decicison treed, association rules |
||