数据库系统概念 英文精编版 第6版【2025|PDF下载-Epub版本|mobi电子书|kindle百度云盘下载】

数据库系统概念 英文精编版 第6版PDF格式电子书版下载

注意：本站所有压缩包均有解压码： 点击下载压缩包解压工具

Chapter 1 Introduction1

1.1 Database-System Applications1

1.2 Purpose of Database Systems3

1.3 View of Data6

1.4 Database Languages9

1.5 Relational Databases12

1.6 Database Design15

1.7 Data Storage and Querying20

1.8 Transaction Management22

1.9 Database Architecture23

1.10 Data Mining and Information Retrieval27

1.11 Specialty Databases28

1.12 Database Users and Administrators29

1.13 History of Database Systems31

1.14 Summary33

Review Terms35

Practice Exercises35

Exercises36

Tools36

Bibliographical Notes36

PART ONE RELATIONAL DATABASES41

Chapter 2 Introduction to the Relational Model41

2.1 Structure of Relational Databases41

2.2 Database Schema44

2.3 Keys47

2.4 Schema Diagrams48

2.5 Relational Query Languages49

2.6 Relational Operations50

2.7 Summary54

Review Terms54

Practice Exercises55

Exercises56

Bibliographical Notes57

Chapter 3 Introduction to SQL59

3.1 Overview of the SQL Query Language59

3.2 SQL Data Definition60

3.3 Basic Structure of SQL Queries65

3.4 Additional Basic Operations76

3.5 Set Operations81

3.6 Null Values85

3.7 Aggregate Functions86

3.8 Nested Subqueries92

3.9 Modification of the Database100

3.10 Summary106

Review Terms106

Practice Exercises107

Exercises110

Tools113

Bibliographical Notes114

Chapter 4 Intermediate SQL115

4.1 Join Expressions115

4.2 Views122

4.3 Transactions129

4.4 Integrity Constraints130

4.5 SQL Data Types and Schemas138

4.6 Authorization145

4.7 Summary152

Review Terms153

Practice Exercises154

Exercises157

Bibliographical Notes158

Chapter 5 Advanced SQL159

5.1 Accessing SQL From a Programming Language159

5.2 Functions and Procedures175

5.3 Triggers182

5.4 Recursive Queries189

5.5 Advanced Aggregation Features194

5.6 OLAP199

5.7 Summary211

Review Terms212

Practice Exercises213

Exercises214

Tools218

Bibliographical Notes218

Chapter 6 Formal Relational Query Languages218

6.1 The Relational Algebra219

6.2 The Tuple Relational Calculus241

6.3 The Domain Relational Calculus247

6.4 Summary250

Review Terms251

Practice Exercises251

Exercises254

Bibliographical Notes256

PART TWO DATABASE DESIGN259

Chapter 7 Database Design and the E-R Model259

7.1 Overview of the Design Process259

7.2 The Entity-Relationship Model262

7.3 Constraints269

7.4 Removing Redundant Attributes in Entity Sets272

7.5 Entity-Relationship Diagrams274

7.6 Reduction to Relational Schemas283

7.7 Entity-Relationship Design Issues290

7.8 Extended E-R Features295

7.9 Alternative Notations for Modeling Data304

7.10 Other Aspects of Database Design310

7.11 Summary313

Review Terms315

Practice Exercises315

Exercises319

Tools321

Bibliographical Notes321

Chapter 8 Relational Database Design323

8.1 Features of Good Relational Designs323

8.2 Atomic Domains and First Normal Form327

8.3 Decomposition Using Functional Dependencies329

8.4 Functional-Dependency Theory338

8.5 Algorithms for Decomposition348

8.6 Decomposition Using Multivalued Dependencies355

8.7 More Normal Forms360

8.8 Database-Design Process361

8.9 Modeling Temporal Data364

8.10 Summary367

Review Terms368

Practice Exercises368

Exercises372

Bibliographical Notes374

Chapter 9 Application Design and Development374

9.1 Application Programs and User Interfaces375

9.2 Web Fundamentals377

9.3 Servlets and JSP383

9.4 Application Architectures391

9.5 Rapid Application Development396

9.6 Application Performance400

9.7 Application Security402

9.8 Encryption and Its Applications411

9.9 Summary417

Review Terms418

Practice Exercises419

Exercises421

Project Suggestions422

Tools426

Bibliographical Notes426

PART THREE DATA STORAGE,QUERYING,AND TRANSACTION MANAGEMENT426

Chapter 10 Data Storage and Data Access426

10.1 Overview of Physical Storage Media429

10.2 Magnetic Disk and Flash Storage432

10.3 Organization of Files and Records440

10.4 Data-Dictionary Storage445

10.5 Database Buffer448

10.6 Basic Concepts of Index451

10.7 Ordered Indices452

10.8 B+-Tree Index Files460

10.9 Hash File Organization and Hash Index474

10.10 Index Definition in SQL482

10.11 Summary483

Review Terms486

Practice Exercises487

Exercises488

Bibliographical Notes489

Chapter 11 Query Processing and Query Optimization489

11.1 Overview491

11.2 Measures of Query Cost493

11.3 Implementation of Relational Algebra Operation495

11.4 Evaluation of Expressions509

11.5 Query Optimization512

11.6 Summary533

Review Terms535

Practice Exercises536

Exercises537

Bibliographical Notes538

Chapter 12 Transaction Management541

12.1 Transaction Concept541

12.2 Transaction Atomicity and Durability545

12.3 Transaction Isolation548

12.4 Serializability554

12.5 Recoverability557

12.6 Concurrency Control559

12.7 Recovery System573

12.8 Summary584

Review Terms587

Practice Exercises589

Exercises590

Bibliographical Notes592

PART FOUR ADVANCED TOPICS597

Chapter 13 Data Warehousing and Mining597

13.1 Decision-Support Systems597

13.2 Data Warehousing599

13.3 Data Mining603

13.4 Summary610

Review Terms611

Practice Exercises612

Exercises612

Tools613

Bibliographical Notes613

Chapter 14 Object-Based Databases615

14.1 Overview615

14.2 Complex Data Types616

14.3 Structured Types and Inheritance in SQL619

14.4 Table Inheritance624

14.5 Array and Multiset Types in SQL626

14.6 Object-Identity and Reference Types in SQL631

14.7 Implementing O-R Features633

14.8 Persistent Programming Languages634

14.9 Object-Relational Mapping643

14.10 Object-Oriented versus Object-Relational643

14.11 Summary645

Review Terms645

Practice Exercises646

Exercises648

Tools650

Bibliographical Notes650

Chapter 15 XML651

15.1 Motivation651

15.2 Structure of XML Data656

15.3 XML Document Schema660

15.4 Querying and Transformation668

15.5 Application Program Interfaces to XML678

15.6 Storage of XML Data679

15.7 XML Applications686

15.8 Summary689

Review Terms690

Practice Exercises691

Exercises693

Tools694

Bibliographical Notes694

Chapter 16 Advanced Application Development694

16.1 Performance Tuning697

16.2 Performance Benchmarks713

16.3 Other Issues in Application Development716

16.4 Standardization719

16.5 Summary724

Review Terms725

Practice Exercises725

Exercises726

Bibliographical Notes727

Bibliography729