本书是经典的数据库系统教科书《DatabaseSystemConcepts》的最新修订版,全面介绍数据库系统的各种知识,透彻阐释数据库管理的基本概念。本书内容丰富,不仅讨论了关系数据模型和关系语言、数据库设计过程、关系数据库理论、数据库应用设计和开发、数据存储结构、数据存取技术、查询优化方法、事务处理系统和并发控制、故障恢复技术、数据仓库和数据挖掘,而且对性能调整、性能评测标准、数据库应用测试和标准化、空间和地理数据、时间数据、多媒体数据、移动和个人数据库管理以及事务处理监控器、事务工作流、电子商务、高性能事务系统、实时事务系统和持续长时间的事务等高级应用主题进行了广泛讨论。
本书既可作为高年级本科生或低年级研究生的数据库课程教材,也可供数据库领域的技术人员参考。
- Chapter 1 Introduction
- 1.1 Database-System Applications
- 1.2 Purpose of Database Systems
- 1.3 View of Data
- 1.4 Database Languages
- 1.5 Relational Databases
- 1.6 Database Design
- 1.7 Data Storage and Querying
- 1.8 Transaction Management
- 1.9 Database Architecture
- 1.10 Data Mining and Information Retrieval
- 1.11 Specialty Databases
- 1.12 Database Users and Administrators
- 1.13 History of Database Systems
- 1.14 Summary
- Exercises
- Bibliographical Notes
- PART ONE RELATIONAL DATABASES
- Chapter 2 Introduction to the Relational Model
- 2.1 Structure of Relational Databases
- 2.2 Database Schema
- 2.3 Keys
- 2.4 Schema Diagrams
- 2.5 Relational Query Languages
- 2.6 Relational Operations
- 2.7 Summary
- Exercises
- Bibliographical Notes
- Chapter 3 Introduction to SQL
- 3.1 Overview of the SQL Query Language
- 3.2 SQL Data Definition
- 3.3 Basic Structure of SQL Queries
- 3.4 Additional Basic Operations
- 3.5 Set Operations
- 3.6 Null Values
- 3.7 Aggregate Functions
- 3.8 Nested Subqueries
- 3.9 Modification of the Database
- 3.10 Summary
- Exercises
- Bibliographical Notes
- Chapter 4 Intermediate SQL
- 4.1 Join Expressions
- 4.2 Views
- 4.3 Transactions
- 4.4 Integrity Constraints
- 4.5 SQL Data Types and Schemas
- 4.6 Authorization
- 4.7 Summary
- Exercises
- Bibliographical Notes
- Chapter 5 Advanced SQL
- 5.1 Accessing SQL From a Programming Language
- 5.2 Functions and Procedures
- 5.3 Triggers
- 5.4 Recursive Queries**
- 5.5 Advanced Aggregation Features**
- 5.6 OLAP**
- 5.7 Summary
- Exercises
- Bibliographical Notes
- Chapter 6 Formal Relational Query Languages
- 6.1 The Relational Algebra
- 6.2 The Tuple Relational Calculus
- 6.3 The Domain Relational Calculus
- 6.4 Summary
- Exercises
- Bibliographical Notes
- PART TWO DATABASE DESIGN
- PART THREE DATA STORAGE AND QUERYING
- PART FOUR TRANSACTION MANAGEMENT
- PART FIVE SYSTEM ARCHITECTURE
- PART SIX DATA WAREHOUSING, DATA MINING AND INFORMATION RETRIEVAL
- PART SEVEN SPECIALTY DATABASES
- PART EIGHT ADVANCED TOPICS
- PART NINE CASE STUDIES
- PART TEN APPENDICES