Lecture “Relational Database Systems 2”

Information
Classification: 
Master Informatik / Wirtschaftsinformatik
Credits: 
4
Exam: 
Oral (scoring 50% of total exercise points is required to take final exam)
Regular Dates: 
9:45 am - 12:15 pm on Wednesdays in M160
Materials
Date Title Slides Print slides Video
01.04.2009 System Architecture download download view download
08.04.2009 Physical Data Storage download download view download
15.04.2009 Indexing and Access Paths download download view download
22.04.2009 Trees and Advanced Indexes download download view download
29.04.2009 Query Processing download download view download
06.05.2009 Query Optimization download download view download
13.05.2009 Query Optimization II download download view download
20.05.2009 Join Order Optimization download download view download
27.05.2009 Transaction Processing (1) download download ---
10.06.2009 Transaction Processing 2 download download view download
17.06.2009 Recovery download download view download
24.06.2009 Security download download view download
01.07.2009 Beyond Relational Databases download download view download
01.07.2009 More things beyond RDBs download download view download

Evaluation

Results of the evaluation are available now.

Exercises

The results from exercises [1-12] are shown below:

group # 1 2 3 4 5 6 7 8 9 10    
total % 79% 51% 74% 66% 55% 56% 64% 56% 73% 70% 26% 08%

 

AttachmentDateSize
File RDB2_01_SystemArchitecture.pdf02/04/09 1:56 pm2.99 MB
File RDB2_01_SystemArchitecturePrint.pdf02/04/09 1:56 pm1.76 MB
File rdb2-ss09-v1.avi07/04/09 8:41 am29.19 MB
File RDB2_02_Storage.pdf07/04/09 1:51 pm5.99 MB
File RDB2_02_StoragePrint.pdf07/04/09 1:52 pm4.08 MB
File rdb2-ss09-v2.avi14/04/09 8:29 am140.97 MB
File RDB2_03_Indexing.pdf14/04/09 12:48 pm4.65 MB
File RDB2_03_IndexingPrint.pdf14/04/09 12:48 pm2.5 MB
File rdb2-ss09-v3.avi20/04/09 12:35 pm138.71 MB
File RDB2_04_Trees.pdf21/04/09 6:26 pm5.67 MB
File RDB2_04_TreesPrint.pdf21/04/09 6:27 pm3.69 MB
File rdb2-ss09-v4.avi27/04/09 6:14 pm181.55 MB
File RDB2_05_QueryProc.pdf28/04/09 9:53 am5.47 MB
File RDB2_05_QueryProcPrint.pdf28/04/09 9:53 am2.8 MB
File rdb2-ss09-v5.avi04/05/09 10:18 am142.27 MB
File RDB2_06_QueryOpt1.pdf06/05/09 6:20 pm5.39 MB
File RDB2_06_QueryOpt1Print.pdf06/05/09 6:20 pm3.06 MB
File rdb2-ss09-v6.avi07/05/09 3:09 pm157.45 MB
File rdb2-ss09-v6.flv07/05/09 3:10 pm140.52 MB
File RDB2_07_QueryOpt2.pdf13/05/09 5:36 pm5.34 MB
File RDB2_07_QueryOpt2Print.pdf13/05/09 5:36 pm3.19 MB
File rdb2-ss09-v7.avi19/05/09 9:38 am91.08 MB
File RDB2_08_QueryOpt3.pdf20/05/09 1:30 pm5.42 MB
File RDB2_08_QueryOpt3Print.pdf20/05/09 1:30 pm2.63 MB
File RDB2_09_Transactions1.pdf25/05/09 4:23 pm4.47 MB
File RDB2_09_Transactions1Print.pdf25/05/09 4:23 pm3.13 MB
File rdb2-ss09-v8.avi25/05/09 4:47 pm145.28 MB
File RDB2_10_Transactions2.pdf15/06/09 9:37 am5.8 MB
File RDB2_10_Transactions2Print.pdf15/06/09 9:37 am3.28 MB
File RDB2_11_Recovery.pdf15/06/09 9:37 am5.1 MB
File RDB2_11_RecoveryPrint.pdf15/06/09 9:38 am3.19 MB
File rdb2-ss09-v9.avi22/06/09 10:40 am65.65 MB
File rdb2-ss09-v10.avi22/06/09 10:41 am65.65 MB
File RDB2_12_Security.pdf24/06/09 4:04 pm4.7 MB
File RDB2_12_SecurityPrint.pdf24/06/09 4:04 pm2.61 MB
File rdb2-ss09-v11.avi26/06/09 1:53 pm139.02 MB
File RDB2_13_NonStandardAppl.pdf29/06/09 3:33 pm19.24 MB
File rdb2-ss09-v12.avi29/06/09 3:37 pm154.32 MB
File rdb2-ss09-v13.avi07/07/09 5:14 pm207.61 MB
File RDB2_13_XMLNonStdApplPrint.pdf08/07/09 9:47 am5.22 MB
File RDB2_14_NonStandardAppl2.pdf09/07/09 6:47 pm8.5 MB
File RDB2_14_NonStandardAppl2Print.pdf09/07/09 6:48 pm4.14 MB
File rdb2-ss09-v14.avi13/07/09 10:38 am147.78 MB
File SS_09-Relationale_Datenbanksysteme_II.pdf14/07/09 1:42 pm324.28 KB