|
 Online Resources |
Online Resources |
|
 Database Course 2014/15 |
|
|
 Solutions to Old Exams |
|
|
| Homework Assignments |
 Gradiance Registration Instructions |
|
|
Gradiance System |
|
|
Ex1 |
|
|
sol1 |
|
|
Ex3 |
|
|
sol3 |
|
|
Ex5 |
|
|
 ex5Testers.zip |
|
|
ex6 (updated) |
|
|
 createTables.sql |
|
|
ex6 testers |
|
|
ex7 |
|
|
Ex7 solution |
|
|
ex10 PDF |
|
|
Ex10 Solution |
|
|
 ex10 docx |
|
|
| Introduction and Administration |
 PPT |
|
|
PDF |
|
|
| Modeling with Entity Relationship Diagrams |
Lecture PPT |
|
|
Lecture PDF (1 slide per page) |
|
|
Lecture PDF (6 slides per page) |
|
|
Tirgul PPT |
|
|
Tirgul PDF |
|
|
Tirgul Solutions PPT |
|
|
Tirgul Solutions PDF |
|
|
| Querying: Relational Algebra |
RelAlg PPTX |
|
|
RelAlg PDF (1 slide per page) |
|
|
RelAlg PDF (6 slides per page) |
|
|
RelAlg Tirgul PPT |
|
|
RelAlg Tirgul PDF (1 slide per page) |
|
|
RelAlg Tirgul PDF (6 slides per page) |
|
|
RelAlg Tirgul Solutions PPT |
|
|
RelAlg Tirgul Solutions PDF (1 slide per page) |
|
|
RelAlg Tirgul Solutions PDF (6 slide per page) |
|
|
| Querying: SQL |
SQL Query Language (PPT) |
|
|
SQL DDL Language (PPT) |
|
|
SQL Query Language (1 slide per page) |
|
|
SQL Query Language (6 slides per page) |
|
|
SQL DDL Language (PDF) |
|
|
SQL Tirgul (PPT) |
|
|
SQL Tirgul (PDF) |
|
|
SQL Tirgul Solution (Part 1) |
|
|
SQL Tirgul Solution (Part 2) |
|
|
| Programming: JDBC, PLSQL, Triggers |
PL/pgSQL (PPT) |
|
|
PL/pgSQL (PDF 1 slide per page) |
|
|
PL/pgSQL (PDF 6 slides per page) |
|
|
JDBC (PPT) |
|
|
JDBC (PDF 1 slide per page) |
|
|
JDBC (PDF 6 slides per page) |
|
|
Views, PL/SQL Tirgul (PPT) |
|
|
Views, PL/SQL Tirgul (PDF) |
|
|
Views, PL/SQL Tirgul Solution PPT |
|
|
Views, PL/SQL Tirgul Solution PDF |
|
|
| Design Theory |
PPT |
|
|
PDF |
|
|
PDF (6 slides per page) |
|
|
Finding All Keys PPT |
|
|
Finding All Keys PDF |
|
|
Finding All Keys (6 slides) |
|
|
Design Theory Limitations and Uses PPT |
|
|
Design Theory Limitations and Uses PDF |
|
|
Design Theory Limitations and Uses (6 slides) |
|
|
Tirgul 1 PPT |
|
|
Tirgul 1 PDF |
|
|
Tirgul 2 PPT |
|
|
Tirgul 2 PDF |
|
|
Trigul 3 PPT |
|
|
Tirgul 3 PDF |
|
|
Tirgul 1 Solution PPT |
|
|
Tirgul 1 Solution PDF |
|
|
Tirgul 2 Solution PPT |
|
|
Tirgul 2 Solution PDF |
|
|
Tirgul 3 Solution PPT |
|
|
Tirgul 3 Solution PDF |
|
|
| Query Processing Week 1: Disks, Files and Indexes |
QP1.1_Disks.ppt |
|
|
QP1.1_Disks.pdf (1 slide per page) |
|
|
QP1.1_Disks.pdf (6 slides per page) |
|
|
QP1.2_Indexes.ppt |
|
|
QP1.2_Indexes.pdf (1 slide per page) |
|
|
QP1.2_Indexes.pdf (6 slides per page) |
|
|
QP1.3_Tirgul.ppt |
|
|
QP1.3_Tirgul.pdf (1 slide per page) |
|
|
QP1.3_Tirgul.pdf (6 slides per page) |
|
|
QP1.4_B+Trees.ppt |
|
|
QP1.4_B+Trees.pdf (1 slide per page) |
|
|
QP1.4_B+Trees.pdf (6 slides per page) |
|
|
| Query Processing Week 2: Join Algorithms |
QP2.1_Join.ppt |
|
|
QP2.1_Join.pdf (1 slide per page) |
|
|
QP2.1_Join.pdf (6 slides per page) |
|
|
QP2.2_Tirgul.ppt |
|
|
QP2.2_Tirgul.pdf (1 slide per page) |
|
|
QP2.2_Tirgul.pdf (6 slides per page) |
|
|
QP2.3_Index_Nested_Loop_Join.ppt |
|
|
QP2.3_Index_Nested_Loop_Join.pdf (1 slide per page) |
|
|
QP2.3_Index_Nested_Loop_Join.pdf (6 slides per page) |
|
|
| Query Processing Week 3: Size Estimation and Efficient Query Plan |
QP3.1_Size_Estimation.ppt |
|
|
QP3.1_Size_Estimation.pdf (1 slide per page) |
|
|
QP3.1_Size_Estimation.pdf (6 slides per page) |
|
|
QP3.2_Tirgul.ppt |
|
|
QP3.2_Tirgul.pdf (1 slide per page) |
|
|
QP3.2_Tirgul.pdf (6 slides per page) |
|
|
QP3.3_Optimal_Plan.ppt |
|
|
QP3.3_Optimal_Plan.pdf (1 slide per page) |
|
|
QP3.3_Optimal_Plan.pdf (6 slides per page) |
|
|
| Concurrency Control Week 1: The Model and Two-Phase Locking (2PL) |
CC1.1_Model.ppt |
|
|
CC1.1_Model.pdf (1 slide per page) |
|
|
CC1.1_Model.pdf (6 slides per page) |
|
|
QP4.1_Tirgul.ppt |
|
|
QP4.1_Tirgul.pdf (1 slide per page) |
|
|
QP4.1_Tirgul.pdf (6 slides per page) |
|
|
CC1.2_2PL.ppt |
|
|
CC1.2_2PL.pdf (1 slide per page) |
|
|
CC1.2_2PL.pdf (6 slides per page) |
|
|
| Concurrency Control Week 2: Concurrency Control Without Locking |
CC2.1_VO.ppt |
|
|
CC2.1_VO.pdf (1 slide per page) |
|
|
CC2.1_VO6.pdf (6 slides per page) |
|
|
CC2.2_Tirgul.ppt |
|
|
CC2.2_Tirgul.pdf (1 slide per page) |
|
|
CC2.2_Tirgul.pdf (6 slides per page) |
|
|
CC2.3_TS.ppt |
|
|
CC2.3_TS.pdf (1 slide per page) |
|
|
CC2.3_TS.pdf (6 slides per page) |
|
|
CC2.4_MV.ppt |
|
|
CC2.4_MV.pdf (1 slide per page) |
|
|
CC2.4_MV.pdf (6 slides per page) |
|
|
| Concurrency Control Week 3: Recovery |
CC3.1_Recovery.ppt |
|
|
CC3.1_Recovery.pdf (1 slide per page) |
|
|
CC3.1_Recovery.pdf (6 slides per page) |
|
|
CC3.2_Tirgul.ppt |
|
|
CC3.2_Tirgul.pdf (1 slide per page) |
|
|
CC3.2_Tirgul.pdf (6 slides per page) |
|
|
CC3.3_SQL_Isolation.ppt |
|
|
CC3.3_SQL_Isolation.pdf (1 slide per page) |
|
|
CC3.3_SQL_Isolation.pdf (6 slides per page) |
|
|
| Topic 15 |
pdf 1 slide/page |
|
|
pdf 3 slides/page |
|
|
pdf 6 slides/page |
|
|
| Topic 16 |
concurrency control |
|
|
review |
|