Slides and Reader
Contents of the course| Subject (preliminary) | Slides | Reader | |
|---|---|---|---|
| 13.4. | Introduction | Organization of the course 1 per page / 6 per page Introduction-1.pdf Introduction-6.pdf |
E.F. Codd: A Relational Model of Data for Large Shared Data Banks, CACM 6/1970 |
| 15.4 | Conceptual Data modeling(1): ERM vs UML (2.1): Integrity constraints |
ConcMod-1-1.pdf ConcMod-1-6.pdf ConcMod-2-1.pdf ConcMod-2-6.pdf |
P. Chen: original paper on ER-Modeling |
| 20.4. | OO concepts in ER, Modeling patterns Mapping ER to RDM |
Datadefinition-1-1.pdf Datadefinition-1-6.pdf |
|
| 22.4. | SQL Data Definition. Functional dependencies ACM- and IEEE-links mentioned in the course (VPN required) |
Datadefinition-2-1.pdf Datadefinition-2-6.pdf |
Radio podcast: Interview with Jim Melton, SQL standardization main player. Lesen: SQL DDL Oracle / PG Happy Birthday, RDBMS CACM 5/2010 |
| 27.4. | Data Definition: how to express constraints |
||
| 29.4. | Functional dependencies and Normal forms | Normal Forms-1.pdf Normal-Forms-6.pdf |
See online book on Relational Theory by Maier |
| 4.5. | BCNF; Relational Algebra and elementary SQL | Rel. Algebra-1.pdf Rel. Algebra-6.pdf |
|
| 6.5. | Rel. Algebra (2) SQL DML |
SQL_DML-1.pdf SQL_DML-6.pdf (new, complete) |
SQL-differences of various DBS Mondial Schema (ER) " (Rel.Mod) |
| 11.5. | Advanced SQL | " | |
| 13.5. | - | (Himmelfahrt) | |
| 18.5. | Views, Stored Procedures PL/pgSQL, triggers | ViewsPL/SQLetc-1.pdf ViewsPL/SQLetc-6.pdf |
Application Development (Oracle Manual), chap. 1 for PL/pgSQL see Postgres Manual V "Server programming" , for PL/SQL: Intro by J. Ullman |
| 20.5. | Embedded SQL, JDBC, | ESQL/JDBC-1-1.pdf ESQL/JDBC-1-6.pdf |
|
| 25.5. | JDBC(2) SQLJ,OR-Mapping. |
ESQL/JDBC-2-1.pdf ESQL/JDBC-2-6.pdf |
JDBC z.B. Sun: http://java.sun.com/j2se/1.4.2/docs/guide /jdbc/getstart/GettingStartedTOC.fm.html Connection Mgr with Connection Pooling: - Interface and Implementation (useful to study!) Hibernate Tutorial |
| 27.5. | Indexing, B-Trees | PhysSchemaB+tree-1.pdf PhysSchemaB+tree-6.pdf |
The original B-tree paper by Bayer, McCreigth |
| 1.6. | Serializability | DBS-TA-1.pdf DBS-TA-6.pdf |
|
| 3.6. | Two Phase locking | DBS-CC-1-1.pdf DBS-CC-1-6.pdf |
Deadlockdetection in the real world: how PostgresSQL does it |
| 8.6. | Optimistic CC, MVCC-1 |
DBS-CC-2-1.pdf DBS-CC-2-6.pdf |
DBS Concurrency Control in a nutshell |
| 10.6. | MVCC-2, Resilience | DBS-LogRec-1.pdf DBS-LogRec-6.pdf |
|
| 15.6. | Recovery Data Warehouse (1) |
" DWH-1.pdf DWH-6.pdf updated |
|
| 17.6. | Data Warehouse | " | |
| 22.6. | Data Mining | DM-1.pdf DM-6.pdf |
|
| 27.6. | Information Retrieval | Slides on IR, not part of the course IR-1.pdf IR-6.pdf |
L. Page, S. Brin: The anatomy of a hypertext search engine. (i.e. the Googele search engine ~ 1998) |
| 29.6. | Klausur /final exam |