Advanced Database Notes

Course Outline

DB Architecture and System Catalog

Query Processing and Optimization

Transaction Management

Concurrency Control

Recovery

Security

Advanced Modelling I

Advanced Modelling II

Advanced Modelling III

Introduction to OODBMS

OO Standards, Language and Design

Spatial and Temporal Data Management

Data mining: find most popular packages

Graph Databases

Index techniques

Data Warehouse

Signature files and signature trees

Web browser of search engines

Reachability queries

A simple web clawler

Review

Review

General Review

Assignments

Assignment #1

Answers to Assignment #1

Assignment #2

Answers to Assignment #2

Assignment #3

Answers to Assignment #3

Assignment #4

Answers to Assignment #4

Discussion of Mid-Term Exam.

Answers to the 2022 Midterm Examination

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