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

JDBC - database application in Java

Spatial and Temporal Data Management

Index techniques

Security

Data warehouse

Signature files and signature trees

Web browser of search engines

A simple web clawler

Review

Review

General Review

Assignments

Assignment #1

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