數(shù)據(jù)庫系統(tǒng)概念：英文本

定　價：￥68.00

作　者：	（美）Abraham Silberschatz等著
出版社：	高等教育出版社
叢編項：	國外優(yōu)秀信息科學與技術系列教學用書
標　簽：	數(shù)據(jù)庫存儲與管理

購買這本書可以去

ISBN：	9787040110494	出版時間：	2002-05-01	包裝：	平裝
開本：	24cm	頁數(shù)：	1064	字數(shù)：

內(nèi)容簡介

　　數(shù)據(jù)庫應用從特定的計算機應用到現(xiàn)代計算環(huán)境中的關鍵組件，已經(jīng)越來越深入和廣泛，因此對數(shù)據(jù)庫系統(tǒng)知識的掌握就成為計算機科學教育中的基礎及重要部分。本書介紹了數(shù)據(jù)庫管理中的基本概念與算法，包括數(shù)據(jù)庫設計、數(shù)據(jù)庫語言、數(shù)據(jù)庫系統(tǒng)實現(xiàn)等。主要內(nèi)容分九大部分，第一篇概述（第1章），講述了數(shù)據(jù)庫系統(tǒng)中的基本概念。第二篇數(shù)據(jù)建模（第2～3章），描述了實體關系性模型。第三篇關系型數(shù)據(jù)庫（第4～7章）介紹了面向用戶的關系型語言SQL，關系性語言QBE、Datalog，數(shù)據(jù)庫的安全防護以及關系型數(shù)據(jù)庫的設計理論。第四篇基于對象的數(shù)據(jù)庫與XML（第8～10章），引入面向?qū)ο蟮臄?shù)據(jù)設計概念，介紹了XML數(shù)據(jù)描述，對象-關系型數(shù)據(jù)庫、面向?qū)ο髷?shù)據(jù)庫。第五篇數(shù)據(jù)存儲與查詢（第11～14章），介紹了數(shù)據(jù)存取技術、查詢優(yōu)化及評估算法。第六篇事務處理（第15～17章），討論了事務處理的基礎知識，如事務原子數(shù)、一致性、持續(xù)性等，介紹了保證可串形性的并發(fā)控制技術。第七篇數(shù)據(jù)庫系統(tǒng)結(jié)構（第18～20章），介紹了計算機系統(tǒng)結(jié)構，分布式數(shù)據(jù)庫、并行數(shù)據(jù)庫等。第八篇（第21～24章）介紹了當今數(shù)據(jù)庫領域中的一些新技術、新概念。最后一部分以目前流行的三個商業(yè)數(shù)據(jù)庫Oracle、IBMDB2、微軟SQL服務器為實例，進行了詳細的討論。內(nèi)容：1.引言2.實體-關系模型3.關系模型4.SQL5.其他關系語言6.完整性與安全性7.關系型數(shù)據(jù)庫設計8.面向?qū)ο髷?shù)據(jù)庫9.對象-關系數(shù)據(jù)庫10.XML11.存儲與文件結(jié)構12.索引與散列13.查詢處理14.查詢優(yōu)化15.事務處理16.并發(fā)控制17.系統(tǒng)恢復18.數(shù)據(jù)庫系統(tǒng)結(jié)構19.分布式數(shù)據(jù)庫20.并行數(shù)據(jù)庫21.應用程序開發(fā)與管理22.高級查詢與信息檢索23.高級數(shù)據(jù)類型24.高級事物處理25.Oracle26.IBMDB2通用數(shù)據(jù)庫27.微軟SQL服務器附錄A.網(wǎng)絡模型附錄B.分層模型附錄C.高級關系型設計

作者簡介

　　作者AbrahamSilberschatz是貝爾實驗室信息科學研究中心副主任，HenryF.Korth是貝爾實驗室信息科學研究中心數(shù)據(jù)庫原理研究室主任，S.Sudarshan是印度工學院計算機科學與工程系副教授，曾是貝爾實驗室技術小組成員。相關圖書操作系統(tǒng)概念：第6版

圖書目錄

