Centralized and Client-Server Systems Server System Architectures Parallel Systems Distributed Systems Network Types

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

Failure Classification Storage Structure Recovery and Atomicity Log-Based Recovery Remote Backup Systems

Decision Support Systems Data Warehousing Data Mining Classification Association Rules Clustering

Performance Tuning Performance Benchmarks Standardization E-Commerce Legacy Systems

▪ Structure of Relational Databases ▪ Database Schema ▪ Keys ▪ Schema Diagrams ▪ Relational Query Languages ▪ The Relational Algebra

《数据库系统概念 Database System Concepts》原书教学资源（第七版，PPT课件讲稿，英文版）Chapter 06 Database Design Using the E-R Model

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

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

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