Database System Concepts, 6th Edition

Database System Concepts by Silberschatz, Korth and Sudarshan is now in its 6th edition and is one of the cornerstone texts of database education. It presents the fundamental concepts of database management in an intuitive manner geared toward allowing students to begin working with databases as quickly as possible.

The text is designed for a first course in databases at the junior/senior undergraduate level or the first year graduate level. It also contains additional material that can be used as supplements or as introductory material for an advanced course. Because the authors present concepts as intuitive descriptions, a familiarity with basic data structures, computer organization, and a high-level programming language are the only prerequisites. Important theoretical results are covered, but formal proofs are omitted. In place of proofs, figures and examples are used to suggest why a result is true.

Table of Contents

Chapter 1 Introduction

PART ONE: RELATIONAL DATABASES
Chapter 2 Introduction to the Relational Model
Chapter 3 Introduction to SQL
Chapter 4 Intermediate SQL
Chapter 5 Advanced SQL
Chapter 6 Formal Relational Query Languages

PART TWO: DATABASE DESIGN
Chapter 7 Database Design and the E-R Model
Chapter 8 Relational Database Design
Chapter 9 Application Design and Development

PART THREE: DATA STORAGE AND QUERYING
Chapter 10 Storage and File Structure
Chapter 11 Indexing and Hashing
Chapter 12 Query Processing
Chapter 13 Query Optimization

PART FOUR: TRANSACTION MANAGEMENT
Chapter 14 Transactions
Chapter 15 Concurrency Control
Chapter 16 Recovery System

PART FIVE: SYSTEM ARCHITECTURE
Chapter 17 Database-System Architectures
Chapter 18 Parallel Databases
Chapter 19 Distributed Databases

PART SIX: DATA WAREHOUSING, DATA MINING, AND INFORMATION RETRIEVAL
Chapter 20 Data Warehousing and Mining
Chapter 21 Information Retrieval

PART SEVEN: SPECIALTY DATABASES
Chapter 22 Object-Based Databases
Chapter 23 XML

PART EIGHT: ADVANCED TOPICS
Chapter 24 Advanced Application Development
Chapter 25 Spatial and Temporal Data and Mobility
Chapter 26 Advanced Transaction Processing

PART NINE: CASE STUDIES
Chapter 27 PostgreSQL
Chapter 28 Oracle
Chapter 29 IBM DB2 Universal Database
Chapter 30 Microsoft SQL Server

PART TEN: APPENDICES
Appendix A: Detailed University Schema