Basic Concepts Ordered Indices B+-Tree Index Files B-Tree Index Files Static Hashing Dynamic Hashing Comparison of Ordered Indexing and Hashing Index Definition in SQL Multiple-Key Access

Heterogeneous and Homogeneous Databases Distributed Data Storage Distributed Transactions Commit Protocols Concurrency Control in Distributed Databases Availability Distributed Query Processing Heterogeneous Distributed Databases Directory Systems

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

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

▪ Transaction Concept ▪ Transaction State ▪ Concurrent Executions ▪ Serializability ▪ Recoverability ▪ Implementation of Isolation ▪ Transaction Definition in SQL ▪ Testing for Serializability

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

▪ Relevance Ranking Using Terms ▪ Relevance Using Hyperlinks ▪ Synonyms., Homonyms, and Ontologies ▪ Indexing of Documents ▪ Measuring Retrieval Effectiveness ▪ Web Search Engines ▪ Information Retrieval and Structured Data ▪ Directories

▪ Structure of XML Data ▪ XML Document Schema ▪ Querying and Transformation ▪ Application Program Interfaces to XML ▪ Storage of XML Data ▪ XML Applications

▪ Reasoning with MVDs ▪ Higher normal forms • Join dependencies and PJNF • DKNF

▪ Tuple Relational Calculus ▪ Domain Relational Calculus ▪ Datalog