Home › Teaching › SS 2009 › RDB2

Lecture “Relational Database Systems 2”

Information
Lecturer: 
Dr. Silke Eckstein
Assistant: 
Dipl.-Inform. Andreas Kupfer
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
QIS Link: 
https://mhb.tu-bs.de/mhb0909ss/veranstaltungAbstract.do?id=9646
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
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

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%