Database Management Systems

1 Foundations 1 Overview of Database Systems 2 Introduction to Database Design 3 The Relational Model 4 Relational Algebra and Calculus 5 SQL: Queries, Constraints, Triggers 2 Application Development 6 Database Application Development 7 Internet Applications 3 Storage and Indexing 8 Overview of Storage and Indexing 9 Storing Data: Disks and Files 10 Tree-Structured Indexing 11 Hash-Based Indexing 4 Query Evaluation 12 Overview of Query Evaluation 13 External Sorting 14 Evaluating Relational Operators 15 A Typical Relational Query Optimizer 5 Transaction Management 16 Overview of Transaction Management 17 Concurrency Control 18 Crash Recovery 6 Database Design and Tuning 19 Schema Refinement and Normal Forms 20 Physical Database Design and Tuning 21 Security and Authorization 7 Additional Topics 22 Parallel and Distributed Databases 23 Object-Database Systems 24 Deductive Databases 25 Data Warehousing and Decision Support 26 Data Mining 27 Information Retrieval and XML Data 28 Spatial Data Management 29 Further Reading 30 The Minibase Software