【数据库】Database System Concepts

发布者：浅蓝色

部分目录
Chapter 1 Introduction
1.1 Database-System Applications 1
1.2 Purpose of Database Systems 5
1.3 View of Data 8
1.4 Database Languages 13
1.5 Database Design 17
1.6 Database Engine 18
1.7 Database and Application Architecture 21
1.8 Database Users and Administrators 24
1.9 History of Database Systems 25
1.10 Summary 29
Exercises 31
Further Reading 33
PART ONE RELATIONAL LANGUAGES
Chapter 2 Introduction to the Relational Model
2.1 Structure of Relational Databases 37
2.2 Database Schema 41
2.3 Keys 43
2.4 Schema Diagrams 46
2.5 Relational Query Languages 47
2.6 The Relational Algebra 48
2.7 Summary 58
Exercises 60
Further Reading 63
Chapter 3 Introduction to SQL
3.1 Overview of the SQL Query Language 65
3.2 SQL Data Definition 66
3.3 Basic Structure of SQL Queries 71
3.4 Additional Basic Operations 79
3.5 Set Operations 85
3.6 Null Values 89
3.7 Aggregate Functions 91
3.8 Nested Subqueries 98
3.9 Modification of the Database 108
3.10 Summary 114
Exercises 115
Further Reading 124
Chapter 4 Intermediate SQL
4.1 Join Expressions 125
4.2 Views 137
4.3 Transactions 143
4.4 Integrity Constraints 145
4.5 SQL Data Types and Schemas 153
4.6 Index Definition in SQL 164
4.7 Authorization 165
4.8 Summary 173
Exercises 176
Further Reading 180
Chapter 5 Advanced SQL
5.1 Accessing SQL from a Programming
Language 183
5.2 Functions and Procedures 198
5.3 Triggers 206
5.4 Recursive Queries 213
5.5 Advanced Aggregation Features 219
5.6 Summary 231
Exercises 232
Further Reading 237
PART TWO DATABASE DESIGN
Chapter 6 Database Design Using the E-R Model
6.1 Overview of the Design Process 241
6.2 The Entity-Relationship Model 244
6.3 Complex Attributes 249
6.4 Mapping Cardinalities 252
6.5 Primary Key 256
6.6 Removing Redundant Attributes in Entity
Sets 261
6.7 Reducing E-R Diagrams to Relational
Schemas 264
6.8 Extended E-R Features 271
6.9 Entity-Relationship Design Issues 279
6.10 Alternative Notations for Modeling
Data 285
6.11 Other Aspects of Database Design 291
6.12 Summary 292
Exercises 294
Further Reading 300
Chapter 7 Relational Database Design
7.1 Features of Good Relational Designs 303
7.2 Decomposition Using Functional Dependencies 308
7.3 Normal Forms 313
7.4 Functional-Dependency Theory 320
7.5 Algorithms for Decomposition Using Functional Dependencies 330
7.6 Decomposition Using Multivalued Dependencies 336
7.7 More Normal Forms 341
7.8 Atomic Domains and First Normal Form 342
7.9 Database-Design Process 343
7.10 Modeling Temporal Data 347
7.11 Summary 351
Exercises 353
Further Reading 360
PART THREE APPLICATION DESIGN AND DEVELOPMENT
Chapter 8 Complex Data Types
8.1 Semi-structured Data 365
8.2 Object Orientation 376
8.3 Textual Data 382
8.4 Spatial Data 387
8.5 Summary 394
Exercises 397
Further Reading 401
Chapter 9 Application Development
9.1 Application Programs and User
Interfaces 403
9.2 Web Fundamentals 405
9.3 Servlets 411
9.4 Alternative Server-Side Frameworks 416
9.5 Client-Side Code and Web Services 421
9.6 Application Architectures 429
9.7 Application Performance 434
9.8 Application Security 437
9.9 Encryption and Its Applications 447
9.10 Summary 453
Exercises 455
Further Reading 462
剩余目录过长，未全部列出。