Instructor:

Vassilis J. Tsotras
office: ENGR II, Room 335
tel: 951-827-2888
e-mail: tsotras@cs.ucr.edu

Lecture: Tuesday/Thursday 2:10 - 3:30, SURGE 171

Office Hours:

Tuesday/Thursday 12:40-1:40pm or by appointment.

The first part of the course will use the following textbook:

“Database Management Systems,” by Raghu Ramakrishnan and Johannes Gehrke, McGraw-Hill, 3rd edition, ISBN 0-07-246563-8.

The slides for the various chapters can be found here.

We will first cover Chapters 3,4 and 5 (quickly) as an introduction.

Here are the slides ch3.pdf,ch4.pdf,ch5.pdf

Interesting Book Exercises: 4.2, 4.3, 4.5, 5.1, 5.2, 5.3

Then we will concentrate on:

Indexing (chapters 10 and 28; see also papers on R-trees)

Next item: the papers on Join Processing and Spatial Joins (see below and section 14.4)

Interesting Book Exercises: 10.1, 10.4, 10.5, 10.9, 14.4, 14.5

Temporal Databases and Temporal Indexing

Transaction Management (Chapters 16, 17 and 18)

Interesting Book Exercises: 16.3, 17.2, 17.4, 17.6, 17.10, 18.3 - 18.8

Normalization (Chapter 19)

Interesting Book Exercises: 19.2, 19.3, 19.5, 19.7, 19.8, 19.10

Decision Support (Chapter 25 and paper on data cubes)

XML Data Management (Chapter 27)

We will also use the following papers:

R-tree indices:
Antonin Guttman: R-Trees: A Dynamic Index Structure for Spatial Searching. SIGMOD Conference 1984: 47-57 R-tree.pdf

N. Beckmann, H.-P. Kriegel, R. Schneider, and B. Seeger. The R*-tree: An Efficient and Robust Access Method For Points and Rectangles. SIGMOD Conference 1990. rstar.pdf

The Grid File:

J. Nievergelt, H. Hinterberger, K.C. Sevcik. The Grid File: An Adaptable, Symmetric Multikey File Structure. ACM Trans. Database Syst. 9(1): 38-71 (1984) grid-file.pdf

Atinder's slides on R-Trees. rtree-slides

slides on R-Trees and grid-file from G. Kollios: Kollios-NTUA-structures-slides.

You can find a framework (implemented by Marios Hadjieleftheriou) to create spatial indices here.

Join Processing:
Leonard D. Shapiro: Join Processing in Database Systems with Large Main Memories. TODS 11(3): 239-264 join.pdf

Donghui's slides on join processing. join-slides

Spatial Joins:

T. Brinkhoff, H-P Kriegel, B. Seeger: Efficient Processing of Spatial Joins using R-trees. Proc. SIGMOD, 1993. r-tree-join.pdf

Ming-Ling Lo, Chinya V. Ravishankar: Spatial Joins using Seeded Trees. SIGMOD Conference 1994: 209-220 seeded.trees.pdf

Ming-Ling Lo, Chinya V. Ravishankar: Spatial Hash-Joins. SIGMOD Conference 1996: 247-258 shj.pdf

Nick Koudas, Kenneth C. Sevcik: Size Separation Spatial Join. SIGMOD Conference 1997: 324-335 ssj.pdf

Donghui's slides on spatial joins. spatial-join-slides

Nearest Neighbors:

N. Roussopoulos, S. Kelley, F. Vincent: Nearest Neighbor Queries. SIGMOD Conference 1995: 71-79 roussopoulosNN95.pdf

G.R. Hjaltason, H. Samet: Ranking in Spatial Databases. SSD 1995: 83-95 hjaltason95ranking.pdf

NN slides from NTUA slides1 and from Y. Tao slides2

Temporal Databases and Indexing:

Slides on Temporal DBs and Indexing: temporal databases, snapshot index, MVB-Tree.

B. Salzberg and V.J. Tsotras: Comparison of Access Methods for Time-Evolving Data. ACM Comput. Surv. 31(2): 158-221 (1999) tempDB-survey.

V.J. Tsotras, N. Kangerlaris: The Snapshot Index: An I/O-optimal access method for timeslice queries. Inf. Syst. 20(3): 237-260 (1995) SI-index.

B. Becker, S. Gschwind, T. Ohler, B. Seeger, P. Widmayer: An Asymptotically Optimal Multiversion B-Tree. VLDB J. 5(4): 264-275 (1996) MVB-Tree

Other Topics:

Here are most of the transaction-slides

DataCubes:
Jim Gray, Adam Bosworth, Andrew Layman, Hamid Pirahesh: Data Cube, A Relational Aggregation Operator Generalizing Group-By, Cross-Tab, and Sub-Total. ICDE Conference 1996, pp: 152-159. DataCube.doc, or, here.

Data streams:
Shivnath Babu, Jennifer Widom: Continuous Queries over Data Streams. SIGMOD Record 30(3), pp: 109-120 (2001). streams.pdf

Brian Babcock, Shivnath Babu, Mayur Datar, Rajeev Motwani, Jennifer Widom: Models and Issues in Data Stream Systems. PODS 2002, pp: 1-16. streams-issues.pdf

XML Query Processing: TBA