Advanced Database Notes

Course Outline

DB Architecture and System Catalog

Query Processing and Optimization

Transaction Management

Concurrency Control

Recovery

Advanced Modelling I

Advanced Modelling II

Advanced Modelling III

Introduction to OODBMS

OO Standards, Language and Design

Spatial and Temporal Data Management

Index techniques

Security

Data mining

Signature files and signature trees

Web browser of search engines

A simple web clawler

Review

Review

General Review

Assignments

Assignment #1

Assignment #2

Assignment #3

Assignment #4

Discussion of Mid-Term Exam.

Figures

figures of Chapter 2

figures of Chapter 19

figures of Chapter 20

figures of Chapter 4

figures of Chapter 21

Sample tests

Sample Test

Java programs

Java Programs for sorting