The landscape of computer science education has undergone a profound transformation in recent years, as database management has emerged as a critical pillar in modern computing environments. To equip students with the essential knowledge about database systems, we present a comprehensive exploration of the fundamental concepts of database management, ranging from database design to database languages to database-system implementation.

Intended for students at the junior or senior undergraduate or first-year graduate level, this text provides both basic materials for an introductory course as well as advanced material suitable for supplemental or advanced study. Assuming only a familiarity with basic data structures, computer organization, and high-level programming languages like Java, C, or Pascal, we present concepts as intuitive descriptions, grounded in the running example of a university.

While important theoretical results are covered, we eschew formal proofs in favor of figures and examples that vividly illustrate the truth of a given result. Formal descriptions and proofs can be found in advanced texts and research papers referenced in the bibliographical notes.

This repository is an indispensable resource for anyone seeking to acquire a deep understanding of database management, rooted in theoretical foundations but connected to practical applications.

Introduction

RELATIONAL DATABASES

Introduction to the Relational Model

Introduction to SQL

Intermediate SQL

Advanced SQL

Formal Relational Query Languages

DATABASE DESIGN

Database Design and the E-R Model

Relational Database Design

Application Design and Development

DATA STORAGE AND QUERYING

Storage and File Structure

Indexing and Hashing

Query Processing

Query Optimization

TRANSACTION MANAGEMENT

Transactions

Concurrency Control

Recovery System

SYSTEM ARCHITECTURE

Database-System Architectures

Parallel Databases

Distributed Databases

DATA WAREHOUSING, DATA MINING, AND INFORMATION RETRIEVAL

Data Warehousing and Mining

Information Retrieval

SPECIALTY DATABASES

Object-Based Databases

XML

ADVANCED TOPICS

Advanced Application Development

Spatial and Temporal Data and Mobility

Advanced Transaction Processing