▪ Lock-Based Protocols ▪ Timestamp-Based Protocols ▪ Validation-Based Protocols ▪ Multiple Granularity ▪ Multiversion Schemes ▪ Insert and Delete Operations ▪ Concurrency in Index Structures

▪ Introduction ▪ Transformation of Relational Expressions ▪ Catalog Information for Cost Estimation ▪ Statistical Information for Cost Estimation ▪ Cost-based optimization ▪ Dynamic Programming for Choosing Evaluation Plans ▪ Materialized views

▪ Basic Concepts ▪ Ordered Indices ▪ B+ -Tree Index Files ▪ B-Tree Index Files ▪ Hashing ▪ Write-optimized indices ▪ Spatio-Temporal Indexing

《数据库系统概念 Database System Concepts》原书教学资源（第七版，PPT课件讲稿，英文版）Chapter 12 Physical Storage Systems

《数据库系统概念 Database System Concepts》原书教学资源（第七版，PPT课件讲稿，英文版）Chapter 10 Big Data

▪ Semi-Structured Data ▪ Object Orientation ▪ Textual Data ▪ Spatial Data

▪ Accessing SQL From a Programming Language ▪ Functions and Procedures ▪ Triggers ▪ Recursive Queries ▪ Advanced Aggregation Features

▪ Join Expressions ▪ Views ▪ Transactions ▪ Integrity Constraints ▪ SQL Data Types and Schemas ▪ Index Definition in SQL ▪ Authorization

《数据库系统概念 Database System Concepts》原书教学资源（第七版，PPT课件讲稿，英文版）Chapter 01 Introduction（Avi Silberschatz Henry F. Korth S. Sudarshan）

Transaction-Processing Monitors Transactional Workflows High-Performance Transaction Systems Main memory databases Real-Time Transaction Systems Long-Duration Transactions Transaction management in multidatabase systems