Preface xv
Chapter 1 Introduction
1.1 Database System Applications
1.2 Database Systems versus File Systems
1.3 View of Data
1.4 Data Models
1.5 Database Languages
1.6 Database Users and Administrators
1.7 Transaction Management
1.8 Database System Structure
1.9 Application Architectures
1.10 History of Database Systems
1.11 Summary
Exercises
Bibliographical Notes
PART 1 DATA MODELS
Chapter 2 Entity-Relationship Model
2.1 Basic Concepts
2.2 Constraints
2.3 Keys
2.4 Design Issues
2.5 Entity-Relationship Diagram
2.6 Weak Entity Sets
2.7 Extended E-R Features
2.8 Design of an E-R Database Schema
2.9 Reduction of an E-R Schema to Tables
2.10 The Unified Modeling Language UML
2.11 Summary
Exercises
Bibliographical Notes
Chapter 3 Relational Model
3.1 Structure of Relational Databases
3.2 The Relational Algebra
3.3 Extended Relational-Algebra Operations
3.4 Modification of the Database
3.5 Views
3.6 The Tuple Relational Calculus
3.7 The Domain Relational Calculus
3.8 Surnmary
Exercises
Bibliographical Notes
PART 2 RELATIONAL DATABASES
Chapter 4 SQL
4.1 Background
4.2 Basic Structure
4.3 Set Operations 1M
4.4 Aggregate Functions
4.5 Null Values
4.6 Nested Subqueries
4.7 Views
4.8 Complex Queries
4.9 Modification of the Database
4.10 Joined Relations
4.11 Data-Definition Language
4.12 Embedded SQL
4.13 Dynamic SQL
4.14 Other SQL Features
4.15 Summary
Exercises
Bibliographical Notes
Chapter 5 Other Relational Languages
5.1 Query-by-Example
5.2 Datalog
5.3 User Interfaces and Tools
5.4 Summary
Exercises
Bibliographical Notes
Chapter 6 Integrity and Security
6.1 Domain Constraints
6.2 Referential Integrity
6.3 Assertions
6.4 Triggers
6.5 Security and Authorization
6.6 Authorization in SQL
6.7 Encryption and Authentication
6.8 Summary
Exercises
Bibliographical Notes
Chapter 7 Relational-Database Design
7.l First Normal Form
7.2 Pitfalls in Relational-Database Design
7.3 Functional Dependencies
7.4 Decomposition
7.5 Desirable Properties of Decomposition
7.6 Boyce--Codd Normal Form
7.7 Third Normal Form
7.8 Fourth Normal Form
7.9 More Normal Forms
7.10 Overall Database Design Process
7.11 Surrunary
Exercises
Bibliographical Notes
PART 3 OBJECT-BASED DATABASES AND XML
Chapter 8 Object-Oriented Databases
8.1 Need for Complex Data Types
8.2 The Object-Oriented Data Model
8.3 Object-Oriented Languages
8.4 Persistent Programming Languages
8.5 Persistent C++ Systems
8.6 Persistent Java Systems
8.7 Summary
Exercises
Bibliographical Notes
Chapter 9 Object-Relational Databases
9.1 Nested Relations
9.2 Complex Types
9.3 Inheritance
9.4 Reference Types
9.5 Querying with Complex Types
9.6 Functions and Procedures
9.7 Obect-Oriented versus Object-Relational
9.8 Summary
Exercises
Bibliographical Notes
Chapter 10 XML
10.1 Background
10.2 Structure of XML Data
10.3 XML Document Schema
10.4 Querying and Transformation
10.5 The App1ication Program Interface
10.6 Storage of XML Data
10.7 XML Applications
10.8 Summary
Exercises
Bibliographical Notes
PART 4 DATA STORAGE AND QUERYING
Chapter 11 Storage and File Structure
11.1 Overview of Physical Storage Media
11.2 Magnetic Disks
1l.3 RAID
11.4 Tertiary Storage
11.5 Storage Access
11.6 File Organization
11.7 Organization of Records in Files
11.8 Data-Dictionary Storage
1l.9 Storage for Object-Oriented Databases
11.10 Summary
Exercises
Bibliographical Notes
Chapter 12 Indexing and Hashing
l2.1 Basic Concepts
12.2 Ordered Indices
12.3 B+-Tree Index Files
12.4 B-Tree Index Files
l2.5 Static Hashing
12.6 Dynamic Hashing
12.7 Comparison of Ordered Indexing and Hashing
12.8 Index Definition in SQL
12.9 Multiple-Key Access
12.10 Summary
Exercises
Bibliographical Notes
Chapter 13 Query Processing
13.l Overview
13.2 Measures of Query Cost
13.3 Selection Operation
13.4 Sorting
13.5 Join Operation
13.6 Other Operations
13.7 Evaluation of Expressions
13.8 Summary
Exercises
Bibliographical Notes
Chapter 14 Query Optimization
l4.1 Overview
14.2 Estimating Statistics of Expression Results
14.3 Transformation of Relational Expressions
14.4 Choice of Evaluation Plans
14.5 Materialized Views
14.6 Summary
Exercises
Bibliographical Notes
PART 5 TRANSACTION MANAGEMENT
Chapter 15 Transactions
15.1 Transaction Concept
15.2 TransactionState
15.3 Implementation of Atomicity and Durability
15.4 Concurrent Executions
15.5 Serializability
15.6 Recoverability
15.7 Implementation of Isolation
15.8 Transaction Definition in SQL
15.9 Testing for Serializability
15.10 Summary
Exercises
Bibliographical Notes
Chapter 16 Concurrency Control
16.1 Lock-Based Protocols
16.2 Timestamp-Based Protocols
16.3 Validation-Based Protocols
16.4 Multiple Granularity
16.5 Multiversion Schemes
l6.6 Deadlock Handling
16.7 Insert and Delete Operations
16.8 Weak Levels of Consistency
16.9 Concurrency in Index Structures
16.10 Summary
Exercises
Bibliographical Notes
Chapter 17 Recovery System
17.1 Failure Classification
17.2 Storage Structure
17.3 Recovery and Atomicity
17.4 Log-Based Recovery
17.5 Shadow Paging
17.6 Recovery with Concurrent Transactions
17.7 Buffer Management
17.8 Failure with Loss of Nonvolatile Storage
17.9 Advanced Recovery Techniques
17.10 Remote Backup Systems
17.11 Summary
Exercises
Bibliographical Notes
PART 6 DATABASE SYSTEM ARCHITECTURE
Chapter 18 Database System Architectures
18.1 Centralized and Client--Server Architectures
18.2 Server System Architectures
18.3 Parallel Systems
18.4 Distributed Systems
18.5 NetWorkTypes
18.6 Summary
Exercises
Bibliographical Notes
Chapter 19 Distributed Databases
l9.1 Homogeneous and Heterogeneous Databases
19.2 Distributed Data Storage
19.3 Distributed Transactions
19.4 Commit Protocols
19.5 Concurrency Control in Distributed Databases
19.6 Asailability
19.7 Distributed Query Processing
19.8 Heterogeneous Distributed Databases
l9.9 Directory Systems
19.10 Summary
Exercises
Bibliographical Notes
Chapter 20 Parallel Databases
20.1 Introduction
20.2 I/O Parallelism
20.3 Interquery Parallelism
20.4 Intraquery Parallelism
20.5 Intraoperation Parallelism
20.6 Interoperation Parallelism
20.7 Design of Parallel Systems
20.8 Summary
Exercises
Bibliographical Notes
PART 7 OTHER TOPICS
Chapter 21 Application Development and Administration
2l.1 Web Interfaces to Databases
21.2 Performance Tuning
21.3 Performance Benchmarks
2l.4 Standardization
2l.5 E-Commerce
21.6 Legacy Systems
2l.7 Summary
Exercises
Bibliographical Notes
Chapter 22 Advanced Querying and Information Retrieval
22.1 Decision-Support Systems
22.2 Data Analysis and OLAP
22.3 Data Mining
22.4 Data Warehousing
22.5 Information-Retrieval Systems
22.6 Summary
Exercises
Bibliographical Notes
Chapter 23 Advanced Data Types and New Applications
23.1 Motivation
23.2 Time in Databases
23.3 Spatial and Geographic Data
23.4 Multimedia Databases
23.5 Mobility and Personal Databases
23.6 Summary
Exercises
Bibliographical Notes
Chapter 24 Advanced Transaction Processing
24.1 Transaction-Processing Monitors
24.2 Transactional Workflows
24.3 Main-Memory Databases
24.4 Real-Time Transaction Systems
24.5 Long-Duration Transactions
24.6 Transaction Management in Multidatabases
24.7 Summary
Exercises
Bibliographical Notes
PART 8 CASE STUDIES
Chapter 25 Oracle
25.1 Database Design and Querying Tools
25.2 SQL Variations and Extensions
25.3 Storage and Indexing
25.4 Query Processing and Optimization
25.5 Concurrency Control and Recovery
25.6 System Architecture
25.7 Replication, Distribution, and External Data
25.8 Database Administration Tools
Bibliographical Notes
Chapter 26 IBM DB2 Universal Database
26.1 Database Design and Querying Tools
26.2 SQL Variations and Extensions
26.3 Storage and Indexing
26.4 Query Processing and Optimization
26.5 Concurrency Control and Recovery
26.6 System Architecture
26.7 Replication, Distribution, and External Data
26.8 Database Administration Tools
26.9 Summary
Bibliographical Notes
Chapter 27 Microsoft SQL Server
27.1 Management, Design, and Querying Tools
27.2 SQL Variations and Extensions
27.3 Storage and Indexing
27.4 Query Processing and Optimization
27.5 Concurrency and Recovery
27.6 System Architecture
27.7 Data Access
27.8 Distribution and Replication
27.9 Full-Text Queries on Relational Data
27.10 Data Warehousing and Analysis Services
27.11 XML and Web Support
27.12 Summary
Bibliographical Notes
PART 9 APPENDICES
Appendix A Network Model (contents online)
A.1 Basic Concepts
A.2 Data-Structure Diagrams
A.3 The DBTG CODASYL Model
A.4 DBTG Data-Retrieval Facility
A.5 DBTG Update Facility
A.6 DBTG Set-Processing Facility
A.7 Mapping of NetWorks to Files
A.8 Summary
Exercises
Bibliographical Notes
Appendix B Hierarchical Model (contents online)
B.1 Basic Concepts
B.2 Tree-Structure Diagrams
B.3 Data-Retrieval Facility
B.4 Update Facility
B.5 Virtual Records
B.6 Mapping of Hierarchies to Files
B.7 The IMS Database System
B.8 Summary
Exercises
Bibliographical Notes
Appendix C Advanced Relational Design (contents online)
C.1 Multivalued Dependencies
C.2 Join Dependencies
C.3 Domain-Key Normal Form
C.4 Summary
Exercises
Bibliographical Notes
Bibliography
Index