Advances in Data Management
Background Reading
-
For Principles of Database Systems 1:
R.Ramakrishnan and J.Gehrke (2003):
Chapter 1,
Chapter 3 (you can skip 3.2.3 - 3.3, 3.5, 3.6.2, 3.7, 3.8),
Chapter 4 (you can skip 4.2.5, 4.3, 4.4),
Chapter 5 (you can skip HAVING clauses, 5.7, 5.8, 5.9)
-
For Principles of Database Systems 2:
R.Ramakrishnan and J.Gehrke (2003):
Chapter 8 (you can skip 8.4, 8.5),
Chapter 9 (you can skip 9.2, 9.5, 9.6, 9.7),
Chapter 10 (skip 10.2, 10.7),
Chapter 11 (skip 11.2, 11.4)
-
For Active and Deductive Databases:
R.Ramakrishnan and J.Gehrke (2003):
Chapter 5 (5.8, 5.9), Chapter 24 (24.1, 24.2, 24.3, 24.5 - up to 24.5.2)
-
For Transaction Management:
R.Ramakrishnan and J.Gehrke (2003):
Chapter 16 (up to 16.7.3),
Chapter 17 (17.1 is optional reading up to 17.1.1;
dip into 17.2, 17.4 up to 17.4.1, 17.5)
-
For Query Processing and Query Optimisation:
R.Ramakrishnan and J.Gehrke (2003):
Chapter 12 (a summary you can dip into),
Chapter 13 (up to 13.3.1),
Chapter 14 (skip 14.3.2, 14.3.3, 14.4.3 beyond the hash join algorithm itself,
14.4.4, 14.7),
Chapter 15 (up to 15.6)
-
For Distributed and Heterogeneous Databases:
Chapter on "Distributed Databases" by P.McBrien and A.Poulovassilis
in the book on Advanced Database Technology and Design ,
ed. M.Piattini and O.Diaz, Artech House, 2000. pp 291-327
(you can skip sections 3.2 and 5.2.2 of the chapter).
Note that my terminology in the lectures of 'integrated, homogeneous DDB' corresponds to what is termed an
'unfederated (homogeneous) DDB' in this chapter.
My terminology of 'multi-database, heterogeneous DDB' in the lectures
corresponds to what is termed a
'federated (heterogeneous) DDB' with 'multiple federated schemas' in this chapter.
R.Ramakrishnan and J.Gehrke (2003):
Chapter 22 (22.6 - 22.10, 22.12, 22.13, 22.14 but skip 3-phase commit)
-
For Web Data Management:
R.Ramakrishnan and J.Gehrke (2003):
Dip into Chapters 6, 7, 27