顶部
收藏

数据库系统概念(第7版 影印版)

教育部推荐引进版教材

作者:
Abraham Silberschatz等
定价:
98.00 元
版面字数:
2150千字
开本:
16开
装帧形式:
平装
版次:
1
最新版次
印刷时间:
1899年
ISBN:
978-7-04-055444-1
物料号:
55444-00
出版时间:
2021-03-26
读者对象:
高等教育
一级分类:
计算机/教育技术类
二级分类:
计算机类专业核心课程
三级分类:
数据库系统原理

暂无
  • 目录
    • 前辅文
      • 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 Database Design
                  • 1.6 Database Engine
                    • 1.7 Database and Application Architecture
                      • 1.8 Database Users and Administrators
                        • 1.9 History of Database Systems
                          • 1.10 Summary
                            • Exercises
                              • Further Reading
                            • PART ONE RELATIONAL LANGUAGES
                              • 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 The Relational Algebra
                                            • 2.7 Summary
                                              • Exercises
                                                • Further Reading
                                              • 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
                                                                      • Further Reading
                                                                    • 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 Index Definition in SQL
                                                                                  • 4.7 Authorization
                                                                                    • 4.8 Summary
                                                                                      • Exercises
                                                                                        • Further Reading
                                                                                      • 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 Summary
                                                                                                    • Exercises
                                                                                                      • Further Reading
                                                                                                  • PART TWO DATABASE DESIGN
                                                                                                    • Chapter 6 Database Design Using the E-R Model
                                                                                                      • 6.1 Overview of the Design Process
                                                                                                        • 6.2 The Entity-Relationship Model
                                                                                                          • 6.3 Complex Attributes
                                                                                                            • 6.4 Mapping Cardinalities
                                                                                                              • 6.5 Primary Key
                                                                                                                • 6.6 Removing Redundant Attributesin Entity Sets
                                                                                                                  • 6.7 Reducing E-R Diagrams to Relational Schemas
                                                                                                                    • 6.8 Extended E-R Features
                                                                                                                      • 6.9 Entity-Relationship Design Issues
                                                                                                                        • 6.10 Alternative Notations for Modeling Data
                                                                                                                          • 6.11 Other Aspects of Database Design
                                                                                                                            • 6.12 Summary
                                                                                                                              • Exercises
                                                                                                                                • Further Reading
                                                                                                                              • Chapter 7 Relational Database Design
                                                                                                                                • 7.1 Features of Good Relational Designs
                                                                                                                                  • 7.2 Decomposition Using Functional Dependencies
                                                                                                                                    • 7.3 Normal Forms
                                                                                                                                      • 7.4 Functional-Dependency Theory
                                                                                                                                        • 7.5 Algorithms for Decomposition Using Functional Dependencies
                                                                                                                                          • 7.6 Decomposition Using Multivalued Dependencies
                                                                                                                                            • 7.7 More Normal Forms
                                                                                                                                              • 7.8 Atomic Domains and First Normal Form
                                                                                                                                                • 7.9 Database-Design Process
                                                                                                                                                  • 7.10 Modeling Temporal Data
                                                                                                                                                    • 7.11 Summary
                                                                                                                                                      • Exercises
                                                                                                                                                        • Further Reading
                                                                                                                                                    • PART THREE APPLICATION DESIGN AND DEVELOPMENT
                                                                                                                                                      • Chapter 8 Complex Data Types
                                                                                                                                                        • 8.1 Semi-structured Data
                                                                                                                                                          • 8.2 Object Orientation
                                                                                                                                                            • 8.3 Textual Data
                                                                                                                                                              • 8.4 Spatial Data
                                                                                                                                                                • 8.5 Summary
                                                                                                                                                                  • Exercises
                                                                                                                                                                    • Further Reading
                                                                                                                                                                  • Chapter 9 Application Development
                                                                                                                                                                    • 9.1 Application Programs and User Interfaces
                                                                                                                                                                      • 9.2 Web Fundamentals
                                                                                                                                                                        • 9.3 Servlets
                                                                                                                                                                          • 9.4 Alternative Server-Side Frameworks
                                                                                                                                                                            • 9.5 Client-Side Code and Web Services
                                                                                                                                                                              • 9.6 Application Architectures
                                                                                                                                                                                • 9.7 Application Performance
                                                                                                                                                                                  • 9.8 Application Security
                                                                                                                                                                                    • 9.9 Encryption and Its Applications
                                                                                                                                                                                      • 9.10 Summary
                                                                                                                                                                                        • Exercises
                                                                                                                                                                                          • Further Reading
                                                                                                                                                                                      • PART FOUR BIG DATA ANALYTICS
                                                                                                                                                                                        • Chapter 10 Big Data
                                                                                                                                                                                          • 10.1 Motivation
                                                                                                                                                                                            • 10.2 Big Data Storage Systems
                                                                                                                                                                                              • 10.3 The MapReduce Paradigm
                                                                                                                                                                                                • 10.4 Beyond MapReduce: Algebraic Operations
                                                                                                                                                                                                  • 10.5 Streaming Data
                                                                                                                                                                                                    • 10.6 Graph Databases
                                                                                                                                                                                                      • 10.7 Summary
                                                                                                                                                                                                        • Exercises
                                                                                                                                                                                                          • Further Reading
                                                                                                                                                                                                        • Chapter 11 Data Analytics
                                                                                                                                                                                                          • 11.1 Overview of Analytics
                                                                                                                                                                                                            • 11.2 Data Warehousing
                                                                                                                                                                                                              • 11.3 Online Analytical Processing
                                                                                                                                                                                                                • 11.4 Data Mining
                                                                                                                                                                                                                  • 11.5 Summary
                                                                                                                                                                                                                    • Exercises
                                                                                                                                                                                                                      • Further Reading
                                                                                                                                                                                                                  • PART FIVE STORAGE MANAGEMENT AND INDEXING
                                                                                                                                                                                                                    • Chapter 12 Physical Storage Systems
                                                                                                                                                                                                                      • 12.1 Overview of Physical Storage Media
                                                                                                                                                                                                                        • 12.2 Storage Interfaces
                                                                                                                                                                                                                          • 12.3 Magnetic Disks
                                                                                                                                                                                                                            • 12.4 Flash Memory
                                                                                                                                                                                                                              • 12.5 RAD
                                                                                                                                                                                                                                • 12.6 Disk-Block Access
                                                                                                                                                                                                                                  • 12.7 Summary
                                                                                                                                                                                                                                    • Exercises
                                                                                                                                                                                                                                      • Further Reading
                                                                                                                                                                                                                                    • Chapter 13 Data Storage Structures
                                                                                                                                                                                                                                      • 13.1 Database Storage Architecture
                                                                                                                                                                                                                                        • 13.2 File Organization
                                                                                                                                                                                                                                          • 13.3 Organization of Records in Files
                                                                                                                                                                                                                                            • 13.4 Data-Dictionary Storage
                                                                                                                                                                                                                                              • 13.5 Database Buffer
                                                                                                                                                                                                                                                • 13.6 Column-Oriented Storage
                                                                                                                                                                                                                                                  • 13.7 Storage Organization in Main-Memory Databases
                                                                                                                                                                                                                                                    • 13.8 Summary
                                                                                                                                                                                                                                                      • Exercises
                                                                                                                                                                                                                                                        • Further Reading
                                                                                                                                                                                                                                                      • Chapter 14 Indexing
                                                                                                                                                                                                                                                        • 14.1 Basic Concepts
                                                                                                                                                                                                                                                          • 14.2 Ordered Indices
                                                                                                                                                                                                                                                            • 14.3 B+-Tree Index Files
                                                                                                                                                                                                                                                              • 14.4 B+-Tree Extensions
                                                                                                                                                                                                                                                                • 14.5 Hash Indices
                                                                                                                                                                                                                                                                  • 14.6 Multiple-Key Access
                                                                                                                                                                                                                                                                    • 14.7 Creation of Indices
                                                                                                                                                                                                                                                                      • 14.8 Write-Optimized Index Structures
                                                                                                                                                                                                                                                                        • 14.9 Bitmap Indices
                                                                                                                                                                                                                                                                          • 14.10 Indexing of Spatial and Temporal Data
                                                                                                                                                                                                                                                                            • 14.11 Summary
                                                                                                                                                                                                                                                                              • Exercises
                                                                                                                                                                                                                                                                                • Further Reading
                                                                                                                                                                                                                                                                            • PART SIX QUERY PROCESSING AND OPTIMIZATION
                                                                                                                                                                                                                                                                              • Chapter 15 Query Processing
                                                                                                                                                                                                                                                                                • 15.1 Overview
                                                                                                                                                                                                                                                                                  • 15.2 Measures of Query Cost
                                                                                                                                                                                                                                                                                    • 15.3 Selection Operation
                                                                                                                                                                                                                                                                                      • 15.4 Sorting
                                                                                                                                                                                                                                                                                        • 15.5 Join Operation
                                                                                                                                                                                                                                                                                          • 15.6 Other Operations
                                                                                                                                                                                                                                                                                            • 15.7 Evaluation of Expressions
                                                                                                                                                                                                                                                                                              • 15.8 Query Processing in Memory
                                                                                                                                                                                                                                                                                                • 15.9 Summary
                                                                                                                                                                                                                                                                                                  • Exercises
                                                                                                                                                                                                                                                                                                    • Further Reading
                                                                                                                                                                                                                                                                                                  • Chapter 16 Query Optimization
                                                                                                                                                                                                                                                                                                    • 16.1 Overview
                                                                                                                                                                                                                                                                                                      • 16.2 Transformation of Relational Expressions
                                                                                                                                                                                                                                                                                                        • 16.3 Estimating Statistics of Expression Results
                                                                                                                                                                                                                                                                                                          • 16.4 Choice of Evaluation Plans
                                                                                                                                                                                                                                                                                                            • 16.5 Materialized Views
                                                                                                                                                                                                                                                                                                              • 16.6 Advanced Topics in Query Optimization
                                                                                                                                                                                                                                                                                                                • 16.7 Summary
                                                                                                                                                                                                                                                                                                                  • Exercises
                                                                                                                                                                                                                                                                                                                    • Further Reading
                                                                                                                                                                                                                                                                                                                • PART SEVEN TRANSACTION MANAGEMENT
                                                                                                                                                                                                                                                                                                                  • Chapter 17 Transactions
                                                                                                                                                                                                                                                                                                                    • 17.1 Transaction Concept
                                                                                                                                                                                                                                                                                                                      • 17.2 A Simple Transaction Model
                                                                                                                                                                                                                                                                                                                        • 17.3 Storage Structure
                                                                                                                                                                                                                                                                                                                          • 17.4 Transaction Atomicity and Durability
                                                                                                                                                                                                                                                                                                                            • 17.5 Transaction Isolation
                                                                                                                                                                                                                                                                                                                              • 17.6 Serializability
                                                                                                                                                                                                                                                                                                                                • 17.7 Transaction Isolation and Atomicity
                                                                                                                                                                                                                                                                                                                                  • 17.8 Transaction Isolation Levels
                                                                                                                                                                                                                                                                                                                                    • 17.9 Implementation of Isolation Levels
                                                                                                                                                                                                                                                                                                                                      • 17.10 Transactions as SQL Statements
                                                                                                                                                                                                                                                                                                                                        • 17.11 Summary
                                                                                                                                                                                                                                                                                                                                          • Exercises
                                                                                                                                                                                                                                                                                                                                            • Further Reading
                                                                                                                                                                                                                                                                                                                                          • Chapter 18 Concurrency Control
                                                                                                                                                                                                                                                                                                                                            • 18.1 Lock-Based Protocols
                                                                                                                                                                                                                                                                                                                                              • 18.2 Deadlock Handling
                                                                                                                                                                                                                                                                                                                                                • 18.3 Multiple Granularity
                                                                                                                                                                                                                                                                                                                                                  • 18.4 Insert Operations, Delete Operations, and Predicate Reads
                                                                                                                                                                                                                                                                                                                                                    • 18.5 Timestamp-Based Protocols
                                                                                                                                                                                                                                                                                                                                                      • 18.6 Validation-Based Protocols
                                                                                                                                                                                                                                                                                                                                                        • 18.7 Multiversion Schemes
                                                                                                                                                                                                                                                                                                                                                          • 18.8 SnapshotIsolation
                                                                                                                                                                                                                                                                                                                                                            • 18.9 Weak Levels of Consistency in Practice
                                                                                                                                                                                                                                                                                                                                                              • 18.10 Advanced Topics in Concurrency Control
                                                                                                                                                                                                                                                                                                                                                                • 18.11 Summary
                                                                                                                                                                                                                                                                                                                                                                  • Exercises
                                                                                                                                                                                                                                                                                                                                                                    • Further Reading
                                                                                                                                                                                                                                                                                                                                                                  • Chapter 19 Recovery System
                                                                                                                                                                                                                                                                                                                                                                    • 19.1 Failure Classification
                                                                                                                                                                                                                                                                                                                                                                      • 19.2 Storage
                                                                                                                                                                                                                                                                                                                                                                        • 19.3 Recovery and Atomicity
                                                                                                                                                                                                                                                                                                                                                                          • 19.4 Recovery Algorithm
                                                                                                                                                                                                                                                                                                                                                                            • 19.5 Buffer Management
                                                                                                                                                                                                                                                                                                                                                                              • 19.6 Failure with Loss of Non-Volatile Storage
                                                                                                                                                                                                                                                                                                                                                                                • 19.7 High Availability Using Remote Backup Systems
                                                                                                                                                                                                                                                                                                                                                                                  • 19.8 Early Lock Release and Logical Undo Operations
                                                                                                                                                                                                                                                                                                                                                                                    • 19.9 ARIES
                                                                                                                                                                                                                                                                                                                                                                                      • 19.10 Recovery in Main-Memory Databases
                                                                                                                                                                                                                                                                                                                                                                                        • 19.11 Summary
                                                                                                                                                                                                                                                                                                                                                                                          • Exercises
                                                                                                                                                                                                                                                                                                                                                                                            • Further Reading
                                                                                                                                                                                                                                                                                                                                                                                        • PART EIGHT PARALLEL AND DISTRIBUTED DATABASES
                                                                                                                                                                                                                                                                                                                                                                                          • Chapter 20 Database-System Architectures
                                                                                                                                                                                                                                                                                                                                                                                            • 20.1 Overview
                                                                                                                                                                                                                                                                                                                                                                                              • 20.2 Centralized Database Systems
                                                                                                                                                                                                                                                                                                                                                                                                • 20.3 Server System Architectures
                                                                                                                                                                                                                                                                                                                                                                                                  • 20.4 Parallel Systems
                                                                                                                                                                                                                                                                                                                                                                                                    • 20.5 Distributed Systems
                                                                                                                                                                                                                                                                                                                                                                                                      • 20.6 Transaction Processing in Paralleland Distributed Systems
                                                                                                                                                                                                                                                                                                                                                                                                        • 20.7 Cloud-Based Services
                                                                                                                                                                                                                                                                                                                                                                                                          • 20.8 Summary
                                                                                                                                                                                                                                                                                                                                                                                                            • Exercises
                                                                                                                                                                                                                                                                                                                                                                                                              • Further Reading
                                                                                                                                                                                                                                                                                                                                                                                                            • Chapter 21 Parallel and Distributed Storage
                                                                                                                                                                                                                                                                                                                                                                                                              • 21.1 Overview
                                                                                                                                                                                                                                                                                                                                                                                                                • 21.2 Data Partitioning
                                                                                                                                                                                                                                                                                                                                                                                                                  • 21.3 Dealing with Skew in Partitioning
                                                                                                                                                                                                                                                                                                                                                                                                                    • 21.4 Replication
                                                                                                                                                                                                                                                                                                                                                                                                                      • 21.5 Parallel Indexing
                                                                                                                                                                                                                                                                                                                                                                                                                        • 21.6 Distributed File Systems
                                                                                                                                                                                                                                                                                                                                                                                                                          • 21.7 Parallel Key-Value Stores
                                                                                                                                                                                                                                                                                                                                                                                                                            • 21.8 Summary
                                                                                                                                                                                                                                                                                                                                                                                                                              • Exercises
                                                                                                                                                                                                                                                                                                                                                                                                                                • Further Reading
                                                                                                                                                                                                                                                                                                                                                                                                                              • Chapter 22 Parallel and Distributed Query Processing
                                                                                                                                                                                                                                                                                                                                                                                                                                • 22.1 Overview
                                                                                                                                                                                                                                                                                                                                                                                                                                  • 22.2 Parallel Sort
                                                                                                                                                                                                                                                                                                                                                                                                                                    • 22.3 Parallel Join
                                                                                                                                                                                                                                                                                                                                                                                                                                      • 22.4 Other Operations
                                                                                                                                                                                                                                                                                                                                                                                                                                        • 22.5 Parallel Evaluation of Query Plans
                                                                                                                                                                                                                                                                                                                                                                                                                                          • 22.6 Query Processing on Shared-Memory Architectures
                                                                                                                                                                                                                                                                                                                                                                                                                                            • 22.7 Query Optimization for Parallel Execution
                                                                                                                                                                                                                                                                                                                                                                                                                                              • 22.8 Parallel Processing of Streaming Data
                                                                                                                                                                                                                                                                                                                                                                                                                                                • 22.9 Distributed Query Processing
                                                                                                                                                                                                                                                                                                                                                                                                                                                  • 22.10 Summary
                                                                                                                                                                                                                                                                                                                                                                                                                                                    • Exercises
                                                                                                                                                                                                                                                                                                                                                                                                                                                      • Further Reading
                                                                                                                                                                                                                                                                                                                                                                                                                                                    • Chapter 23 Paralleland Distributed Transaction Processing
                                                                                                                                                                                                                                                                                                                                                                                                                                                      • 23.1 Distributed Transactions
                                                                                                                                                                                                                                                                                                                                                                                                                                                        • 23.2 Commit Protocols
                                                                                                                                                                                                                                                                                                                                                                                                                                                          • 23.3 Concurrency Controlin Distributed Databases
                                                                                                                                                                                                                                                                                                                                                                                                                                                            • 23.4 Replication
                                                                                                                                                                                                                                                                                                                                                                                                                                                              • 23.5 Extended Concurrency Control Protocols
                                                                                                                                                                                                                                                                                                                                                                                                                                                                • 23.6 Replication with Weak Degrees of Consistency
                                                                                                                                                                                                                                                                                                                                                                                                                                                                  • 23.7 Coordinator Selection
                                                                                                                                                                                                                                                                                                                                                                                                                                                                    • 23.8 Consensus in Distributed Systems
                                                                                                                                                                                                                                                                                                                                                                                                                                                                      • 23.9 Summary
                                                                                                                                                                                                                                                                                                                                                                                                                                                                        • Exercises
                                                                                                                                                                                                                                                                                                                                                                                                                                                                          • Further Reading
                                                                                                                                                                                                                                                                                                                                                                                                                                                                      • PART NINE ADVANCED TOPICS
                                                                                                                                                                                                                                                                                                                                                                                                                                                                        • Chapter 24 Advanced Indexing Techniques
                                                                                                                                                                                                                                                                                                                                                                                                                                                                          • 24.1 Bloom Filter
                                                                                                                                                                                                                                                                                                                                                                                                                                                                            • 24.2 Log-Structured Merge Tree and Variants
                                                                                                                                                                                                                                                                                                                                                                                                                                                                              • 24.3 Bitmap Indices
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                • 24.4 Indexing of Spatial Data
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  • 24.5 Hash Indices
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    • 24.6 Summary
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      • Exercises
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        • Further Reading
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      • Chapter 25 Advanced Application Development
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        • 25.1 Performance Tuning
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          • 25.2 Performance Benchmarks
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            • 25.3 Other Issuesin Application Development
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              • 25.4 Standardization
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                • 25.5 Distributed Directory Systems
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  • 25.6 Summary
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    • Exercises
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      • Further Reading
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    • Chapter 26 Blockchain Databases
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      • 26.1 Overview
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        • 26.2 Blockchain Properties
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          • 26.3 Achieving Blockchain Properties via Cryptographic Hash Functions
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            • 26.4 Consensus
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              • 26.5 Data Managementin a Blockchain
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                • 26.6 Smart Contracts
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  • 26.7 Performance Enhancement
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    • 26.8 Emerging Applications
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      • 26.9 Summary
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        • Exercises
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          • Further Reading
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      • PART TEN APPENDIX A
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        • Appendix A Detailed University Schema
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          • Index
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          • PART ELEVEN ONLINE CHAPTERS
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            • Chapter 27 Formal Relational Query Languages
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              • Chapter 28 Advanced Relational Database Design
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                • Chapter 29 Object-Based Databases
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  • Chapter 30 XML
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    • Chapter 31 Information Retrieval
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      • Chapter 32 PostgreSQL

                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    相关图书